Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bugcheck or database corruption when attempting to store long incompressible data into a table [CORE4036] #4366

Closed
firebird-issue-importer opened this issue Jan 14, 2013 · 11 comments

Comments

@firebird-issue-importer

Submitted by: @pavel-zotov

Is related to QA512

G:\TEMP>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 't2.fdb'; commit;
SQL> show version;
ISQL Version: WI-V2.5.3.26566 Firebird 2.5
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.3.26566 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.3.26566 Firebird 2.5/XNet (TLPRG)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.3.26566 Firebird 2.5/XNet (TLPRG)/P12"
on disk structure version 11.2
SQL> create table tw(s01 varchar(32600), s02 varchar(32600)); commit;
SQL> insert into tw select rpad('',32600, gen_uuid()),rpad('',32600, gen_uuid()) from rdb$database;
Statement failed, SQLSTATE = XX001
database file appears corrupt (G:\TEMP\T2.FDB)
-wrong page type
-page 165 is of wrong type (expected 4, found -97)
-internal Firebird consistency check (error during savepoint backout (290), file: exe.cpp line: 4141)
SQL> rollback;
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (can't continue after bugcheck)
SQL> exit;
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (can't continue after bugcheck)
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (can't continue after bugcheck)

G:\TEMP>gfix -v -full T2.FDB
-- no output --

Commits: a6bdb1c cd869f4 680d1b4 FirebirdSQL/fbt-repository@010bfb7

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2013

Commented by: @dyemanov

Hard case when the record of 65208 bytes is compressed into 65722 bytes and no 64KB overflow protection is made. Sigh.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 14, 2013

Modified by: @dyemanov

priority: Minor [ 4 ] => Major [ 3 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2013

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2013

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2013

Modified by: @dyemanov

Version: 2.5.2 [ 10450 ]

Version: 2.1.5 [ 10420 ]

Version: 2.0.7 [ 10390 ]

Version: 2.5.1 [ 10333 ]

Version: 2.1.4 [ 10361 ]

Version: 2.5.0 [ 10221 ]

Version: 2.0.6 [ 10303 ]

Version: 3.0 Initial [ 10301 ]

Version: 2.1.3 [ 10302 ]

Version: 2.1.2 [ 10270 ]

Version: 2.0.5 [ 10222 ]

Version: 2.1.1 [ 10223 ]

Version: 2.1.0 [ 10041 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2013

Modified by: @dyemanov

summary: error during savepoint backout (290) when attempting to insert varchar(32600) in two fields => Bugcheck or database corruption when attempting to store long incompressible data into a table

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2013

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2013

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.3 [ 10461 ]

Fix Version: 2.1.6 [ 10460 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 29, 2014

Modified by: @pcisar

Link: This issue is related to QA512 [ QA512 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 12, 2015

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 12, 2015

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment