Online validation during DML activity in other connection leads to message
"Error while trying to read from file" and "page in use during flush (210),
file: cch.cpp line: 2672"
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4855
URL: http://tracker.firebirdsql.org/browse/CORE-4855
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Beta 2
Environment: OS = Windows XP.
Affected only 3.0 SuperServer.
Reporter: Pavel Zotov
Attachments: firebird.log.zip
On empty database with default settings (FW = ON, page_size = 4K) do:
Window-1:
========
isqi localhost/3333:e30
SQL> recreate table test(s varchar(1000) unique using index test_s_unq); commit;
SQL> insert into test select rpad('',1000, uuid_to_char(gen_uuid())) from
rdb$types,rdb$types;
-- here this connection will do lot of work, so we can switch to another window
--
Window-2:
========
fbsvcmgr.exe localhost/3333:service_mgr user SYSDBA password masterkey
action_validate dbname e30
First execution of OV can finish with expected message:
===
09:29:30.75 Validation started
09:29:30.93 Relation 128 (TEST)
09:29:40.93 Acquire relation lock failed
09:29:40.93 Relation 128 (TEST) : 1 ERRORS found
09:29:44.32 Validation finished
===
Second call of OV lead to appearing in the Window-1 following:
===
Statement failed, SQLSTATE = 08001
I/O error during "ReadFile" operation for file
"C:\FBTESTING\qa\fbt-repo\tmp\E30.fdb"
-Error while trying to read from file
-Invalid descriptor.
===
firebird.log will contain after this:
===
. . .
BALAHA Thu Jul 02 09:29:44 2015
Database: C:\FBTESTING\qa\fbt-repo\tmp\E30.fdb
lock time-out on wait transaction
internal Firebird consistency check (page in use during flush (210),
file: cch.cpp line: 2672)
BALAHA Thu Jul 02 09:29:44 2015
Database: e30
Validation aborted
lock time-out on wait transaction
internal Firebird consistency check (page in use during flush (210),
file: cch.cpp line: 2672)
BALAHA Thu Jul 02 09:29:44 2015
I/O error during "ReadFile" operation for file
"C:\FBTESTING\qa\fbt-repo\tmp\E30.fdb"
Error while trying to read from file
Invalid descriptor.
BALAHA Thu Jul 02 09:29:44 2015
Database: C:\FBTESTING\qa\fbt-repo\tmp\E30.fdb
I/O error during "ReadFile" operation for file
"C:\FBTESTING\qa\fbt-repo\tmp\E30.fdb"
Error while trying to read from file
Invalid descriptor.
===
Issuing 'QUIT' statement in the Window-1 leads to load CPU up to ~80%, w/o
ability to interrupt ISQL or to stop FB service (it needs to be forcely killed
using PE or similar tool).
Running OV 3rd time (after restart FB) will show lot of warninggs in
firebird.log, like these:
===
Warning: Pointer page 211 {sequence 0} bits {0x00 } are not consistent with
data page N {sequence M} state {0x01 full} in table TEST (128)
Warning: Index 1 has inconsistent left sibling pointer, page N level M at
offset K in table TEST (128)
Warning: Index 1 misses node on page M level N at offset K in table TEST (128)
===
(see attached file).
--
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
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
