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
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
e
