Allow more than one alias for same database
-------------------------------------------

                 Key: CORE-5977
                 URL: http://tracker.firebirdsql.org/browse/CORE-5977
             Project: Firebird Core
          Issue Type: Improvement
    Affects Versions: 3.0.4
         Environment: Win7-64, Firebird 3.0.4, php 7.3
            Reporter: Volker Rehn


While testing php 7 and Firebird 3, I found that the connect routine 
"ibase_connect" is broken, a confirmed unresolved bug: 
https://bugs.php.net/bug.php?id=72175 and 
https://bugs.launchpad.net/ubuntu/+source/php7.0/+bug/1578600.  

It means that you cannot open more than one connection to the same database 
anymore, to e.g.
- run an interleaved query (monitoring queries, stopping a query, ...) 
- run queries in parallel using curl or async javascript functions (to utilize 
Firebird 3 SMP capabilities)

This has worked flawlessly in php versions < 7. However, since php 5.6 hits EOL 
on 31-12-2018, users must upgrade to php 7 NOW and there is NO WORKAROUND. This 
severlely restricts the use of php and Firebird from now on. It almost seems 
the php/Firebird extension has been abandoned.

A partial workaround could be to define more than one alias to the same 
database in databases.conf:

data = D:\web\data\data.fdb
{
        DefaultDbCachePages = 100000
}

data2 = D:\web\data\data.fdb
{
        DefaultDbCachePages = 100000
}

But Firebird doesn't accept this, firebird.log shows:
File databases.conf contains bad data: Duplicated configuration for database 
D:\web\data\data.fdb

Can this logic be relaxed?

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

Reply via email to