[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