--- In firebird-support@yahoogroups.com, "rtbunker" <rbunker.tsi@...>
wrote:

>
>
>
> --- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@>
> wrote:
> >
> > Could you please show us the complete stack trace?
> >
> >
> > Dmitry
> >
> Okay here is a complete stack trace of all threads. It would seem
> like Thread 7 is suspect? Did someone enter the stall without
> releasing a critical section?
>

Okay, i believe i have a simple repro. From the stacks i guessed that
it was related to DDL which we do on first connect to test whether we
have create table privileges. This repro rapidly fires up 16 isql's
that will try to create a temp table in the same database. Some will
get through, but for me, this reliably locks up the server. Further
attempts to connect to the database fail and you can't stop the server
short of killing the process.

1) Open a command prompt
2) cd to \Program Files\Firebird\Firebird_2_1
3) run the following command line
for /L %i in (1,1,16) do start cmd.exe /c "echo CONNECT
examples\empbuild\EMPLOYEE.FDB; CREATE TABLE "#TEST_%i_Connect" ("COL"
INTEGER); DROP TABLE "#TEST_%i_Connect"; | bin\isql -u SYSDBA -p
masterkey -q"