14.11.2011 23:15, Damyan Ivanov wrote:

> # session 1
> $ FIREBIRD=. FIREBIRD_LOCK=. isql-fb dbd-firebird-test.fdb
> Database:  dbd-firebird-test.fdb
> SQL>
>
> # session 2, from another terminal, running in the same working
> # directory
> FIREBIRD=. FIREBIRD_LOCK=. isql-fb dbd-firebird-test.fdb
> # hangs

Do both terminals run with the same Linux user credentials?
Is there anything interesting in firebird.log?

> Attaching gdb to the second session's isql and requesting a backtrace
> gives the following:

The second connection waits for the first one to downgrade its database 
lock, but its request gets ignored.

A lock print output (with the -a switch) could be useful here.


Dmitry

------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to