search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.22k stars 213 forks source link

bugcheck + coredump when recreate GTT with FK references on it`s PK and definition together with ref. field [CORE3835] #4177

Open firebird-automations opened 12 years ago

firebird-automations commented 12 years ago

Submitted by: @pavel-zotov

Attachments: core_isql.zip

[firebird@firebirdG]$ isql Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'td1.fdb'; commit; SQL> show version; ISQL Version: LI-V2.5.2.26390 Firebird 2.5 Server version: Firebird/linux AMD64 (access method), version "LI-V2.5.2.26390 Firebird 2.5" on disk structure version 11.2 SQL> recreate global temporary table ttt$t1(id int); SQL> commit; SQL> recreate global temporary table ttt$t1 ( CON> id int primary key CON> ,ref_id int CON> ,constraint ttt$fk foreign key (ref_id) references ttt$t1(id) CON> ); Aborted (core dumped)

Backtrace of coredump please see in attach.

firebird-automations commented 12 years ago
Modified by: @pavel-zotov Attachment: core\_isql\.zip \[ 12141 \]
firebird-automations commented 12 years ago

Commented by: @pavel-zotov

PS. When connect to empty (new) .fdb via TCP rather than local:

[firebird@firebirdG Zotov]$ isql localhost:/u01/db/firebird/Zotov/td1.fdb Database: localhost:/u01/db/firebird/Zotov/td1.fdb SQL> recreate global temporary table ttt$t1(id int); SQL> commit; SQL> recreate global temporary table ttt$t1 ( CON> id int primary key CON> ,ref_id int CON> ,constraint ttt$fk foreign key (ref_id) references ttt$t1(id) CON> ); Statement failed, SQLSTATE = 08006 Error reading data from the connection.

-- no coredump at this case.

firebird.log: ---------------- firebirdG Sat Apr 28 00:40:04 2012 REMOTE INTERFACE/gds__detach: Unsuccesful detach from database. Uncommitted work may have been lost

firebird-automations commented 12 years ago

Commented by: @pavel-zotov

On Windows (both local and TCP):

C:\MIX\firebird\fb25>isql localhost/3050:C:\MIX\firebird\fb25\TWW.FDB Database: localhost/3050:C:\MIX\firebird\fb25\TWW.FDB SQL> show version; ISQL Version: WI-V2.5.1.26351 Firebird 2.5 Server version: Firebird/x86/Windows NT (access method), version "WI-V2.5.1.26351 Firebird 2.5" Firebird/x86/Windows NT (remote server), version "WI-V2.5.1.26351 Firebird 2.5/tcp (csprog)/P12" Firebird/x86/Windows NT (remote interface), version "WI-V2.5.1.26351 Firebird 2.5/tcp (csprog)/P12" on disk structure version 11.2

SQL> in r; -- script see above Statement failed, SQLSTATE = 08001 I/O error during "ReadFile" operation for file "C:\MIX\FIREBIRD\FB25\TWW.FDB" -Error while trying to read from file -Wrong descriptor After line 2 in file r SQL> quit;