[Bucardo-general] BYTEA columns not synchronized correctly

Christian Kaltepoth kaltepoth at ingenit.com
Thu Mar 1 15:37:11 UTC 2012

Dear Bucardo team,

first of all thank you for all your work on this great software. I just
started to use Bucardo but I'm really impressed how great everything

But unfortunately we have one major problem. We have on table containing
a BYTEA column that doesn't sync correctly using 'swap' mode. Let me try
to describe the problem.

If we insert a new row into the corresponding table the data looks like


This data is correct. I manually decoded the HEX representation and
confirmed that the data is exactly the data we wrote to the database.

The column is then automatically duplicated to the second host, but on
the second host the data gets messed up. The row on the second host
contains completely different binary data:


We used the psql command line client on both hosts to get this HEX
representation out of the database.

Two things about the broken data is eye catching:

      * The total length of the broken HEX representation on the second
        host is twice as long as the correct HEX representation on the
        first host.
      * The broken data doesn't contain a single letter character (A-F)
        which is very strange for a HEX representation.

Do you have any idea what is causing this?

Some details about my setup.

      * CentOS 6.2 Minimal Install
      * Bucardo 4.4.8
      * PostgreSQL 9.0.7

Thanks for your help



 Dipl.-Inform. Christian Kaltepoth                kaltepoth at ingenit.com
 Senior Developer
 ingenit GmbH & Co. KG                       Tel. +49 (0)231 58 698-168
 Emil-Figge-Strasse 76-80                    Fax. +49 (0)231 58 698-121
 D-44227 Dortmund                                       www.ingenit.com

 Registergericht: Amtsgericht Dortmund, HRA 13 914
 Gesellschafter : Thomas Klute, Marc-Christian Schröer
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 6131 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120301/010c3042/attachment.bin 

More information about the Bucardo-general mailing list