[Bucardo-general] bucardo tables causing REINDEX fail
Jonathan Brinkman
JB at BlackSkyTech.com
Tue Apr 10 20:31:06 UTC 2012
Hmm
No I'm only running the 4.4.8 version. I guess I could bucardo_ctl stop, do
the REINDEX, then restart bucardo.
Would that work?
When will B5 be ready for production use?
-----Original Message-----
From: Greg Sabino Mullane [mailto:greg at endpoint.com]
Sent: Tuesday, April 10, 2012 12:24 PM
To: Jonathan Brinkman
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] bucardo tables causing REINDEX fail
On Sun, Apr 08, 2012 at 07:51:43AM -0400, Jonathan Brinkman wrote:
> Greetings
> For the second Sunday AM in a row my weekly REINDEX failed. It now fails
> when I run the REINDEX manually.
> It is due to 2 bucardo tables locked, apparently. How can I fix this so
the
> weekly routine succeeds?
...
> 120249365 | bucardo_delta
> 120253675 | bucardo_delta_archive_log_gateserviceerrors_txn
Hm...are you running a mixture of B4 and B5?
I'm not sure offhand what can be done, as REINDEX needs a heavy lock and
those tables are obviously very busy. If you can stop things from
writing to the gateserviceerrors table while the reindex is going on,
that might help. And switching to B5 is the only thing that will
prevent bucardo_delta from causing problems, as it is shared across
all tables in B4, so you would need to stop everything to ensure it
gets reindexed.
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
More information about the Bucardo-general
mailing list