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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
