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
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @sim1984description: SQL> create database 'localhost:test' user 'sysdba' password 'masterkey'; Crash. => SQL> create database 'localhost:test' user 'sysdba' password 'masterkey'; Crash. |
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. |
Modified by: @sim1984Attachment: error.jpg [ 12583 ] |
Modified by: @AlexPeshkoffsummary: Firebird server crashes when execute command show roles after reconnect => Firebird server crashes when execute most of "show ..." commands after reconnect |
Commented by: @AlexPeshkoff Yes, it was due to not cleared after reconnect cached request handles. |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 1 [ 10332 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
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
The text was updated successfully, but these errors were encountered: