Hi Everyone,

 

I have just noticed that my postgres logfile receives continuously messages
from slony listed below:

 

2008-07-16 12:37:50 CEST NOTICE:  Slony-I: cleanup stale sl_nodelock entry
for pid=5810

2008-07-16 12:37:50 CEST CONTEXT:  SQL statement "SELECT
"_slony1".cleanupNodelock()"

        PL/pgSQL function "cleanupevent" line 77 at PERFORM

2008-07-16 12:51:35 CEST LOG:  could not receive data from client: Connection
timed out

2008-07-16 12:51:35 CEST LOG:  unexpected EOF on client connection

2008-07-16 13:00:44 CEST NOTICE:  Slony-I: cleanup stale sl_nodelock entry
for pid=30480

2008-07-16 13:00:44 CEST CONTEXT:  SQL statement "SELECT
"_slony1".cleanupNodelock()"

        PL/pgSQL function "cleanupevent" line 77 at PERFORM

2008-07-16 13:08:52 CEST LOG:  could not receive data from client: Connection
timed out

2008-07-16 13:08:52 CEST LOG:  unexpected EOF on client connection

2008-07-16 13:11:45 CEST NOTICE:  Slony-I: cleanup stale sl_nodelock entry
for pid=29970

2008-07-16 13:11:45 CEST CONTEXT:  SQL statement "SELECT
"_slony1".cleanupNodelock()"

        PL/pgSQL function "cleanupevent" line 77 at PERFORM

2008-07-16 13:13:48 CEST LOG:  could not receive data from client: Connection
timed out

2008-07-16 13:13:48 CEST LOG:  unexpected EOF on client connection

2008-07-16 13:23:25 CEST NOTICE:  Slony-I: cleanup stale sl_nodelock entry
for pid=14475

2008-07-16 13:23:25 CEST CONTEXT:  SQL statement "SELECT
"_slony1".cleanupNodelock()"

        PL/pgSQL function "cleanupevent" line 77 at PERFORM

2008-07-16 13:24:33 CEST LOG:  could not receive data from client: Connection
timed out

2008-07-16 13:24:33 CEST LOG:  unexpected EOF on client connection

2008-07-16 13:32:48 CEST LOG:  could not receive data from client: Connection
timed out

2008-07-16 13:32:48 CEST LOG:  unexpected EOF on client connection

2008-07-16 13:34:07 CEST NOTICE:  Slony-I: cleanup stale sl_nodelock entry
for pid=21685

2008-07-16 13:34:07 CEST CONTEXT:  SQL statement "SELECT
"_slony1".cleanupNodelock()"

        PL/pgSQL function "cleanupevent" line 77 at PERFORM

2008-07-16 13:34:07 CEST NOTICE:  Slony-I: cleanup stale sl_nodelock entry
for pid=28842

2008-07-16 13:34:07 CEST CONTEXT:  SQL statement "SELECT
"_slony1".cleanupNodelock()"

        PL/pgSQL function "cleanupevent" line 77 at PERFORM

2008-07-16 15:02:01 CEST LOG:  incomplete startup packet

2008-07-16 16:22:04 CEST LOG:  could not receive data from client: Connection
timed out

2008-07-16 16:22:04 CEST LOG:  unexpected EOF on client connection

2008-07-16 16:24:36 CEST NOTICE:  Slony-I: cleanup stale sl_nodelock entry
for pid=1779

2008-07-16 16:24:36 CEST CONTEXT:  SQL statement "SELECT
"_slony1".cleanupNodelock()"

        PL/pgSQL function "cleanupevent" line 77 at PERFORM

 

What does that message mean? Is there something wrong?

 

Thx

Best regards

Felix

 

 

 

Slony logfile:

 

2008-07-16 12:37:50 CEST DEBUG2 calc sync size - last time: 1 last length:
2494 ideal: 24 proposed size: 3

2008-07-16 12:37:50 CEST DEBUG2 remoteWorkerThread_3: SYNC 6967 processing

2008-07-16 12:37:50 CEST DEBUG2 remoteWorkerThread_3: no sets need syncing
for this event

2008-07-16 12:37:50 CEST DEBUG2 remoteWorkerThread_7: forward confirm 3,6967
received by 7

2008-07-16 12:37:50 CEST DEBUG2 remoteWorkerThread_7: forward confirm 6,6969
received by 4

2008-07-16 12:37:50 CEST DEBUG2 syncThread: new sl_action_seq 1376802 - SYNC
14077

2008-07-16 12:37:57 CEST DEBUG2 remoteListenThread_2: LISTEN

2008-07-16 12:37:57 CEST DEBUG2 remoteWorkerThread_2: forward confirm 1,14076
received by 5

2008-07-16 12:37:57 CEST DEBUG2 remoteWorkerThread_2: forward confirm 1,14076
received by 4

2008-07-16 12:37:57 CEST DEBUG2 remoteWorkerThread_2: forward confirm 3,6967
received by 2

2008-07-16 12:37:57 CEST DEBUG2 remoteWorkerThread_2: forward confirm 6,6969
received by 9

2008-07-16 12:37:57 CEST DEBUG2 remoteWorkerThread_2: forward confirm 3,6967
received by 5

2008-07-16 12:37:57 CEST DEBUG2 remoteWorkerThread_2: forward confirm 3,6967
received by 9

2008-07-16 12:37:58 CEST DEBUG2 remoteListenThread_8: queue event 8,6970 SYNC

2008-07-16 12:37:58 CEST DEBUG2 remoteListenThread_8: UNLISTEN

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: Received event 8,6970
SYNC

