Bugcheck or database corruption when attempting to store long incompressible data into a table [CORE4036] #4366
Labels
affect-version: 2.0.5
affect-version: 2.0.6
affect-version: 2.0.7
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.1.4
affect-version: 2.1.5
affect-version: 2.5.0
affect-version: 2.5.1
affect-version: 2.5.2
affect-version: 3.0 Initial
component: engine
fix-version: 2.1.6
fix-version: 2.5.3
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
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: