[Bucardo-general] debugging KID SQL errors

[Bill McGonigle]

Hi, all, 

I'm attempting to install a new bucardo instance.  In the logs, I see bucardo finding new swap kids, but then:

Sep 27 20:20:45 database3 Bucardo[12576]: KID Kid exiting at cleanup_kid. Reason: DBD::Pg::st execute failed: ERROR:  schema "bucardo" does not exist at /usr/lib/perl5/vendor_perl/5.8.8/Bucardo.pm line 4433.  main error: none source error: 7 target error: none States:/3F000/ 

Sep 27 20:20:45 database3 Bucardo[12575]: KID Kid exiting at cleanup_kid. Reason: DBD::Pg::st execute failed: ERROR:  syntax error at or near "," at character 89 at /usr/lib/perl5/vendor_perl/5.8.8/Bucardo.pm line 4433.  main error: none source error: 7 target error: none States:/42601/ 

I feel like I must have missed something obvious here - for the first one, I can connect via psql as 'bucardo' and \dn and see the bucardo schema.

For the second one, I'd like to figure out what's going on here, but I'm not sure how to do that.  It looks like there's some invalid SQL being thrown.  I suspect I must have a bad character in my SQL or something, but I haven't figured out how to see the offending SQL statement.

I tried using DBI_TRACE and matching up to Bucardo.pm, but it looks like things were happening asynchronously to the code, or at least I couldn't follow it.

Any suggestions on how to debug?

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