[Bucardo-general] bucardo 5.1.1 stalled?

[Jonathan Brinkman]

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:michelle at sorbs.net] 
Sent: Tuesday, September 09, 2014 3:06 PM
To: Jonathan Brinkman
Cc: bucardo-general at bucardo.org
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/