Fri Dec 23 02:21:26 PST 2011
- Previous message: [Slony1-general] Deadlock detected in slony
- Next message: [Slony1-general] Locking Problems after Table Creation with SLONIK EXECUTE SCRIPT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> > 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
- Previous message: [Slony1-general] Deadlock detected in slony
- Next message: [Slony1-general] Locking Problems after Table Creation with SLONIK EXECUTE SCRIPT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list