<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt">Hi<br><br>When I restarted slony, then all of a sudden my sl_status is empty and nothing is getting replicated in the subscriber (node 37) nor its forwarding.<br><br>All I can see in the logs...<br><br>2012-02-23 14:58:20 CSTCONFIG main: done<br>2012-02-23 14:58:20 CSTCONFIG slon: child terminated status: 0; pid: 5254, current worker pid: 5254<br>2012-02-23 14:58:20 CSTCONFIG slon: restart of worker<br>2012-02-23 14:58:20 CSTCONFIG main: slon version 2.0.4 starting up<br><br>...<br>2012-02-23 14:58:55 CSTWARN remoteWorker_wakeup: node 34 - no worker thread<br>2012-02-23 14:58:55 CSTDEBUG2 sched_wakeup_node(): no_id=34 (0 threads + worker signaled)<br>2012-02-23 14:58:55 CSTCONFIG storeSubscribe: sub_set=2 sub_provider=36 sub_forward='t'<br>2012-02-23 14:58:55 CSTWARN remoteWorker_wakeup: node
36 - no worker thread<br>...<br><br>finally it dies with dup error..<br><br>2012-02-23 14:58:55 CSTFATAL localListenThread: "select "_application".cleanupNodelock(); insert into "_application".sl_nodelock values ( 37, 0, "pg_catalog".pg_backend_pid()); " - ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey"<br><br>2012-02-23 14:58:55 CSTDEBUG2 slon_abort() from pid=12679<br>2012-02-23 14:58:55 CSTINFO slon: shutdown requested<br>2012-02-23 14:58:55 CSTINFO slon: notify worker process to shutdown<br>2012-02-23 14:59:15 CSTINFO slon: child termination timeout - kill child<br><br>Any help on how to fix this will be appreciated.. other nodes are fine in the cluster.<br><br>Thanks<br>Venu<br><br><br></div></body></html>