[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...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general