[Bucardo-general] 'type "int_unsigned" does not exist' error when creating sync

[Bill McGonigle]

Hi,

I'm trying to set up a new bucardo instance (for a drupal install in 
this case) and when I go to add the sync, I'm getting an error:

> # bucardo_ctl add sync drupal_left type=swap source=community_herd targetdb=drupal_right
> NOTICE:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=drupal;host=<this-host's-ip>;port=5432 at line 29.
>
> CONTEXT:  SQL function "validate_sync" statement 1
> SQL statement "SELECT validate_sync('drupal_left')"
> Failed to add sync: DBD::Pg::st execute failed: ERROR:  error from Perl trigger function: error from Perl function: DBD::Pg::db do failed: ERROR:  type "int_unsigned" does not exist at line 787. at line 30. at /usr/sbin/bucardo_ctl line 3346.

I get the same thing if I try the SQL by hand:

> bucardo=# INSERT INTO sync(name,source,targetdb,synctype,checktime) VALUES ('drupal_left','community_herd','drupal_right','swap','10 minutes');
> ERROR:  error from Perl trigger function: error from Perl function: DBD::Pg::db do failed: ERROR:  type "int_unsigned" does not exist at line 787. at line 30.

It sounds like DBD::Pg doesn't know about the int_unsigned data type 
from the message, but that doesn't seem right.  It's the same version 
that's current on CPAN.  Looking in my goats, I see several instances of 
int_unsigned as the pkeytype.

I thought perhaps somebody here may have run into something like this 
before.

software versions (using packaged versions on CentOS):

# rpm -q postgresql-server bucardo perl-DBD-Pg perl-DBIx-Safe
  postgresql-server-8.1.21-1.el5_5.1
  bucardo-4.4.0-2.el5
  perl-DBD-Pg-2.17.1-1.el5.rf
  perl-DBIx-Safe-1.2.5-6.el5

Thanks,
-Bill
-- 
Bill McGonigle, Owner
BFC Computing, LLC
http://bfccomputing.com/
Telephone: +1.603.448.4440
Email, IM, VOIP: bill at bfccomputing.com
VCard: http://bfccomputing.com/vcard/bill.vcf
Social networks: bill_mcgonigle/bill.mcgonigle