Mon Aug 20 23:48:52 PDT 2007
- Previous message: [Slony1-general] Log shipping fix in place
- Next message: [Slony1-general] error connection
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
hi, i've run slon process,then rise error messages like this..whats wrong with my setup connection..help me please... thanks, regards, bayu [postgres at laptopbps ~]$ /usr/local/pgsql/bin/slon sdki "dbname=sdki user=postgres port=5432 host=laptopbps" 2007-08-20 15:53:35 UTC CONFIG main: slon version 1.2.9 starting up 2007-08-20 15:53:35 UTC DEBUG2 slon: watchdog process started 2007-08-20 15:53:35 UTC DEBUG2 slon: watchdog ready - pid = 4496 2007-08-20 15:53:35 UTC DEBUG2 slon: worker process created - pid = 4497 2007-08-20 15:53:35 UTC CONFIG main: local node id = 1 2007-08-20 15:53:35 UTC DEBUG2 main: main process started 2007-08-20 15:53:35 UTC CONFIG main: launching sched_start_mainloop 2007-08-20 15:53:35 UTC CONFIG main: loading current cluster configuration 2007-08-20 15:53:35 UTC CONFIG storeNode: no_id=2 no_comment='gb 8.0 5432' 2007-08-20 15:53:35 UTC DEBUG2 setNodeLastEvent: no_id=2 event_seq=498 2007-08-20 15:53:35 UTC CONFIG storeNode: no_id=3 no_comment='gb_replica 8.0 5430' 2007-08-20 15:53:35 UTC DEBUG2 setNodeLastEvent: no_id=3 event_seq=2 2007-08-20 15:53:35 UTC CONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=sdki host=pchome port=5432 user=postgres" pa_connretry=10 2007-08-20 15:53:35 UTC CONFIG storePath: pa_server=3 pa_client=1 pa_conninfo="dbname=sdki2 host=localhost port=5432 user=postgres" pa_connretry=10 2007-08-20 15:53:35 UTC CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2 2007-08-20 15:53:35 UTC CONFIG storeListen: li_origin=3 li_receiver=1 li_provider=3 2007-08-20 15:53:35 UTC CONFIG storeSet: set_id=1 set_origin=1 set_comment='gb tables' 2007-08-20 15:53:35 UTC DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled) 2007-08-20 15:53:35 UTC DEBUG2 main: last local event sequence = 669 2007-08-20 15:53:35 UTC CONFIG main: configuration complete - starting threads 2007-08-20 15:53:35 UTC DEBUG1 localListenThread: thread starts 2007-08-20 15:53:35 UTC DEBUG4 version for "dbname=sdki user=postgres port=5432 host=laptopbps" is 80204 2007-08-20 15:53:35 UTC FATAL localListenThread: "select "_sdki".cleanupNodelock(); insert into "_sdki".sl_nodelock values ( 1, 0, "pg_catalog".pg_backend_pid()); " - ERROR: duplicate key violates unique constraint "sl_nodelock-pkey" 2007-08-20 15:53:35 UTC FATAL Do you already have a slon running against this node? 2007-08-20 15:53:35 UTC FATAL Or perhaps a residual idle backend connection from a dead slon? 2007-08-20 15:53:35 UTC DEBUG2 slon_abort() from pid=4497 2007-08-20 15:53:35 UTC DEBUG1 slon: shutdown requested 2007-08-20 15:53:35 UTC DEBUG2 slon: notify worker process to shutdown 2007-08-20 15:53:55 UTC DEBUG1 slon: child termination timeout - kill child 2007-08-20 15:53:55 UTC DEBUG2 slon: child terminated status: 9; pid: 4497, current worker pid: 4497 2007-08-20 15:53:55 UTC DEBUG1 slon: done 2007-08-20 15:53:55 UTC DEBUG2 slon: exit(0) --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070820/70fc012f/attachment.htm
- Previous message: [Slony1-general] Log shipping fix in place
- Next message: [Slony1-general] error connection
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list