Christian Storm storm at iparadigms.com
Wed Jun 10 15:19:42 PDT 2009
Will this go into 2.1?


>   4. Re: Slony bug and patch proposal (Jan Wieck)
>
>
> Message: 4
> Date: Wed, 10 Jun 2009 11:04:08 -0400
> From: Jan Wieck <JanWieck at Yahoo.com>
> Subject: Re: [Slony1-general] Slony bug and patch proposal
> To: "Oleg A. Mamontov" <oleg at mamontov.net>
> Cc: slony1-general at lists.slony.info
> Message-ID: <4A2FCB68.8030001 at Yahoo.com>
> Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed
>
> On 6/1/2009 5:07 AM, Oleg A. Mamontov wrote:
> > Hello!
> >
> > I am using it on FreeBSD systems for moving PostgreSQL databases between
> > servers with minimum downtime, all works fine.
> > But when I try to setup permanent master-slave schema some problems
> > occured.
> > Some times (accidentally) master system didn't generate sync events,
> > and shutting down
> > slon on master systems had long time.
> > After debugging session, i found cause of problem (there is two
> > problem, Slony and FreeBSD too).
> > IMHO there is a logical mistake in slon/scheduler.c, in sched_mainloop
> > fdsets copied
> > for select before checking connections for their timeouts. In timeout
> > case this
> > descriptors will be removed with DLLIST_REMOVE and sched_remove_fdset,
> > but stayed in
> > select descriptors bit vector.
> > There is a race condition: scheduler and libpq client polls same file
> > descriptor and sometime
> > scheduler select discover readable descriptor and lipbq poll blocks
> > for infinte time :(
> > I tested this on FreeBSD 7.0, trouble repeated in ~60% runs.
> > I attach a patch, please, take a look on this code, it seems right,
> > imho...
>
> No need for a test case, Chris. A quick look at the code reveals that
> Oleg is indeed right.
>
> Patch applied.
>
> Good work, thank you.
>
>
> Jan
>
> --
> Anyone who trades liberty for security deserves neither
> liberty nor security. -- Benjamin Franklin
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090610/=
06f0249a/attachment.htm


More information about the Slony1-general mailing list