hi,<br>i've run slon process,then rise error messages like this..whats wrong with my setup connection..help me please...<br>thanks,<br>regards,<br>bayu<br><br><br>[postgres@laptopbps ~]$ /usr/local/pgsql/bin/slon sdki "dbname=sdki user=postgres port=5432 host=laptopbps"<br>2007-08-20 15:53:35 UTC CONFIG main: slon version 1.2.9 starting up<br>2007-08-20 15:53:35 UTC DEBUG2 slon: watchdog process started<br>2007-08-20 15:53:35 UTC DEBUG2 slon: watchdog ready - pid = 4496<br>2007-08-20 15:53:35 UTC DEBUG2 slon: worker process created - pid = 4497<br>2007-08-20 15:53:35 UTC CONFIG main: local node id = 1<br>2007-08-20 15:53:35 UTC DEBUG2 main: main process started<br>2007-08-20 15:53:35 UTC CONFIG main: launching sched_start_mainloop<br>2007-08-20 15:53:35 UTC CONFIG main: loading current cluster configuration<br>2007-08-20 15:53:35 UTC CONFIG storeNode: no_id=2 no_comment='gb 8.0 5432'<br>2007-08-20 15:53:35 UTC DEBUG2 setNodeLastEvent: no_id=2 event_seq=498<br>2007-08-20
15:53:35 UTC CONFIG storeNode: no_id=3 no_comment='gb_replica 8.0 5430'<br>2007-08-20 15:53:35 UTC DEBUG2 setNodeLastEvent: no_id=3 event_seq=2<br>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<br>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<br>2007-08-20 15:53:35 UTC CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2<br>2007-08-20 15:53:35 UTC CONFIG storeListen: li_origin=3 li_receiver=1 li_provider=3<br>2007-08-20 15:53:35 UTC CONFIG storeSet: set_id=1 set_origin=1 set_comment='gb tables'<br>2007-08-20 15:53:35 UTC DEBUG2 sched_wakeup_node(): no_id=1 (0 threads + worker signaled)<br>2007-08-20 15:53:35 UTC DEBUG2 main: last local event sequence = 669<br>2007-08-20 15:53:35 UTC CONFIG main: configuration complete - starting threads<br>2007-08-20 15:53:35 UTC DEBUG1
localListenThread: thread starts<br>2007-08-20 15:53:35 UTC DEBUG4 version for "dbname=sdki user=postgres port=5432 host=laptopbps" is 80204<br>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"<br>2007-08-20 15:53:35 UTC FATAL Do you already have a slon running against this node?<br>2007-08-20 15:53:35 UTC FATAL Or perhaps a residual idle backend connection from a dead slon?<br>2007-08-20 15:53:35 UTC DEBUG2 slon_abort() from pid=4497<br>2007-08-20 15:53:35 UTC DEBUG1 slon: shutdown requested<br>2007-08-20 15:53:35 UTC DEBUG2 slon: notify worker process to shutdown<br>2007-08-20 15:53:55 UTC DEBUG1 slon: child termination timeout - kill child<br>2007-08-20 15:53:55 UTC DEBUG2 slon: child terminated status: 9; pid: 4497, current worker pid:
4497<br>2007-08-20 15:53:55 UTC DEBUG1 slon: done<br>2007-08-20 15:53:55 UTC DEBUG2 slon: exit(0)<br><br><p> 
<hr size=1>Sick sense of humor? Visit Yahoo! TV's
<a href="http://us.rd.yahoo.com/evt=47093/*http://tv.yahoo.com/collections/222">Comedy with an Edge </a>to see what's on, when.