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

Command 'REVOKE ALL ON ALL FROM <anyname>' lead server to crash [CORE5858] #6118

Closed
firebird-automations opened this issue Jun 23, 2018 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Attachments:
firebird.4068.WI-T4_0_0_1036.stack_trace.7z
firebird.4488.WI-T4_0_0_1036.stack_trace.7z

Adjust path and name of database in following script.
Then run it:

shell del C:\\FBTESTING\\qa\\fbt\-repo\\tmp\\c5593\.fdb 2\>nul;

set wng off;
set list on;
set echo on;
set bail on;

set names utf8;
create database 'localhost:C:\\FBTESTING\\qa\\fbt\-repo\\tmp\\c5593\.fdb';

revoke all on all from any\_name\_here;
commit;
quit;

===

Output will be (as reply on 'revoke all on all from any_name_here;'):

Statement failed, SQLSTATE = 08006
Error reading data from the connection.
After line 9 in file c5593a.sql
Statement failed, SQLSTATE = 08006
Error writing data to the connection.
-send_packet/send

It seems that only 4.x if affected, no such error on 3.0.4.32997.

Link to folder where FB distr + dumps + stack traces can be found:

https://drive.google.com/drive/folders/1sqgNBuR78J97Q3kAy4-2SCp5alxnuTa_

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Two stack traces are attached here (in case if google-disk will be unavaliable somewhere)

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: firebird.4068.WI-T4_0_0_1036.stack_trace.7z [ 13272 ]

Attachment: firebird.4488.WI-T4_0_0_1036.stack_trace.7z [ 13273 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @romansimakov

This was my fault which Vlad fixed. Thanks!

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-automations
Copy link
Collaborator Author

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
Projects
None yet
Development

No branches or pull requests

1 participant