Infinite ES EDS with AUTONOMOUS transaction leads to memory leak + 335544333:
internal consistency check (cannot start cache writer thread)
-------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4194
URL: http://tracker.firebirdsql.org/browse/CORE-4194
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Reporter: Pavel Zotov
Attachments:
fb_memory_consumption_during_infinite_ES_EDS_with_autonom_tran.zip
Running this simple script during ~1 day leads to memory consumption ~630 Mb
and after all to internal consistency check.
-- run from Windows machine with FB 2.5 installed, ip = 192.168.43.96:
C:\MIX\firebird\fb25>isql 192.168.99.44/3330:empty30
Database: 192.168.99.44/3330:empty30 -- this is on host with FB 3.0
SQL> set term ^;
SQL> execute block as
CON> declare host varchar(128) = '192.168.0.201/3330:empty30' ;
CON> declare stt varchar(255) = 'select count(*) from rdb$relations';
CON> declare usr varchar(255);
CON> declare psw varchar(255);
CON> declare cnt int;
CON> begin
CON> usr = 'sysdba';
CON> psw = 'masterke';
CON> while (1=1) do
CON> execute statement (:stt)
CON> with autonomous transaction
CON> on external (:host)
CON> as user :usr password :psw
CON> into cnt
CON> ;
CON> end^
-- after ~20 hours this message appeared:
Statement failed, SQLSTATE = 42000
Execute statement error at attach :
335544333 : internal Firebird consistency check (cannot start cache writer
thread)
Data source : Firebird::192.168.0.201/3330:empty30
SQL> set term ;^
SQL>
SQL> ^C
This is from firebird.log (test was in run since 27-aug-2013 09:17 till
28-aug-2013 11:40):
-----------
CSMIRROR Tue Aug 27 08:46:34 2013
INET/inet_error: read errno = 10054
CSMIRROR Wed Aug 28 05:37:30 2013
Operating system call _beginthreadex failed. Error code 8
CSMIRROR Wed Aug 28 05:37:30 2013
Database: C:\1Install\FBTEST\empty30.fdb
internal Firebird consistency check (cannot start cache writer thread)
CSMIRROR Wed Aug 28 05:37:31 2013
Operating system call _beginthreadex failed. Error code 8
CSMIRROR Wed Aug 28 05:37:31 2013
Database: C:\1Install\FBTEST\empty30.fdb
internal Firebird consistency check (cannot start cache writer thread)
-----------
After the last message (05:37:31 2013) memory consumption of FB did not changed.
Please see in attach incremental log of memory consumption (result of psList -m
and psList -x for firebird process).
PS-1.
SQL> show version;
ISQL Version: WI-V2.5.3.26661 Firebird 2.5
Server version:
Firebird/linux AMD64 (access method), version "LI-T3.0.0.30616 Firebird 3.0
Alpha 1"
Firebird/linux AMD64 (remote server), version "LI-T3.0.0.30616 Firebird 3.0
Alpha 1/tcp (vmoel63.local)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.3.26661 Firebird
2.5/tcp (csprog)/P12"
on disk structure version 12.0
PS-2. firebird.conf:
# Type: boolean
#SharedCache = true
# Type: boolean
#SharedDatabase = false
--
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
