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