[Bucardo-general] Bucardo import problem

[Greg Sabino Mullane]

On 01/19/2010 06:58 AM, Vilem Kebrt wrote:
> Hello greg,
> i have problem with bucardo:
> 
> scheme: DB1 - master - swap - DB2 - master
> we have imported data from old db system to DB1 with sync running to DB1.
> we get this err:
>  KID Warning! Aborting due to exception for public.radcheck.id: 1009
> Error was DBD::Pg::st execute failed: ERROR:  null value in column
> "userId" violates not-null constraint at
> /usr/local/share/perl/5.10.0/Bucardo.pm line 5716.
> which is absolutely nonsence, because there is not NULL value (neither
> 0) in that column.
> Any idea ?

The Postgres logs should show you the exact command that was attempted,
but it looks to me as though you might have a schema mismatch between
the servers? Compare public.radcheck on both servers and make sure
everything is identical.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100119/9dfe3531/attachment.bin