[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