[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.

Itamar Reis Peixoto itamar at ispbrasil.com.br
Mon Nov 7 23:24:50 UTC 2011


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)


More information about the Bucardo-general mailing list