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

An uncommitted select of the pseudo table sec$users blocks new database connections [CORE4200] #4525

Closed
firebird-issue-importer opened this issue Aug 31, 2013 · 6 comments

Comments

@firebird-issue-importer

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 1, 2013

Commented by: @sim1984

Confirmed. Bug reproduced also in IBExpert.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 2, 2013

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 30, 2013

Modified by: @AlexPeshkoff

summary: 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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 30, 2013

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 27, 2014

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 29, 2015

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully

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

2 participants