FB craches with "invalid lock id (NNNNN), errno: 0" when all connects except
one (that locks some record) are forcely killed
----------------------------------------------------------------------------------------------------------------------------
Key: CORE-4185
URL: http://tracker.firebirdsql.org/browse/CORE-4185
Project: Firebird Core
Issue Type: Bug
Components: Engine
Reporter: Pavel Zotov
Attachments: core_firebird_log_+_LT_rawdump.rar
Scenario:
=======
1. Database with table TLOCK(id int, f01 int) and single record in it (e.g
ID=1, F01=100).
2. Machine #1.
Connect to this database via TCP and do:
SELECT * FROM TLOCK WHERE ID=1;
UPDATE TLOCK SET F01=RAND()*10000 WHERE ID=1;
SELECT * FROM TLOCK WHERE ID=1;
3. Machine #2.
Run batch (or shell) that:
3.1. Opens simultaneously N test ISQLs (I've reproduced result on at least
N=10) which all should just stay quiet in "SQL>" prompt after being loaded;
3.2. Waits ~10 seconds to insure that all ISQLs do establishe connect to the
database;
3.3. Runs the utility from SysInternals package to kill all ISQL processes:
PSKILL.EXE ISQL;
3.4. Waits again ~10 seconds to insure that all test windows and processes
are killed;
3.5. Loop to step 3.1
After some (short) time the Firebird daemon will craches with producing core
file, LockTable dump and the following message in it's log:
---------------
vmoel63.local Tue Aug 20 13:37:35 2013
Fatal lock manager error: invalid lock id (143960), errno: 0
vmoel63.local Tue Aug 20 13:37:59 2013
/opt/fb30cs/bin/fbguard: /opt/fb30cs/bin/firebird terminated abnormally
(-1)
vmoel63.local Tue Aug 20 13:37:59 2013
/opt/fb30cs/bin/fbguard: guardian starting /opt/fb30cs/bin/firebird
--------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
