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

Greg Sabino Mullane greg at endpoint.com
Tue Nov 8 03:37:35 UTC 2011

On Mon, Nov 07, 2011 at 04:29:36PM -0700, Brady S Edwards wrote:
> Everything was fine until a large update ~300,000 rows.
> Since then, seems like Bucardo can't quite process all of the rows before
> encountering an error and rolling everything back.

The error has nothing to do with the number of rows, but the failure 
to quote a non-numeric field:

> LINE 1: ...vices WHERE (test_id,serial_number) IN
> ((8526717,S2U4J9KBA0...

That should be ((8526717,'S2U4J9KBA0'...

Could be a bug, but the first thing to do is to check what Bucardo 
thinks is the column type for the serial_number column in that 
table. Try from the command line:

bucardo_ctl list table foobar -verbose -verbose

There should be a pkeytype line there. If that doesn't work, query 
the bucardo database directly with:

SELECT * FROM goat WHERE tablename = 'foobar';

Either way, it should be reporting the first as an int, and the second 
as something else, probably text. If it's an int, change it and see if 
that fixes it. If it's already an int, let us know.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111107/c7d334f0/attachment.bin 

More information about the Bucardo-general mailing list