Edit report at http://bugs.php.net/bug.php?id=53962&edit=1
ID: 53962 User updated by: tiago dot duarte at softconcept dot pt Reported by: tiago dot duarte at softconcept dot pt Summary: Persistent connections Status: Bogus Type: Bug Package: OCI8 related Operating System: Windows 7 PHP Version: 5.3.5 Block user comment: N Private report: N New Comment: What do you recomend is to upgrade to oracle 11, using Database Resident Connection Pooling? I do not understand how this is not a bug, because the TCP between apache and oracle remains ESTABLISHED. Is there any way to resolve my problem? Previous Comments: ------------------------------------------------------------------------ [2011-02-08 19:32:30] johan...@php.net Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php Mind the notes on http://php.net/oci8.persistent-timeout ------------------------------------------------------------------------ [2011-02-08 18:55:03] tiago dot duarte at softconcept dot pt Description: ------------ I would aspect to see TCP connection between the apache and the Oracle server to die, after 10seconds the script ends. What i see, is that the connections stays ESTABLISHED until i restart apache. //php.ini changes oci8.max_persistent = 2 oci8.persistent_timeout = 10 oci8.ping_interval = -1 Test script: --------------- $sql = "SELECT nome FROM f_pessoa"; $conn = oci_pconnect($user_oracle, $password_db_oracle, $database_oracle); $stid = oci_parse($conn, $sql); $r = oci_execute($stid, OCI_DEFAULT); if (!$r) { $e = oci_error($stid); echo htmlentities($e['message']); exit; } while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) { foreach ($row as $item) { $table_2 .= ($item?htmlentities($item):' '); } } oci_close($conn); oci_free_statement($stid); Expected result: ---------------- I would expect that TCP connections will die 10s after the script ends. Actual result: -------------- The TCP connection between the apache and the Oracle Server stays ESTABLISHED for ever... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=53962&edit=1
