[Bucardo-general] bucardo tables causing REINDEX fail

Jonathan Brinkman JB at BlackSkyTech.com
Tue Apr 10 20:31:06 UTC 2012

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
> 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