Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
On 10/20/16 11:10, Rosser Schwarz wrote: On Thu, Oct 20, 2016 at 11:03 AM, Paul Theodoropoulos mailto:p...@anastrophe.com>> wrote: 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?? The delta tables can be found in the bucardo schema, in the databases bucardo is *replicating*, not in its configuration db. rls -- :wq ohduh. Sorry for the list noise! -- Paul Theodoropoulos www.anastrophe.com ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
On Thu, Oct 20, 2016 at 11:03 AM, Paul Theodoropoulos wrote: > 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?? The delta tables can be found in the bucardo schema, in the databases bucardo is *replicating*, not in its configuration db. rls -- :wq ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
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 ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
> I think it might be appropriate to redeploy the syncs from scratch, which > I'll wait to do late night - perhaps over the weekend. Sounds good, keep us posted! You can feel free to use git HEAD, I'm trying to keep it functional. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 signature.asc Description: PGP signature ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
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 ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
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? -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 signature.asc Description: PGP signature ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
Pulled the latest from github, same error. Perhaps I should destroy and redo the sync, it could be some artifact from the postgresql upgrade process. On 10/18/2016 8:27 PM, Paul Theodoropoulos wrote: Hi Greg, 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. On 10/18/2016 8:19 PM, Greg Sabino Mullane wrote: On Mon, Oct 17, 2016 at 12:55:59PM -0700, Paul Theodoropoulos wrote: ... After rebuilding Bucardo for the new os, bucardo runs seemingly fine, except for some peculiar errors in the logs, which I'm not sure how serious they are to the actual replication. How exactly did you rebuild Bucardo? These look like there are some remnants left from the old Bucardo, specifically bucardo_delta_targets. -- Paul Theodoropoulos www.anastrophe.com ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
Hi Greg, 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. On 10/18/2016 8:19 PM, Greg Sabino Mullane wrote: On Mon, Oct 17, 2016 at 12:55:59PM -0700, Paul Theodoropoulos wrote: ... After rebuilding Bucardo for the new os, bucardo runs seemingly fine, except for some peculiar errors in the logs, which I'm not sure how serious they are to the actual replication. How exactly did you rebuild Bucardo? These look like there are some remnants left from the old Bucardo, specifically bucardo_delta_targets. -- Paul Theodoropoulos www.anastrophe.com ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie
On Mon, Oct 17, 2016 at 12:55:59PM -0700, Paul Theodoropoulos wrote: ... > After rebuilding Bucardo for the new os, bucardo runs seemingly fine, except > for some peculiar errors in the logs, which I'm not sure how serious they > are to the actual replication. How exactly did you rebuild Bucardo? These look like there are some remnants left from the old Bucardo, specifically bucardo_delta_targets. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 signature.asc Description: PGP signature ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general