[Bucardo-general] Add Sync Error

[Ed Snajder]

So close!! The error related to the variable is resolved, upon adding a sync, I get a new error. I tried tearing everything down, dbs, group, herds and building back up, but it persisted:

# bucardo add sync ec2pk herd=ec2pk dbs=ec2pk
WARNING:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=sbs;host=localhost;port=5435 at line 29.
CONTEXT:  PL/Perl function "validate_sync"
SQL statement "SELECT validate_sync('ec2pk')"
PL/Perl function "validate_sync"
Failed to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::db selectall_arrayref failed: ERROR:  relation "bucardo.bucardo_sequences" does not exist at line 784. at line 30.
CONTEXT:  PL/Perl function "validate_sync" at /usr/bin/bucardo line 4068.

When I saw that, I turned on full query logging on the source database to trap the sequence of creates when building the sync. It only appears to create a few tables and functions, though I don't see any errors that would suggest why it decided not to make them. It looks like it is only creating the bucardo_truncate_trigger and bucardo_truncate_trigger_log tables, and a few functions. After creating the function bucardo_purge_delta(text) function, it goes to look bucardo_sequences and dies. 

I've attached the full query logs from the add sync event for reference. 
Thanks!
Ed
________________________________________
From: Greg Sabino Mullane [greg at endpoint.com]
Sent: Wednesday, April 18, 2012 2:08 PM
To: Ed Snajder
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] Add Sync Error

On Wed, Apr 18, 2012 at 06:09:20AM +0000, Ed Snajder wrote:
> I really appreciate the responses so far!
> I think we're close! It looks like perhaps the variable 'tablename'
> as a similar conflict?

Ha ha! That will teach me to reduce my multi-tasking a bit! Yes, that
was a bad choice of variable name. I've changed it to 'mytable' in commit
a0b01befdc8e0b4404732275e7195f155c69a798.

I don't think this will conflict with anything this time.

--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bucardoaddsyncFQL.log
Type: text/x-log
Size: 257010 bytes
Desc: bucardoaddsyncFQL.log
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120418/7d4e403c/attachment-0001.bin