Subject Firebird, Interserver Problem
Author narouie
Firebird deadlocks while performing the followings ...

1. Heavy inserts into a table
2. Perform SELECT queries (was performing SELECT COUNT
(*) FROM SOMETABLE)

* Inserts were performed through Interclient
* SELECT queries were performed through IBConsole
* Problem occured in Firebird 1.0 running on Linux Redhat 7.2
* No triggers, generators or stored procedures
present. Only plain tables were used.

Deadlock causes my Java program to hang (does not
return from Interclient
function call).

IBConsole which was already logged on did still allow
queries to be performed.
However, attempting to logon to the server using
IBConsole would hang IBConsole.

Interbase Server service does not shut down.
Interserver service does not shut down.