Rose Nancy rnancy at afilias.info
Tue Jul 23 11:13:03 PDT 2013
Hi All,

At the server startup,  my slony daemon crashed with the following error

FATAL localListenThread: "select "_xxxx".cleanupNodelock(); insert into 
"_xxxx".sl_nodelock values ( 9151, 0,
"pg_catalog".pg_backend_pid()); " - ERROR: duplicate key value violates 
unique constraint "sl_nodelock-pkey"
DETAIL: Key (nl_nodeid, nl_conncnt)=(9151, 0) already exists.
2013-07-23 07:10:16 UTC FATAL Do you already have a slon running against 
this node?
2013-07-23 07:10:16 UTC FATAL Or perhaps a residual idle backend 
connection from a dead slon?
2013-07-23 07:10:16 UTC DEBUG2 slon_abort() from pid=1699
2013-07-23 07:10:16 UTC FATAL main: localListenThread did not start
2013-07-23 07:10:16 UTC CONFIG slon: child terminated signal: 9; pid: 
1699, current worker pid: 1699
2013-07-23 07:10:16 UTC INFO slon: done

I know the origin of the duplicate key error, but I expected the 
Watchdog to try every 10s to start the daemon again.
In my case it seems like the watchdog process died with the child process.

What is the expected behaviour of the Watchdog slony process in this case?


Thanks.

-- 
Rose Nancy



More information about the Slony1-general mailing list