Hi

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.

All I can see in the logs...

2012-02-23 14:58:20 CSTCONFIG main: done
2012-02-23 14:58:20 CSTCONFIG slon: child terminated status: 0; pid: 5254, current worker pid: 5254
2012-02-23 14:58:20 CSTCONFIG slon: restart of worker
2012-02-23 14:58:20 CSTCONFIG main: slon version 2.0.4 starting up

...
2012-02-23 14:58:55 CSTWARN   remoteWorker_wakeup: node 34 - no worker thread
2012-02-23 14:58:55 CSTDEBUG2 sched_wakeup_node(): no_id=34 (0 threads + worker signaled)
2012-02-23 14:58:55 CSTCONFIG storeSubscribe: sub_set=2 sub_provider=36 sub_forward='t'
2012-02-23 14:58:55 CSTWARN   remoteWorker_wakeup: node 36 - no worker thread
...

finally it dies with dup error..

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"

2012-02-23 14:58:55 CSTDEBUG2 slon_abort() from pid=12679
2012-02-23 14:58:55 CSTINFO   slon: shutdown requested
2012-02-23 14:58:55 CSTINFO   slon: notify worker process to shutdown
2012-02-23 14:59:15 CSTINFO   slon: child termination timeout - kill child

Any help on how to fix this will be appreciated.. other nodes are fine in the cluster.

Thanks
Venu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120223/30221b6a/attachment.htm