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

Alex Balashov abalashov at evaristesys.com
Mon Sep 2 08:36:25 UTC 2013


That's really odd.  Are Perl strings not 8-bit clean by default?  I 
wouldn't have thought...

On 09/02/2013 04:33 AM, Christian Ritter wrote:

> Hello,
>
> i have a really strange problem with bucardo and german umlauts.
> If you have a table where a column name contains german umlauts bucardo
> is unable to replicate the data.
>
> Bucardo version is 4.5.0 and postgres version is 9.1.9 or 9.2.1
>
> If you create a table like that on both databases:
>
> CREATE TABLE testtable
> (
>     id integer primary key,
>      host_ip inet NOT NULL,
>     prüfsumme character varying(255) NOT NULL
> );
>
>
> and then add some data to that table, like:
>
> INSERT INTO testtable VALUES (1, '192.168.1.1', 'foobar');
>
>
> bucardo fails to replicate it and you get an error:
>
> KID [1/1] public.testtable INSERT source to target pk 1
> KID Warning! Aborting due to exception for public.testtable.id: 1 Error
> was DBD::Pg::st execute failed: ERROR:  null value in column "prüfsumme"
> violates not-null constraint at /root/perl5/lib/perl5/Bucardo.pm line 5769.
> KID Final database backend PID is 10758
>
> It looks like bucardo tries to insert NULL and not foobar into the
> column called "prüfsumme" which of course breaks the NOT NULL constraint.
>
>
>
> complete log of db creation and bucardo install is here:
> http://pastebin.com/Q8KV06jA
>
> log.bucardo could be found here:
> http://pastebin.com/TyCbn8mz
>
> Cheers
>
> Christian
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general


-- 
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/


More information about the Bucardo-general mailing list