Thanks, tried that. We were able to clear the "stalled" from the status field by using "deactivate sync" and then "activate sync" but the sync still isn't running. Now its status says "active". The only "errors" in the log.bucardo are items similar to this:
"(15358) [Tue Sep 9 15:02:56 2014] MCP Table archive.log_users_logins references configs.admin_users(fk_log_users_logins_userid), which is not part of this sync!" "bucardo validate all" indicates OK for all syncs I can't find the bucardo.warning.log file in the bucardo 5 that I used to have in bucardo 4. Thanks for any ideas! -----Original Message----- From: Michelle Sullivan [mailto:[email protected]] Sent: Tuesday, September 09, 2014 3:06 PM To: Jonathan Brinkman Cc: [email protected] Subject: Re: [Bucardo-general] bucardo 5.1.1 stalled? Jonathan Brinkman wrote: > Greetings > 2 of 3 bucardo 5.1.1 syncs are now "stalled" for 6 hours. No DB > changes have occurred to cause this. We did stop / restart postgresql > service 6 hours ago b/c it was running at 100% for unknown reasons (bucardo is suspected). > > Last error: : Failed : DBD::Pg::db pg_result failed: SSL > connection has been closed unexpectedly at > /usr/local/share/perl/5.14.2/Bucardo.pm line 3620. Line: 5339 Main DB state: > ? Error: none DB client_cms_gate state: 22000 Error: 7 DB > client_cms_main > state: ? Error: none (KID 6328) > > We tried to "activate" the (inactive) sync and to kick it, but no > change in stalled state. > How can we "un-stall" the sync? > > Restart bucardo and read the logs for errors... the current log would indicate the server is not accepting connections from the bucardo client. -- Michelle Sullivan http://www.mhix.org/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
