Subject Can I release a lock by invalid (uncomplete) session ?
Author KIMURA, Meiji
Hi All,

When I tested about error cases, I unplug the computer's network cable between client and server.
Then I re-connect the computer's network cable. In some cases, uncomplete transaction (or invalid
sessions?) keeps the lock then I cannot delete the specific row. (there is no reply to the Firebird).

In this case, the only solution is restart Firebird? Is there any method to detect invalid (or
uncomplete transaction) process and kill it like an Oracle's "ALTER SYSTEM KILL SESSION".



Environment is as below:
OS: Linux(Debian)
Firebird 1.5.1

Regards,
KIMURA, Meiji.(FAMILY, Given)
Tokyo, JAPAN.