[Bucardo-general] add sync error
John Powell
john.powell at emapsite.com
Fri Dec 16 14:00:10 UTC 2011
Hi,
I am getting an error when trying to add a sync
./bucardo add sync ei2_sync herd=ei2_config_herd dbs=ei2_config_group
WARNING: Issuing rollback() due to DESTROY without explicit
disconnect() of DBD::Pg::db handle
dbname=ei2;host=trime.internal.emapsite.com at line 383.
CONTEXT: PL/Perl function "validate_sync"
SQL statement "SELECT validate_sync('ei2_sync')"
PL/Perl function "validate_sync"
Failed to add sync: DBD::Pg::st execute failed: ERROR: DBD::Pg::st
execute failed: ERROR: column "sync" does not exist
LINE 1: ...bucardo.bucardo_delta_targets WHERE tablename=$1 AND sync=$2
^ at
line 383. at line 30.
CONTEXT: PL/Perl function "validate_sync" at ./bucardo line 4157.
bucardo list dbgroup and bucardo list herd both return correct values as
listed in add sync above and goat, herd, herdmap, dbgroup tables all
have what look like correct values from the bucardo add db, table and
dbgroup operations.
Thanks.
John
On 16/12/2011 13:00, bucardo-general-request at bucardo.org wrote:
> Send Bucardo-general mailing list submissions to
> bucardo-general at bucardo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
> or, via email, send a message with subject or body 'help' to
> bucardo-general-request at bucardo.org
>
> You can reach the person managing the list at
> bucardo-general-owner at bucardo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Bucardo-general digest..."
>
>
> Today's Topics:
>
> 1. how to tell the different about pushdelta and swap in
> Bucardo5? (Yan Chunlu)
> 2. Re: how to tell the different about pushdelta and swap in
> Bucardo5? (Yan Chunlu)
> 3. bucardo5 received unknown message error (Yan Chunlu)
> 4. Re: bucardo5 received unknown message error (Yan Chunlu)
> 5. Re: bucardo5 received unknown message error (Yan Chunlu)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 16 Dec 2011 15:19:55 +0800
> From: Yan Chunlu<springrider at gmail.com>
> Subject: [Bucardo-general] how to tell the different about pushdelta
> and swap in Bucardo5?
> To: bucardo-general at bucardo.org
> Message-ID:
> <CAOA66tFHE6AJCB63v2YWW3dPDRJD8dYLzK0c4PRebWy4R7-acQ at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> I am using master-master feature, but just curious since Bucardo5 has
> no sync type, the default seems to be
>
> just tried Bucardo5 on test environment, and when I insert record on
> master db B, it does replicate the record to master db A. but the
> bucardo status shows the record has been deleted:
>
> PID of Bucardo MCP: 16271
> Name State Last good Time Last I/D Last bad Time
> =============+========+============+=======+===========+===========+=======
> bejing2sync | Good | 00:58:45 | 6s | 0/380 | none |
>
>
> I added sync using the follow command:
>
> bucardo add sync bejing2sync herd=testherd
> dbs=washingtondj,beijing2dj ping=false
>
> and kick it manually
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 16 Dec 2011 15:37:21 +0800
> From: Yan Chunlu<springrider at gmail.com>
> Subject: Re: [Bucardo-general] how to tell the different about
> pushdelta and swap in Bucardo5?
> To: bucardo-general at bucardo.org
> Message-ID:
> <CAOA66tFm74ijE28HDN+xwBfnzPeQs98ymt_Dpw14cMNJ5WtDoA at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> figured it out, I should add :source or :target while adding sync.
>
>
> but still dont understand why bucardo status shows Delete after
> inserted records.
>
> On Fri, Dec 16, 2011 at 3:19 PM, Yan Chunlu<springrider at gmail.com> wrote:
>> I am using master-master feature, but just curious since Bucardo5 has
>> no sync type, the default seems to be
>>
>> just tried Bucardo5 on test environment, and when I insert record on
>> master db B, it does replicate the record to master db A. but the
>> bucardo status shows the record has been deleted:
>>
>> PID of Bucardo MCP: 16271
>> ?Name ? ? ? ? ?State ? ?Last good ? ?Time ? ?Last I/D ? ?Last bad ? ?Time
>> =============+========+============+=======+===========+===========+=======
>> ?bejing2sync | Good ? | 00:58:45 ? | 6s ? ?| 0/380 ? ? | none ? ? ?|
>>
>>
>> I added sync using the follow command:
>>
>> bucardo add sync bejing2sync herd=testherd
>> dbs=washingtondj,beijing2dj ?ping=false
>>
>> and kick it manually
>
> ------------------------------
>
> Message: 3
> Date: Fri, 16 Dec 2011 16:30:19 +0800
> From: Yan Chunlu<springrider at gmail.com>
> Subject: [Bucardo-general] bucardo5 received unknown message error
> To: bucardo-general at bucardo.org
> Message-ID:
> <CAOA66tHGSRifbfJo1LqofiqY-cvRhSHHswT0e=ZNfPuDWgXhNg at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> first I download Bucardo4.99.2 from
> http://bucardo.org/downloads/Bucardo-4.99.2.tar.gz
>
> I got the "unknown message" error. then I guess it's been fixed so I
> use ""git clone git://bucardo.org/bucardo.git/" to get the latest
> code, which is 4.99.3
>
> after bucardo upgrade and bucardo validate, I still get the errors.....
> it seems has something to do with postgresql9.0's listen/notify
> feature? I am using postgresql 9.0.4 on both side.
>
>
>
> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
> message stop_sync_bejing2sync from 5226!
> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
> message stop_sync_bejing2syncswap from 5222!
> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
> message stop_sync_newswap from 5224!
> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
> message stop_sync_newswap1 from 5225!
> (5251) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
> message stop_sync_bejing2syncswap from 5222!
> (5251) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
> message stop_sync_newswap from 5224!
> (5253) [Fri Dec 16 16:26:27 2011] KID Warning: received unknown
> message stop_sync_bejing2syncswap from 5222!
> (5253) [Fri Dec 16 16:26:27 2011] KID Warning: received unknown
> message stop_sync_newswap from 5224!
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 16 Dec 2011 19:01:23 +0800
> From: Yan Chunlu<springrider at gmail.com>
> Subject: Re: [Bucardo-general] bucardo5 received unknown message error
> To: bucardo-general at bucardo.org
> Message-ID:
> <CAOA66tEfOV4Pt=vEWB8=g=3v=k03iJAeSxhuDWjHLLyviw9Jeg at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> there are four places has "Warning: received unknown message", after
> add some logs, I believe it is the one on line 2660 in 4.99.3 version.
>
> in the block ## Begin the main KID loop
>
> On Fri, Dec 16, 2011 at 4:30 PM, Yan Chunlu<springrider at gmail.com> wrote:
>> first I download Bucardo4.99.2 from
>> http://bucardo.org/downloads/Bucardo-4.99.2.tar.gz
>>
>> I got the "unknown message" error. then I guess it's been fixed so I
>> use ""git clone git://bucardo.org/bucardo.git/" ?to get the latest
>> code, which is 4.99.3
>>
>> after bucardo upgrade and bucardo validate, I still get the errors.....
>> it seems has something to do with postgresql9.0's listen/notify
>> feature? ?I am using postgresql 9.0.4 on both side.
>>
>>
>>
>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>> message stop_sync_bejing2sync from 5226!
>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>> message stop_sync_bejing2syncswap from 5222!
>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>> message stop_sync_newswap from 5224!
>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>> message stop_sync_newswap1 from 5225!
>> (5251) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>> message stop_sync_bejing2syncswap from 5222!
>> (5251) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>> message stop_sync_newswap from 5224!
>> (5253) [Fri Dec 16 16:26:27 2011] KID Warning: received unknown
>> message stop_sync_bejing2syncswap from 5222!
>> (5253) [Fri Dec 16 16:26:27 2011] KID Warning: received unknown
>> message stop_sync_newswap from 5224!
>
> ------------------------------
>
> Message: 5
> Date: Fri, 16 Dec 2011 19:25:34 +0800
> From: Yan Chunlu<springrider at gmail.com>
> Subject: Re: [Bucardo-general] bucardo5 received unknown message error
> To: bucardo-general at bucardo.org
> Message-ID:
> <CAOA66tEDrj3RXrnhg9SMbhkvJ5uX05AukAg3-wDXR7FGEhJ+dQ at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> the stopsync message was at line 2660.
>
> later I also got ""VAC Warning: received3 unknown message
> syncdone_newswap1 from 31112!
>
> which is at line: 6256
>
>
>
>
>
> and whenever I kick the sync, it just does nothing. nothing showed in
> the log file, and nothing changed in "bucardo status"
>
> how ever master-slave works fine, even with this warning.
>
> On Fri, Dec 16, 2011 at 7:01 PM, Yan Chunlu<springrider at gmail.com> wrote:
>> there are four places has "Warning: received unknown message", after
>> add some logs, I believe it is the one on line 2660 in 4.99.3 version.
>>
>> in the block ? ## Begin the main KID loop
>>
>> On Fri, Dec 16, 2011 at 4:30 PM, Yan Chunlu<springrider at gmail.com> wrote:
>>> first I download Bucardo4.99.2 from
>>> http://bucardo.org/downloads/Bucardo-4.99.2.tar.gz
>>>
>>> I got the "unknown message" error. then I guess it's been fixed so I
>>> use ""git clone git://bucardo.org/bucardo.git/" ?to get the latest
>>> code, which is 4.99.3
>>>
>>> after bucardo upgrade and bucardo validate, I still get the errors.....
>>> it seems has something to do with postgresql9.0's listen/notify
>>> feature? ?I am using postgresql 9.0.4 on both side.
>>>
>>>
>>>
>>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>>> message stop_sync_bejing2sync from 5226!
>>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>>> message stop_sync_bejing2syncswap from 5222!
>>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>>> message stop_sync_newswap from 5224!
>>> (5232) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>>> message stop_sync_newswap1 from 5225!
>>> (5251) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>>> message stop_sync_bejing2syncswap from 5222!
>>> (5251) [Fri Dec 16 16:26:23 2011] KID Warning: received unknown
>>> message stop_sync_newswap from 5224!
>>> (5253) [Fri Dec 16 16:26:27 2011] KID Warning: received unknown
>>> message stop_sync_bejing2syncswap from 5222!
>>> (5253) [Fri Dec 16 16:26:27 2011] KID Warning: received unknown
>>> message stop_sync_newswap from 5224!
>
> ------------------------------
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>
> End of Bucardo-general Digest, Vol 51, Issue 13
> ***********************************************
More information about the Bucardo-general
mailing list