Since w10 a problem come concerning connection database " Database is probably
already opened by another engine instance in another Windows session"
----------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5411
URL: http://tracker.firebirdsql.org/browse/CORE-5411
Project: Firebird Core
Issue Type: Bug
Components: API / Client Library
Reporter: dominique.barrieu
Hi,
Since windows 10 a new problem come concerning connection to database.
See bellow some log extracted from software :
-----
3156: Connection à la base sysdba masterkey read_only
C:\AWRoot\bin\common\..\..\dtrd\database\FLOWCHART_CONTEXT.FDB
3156: Déconnection à la base
C:\AWRoot\bin\common\..\..\dtrd\database\FLOWCHART_CONTEXT.FDB
3156: Connection à la base sysdba masterkey read_only
C:\AWRoot\bin\common\..\..\dtrd\database\FLOWCHART_CONTEXT.FDB
3156: Déconnection à la base
C:\AWRoot\bin\common\..\..\dtrd\database\FLOWCHART_CONTEXT.FDB
3156: Connection à la base sysdba masterkey read_only
C:\AWRoot\bin\common\..\..\dtrd\database\FLOWCHART_CONTEXT.FDB
3156: Erreur dans CDataBase::Connect : Database is probably already opened by
another engine instance in another Windows session
3156: => Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
-----
Two connections are ok but the third seems locked.
Only one thread and exe, uused in admin mode, are querring this database.
We use FireBird 2.5.0 in emmbedded mode.
With the super mode (client / server with windows services) no problems are
raised.
To continue our test we decide to develop a test software (connection - querry
- deconnection endlessly). Using an instance of this software in admin mode and
another instance in normal mode at same time with firebird in embedded mode
causes the same error « Database is probably already opened by another engine
instance in another Windows session »
Is there a way to use embedded server with two softwares launched with
different windows grant ?
Database is opel with options :
*dpb++ = isc_dpb_version1;
*dpb++ = isc_dpb_num_buffers;
*dpb++ = 1;
*dpb++ = 90;
*dpb++ = isc_dpb_force_write;
*dpb++ = 1;
*dpb++ = 0;
Regards.
See you.
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
