[Bucardo-general] Problem with dropped columns
Gustavo Tonini
gustavotonini at gmail.com
Tue Jan 12 00:01:49 UTC 2016
Hello everyone,
I'm getting the following error in bucardo 4.99.5-1 (Debian 7)
(25918) [Mon Jan 11 15:01:16 2016] KID Warning! Aborting due to exception
for public.nfi:? Error was DBD::Pg::db pg_putcopyend failed: ERROR: extra
data after last expected column\nCONTEXT: COPY nfi, line 1: "4000077321758
4000077321750 14753 2 PC 1.0000 1.5660 111.7500
110.000000 110.00 0.0000 1.7500 110.00..." at
/usr/share/perl5/Bucardo.pm line 8669.
I've already checked table structure in all nodes and it is identical, but
some nodes have dropped columns in pg_attribute catalog. For example:
db=# select attname from pg_attribute where attrelid in (select oid from
pg_class where relname='nfi') and attisdropped;
attname
--------------------------------
........pg.dropped.139........
........pg.dropped.140........
(2 rows)
My temporary solution is removing the table from the sync. Does anybody
have any clue? Are dropped columns causing the problem?
Gustavo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160111/52a3e225/attachment.html>
More information about the Bucardo-general
mailing list