[Bucardo-general] Strange log errors after upgrade Wheezy to Jessie

[Paul Theodoropoulos]

So now I'm concerned, but maybe I'm misunderstanding something - the 
documents, and the bucardo code, make many references to table 
'bucardo_delta'.....but there is no bucardo_delta table listed in the db??

bucardo=# \d
                       List of relations
  Schema  |             Name              |   Type   |  Owner
---------+-------------------------------+----------+---------
  bucardo | bucardo_config                | table    | bucardo
  bucardo | bucardo_custom_trigger        | table    | bucardo
  bucardo | bucardo_custom_trigger_id_seq | sequence | bucardo
  bucardo | bucardo_log_message           | table    | bucardo
  bucardo | bucardo_rate                  | table    | bucardo
  bucardo | clone                         | table    | bucardo
  bucardo | clone_id_seq                  | sequence | bucardo
  bucardo | customcode                    | table    | bucardo
  bucardo | customcode_id_seq             | sequence | bucardo
  bucardo | customcode_map                | table    | bucardo
  bucardo | customcols                    | table    | bucardo
  bucardo | customcols_id_seq             | sequence | bucardo
  bucardo | customname                    | table    | bucardo
  bucardo | customname_id_seq             | sequence | bucardo
  bucardo | db                            | table    | bucardo
  bucardo | db_connlog                    | table    | bucardo
  bucardo | dbgroup                       | table    | bucardo
  bucardo | dbmap                         | table    | bucardo
  bucardo | dbrun                         | table    | bucardo
  bucardo | goat                          | table    | bucardo
  bucardo | goat_id_seq                   | sequence | bucardo
  bucardo | herd                          | table    | bucardo
  bucardo | herdmap                       | table    | bucardo
  bucardo | sync                          | table    | bucardo
  bucardo | syncrun                       | table    | bucardo
  bucardo | upgrade_log                   | table    | bucardo
(26 rows)

I'm kind of thinking my bucardo deployment is completely broken since 
the Jessie upgrade of postgresql from 9.1 to 9.4.

On 10/19/16 08:21, Paul Theodoropoulos wrote:
> Well, what I'm really trying to do is escape the bizarro error. :)
>
> I was running 5.4.1 release from Dec 2015. So last night I downloaded
> the latest from github and built a fresh installation from that.  I'm
> beginning to think that this really is an artifact from the
> OS/postgresql upgrade, not a bucardo issue. e.g. the error snippet I
> forwarded was regarding public_unit_history_78 - there are 100 tables
> iteratively named ...78, 79, 80, etc - but only one table is listed as
> missing from bucardo's delta? Probably broken during the
> pg_upgradecluster from 9.1 to 9.4, I'd imagine.
>
> I think it might be appropriate to redeploy the syncs from scratch,
> which I'll wait to do late night - perhaps over the weekend.
>
>
> On 10/19/2016 7:29 AM, Greg Sabino Mullane wrote:
>> On Tue, Oct 18, 2016 at 08:27:11PM -0700, Paul Theodoropoulos wrote:
>>> I built from the exact same source directory as the original build,
>>> after a
>>> 'make clean'. 5.4.1... perhaps I should download the latest from
>>> github? I
>>> see now that this code I'm using is a year old.
>> Maybe back up a step: what are you trying to do? Upgrade an existing
>> Bucardo installation with a new version of Bucardo? Install Bucardo
>> from scratch?
>>
>

-- 
Paul Theodoropoulos
www.anastrophe.com