ID: 44416
User updated by: hhadjali at cdcsoftware dot com
-Summary: OCIStmtExecute: ORA-03135: connection lost contact
Reported By: hhadjali at cdcsoftware dot com
Status: Open
Bug Type: OCI8 related
Operating System: AIX 5.3
PHP Version: 4.4.8
New Comment:
The problem is happening every day, not intermittently.
Thanks
Previous Comments:
------------------------------------------------------------------------
[2008-03-12 11:18:39] hhadjali at cdcsoftware dot com
Description:
------------
Hi;
We are running on :
apache: 1.3.34
php : 4.4.2
Oracle: 10.2.0
Our Web based application seems to have a problem intermittently where
by php looses connection to Oracle. We get the following error:
login :: :: Mar, 12th 10:28:54 ::: Warning: ociexecute():
OCIStmtExecute: ORA
login :: :: Mar, 12th 10:28:54 ::: -03135: connection lost contact
in file /
login :: :: Mar, 12th 10:28:54 :::
CatalystWMS/wmsbase/web/dbaccess/adodb-oci
login :: :: Mar, 12th 10:28:54 ::: 8.inc.php on line 876
--------------------------------------------------------------------------------
login :: :: Mar, 12th 10:28:54 ::: Notice: Only variable references
should be
login :: :: Mar, 12th 10:28:54 ::: returned by reference
in file /CatalystWM
login :: :: Mar, 12th 10:28:54 :::
S/wmsbase/web/dbaccess/adodb.inc.php on li
login :: :: Mar, 12th 10:28:54 ::: ne 867
--------------------------------------------------------------------------------
login :: :: Mar, 12th 10:28:54 ::: Warning: ociexecute():
OCIStmtExecute: ORA
login :: :: Mar, 12th 10:28:54 ::: -03114: not connected to ORACLE
in file /
login :: :: Mar, 12th 10:28:54 :::
CatalystWMS/wmsbase/web/dbaccess/adodb-oci
login :: :: Mar, 12th 10:28:54 ::: 8.inc.php on line 876
--------------------------------------------------------------------------------
login :: :: Mar, 12th 10:28:54 ::: Notice: Only variable references
should be
login :: :: Mar, 12th 10:28:54 ::: returned by reference
in file /CatalystWM
login :: :: Mar, 12th 10:28:54 :::
S/wmsbase/web/dbaccess/adodb.inc.php on li
login :: :: Mar, 12th 10:28:54 ::: ne 867
--------------------------------------------------------------------------------
The only solution is to restart Apache. Why Apache restart solves the
connection problem for a long period?
Also, I've prepared a php script that queries the Oracle Database. This
seems to work eventhough the problem exist and before we restart
Apache.
The script is:
<?php
$conn = OCILogon("username","password", "tnsname");
$stmt = OCIParse($conn,"select emp_id from employee order by emp_id");
#OCIBindByName($stmt, ':emp', $emp);
$ok = OCIExecute($stmt);
while (OCIFetchInto($stmt,$arr)) {
# print_r($arr);
echo "EMP_ID = $arr[0]";
echo "<hr>";
}
?>
Why the query using the above script works and when the application
uses the adodb-oci library we get the "connection lost contact" problem.
Is there a bug in the persistent connection or what?
Any advise will be appreciated.
Thanks
Hicham
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=44416&edit=1
