[Bucardo-general] Bucardo-general Digest, Vol 62, Issue 10

Fri Nov 9 14:17:57 UTC 2012

There is no question Bucardo is stopping and not restarting without manual
intervention. I'm thinking about creating a bash script that restarts
bucardo if the latest log record in log.bucardo is dated longer than, say,
10 minutes ago. I'd hoped not to have to do that.

Using 4.4.8

Yesterday at 5:21PM is the last entry in the bucardo.warning.log
	[Thu Nov  8 15:00:19 2012]  CTL Warning! Kid 1410 seems to have
died. Sync "vog_pushdelta_cms_replication"
	[Thu Nov  8 16:20:15 2012]  KID Kid exiting at cleanup_kid. Reason:
DBD::Pg::db do failed: ERROR:  could not serialize access due to concurrent
update at /usr/local/share/perl/5.10.1/Buc$
 	main error: none source error: none target error: 7 States://40001
	[Thu Nov  8 16:20:20 2012]  CTL Warning! Kid 11959 seems to have
died. Sync "vog_pushdelta_cms_replication"

The log.bucardo file seems to indicate it gave up. Here are the last
entries, ending yesterday at 5:21PM (16 hrs ago)
	[Thu Nov  8 17:12:13 2012]  KID Final database backend PID is 17499
	[Thu Nov  8 17:12:13 2012]  KID Kid exiting at cleanup_kid. Reason:
DBI connect('dbname=vog_cms_gate;port=5432;host=10.0.1.38','bucardo',...)
failed: 		could not connect to server: No route to host
        	Is the server running on host "10.0.1.38" and accepting
        	TCP/IP connections on port 5432? at
/usr/local/share/perl/5.10.1/Bucardo.pm line 267
	[Thu Nov  8 17:12:13 2012]  KID Removed pid file
"/var/run/bucardo/bucardo.kid.sync.cmsvog_pushdelta_main_to_gate.cmsvog_gate
.pid"
	[Thu Nov  8 17:12:22 2012]  CTL Warning! Kid 17496 seems to have
died. Sync "cmsvog_pushdelta_main_to_gate"
	[Thu Nov  8 17:16:16 2012]  KID Final database backend PID is 17638
	[Thu Nov  8 17:16:16 2012]  KID Kid exiting at cleanup_kid. Reason:
Ping failed for source database cmsvog_replication
	[Thu Nov  8 17:16:16 2012]  KID Removed pid file
"/var/run/bucardo/bucardo.kid.sync.vog_pushdelta_cms_replication.cmsvog_main
.pid"
	[Thu Nov  8 17:16:21 2012]  CTL Warning! Kid 15697 seems to have
died. Sync "vog_pushdelta_cms_replication"

-----Original Message-----
From: bucardo-general-bounces at bucardo.org
[mailto:bucardo-general-bounces at bucardo.org] On Behalf Of
bucardo-general-request at bucardo.org
Sent: Wednesday, November 07, 2012 7:00 AM
To: bucardo-general at bucardo.org
Subject: Bucardo-general Digest, Vol 62, Issue 10

Send Bucardo-general mailing list submissions to
	bucardo-general at bucardo.org

To subscribe or unsubscribe via the World Wide Web, visit
	https://mail.endcrypt.com/mailman/listinfo/bucardo-general
or, via email, send a message with subject or body 'help' to
	bucardo-general-request at bucardo.org

You can reach the person managing the list at
	bucardo-general-owner at bucardo.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Bucardo-general digest..."

Today's Topics:

   1. bucardo time-out setting? (Jonathan Brinkman)
   2. Re: bucardo time-out setting? (Greg Sabino Mullane)

----------------------------------------------------------------------

Message: 1
Date: Tue, 6 Nov 2012 08:16:30 -0500
From: "Jonathan Brinkman" <jb at blackskytech.com>
To: <bucardo-general at bucardo.org>
Subject: [Bucardo-general] bucardo time-out setting?
Message-ID: <001501cdbc20$efcfc9c0$cf6f5d40$@com>
Content-Type: text/plain; charset="us-ascii"

I have Bucardo running at a client site where the connection between the
local server and cloud server is unreliable due to Comcast being lousy there
(it could be the POS router they provided.).

When an extended internet outage occurs, after a while Bucardo quits trying
to reconnect and waits (indefinitely) for a manual restart.

Is there a way to extend or remove the timeout so that the cloud server will
keep trying to reinitiate the syncs?

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20121106/ed
fb8437/attachment-0001.html>

------------------------------

Message: 2
Date: Tue, 6 Nov 2012 09:36:13 -0500
From: Greg Sabino Mullane <greg at endpoint.com>
To: Jonathan Brinkman <jb at blackskytech.com>
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] bucardo time-out setting?
Message-ID: <20121106143613.GV3140 at tinybird.home>
Content-Type: text/plain; charset="us-ascii"

> Is there a way to extend or remove the timeout so that the cloud 
> server will keep trying to reinitiate the syncs?

Which timeout are you seeing? And which version of Bucardo are they using? 
In theory, things should retry indefinitely already.

--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL:
<https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20121106/2f
a95436/attachment-0001.sig>

------------------------------

_______________________________________________
Bucardo-general mailing list
Bucardo-general at bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general

End of Bucardo-general Digest, Vol 62, Issue 10
***********************************************