Unable to make embedded connection to 'security.db' if before that CREATE
DATABASE or CONNECT was made using remote protocol
----------------------------------------------------------------------------------------------------------------------------
Key: CORE-4837
URL: http://tracker.firebirdsql.org/browse/CORE-4837
Project: Firebird Core
Issue Type: Bug
Components: Security
Affects Versions: 3.0 Beta 2
Reporter: Pavel Zotov
Sample 1
========
C:\MIX\firebird\fb30>isql -q
SQL> shell del c:\temp\tmp4test.tmp 2>nul;
SQL> create database 'localhost/3333:c:\temp\tmp4test.tmp';
SQL> drop database;
SQL> connect 'security.db';
Statement failed, SQLSTATE = 08001
I/O error during "CreateFile (open)" operation for file "security.db"
-Error while trying to open file
-The process can not access the file because the file is in use by another
process.
SQL>
Sample-2 (with trace in separate session)
========
C:\MIX\firebird\fb30>isql -q
SQL> shell del c:\temp\tmp4test.tmp 2>nul;
SQL> create database 'localhost/3333:c:\temp\tmp4test.tmp' user 'SYSDBA'
password 'masterke'
SQL> commit;
SQL> connect 'localhost/3333:c:\temp\tmp4test.tmp' user 'SYSDBA' password
'masterke';
Database: 'localhost/3333:c:\temp\tmp4test.tmp', User: 'SYSDBA'
-- Here I've waited several seconds untill trace indicated disconnect from
sec3.fdb:
--- 2015-06-10T19:16:02.3900 (2056:01AD14B0) DETACH_DATABASE
--- C:\MIX\FIREBIRD\FB30\SECURITY3.FDB (ATT_26, SYSDBA:NONE, NONE,
<internal>)
-- Then terminate trace session and:
SQL> drop database;
SQL> connect 'security.db';
Statement failed, SQLSTATE = 08001
I/O error during "CreateFile (open)" operation for file "security.db"
-Error while trying to open file
-The process can not access the file because the file is in use by another
process.
SQL>
If there was real detach from sec3.fdb then why this database still can not be
attached by embedded protocol ?
--
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
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
