An uncommitted select of the pseudo table sec$users blocks new database connections [CORE4200] #4525
Assignees
Comments
|
Commented by: @sim1984 Confirmed. Bug reproduced also in IBExpert. |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoffsummary: An uncommitted select of the new pseudo table sec$users (CORE2639) seems to block new database connections => An uncommitted select of the pseudo table sec$users blocks new database connections |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 2 [ 10560 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: Robert (rjm1102)
Testing WI-T3.0.0.30566 Firebird 3.0 Alpha 1 on Windows XP.
An uncommitted select of the new pseudo table sec$users (CORE2639) seems to block new database connections.
Test situation:
session 1:
connect to test database
start transaction
select * from sec$users
(do *not* commit)
session 2:
connect to test database => results in sql error -902; engine code 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
I have tested this with FlameRobin using all isolation modes for the transaction in session 1 (concurrency, dirty read, read committed and consistency) and the error occurs in all circumstances.
The error can easily be avoided using short running transaction, but if the error occurs it can be confusing (it says 'user name and password' not set up, what actually is not the case).
Kind regard,
Robert
NL
Commits: dd73db4 FirebirdSQL/fbt-repository@11a3e82
The text was updated successfully, but these errors were encountered: