Hi ,

I am using slony1-2.0.4.rc2 and postgresql-8.4.0-0. I faced a deadlock in
slony uninstall process.

I was trying to uninstall node from cluster . As per the slony document
unistall requires  AccessExclusive locks on all replicated table.
When slony process uninstalling the node from cluster , same time postgres
insert a row  in one of the table which is in replicated table list and a
Deadlock is occured.

DETAIL:  Process 22593 waits for AccessExclusiveLock on relation 16392 of
database 16388; blocked by process 11808.
Process 11808 waits for AccessShareLock on relation 18366 of database
16388; blocked by process 22593.


Can anyone tell me the reason and solution for it.


thanks
Smriti
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20111223/619bff5b/attachment.htm