[Bucardo-general] bucardo_ctl upgrade doesn't create syncrun table and other problems with upgrade

[Adam Wendt]

I did get upgrade to run and then to get validate all to run I had to
rename the bucardo_delta_targets.targetdb column to 'target'. Then
validate all ran correctly. But now when I start bucardo it finds no
delta entries because the triggers are still inserting into the old
bucardo_delta table and not the new per-table delta tables.

So somehow I need to get the triggers to insert to the per table delta
tables, but I also need bucardo to sync the old bucardo_delta entries
first, thoughts?

On Wed, May 25, 2011 at 2:53 PM, Adam Wendt <thelsdj at gmail.com> wrote:
> Going over the schema and what I have in my database it seems that on
> the sync table 'source' became 'herd' and 'target' became 'dbs'? This
> was also not fixed by an 'upgrade'
>
> Anything else I have to be careful to manually fix upgrading from such
> an old version?
>
> On Wed, May 25, 2011 at 2:43 PM, Adam Wendt <thelsdj at gmail.com> wrote:
>> I'm trying to upgrade an old version of bucardo and when I run
>> bucardo_ctl upgrade it tries to add columns to the syncrun table which
>> doesn't exist. Also I tried creating it manually and dbrun didn't
>> exist either. Now bucardo_ctl upgrade ran but when I try to run
>> bucardo_ctl validate all I get:
>>
>> $ bucardo_ctl validate all
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8032.
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8034.
>> Use of uninitialized value $dbs in hash element at
>> /usr/bin/bucardo_ctl line 8036.
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8032.
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8034.
>> Use of uninitialized value $dbs in hash element at
>> /usr/bin/bucardo_ctl line 8036.
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8032.
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8034.
>> Use of uninitialized value $dbs in hash element at
>> /usr/bin/bucardo_ctl line 8036.
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8032.
>> Use of uninitialized value $sherd in hash element at
>> /usr/bin/bucardo_ctl line 8034.
>> Use of uninitialized value $dbs in hash element at
>> /usr/bin/bucardo_ctl line 8036.
>> Validating sync <mysyncname>...WARNING:  Use of uninitialized value
>> $herd in substitution (s///) at line 32.
>> CONTEXT:  PL/Perl function "validate_sync"
>> WARNING:  Use of uninitialized value $herd in concatenation (.) or
>> string at line 33.
>> CONTEXT:  PL/Perl function "validate_sync"
>> WARNING:  Use of uninitialized value $herd in concatenation (.) or
>> string at line 36.
>> CONTEXT:  PL/Perl function "validate_sync"
>> DBD::Pg::st execute failed: ERROR:  No such herd:  at line 36.
>> CONTEXT:  PL/Perl function "validate_sync" at /usr/bin/bucardo_ctl line 2071.
>>
>> Thoughts?
>>
>> Thanks,
>>
>> Adam Wendt
>> Ace Hosting LLC
>>
>