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
Hi folks,
We have tested master/slave configuration with pure jdbc persistence and the
db used are mysql and postgres. When we plugged out the electric cable of
the master machine, the row lock on the table ACTIVEMQ_LOCK cannot be
released. So later neither of the machines can get the lock and bec
