[Bucardo-general] Kid Dies When using Syslog for Logging

[Ben Allen]

Greg,

p5-DBD-Pg-2.10.7
p5-DBI-1.60.4

Well I think I might of fixed the kid death issue. I've upgraded to  
Perl 5.8.9 (from 5.8.8), reinstalled all the perl modules I had  
installed, upgraded  plperl to 8.2.11, and upgraded to PostgreSQL  
8.2.11 (from 8.2.9) server (client was already at the version). I  
have syslog and debugfile turned on, and nothing has died in the last  
2 and half hours. I've been doing huge deletes of 9000+ records at a  
time, as well as inserts of similar size. I'm guessing this may be  
able to be racked up to a bug in Perl itself or one of the modules  
(when I was doing the upgrades no Perl modules changed versions, just  
reinstalled). However since I went for the "upgrade everything on the  
system" approach I don't know exactly what change made it work. Any  
guesses?

I'll be doing more extensive testing tomorrow to see if I can get it  
to die.

Lastly, the bug when bucardo_ctl is run without --dbhost still  
exists. Any steps you'd like me to do to track this down?

Ben

On Jan 22, 2009, at 8:48 PM, Greg Sabino Mullane wrote:

>> case2_Syslog_Disabled.txt is from Bucardo's debugfile log with  
>> Syslog turned
>> off. This shows the statements that were run after I disabled  
>> Syslog and kicked
>> the sync that was failing before.
>
> Curious. I checked the code for any controller -> kid leakage, but all
> appears sane. It looks as though two kids are sharing the same  
> database
> handle, somehow. Can you tell me the version of DBI and DBD::Pg you  
> have
> installed? Also, if you could tweak your log_line_prefix in
> postgresql.conf to show the PID, that would help greatly as it would
> show which backends are issuing which query.
>
> -- 
> Greg Sabino Mullane greg at endpoint.com 610-983-9073
> End Point Corporation
> PGP Key: 0x14964AC8
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090122/1476d4fd/attachment.html