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

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111107/e9d9c554/attachment-0001.html