Bugcheck or database corruption when attempting to store long incompressible data into a table [CORE4036] #4366
Comments
|
Commented by: @dyemanov Hard case when the record of 65208 bytes is compressed into 65722 bytes and no 64KB overflow protection is made. Sigh. |
Modified by: @dyemanovpriority: Minor [ 4 ] => Major [ 3 ] |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @dyemanovVersion: 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 ] |
Modified by: @dyemanovsummary: 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 |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Modified by: @dyemanovstatus: 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 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
firebird-automations
added
affect-version: 2.5.2
affect-version: 2.1.5
affect-version: 2.0.7
affect-version: 2.5.1
affect-version: 2.1.4
affect-version: 2.5.0
affect-version: 2.0.6
affect-version: 3.0 Initial
affect-version: 2.1.3
affect-version: 2.1.2
affect-version: 2.0.5
affect-version: 2.1.1
affect-version: 2.1.0
fix-version: 3.0 Alpha 1
fix-version: 2.5.3
fix-version: 2.1.6
resolution: fixed
priority: major
labels
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
The text was updated successfully, but these errors were encountered: