This works for me. As soon as the database detects the loss of the
connection it frees the lock. Tested with MySQL and SQL-Server. I
didn't plug the power but instead did a kill -9 or unplugged the
network cable on the master.
I think this is supposed to be a feature of any database or else you'd
Thank you Mario,
Killing the process also works for me. But I seems when suddenly a power
failure occurs, postgres and mysql have no means to release the lock.
Dingwen Yuan
2007/9/13, Mario Siegenthaler [EMAIL PROTECTED]:
This works for me. As soon as the database detects the loss of the