An uncommitted select of the new pseudo table sec$users (CORE-2639) seems to
block new database connections
-----------------------------------------------------------------------------------------------------------
Key: CORE-4200
URL: http://tracker.firebirdsql.org/browse/CORE-4200
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 1
Environment: Windows XP
Reporter: Robert
Priority: Minor
Testing WI-T3.0.0.30566 Firebird 3.0 Alpha 1 on Windows XP.
An uncommitted select of the new pseudo table sec$users (CORE-2639) 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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
