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

Firebird server crashes when execute most of "show ..." commands after reconnect [CORE4506] #4825

Closed
firebird-automations opened this issue Aug 1, 2014 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @sim1984

Attachments:
error.jpg

SQL> create database 'localhost:test' user 'sysdba' password 'masterkey';
SQL> show version;
ISQL Version: WI-T3.0.0.31272 Firebird 3.0 Alpha 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp (s
tation9)/P13:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp
(station9)/P13:C"
on disk structure version 12.0
SQL> create user test password 'test';
SQL> create role r1;
SQL> show roles;
R1
SQL> connect 'localhost:test' user 'test' password 'test';
Commit current transaction (y/n)?y
Committing.
SQL> show roles;

Crash.

Commits: 8ed7e4a 0822c65 FirebirdSQL/fbt-repository@8d69e43 FirebirdSQL/fbt-repository@e6e729d

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @sim1984

description: SQL> create database 'localhost:test' user 'sysdba' password 'masterkey';
SQL> show version;
ISQL Version: WI-T3.0.0.31272 Firebird 3.0 Alpha 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp (s
tation9)/P13:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp
(station9)/P13:C"
on disk structure version 12.0
SQL> create user test password 'test';
SQL> create role r1;
SQL> show roles;
R1
SQL> create database 'localhost:test' user 'test' password 'test';
Commit current transaction (y/n)?y
Committing.
SQL> show roles;

Crash.

=>

SQL> create database 'localhost:test' user 'sysdba' password 'masterkey';
SQL> show version;
ISQL Version: WI-T3.0.0.31272 Firebird 3.0 Alpha 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp (s
tation9)/P13:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp
(station9)/P13:C"
on disk structure version 12.0
SQL> create user test password 'test';
SQL> create role r1;
SQL> show roles;
R1
SQL> connect 'localhost:test' user 'test' password 'test';
Commit current transaction (y/n)?y
Committing.
SQL> show roles;

Crash.

@firebird-automations
Copy link
Collaborator Author

Commented by: @sim1984

It seems this is due not so much to "show role" as reconnect with yourself. A similar error appeared in experiments with BLOB filters. Attached to the message screenshot.

@firebird-automations
Copy link
Collaborator Author

Modified by: @sim1984

Attachment: error.jpg [ 12583 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

summary: Firebird server crashes when execute command show roles after reconnect => Firebird server crashes when execute most of "show ..." commands after reconnect

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Yes, it was due to not cleared after reconnect cached request handles.
To have this bug fixed one should perform full build (including boot & epp preprocessing).

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test

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

2 participants