[Bucardo-general] Sync not working or finding records 4.99 postgres 9.1

Fri Nov 18 18:24:40 UTC 2011

Doesn't seem like it:
$ bucardo kick plonedbgroup1sync 0
Kick plonedbgroup1sync: [240 s]
Postgres log:

2011-11-18 16:54:28 UTC LOG:  Starting validate_sync for plonedbgroup1sync
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC STATEMENT:  INSERT INTO bucardo.sync
(dbs,herd,name,ping) VALUES ($1,$2,$3,$4)
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 280.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 315.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 351.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 432.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 456.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 477.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 621.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 749.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC WARNING:  Use of "goto" to jump into a
construct is deprecated at line 786.
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC LOG:  Ending validate_sync for plonedbgroup1sync
2011-11-18 16:54:28 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:54:28 UTC STATEMENT:  INSERT INTO bucardo.sync
(dbs,herd,name,ping) VALUES ($1,$2,$3,$4)
2011-11-18 16:56:08 UTC LOG:  Starting validate_sync for plonedbgroup1sync
2011-11-18 16:56:08 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:56:08 UTC STATEMENT:  INSERT INTO bucardo.sync
(dbs,herd,name) VALUES ($1,$2,$3)
2011-11-18 16:56:08 UTC LOG:  Ending validate_sync for plonedbgroup1sync
2011-11-18 16:56:08 UTC CONTEXT:  PL/Perl function "validate_sync"
	SQL statement "SELECT validate_sync('plonedbgroup1sync')"
	PL/Perl function "validate_sync"
2011-11-18 16:56:08 UTC STATEMENT:  INSERT INTO bucardo.sync
(dbs,herd,name) VALUES ($1,$2,$3)
2011-11-18 18:05:32 UTC LOG:  unexpected EOF on client connection
2011-11-18 18:08:30 UTC LOG:  unexpected EOF on client connection

The two EOF's are from me killing the kick.
log.bucardo:

(1794) [Fri Nov 18 18:18:44 2011] MCP Starting Bucardo version 4.99.3
(1794) [Fri Nov 18 18:18:44 2011] MCP Log level: verbose

I used the following to set up bucardo:

sudo su bucardo
bucardo set reason_file=/tmp/bucardo.restart.reason.log
bucardo set default_email_from=fromhere at wildcardcorp.com
bucardo set default_email_host=10.0.x.x
bucardo set default_email_to=tothere at wildcardcorp.com

bucardo status

bucardo add db plonedb1 addallsequences dbname=plonedb1 host=127.0.0.1
group=plone user=bucardo pass=passwordhere
bucardo add db plonedb2 addallsequences dbname=plonedb1
host=10.0.250.x group=plone user=bucardo pass=passwordhere

bucardo list dbs

bucardo add table public.blob_chunk public.object_ref
public.current_object  public.object_refs_added public.object_state
public.pack_object public.pack_state public.pack_state_tid
public.transaction herd=ploneherd

bucardo add dbgroup plonedbgroup1 plonedb1:source plonedb2:target
bucardo add sync plonedbgroup1sync herd=ploneherd dbs=plonedbgroup1 ping=true
bucardo start
bucardo status
bucardo kick plonedbgroup1sync
bucardo status

Talin

http://cdig.me  -  http://www.wildcardcorp.com
Domain Registration - DNS - IPv6 - Email & Web Hosting
We do it all for you

On Fri, Nov 18, 2011 at 11:57 AM, Greg Sabino Mullane <greg at endpoint.com> wrote:
>
> > WARNING:  Use of "goto" to jump into a construct is deprecated at line 280.
>
> Ah, yes, we will have to work around that. Should only be a warning though.
>
> > bucardot$ bucardo kick plonedbgroup1sync
> > Kicked sync plonedbgroup1sync
>
> Try kick plonedbgroup1sync 0
>
> Does it ever return?
>
> > The reloading sync just stays there for hours on end.  Any ideas ?
>
> See what the log.bucardo file or the Postgres logs say, they should
> show you where things dies or got stalled.
>
>
> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8