[Bucardo-general] bucardo fails to replicate when the column name contains german umlauts

Christian Ritter lnxlists at lownoize.org
Mon Sep 2 13:06:35 UTC 2013


On 2013-09-02 14:34, Michelle Sullivan wrote:
> Christian Ritter wrote:
>>
>> bucardo version is 4.5.0 <-got that from bucardo_ctl
>>
>> -- Schema for the main Bucardo database
>> -- Version 4.5.0
>>
>> The logs are from postgres, and there is no copy in the logs, only 2
>> inserts
>>
>
> Good...  That should make things easier....
>
> What do you get when you do:
>
>                         SELECT    DISTINCT d.rowid AS "BUCARDO_ID",
>                                   t.id ,host_ip,"prüfsumme"
>                         FROM      bucardo.bucardo_delta d
>                         LEFT JOIN public.testtable t ON (t.id::int4 =
> d.rowid::int4)
>                         WHERE     d.tablename = 28039::oid
>                         AND       NOT EXISTS (
>                                         SELECT 1
>                                         FROM   bucardo.bucardo_track 
> bt
>                                         WHERE  d.txntime = bt.txntime
>                                         AND    bt.targetdb = 
> 'testb'::text
>                                         AND    bt.tablename = 
> 28039::oid
>                                   );
>
> on the source (should be one row) and:
>
>
>                         SELECT    DISTINCT d.rowid AS "BUCARDO_ID",
>                                   t.id ,host_ip,"prüfsumme"
>                         FROM      bucardo.bucardo_delta d
>                         LEFT JOIN public.testtable t ON (t.id::int4 =
> d.rowid::int4)
>                         WHERE     d.tablename = 28047::oid
>                         AND       NOT EXISTS (
>                                         SELECT 1
>                                         FROM   bucardo.bucardo_track 
> bt
>                                         WHERE  d.txntime = bt.txntime
>                                         AND    bt.targetdb = 
> 'testa'::text
>                                         AND    bt.tablename = 
> 28047::oid
>                                   );
>
> On the target (should be no rows)?
>
> Then what do you get when you do:
>
> SELECT id::text AS id FROM public.testtable WHERE (id) IN  (1);
>
> on the source?
>
> Also what OS and PostgreSQL version are you using?
>
> Michelle


source:

  BUCARDO_ID | id |   host_ip   | prüfsumme
------------+----+-------------+-----------
  1          |  1 | 192.168.1.1 | foobar
(1 row)


target:

  BUCARDO_ID | id | host_ip | prüfsumme
------------+----+---------+-----------
(0 rows)


source:

testa=# SELECT id::text AS id FROM public.testtable WHERE (id) IN  (1);
  id
----
  1
(1 row)


OS is Ubuntu 12.04 and Postgres is Version 9.1.9, but was the same on 
Slackware 14 and Postgres 9.2.1

Cheers

Christian


More information about the Bucardo-general mailing list