error during savepoint backout (290) when attempting to insert varchar(32600)
in two fields
-------------------------------------------------------------------------------------------
Key: CORE-4036
URL: http://tracker.firebirdsql.org/browse/CORE-4036
Project: Firebird Core
Issue Type: Bug
Components: Engine
Reporter: Pavel Zotov
Priority: Minor
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 --
--
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
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
