ID: 20298 Comment by: schampailler at easynet dot be Reported By: phpbug at tab1 dot clara dot co dot uk Status: Open Bug Type: ODBC related Operating System: Windows 2000 Server SP4 PHP Version: 4CVS, 5CVS New Comment:
I have a similar problem with : Windows 2000 Server Professional IIS 5 Oracle ODBC 8.01.07 Driver PHP 4.3.4 If the connection to the Oracle DB dies, then PHP is not able to "resurect" it nor to detect it's dead. Using odbc_connect instead of odbc_pconnect solve the problem. "functionaly", but not optimally. I don't have the exact error message here, but it has the same symptoms as the 2 Dec 2003 post : the Oracle ODBC driver tells the connection is dead and PHP "just" returns that error. Previous Comments: ------------------------------------------------------------------------ [2003-12-02 04:47:47] phpbug at tab1 dot clara dot co dot uk okay this was tested with: php4-win32-STABLE-200312020930 1st run: resource(2) of type (odbc link persistent) followed by the correct query results 2nd run (after killing db connection): resource(1) of type (odbc link persistent) Warning: odbc_exec(): SQL error: [Informix][Informix ODBC Driver]Communication link failure., SQL state 08S01 in SQLExecDirect in C:\InetPub\wwwroot\test.php on line 8 ------------------------------------------------------------------------ [2003-12-01 03:00:17] [EMAIL PROTECTED] Can you add 'var_dump($dbconn);' after that odbc_pconnect() call..? What does it output? (in the re-run) ------------------------------------------------------------------------ [2003-02-20 04:58:12] t_o_m_ at yahoo dot com Having reread all of this I see that nowhere have I mentioned I'm using IIS (ISAPI) not Apache, if that makes a difference? I thought when I put Windows in the OS box whoever read it would assume IIS. In answer to your question "no", the behaviour is the same if odbc.check_persistent is on or off. The point is when it is off I would expect it to be my responsibility to check the connection and would expect the error if I did not. I would expect that when odbc.check_persistent was on odbc_pconnect was supposed to check the connection for me if the connection it is about to return from its pool is dead then it should discard it and create a new one as when the pool is empty. Which is clearly not happening. ------------------------------------------------------------------------ [2003-02-18 12:01:03] [EMAIL PROTECTED] Well the nature of CGI doesn't really lend itself to supporting persistant connections. It's run when requested and then exited after that. So no data can really presist between pages that exists solely in the CGI. So this behavior only exists when odbc.check_persistent is turned on? ------------------------------------------------------------------------ [2003-02-17 10:08:22] t_o_m_ at yahoo dot com Yes still a problem under 4.3.0 I am using the ISAPI module. I don't believe that persistent connections are supported at all under CGI. So odbc_pconnect == odbc_connect which would give the illusion of working, although the connection would not actually be persisting. The first time you reload the page after killing the database connection you get: Warning: SQL error: No response from the backend; Subsequent reloads give: Warning: SQL error: Could not send Query(connection dead); ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/20298 -- Edit this bug report at http://bugs.php.net/?id=20298&edit=1