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

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
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T3.0.0.31272 Firebird 3.0 Alpha 2/tcp
on disk structure version 12.0
SQL> create user test password 'test';
SQL> create role r1;
SQL> show roles;
SQL> connect 'localhost:test' user 'test' password 'test';
Commit current transaction (y/n)?y
SQL> show roles;


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
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.

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).