[Bucardo-general] Replication Error

Aaron Sutula Aaron.Sutula at noaa.gov
Mon May 5 17:19:06 UTC 2008


Ok, I have a little test replication set up. When I make a change in my 
source table, the replication fails and I get the following error in my 
log file:

May  5 17:09:42 venus2 Bucardo[3266]: MCP Got notice 
"bucardo_kick_sync_testsync" from 2796 on db venus2
May  5 17:09:42 venus2 Bucardo[3266]: MCP Sent a kick request to 
controller 3294 for sync "testsync"
May  5 17:09:43 venus2 Bucardo[3294]: CTL Got notice 
"bucardo_ctl_kick_testsync" from 3267
May  5 17:09:43 venus2 Bucardo[3294]: CTL Warning! Controller for 
"testsync" was killed at line 2858: DBD::Pg::st fetchall_arrayref 
failed: no statement executing at 
/usr/lib/perl5/site_perl/5.8.8/Bucardo.pm line 2858.
May  5 17:09:44 venus2 Bucardo[3294]: CTL Warning: Error sending email 
to nobody at example.com: connect to localhost failed (Connection refused) 
connect to localhost failed connect to localhost failed (Connection 
refused) no (more) retries!
May  5 17:09:44 venus2 Bucardo[3294]: CTL Asking kid process 3296 to 
terminate
May  5 17:09:44 venus2 Bucardo[3294]: CTL Controller exiting at 
cleanup_controller. Reason: Killed (line 2858): DBD::Pg::st 
fetchall_arrayref failed: no statement executing at 
/usr/lib/perl5/site_perl/5.8.8/Bucardo.pm line 2858.
May  5 17:09:44 venus2 Bucardo[3296]: KID Warning! Child for "testsync" 
was killed at line 269: Caught a SIGTERM at 
/usr/lib/perl5/site_perl/5.8.8/Bucardo.pm line 3674
May  5 17:09:44 venus2 Bucardo[3266]: MCP Could not find controller 
3294, will create a new one. Kicked is 0
May  5 17:09:44 venus2 Bucardo[3266]: MCP Checking for existing 
controllers for sync "testsync"
May  5 17:09:44 venus2 Bucardo[3331]: CTL Controller starting for sync 
"testsync". Source herd is "mobile"
May  5 17:09:44 venus2 Bucardo[3331]: CTL   database: mars2 
synctype:pushdelta stayalive:1 checksecs:600 
May  5 17:09:44 venus2 Bucardo[3331]: CTL   limitdbs:0 kicked:0 
kidsalive:1 triggers: pg_class
May  5 17:09:44 venus2 Bucardo[3266]: MCP Created controller 3331 for 
sync "testsync". Kick is 0
May  5 17:09:44 venus2 Bucardo[3331]: CTL Listening for 
"bucardo_ctl_kick_testsync"
May  5 17:09:44 venus2 Bucardo[3331]: CTL   Herd member 98646: public.z
May  5 17:09:44 venus2 Bucardo[3331]: CTL     Target oids: mars2:16393
May  5 17:09:44 venus2 Bucardo[3331]: CTL Changed lastheardfrom 
1210007384 to 1210007385
May  5 17:09:44 venus2 Bucardo[3331]: CTL Created new kid 3333 for sync 
"testsync"
May  5 17:09:44 venus2 Bucardo[3333]: KID New kid, syncs "venus2" to 
"mars2" for sync "testsync" alive=1 Parent=3331
May  5 17:09:44 venus2 Bucardo[3333]: KID Nothing to do: no entry found 
in the q table for this sync
May  5 17:09:45 venus2 Bucardo[3296]: KID Warning: Error sending email 
to nobody at example.com: connect to localhost failed (Connection refused) 
connect to localhost failed connect to localhost failed (Connection 
refused) no (more) retries!

I also get a perl error in the terminal in which I started Bucardo:

DBI::db=HASH(0x9872464)->disconnect invalidates 1 active statement 
handle (either destroy statement handles or call finish on them before 
disconnecting) at /usr/lib/perl5/site_perl/5.8.8/Bucardo.pm line 2984.

Any idea what is going wrong?

Thank you,
Aaron



More information about the Bucardo-general mailing list