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
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
