[
http://tracker.firebirdsql.org/browse/CORE-4185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Peshkov reopened CORE-4185:
-------------------------------------
Fix is incomplete and wrong
> 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
> Affects Versions: 3.0 Alpha 1
> Reporter: Pavel Zotov
> Assignee: Alexander Peshkov
> Fix For: 3.0 Alpha 2
>
> 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
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