2008-07-16 12:37:58 CEST DEBUG2 calc sync size - last time: 1 last length:
8671 ideal: 6 proposed size: 3

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: SYNC 6970 processing

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: no sets need syncing
for this event

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: forward confirm 1,14077
received by 6

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: forward confirm 3,6967
received by 8

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: forward confirm 3,6967
received by 6

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: forward confirm 1,14077
received by 8

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: forward confirm 1,14077
received by 9

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: forward confirm 8,6970
received by 6

2008-07-16 12:37:58 CEST DEBUG2 remoteWorkerThread_8: forward confirm 3,6967
received by 4

2008-07-16 12:38:00 CEST DEBUG2 remoteListenThread_2: LISTEN

2008-07-16 12:38:00 CEST DEBUG2 remoteWorkerThread_2: forward confirm 8,6970
received by 2

2008-07-16 12:38:00 CEST DEBUG2 remoteWorkerThread_2: forward confirm 1,14077
received by 2

2008-07-16 12:38:00 CEST DEBUG2 localListenThread: Received event 1,14077
SYNC

2008-07-16 12:38:02 CEST DEBUG2 remoteListenThread_9: queue event 9,6980 SYNC

2008-07-16 12:38:02 CEST DEBUG2 remoteListenThread_9: UNLISTEN

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_9: Received event 9,6980
SYNC

2008-07-16 12:38:02 CEST DEBUG2 calc sync size - last time: 1 last length:
3519 ideal: 17 proposed size: 3

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_9: SYNC 6980 processing

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_9: no sets need syncing
for this event

2008-07-16 12:38:02 CEST DEBUG2 remoteListenThread_2: queue event 5,6967 SYNC

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: Received event 5,6967
SYNC

2008-07-16 12:38:02 CEST DEBUG2 calc sync size - last time: 1 last length: 49
ideal: 1224 proposed size: 3

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: SYNC 6967 processing

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: no sets need syncing
for this event

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 5,6967
received by 2

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 5,6967
received by 4

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 8,6970
received by 4

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 1,14077
received by 3

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 8,6970
received by 5

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 8,6970
received by 7

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 1,14076
received by 7

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_2: forward confirm 8,6970
received by 3

2008-07-16 12:38:02 CEST DEBUG2 remoteListenThread_5: LISTEN

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: forward confirm 9,6980
received by 3

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: forward confirm 9,6980
received by 6

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: forward confirm 5,6967
received by 6

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: forward confirm 5,6967
received by 3

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: forward confirm 9,6980
received by 7

2008-07-16 12:38:02 CEST DEBUG2 remoteWorkerThread_5: forward confirm 9,6980
received by 5

.

.

.

.

.

2008-07-16 12:39:37 CEST DEBUG2 remoteListenThread_5: UNLISTEN

2008-07-16 12:39:37 CEST DEBUG2 remoteWorkerThread_4: Received event 4,6973
SYNC

2008-07-16 12:39:37 CEST DEBUG2 calc sync size - last time: 1 last length:
4517 ideal: 13 proposed size: 3

2008-07-16 12:39:37 CEST DEBUG2 remoteWorkerThread_4: SYNC 6973 processing

2008-07-16 12:39:37 CEST DEBUG2 remoteWorkerThread_4: no sets need syncing
for this event

2008-07-16 12:39:37 CEST DEBUG2 remoteWorkerThread_5: forward confirm 4,6973
received by 5

2008-07-16 12:39:37 CEST DEBUG2 remoteWorkerThread_5: forward confirm 1,14084
received by 8

2008-07-16 12:39:37 CEST DEBUG2 remoteWorkerThread_5: forward confirm 1,14083
received by 7

NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=24788

CONTEXT:  SQL statement "SELECT  "_slony1".cleanupNodelock()"

PL/pgSQL function "cleanupevent" line 77 at PERFORM

NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=19225

CONTEXT:  SQL statement "SELECT  "_slony1".cleanupNodelock()"

PL/pgSQL function "cleanupevent" line 77 at PERFORM

NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=25418

CONTEXT:  SQL statement "SELECT  "_slony1".cleanupNodelock()"

PL/pgSQL function "cleanupevent" line 77 at PERFORM

NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=19821

CONTEXT:  SQL statement "SELECT  "_slony1".cleanupNodelock()"

PL/pgSQL function "cleanupevent" line 77 at PERFORM

NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=26081

CONTEXT:  SQL statement "SELECT  "_slony1".cleanupNodelock()"

PL/pgSQL function "cleanupevent" line 77 at PERFORM

NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=23227

CONTEXT:  SQL statement "SELECT  "_slony1".cleanupNodelock()"

PL/pgSQL function "cleanupevent" line 77 at PERFORM

NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=9719

CONTEXT:  SQL statement "SELECT  "_slony1".cleanupNodelock()"

PL/pgSQL function "cleanupevent" line 77 at PERFORM

2008-07-16 12:39:42 CEST DEBUG1 cleanupThread:    0.035 seconds for
cleanupEvent()

2008-07-16 12:39:42 CEST DEBUG1 cleanupThread:    0.048 seconds for delete
logs

2008-07-16 12:39:43 CEST DEBUG2 remoteListenThread_2: queue event 2,6974 SYNC

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: Received event 2,6974
SYNC

2008-07-16 12:39:43 CEST DEBUG2 calc sync size - last time: 1 last length:
6151 ideal: 9 proposed size: 3

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: SYNC 6974 processing

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: no sets need syncing
for this event

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: forward confirm 2,6974
received by 9

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: forward confirm 4,6973
received by 6

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: forward confirm 4,6973
received by 8

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: forward confirm 4,6973
received by 7

2008-07-16 12:39:43 CEST DEBUG2 remoteWorkerThread_2: forward confirm 4,6973
received by 9

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080716/3e4b2212/attachment-0001.htm