Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
firebird-automations opened this issue Apr 27, 2012 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: core_isql.zip [ 12141 ]

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

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;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant