Issue Details (XML | Word | Printable)

Key: CORE-4506
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Simonov Denis
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Firebird server crashes when execute most of "show ..." commands after reconnect

Created: 01/Aug/14 02:54 PM   Updated: 18/Jan/16 03:28 PM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

File Attachments: None
Image Attachments:

1. error.jpg
(117 kB)
Environment: Windows 7 x64, ISQL

QA Status: No test


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov made changes - 04/Aug/14 07:27 AM
Field Original Value New Value
Assignee Alexander Peshkov [ alexpeshkoff ]
Simonov Denis made changes - 04/Aug/14 07:40 AM
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.
Simonov Denis added a comment - 16/Aug/14 01:50 PM
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.

Simonov Denis made changes - 16/Aug/14 01:51 PM
Attachment error.jpg [ 12583 ]
Alexander Peshkov made changes - 19/Aug/14 09:53 AM
Summary Firebird server crashes when execute command show roles after reconnect Firebird server crashes when execute most of "show ..." commands after reconnect
Alexander Peshkov added a comment - 19/Aug/14 09:55 AM
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).

Alexander Peshkov made changes - 19/Aug/14 09:55 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 23/Sep/15 11:28 AM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 18/Jan/16 03:28 PM
Status Closed [ 6 ] Closed [ 6 ]
QA Status No test