Smriti Atrey smriti.atrey at globallogic.com
Fri Dec 23 02:21:26 PST 2011
>
> 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/9aa21e54/attachment.htm 


More information about the Slony1-general mailing list