FB 3.0 crashes when trying to RE_create two tables and define master-detail link between them using text fields with different character sets ---------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5680 URL: http://tracker.firebirdsql.org/browse/CORE-5680 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation, Engine Affects Versions: 4.0 Alpha 1, 3.0.2, 2.5.7 Reporter: Pavel Zotov Create following script: ================== shell del C:\MIX\firebird\QA\fbt-repo\tmp\c2284.fdb 2>nul; create database 'localhost:C:\MIX\firebird\QA\fbt-repo\tmp\c2284.fdb' user 'SYSDBA' password 'masterkey'; recreate table test_cs__detail(x int); recreate table test_cs__master(x int); commit; set autoddl off; recreate table test_cs__master ( str_pk varchar(32) character set UTF8 not null, --------------------- [ 1 ] primary key (str_pk) using index test_s_master_pk ); recreate table test_cs__detail ( str_pk varchar(32) character set WIN1251 not null, ------------------ [ 2 ] foreign key (str_pk) references test_cs__master (str_pk) ); set echo on; commit; rollback; Console output: ============= ISQL Version: WI-V3.0.3.32854 Firebird 3.0 Server version: WI-V3.0.3.32854 Firebird 3.0 WI-V3.0.3.32854 Firebird 3.0/tcp (csprog)/P15:C WI-V3.0.3.32854 Firebird 3.0/tcp (csprog)/P15:C commit; Statement failed, SQLSTATE = 08001 I/O error during "WriteFile" operation for file "C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB" -Error while trying to write to file -invalid descriptor // in national codepage After line 19 in file crash-on-pk-fk-with-diff-cset.sql rollback; Statement failed, SQLSTATE = XX000 internal Firebird consistency check (can't continue after bugcheck) After line 21 in file crash-on-pk-fk-with-diff-cset.sql Statement failed, SQLSTATE = XX000 internal Firebird consistency check (can't continue after bugcheck) After line 21 in file crash-on-pk-fk-with-diff-cset.sql === Note: 1. Both tables have to be created BEFORE 'recreate table' statement, i.e. they must already exist; 2. Charsets in PK and FK fields differ. PS. I thought that this bug is related to CORE-5677 or CORE-2284, but after discussion with Vlal it was decided to create new ticket. The same result on WI-V2.5.8.27083 and WI-T4.0.0.832 -- i.e. this bug is old enough. firebird.log ========= CSPROG Thu Dec 14 20:49:31 2017 Database: C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB internal Firebird consistency check (partner index description not found (175), file: idx.cpp line: 209) CSPROG Thu Dec 14 20:49:31 2017 I/O error during "WriteFile" operation for file "C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB" Error while trying to write to file Неверный дескриптор. CSPROG Thu Dec 14 20:49:31 2017 Database: C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB I/O error during "WriteFile" operation for file "C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB" Error while trying to write to file Неверный дескриптор. CSPROG Thu Dec 14 20:49:31 2017 Database: C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB I/O error during "WriteFile" operation for file "C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\C2284.FDB" Error while trying to write to file Неверный дескриптор. CSPROG Thu Dec 14 20:49:31 2017 INET/inet_error: read errno = 10054, server host = localhost, address = 127.0.0.1/3400 CSPROG Thu Dec 14 20:49:31 2017 REMOTE INTERFACE/gds__detach: Unsuccesful detach from database. Uncommitted work may have been lost. Error writing data to the connection. send_packet/send CSPROG Thu Dec 14 20:49:31 2017 setsockopt: error setting IPV6_V6ONLY to 0 -- 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 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel