[Bucardo-general] add sync fails due to deadlock

Greg Sabino Mullane greg at endpoint.com
Sat Mar 23 23:49:45 UTC 2013


> the validate_sync fails due to a deadlock when trying to create a 
> trigger on one of the tables.  Is there a way to add a sync to a live 
> database so this won't occur?  Any advice would be much appreciated.

Exactly what is it deadlocking against? It always needs to get an exclusive lock 
on each table in the sync to create the triggers, so there is always 
a chance of bumping into other processes. Depending on what it is, though, 
there may be ways to fix the issue.

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


More information about the Bucardo-general mailing list