[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