Home > Archive > Slony1 PostgreSQL Replication > July 2005 > Re: Slony I rc startup script on FreeBSD outputs









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Slony I rc startup script on FreeBSD outputs
Sven Willenberger

2005-07-27, 8:24 pm

On Wed, 2005-07-27 at 11:47 -0400, Sven Willenberger wrote:
> On Tue, 2005-07-26 at 16:29 -0400, Sven Willenberger wrote:
>
>
> The setup script worked fine and the service is running. I do have a
> concern now though. It would appear from the logfiles that slon is
> getting restarted every 12 minutes on the origin. Subsequently, the
> replicant does the same an spits out warnings:
>
> Jul 27 11:40:27 dbhost slon[48276]: [43-22] CONFIG storeListen:
> li_origin=1 li_receiver=3 li_provider=1
> Jul 27 11:40:27 dbhost slon[48276]: [43-23] CONFIG storeSet: set_id=1
> set_origin=1 set_comment='custome
r tables'
> Jul 27 11:40:27 dbhost slon[48276]: [43-24] WARN remoteWorker_wakeup:

> node 1 - no worker thread
> Jul 27 11:40:27 dbhost slon[48276]: [43-25] CONFIG storeSet: set_id=4
> set_origin=1 set_comment='Temp set to integrate'
> Jul 27 11:40:27 dbhost slon[48276]: [43-26] WARN remoteWorker_wakeup:

> node 1 - no worker thread
>
>
> Is this normal? or is svscan somehow under the impression that slon
> stopped running?
>
> Sven
>


Now the next thing I am noticing is that each time this happens, the
parent pid (of slon) does not change, but another listener is set up? In
the log files, for example I see the following scenario:

Jul 27 15:28:28 slon[46792]: [22-34] DEBUG1 cleanupThread: thread
starts
Jul 27 15:28:28 slon[46792]: [22-35] DEBUG1 remoteListenThread_3
:
connected to ...
Jul 27 15:28:28 slon[46792]: [22-36] DEBUG1 cleanupThread: 0.046
seconds for cleanupEvent()
Jul 27 15:28:28 slon[46792]: [22-37] DEBUG1 cleanupThread: 0.025
seconds for delete logs

Jul 27 15:39:52 slon[46792]: [24-34] DEBUG1 cleanupThread: thread
starts
Jul 27 15:39:52 slon[46792]: [24-35] DEBUG1 remoteListenThread_3
:
connected to ...
Jul 27 15:39:52 slon[46792]: [24-36] DEBUG1 cleanupThread: 0.046
seconds for cleanupEvent()
Jul 27 15:39:52 slon[46792]: [24-37] DEBUG1 cleanupThread: 0.025
seconds for delete logs
Jul 27 15:39:52 slon[46792]: [24-38] DEBUG1 cleanupThread: 0.039
seconds for cleanupEvent()
Jul 27 15:39:52 slon[46792]: [24-39] DEBUG1 cleanupThread: 0.018
seconds for delete logs

Jul 27 15:51:48 slon[46792]: [25-34] DEBUG1 cleanupThread: thread
starts
Jul 27 15:51:48 slon[46792]: [25-35] DEBUG1 remoteListenThread_3
:
connected to ...
Jul 27 15:51:48 slon[46792]: [25-36] DEBUG1 cleanupThread: 0.046
seconds for cleanupEvent()
Jul 27 15:51:48 slon[46792]: [25-37] DEBUG1 cleanupThread: 0.025
seconds for delete logs
Jul 27 15:51:48 slon[46792]: [25-38] DEBUG1 cleanupThread: 0.039
seconds for cleanupEvent()
Jul 27 15:51:48 slon[46792]: [25-39] DEBUG1 cleanupThread: 0.018
seconds for delete logs
Jul 27 15:51:48 slon[46792]: [25-40] DEBUG1 cleanupThread: 0.025
seconds for cleanupEvent()
Jul 27 15:51:48 slon[46792]: [26-41] DEBUG1 cleanupThread: 0.017
seconds for delete logs


and for each "restart" like this (I say restart, although the parent pid
remains the same) the number of "Thread" entries increases ... as if the
supervisor is not aware of the the listener threads (?) -- I am not
entirely familiar with the actual inner workings of slony to know how
this all ties together.

Sven
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com