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

Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0) [CORE5756] #6019

Closed
firebird-issue-importer opened this issue Feb 21, 2018 · 7 comments

Comments

@firebird-issue-importer

Submitted by: @pavel-zotov

Attachments:
gdb-crash-when-tried-to-recreate-table-that-was-in-use.7z

Try to run following script:

shell rm -f /var/tmp/tmptest.fdb;
create database 'localhost:/var/tmp/tmptest.fdb' user 'SYSDBA'password 'masterkey';

set list on;
set echo on;

recreate table test(x int);
select 1 from test;
recreate table test(x int, y int);

Output will be:
-------------------
Statement failed, SQLSTATE = 08006
Error reading data from the connection.
After line 8 in file /opt/scripts/recreate-used-table.sql
Statement failed, SQLSTATE = 08006
Error writing data to the connection.
------------------

I can reproduce this on 3.0.3.32875, 3.0.4.32819 and 4.0.0.853.
Stack traces for 3.0.3 and 3.0.4 seems to be equal, but i attach them both.

2.5.x is not afttected and raised expected error:

Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-object TABLE "TEST" is in use

PS. Used config:

BugCheckAbort=1
RemoteServicePort = 3333
IpcName = fb30ss

Providers = Remote,Engine12,Loopback
#⁠Providers = Remote,Loopback
#⁠Providers = Engine12

AuthServer = Srp, Win_Sspi, Legacy_Auth
AuthClient = Srp, Win_Sspi, Legacy_Auth
UserManager = Srp,Legacy_UserManager
WireCrypt = Enabled
#⁠WireCompression = false

Commits: 9afef19 bfb008f

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 21, 2018

Modified by: @pavel-zotov

Attachment: gdb-crash-when-tried-to-recreate-table-that-was-in-use.7z [ 13211 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 21, 2018

Modified by: @pavel-zotov

description: Try to run following script:

shell rm -f /var/tmp/tmptest.fdb;
create database 'localhost:/var/tmp/tmptest.fdb' user 'SYSDBA'password 'masterkey';

set list on;
set echo on;

recreate table test(x int);
select 1 from test;
recreate table test(x int, y int);

Output will be:
-------------------
Statement failed, SQLSTATE = 08006
Error reading data from the connection.
After line 8 in file /opt/scripts/recreate-used-table.sql
Statement failed, SQLSTATE = 08006
Error writing data to the connection.
------------------

I can reproduce this on 3.0.3.32875, 3.0.4.32819 and 4.0.0.853.
Stack traces for 3.0.3 and 3.0.4 seems to be equal, but i attach them both.

2.5.x is not afttected and raised expected error:

Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-object TABLE "TEST" is in use

=>

Try to run following script:

shell rm -f /var/tmp/tmptest.fdb;
create database 'localhost:/var/tmp/tmptest.fdb' user 'SYSDBA'password 'masterkey';

set list on;
set echo on;

recreate table test(x int);
select 1 from test;
recreate table test(x int, y int);

Output will be:
-------------------
Statement failed, SQLSTATE = 08006
Error reading data from the connection.
After line 8 in file /opt/scripts/recreate-used-table.sql
Statement failed, SQLSTATE = 08006
Error writing data to the connection.
------------------

I can reproduce this on 3.0.3.32875, 3.0.4.32819 and 4.0.0.853.
Stack traces for 3.0.3 and 3.0.4 seems to be equal, but i attach them both.

2.5.x is not afttected and raised expected error:

Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-object TABLE "TEST" is in use

PS. Used config:

BugCheckAbort=1
RemoteServicePort = 3333
IpcName = fb30ss

Providers = Remote,Engine12,Loopback
#⁠Providers = Remote,Loopback
#⁠Providers = Engine12

AuthServer = Srp, Win_Sspi, Legacy_Auth
AuthClient = Srp, Win_Sspi, Legacy_Auth
UserManager = Srp,Legacy_UserManager
WireCrypt = Enabled
#⁠WireCompression = false

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 21, 2018

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 21, 2018

Commented by: @dyemanov

Introduced due to CORE2284 / CORE5677.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 21, 2018

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Fix Version: 3.0.4 [ 10863 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 23, 2018

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 23, 2018

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

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