internal Firebird consistency check (decompression overran buffer (179), file:
sqz.cpp line: 282)
-------------------------------------------------------------------------------------------------
Key: CORE-5392
URL: http://tracker.firebirdsql.org/browse/CORE-5392
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.1
Environment: Windows 10 64bit, Firebird 3.0.1.32609 official build
super server, connection to DB by TCP localhost looback.
Reporter: Slavomir Skopalik
Priority: Critical
This happen in this situation (verified 4 times):
1. DB was backup on FB 2.5 W64 and restored under FB3.0.1
2. DB upgrade scripts ran against this DB
3. Last script contain high (~1M) of updates inserts and finally failed on
custom exception
exception 27
-EEXCEPTION
-Unsupported combination idDefectType:1001 idDevice:10000 idState:1006
idScrapReason:1000
-At procedure 'KGS_NEWCUTTYPE' line: 57, col: 27
4. Next run of same script (no touch any other utilities)
D:\Dokumenty\kingspan\sql\upgrade>c:\fb\isql.exe -b -e -q -charset UTF8 -u
sysdba -p masterkey -i 099_CutTypes_remap.inc
localhost:d:\fbdata\kingspan_hu_prod.fdb 1>>_test.sql
Statement failed, SQLSTATE = 40001
lock conflict on no wait transaction
-At procedure 'KGS_NEWCUTTYPE' line: 61, col: 5
After line 26 in file 099_CutTypes_remap.inc
But report from MON$Attachments is (that is part of this script):
MON$STATE MON$ATTACHMENT_NAME MON$USER MON$ROLE
MON$REMOTE_PROTOCOL
0 D:\FBDATA\KINGSPAN_HU_PROD.FDB Cache Writer <null>
0 D:\FBDATA\KINGSPAN_HU_PROD.FDB Garbage Collector <null>
1 D:\FBDATA\KINGSPAN_HU_PROD.FDB SYSDBA NONE TCPv6
4. When I run last script again I receive this
D:\Dokumenty\kingspan\sql\upgrade>c:\fb\isql.exe -b -e -q -charset UTF8 -u
sysdba -p masterkey -i 099_CutTypes_remap.inc
localhost:d:\fbdata\kingspan_hu_prod.fdb 1>>_test.sql
Statement failed, SQLSTATE = XX000
internal Firebird consistency check (decompression overran buffer (179), file:
sqz.cpp line: 282)
After line 26 in file 099_CutTypes_remap.inc
Database is in dialect 1
FB log contains:
CORE-I7-6700K Sun Nov 06 13:03:20 2016
Database: D:\FBDATA\KINGSPAN_HU_PROD.FDB
internal Firebird consistency check (decompression overran buffer
(179), file: sqz.cpp line: 282)
After that, FB service cannot be stopped, must be killed by ProcessExplorer.
--
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
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
