[Bucardo-general] Bucardo version 4.4.6 on Centos 4.7, Postgres 9.0.2 appears to be broken working on a very large bucardo_delta file.

[Brady S Edwards]

The perl version is 5.8.5

On Mon, Nov 7, 2011 at 4:24 PM, Itamar Reis Peixoto <itamar at ispbrasil.com.br
> wrote:

> On Mon, Nov 7, 2011 at 9:11 PM, Brady S Edwards
> <brady.s.edwards at seagate.com> wrote:
> > I have almost 500,000 rows in the bucardo_delta file.
> > In the log file it looks like a new kid is started and then 4 hours later
> > the kid dies while working on all of the rows with an error like:
> >
> > [Mon Nov  7 13:57:03 2011]  KID Action summary: 1:311572 2:11383
> > DBI::db=HASH(0x1469650)->disconnect invalidates 5 active statement
> handles
> > (either destroy statement handles or call finish on them before
> > disconnecting) at /usr/lib/perl5/site_perl/5.8.5/Bucardo.pm line 3581.
> > DBI::db=HASH(0x14752b0)->disconnect invalidates 5 active statement
> handles
> > (either destroy statement handles or call finish on them before
> > disconnecting) at /usr/lib/perl5/site_perl/5.8.5/Bucardo.pm line 3582.
> > [Mon Nov  7 13:57:07 2011]  KID Final database backend PID is 15118
> > [Mon Nov  7 13:57:07 2011]  KID Kid exiting at cleanup_kid. Reason:
> > DBD::Pg::db selectall_arrayref failed: ERROR:  column "s2u4j9kba00089"
> does
> > not exist
> > LINE 1: ...vices WHERE (test_id,serial_number) IN
>  ((8526717,S2U4J9KBA0...
> >                                                              ^ at
> > /usr/lib/perl5/site_perl/5.8.5/Bucardo.pm line 5677.
> >  main error: none source error: 7 target error: none States:/42703/
> > The error says that column "s2u4j9kba00089" doesn't exist, and it
> doesn't.
> > "s2u4j9kba00089" is a value in the touple being replicated.
> > Any help would be greatly appreciated.
> > Thanks
> > --
> > Brady Edwards
> > (720) 684-2984
> > Seagate Technology
>
> seems to be a bug in bucardo, your postgresql version are ok, and your
> bucardo version seems to be ok, but you're using a very old centos, I
> don't know if this bug is related to old perl, I recommend you to ask
> Greg about this.
>
>
>
>
>
> --
> ------------
>
> Itamar Reis Peixoto
> msn, google talk: itamar at ispbrasil.com.br
> +55 11 4063 5033 (FIXO SP)
> +55 34 9158 9329 (TIM)
> +55 34 8806 3989 (OI)
> +55 34 3221 8599 (FIXO MG)
>



-- 
Brady Edwards
(720) 684-2984
Seagate Technology
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111107/ec91d054/attachment.html