ID: 10997
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Closed
Bug Type: OCI8 related
Operating System: Linux Mandrake 7.2
PHP Version: 4.0.5
New Comment:
this should be fixed some time ago. try PHP >= 4.1
Previous Comments:
------------------------------------------------------------------------
[2001-06-14 15:38:03] [EMAIL PROTECTED]
reclassified to an OCI bug, as that is what this is...updated Short
Desc as well...
------------------------------------------------------------------------
[2001-05-28 07:02:51] [EMAIL PROTECTED]
If script is executed on PHP 4.0.4pl1 there is warning in Apache
errof_log file:
Warning: failed to rollback outstanding transactions!: ORA-24324:
service handle not initialized
------------------------------------------------------------------------
[2001-05-28 06:46:58] [EMAIL PROTECTED]
I tryed to reproduce this and here is the script.
I run 2 different SQL statements. First one is wrong (contains invalid
table name) and second is correct. If there is an error in SQL
statement script is terminated using die().
On next page hit after execution of wrong SQL statement i'm getting:
[notice] child pid 7358 exit signal Segmentation fault (11)
in Apache error_log file and mess in defined constants.
In the original script there is no wrong SQL statements but somehow i'm
getting same result. Obviously the problem is in OCI8 extention not in
HTTP redirections.
There is no problems running same script on PHP 4.0.4pl1.
<?php
define("CONSTANT", "value");
define("MAX_REDIRECTS", 10);
define("LOGIN", "scott");
define("PASSWORD", "tiger");
define("DB", "oracle");
if (CONSTANT != "value") die($hitNo." failed."."<br> <a
href='".$SCRIPT_NAME."?hitNo=".$hitNo."'>Click to continue.</a><br>");
$sql[0] = "select * from session_Log where userID=1";
$sql[1] = "select * from sessionLog where userID=1";
$hitNo = $hitNo ? $hitNo+1 : 1;
function ociSelect(&$data) {
global $sql, $hitNo, $SCRIPT_NAME;
$conn = ociNLogon(LOGIN, PASSWORD, DB);
if ($stmt = ociParse($conn, $sql[$hitNo % 2])) {
if (!@ociExecute($stmt,OCI_DEFAULT)) {
$error = ociError($stmt);
die($error["message"]."<br> <a
href='".$SCRIPT_NAME."?hitNo=".$hitNo."'>Click to continue.</a><br>");
}
$nrows = ociFetchStatement($stmt, $data);
ociFreeStatement($stmt);
} else die("Cannot parse SQL statement.");
ociCommit($conn);
ociLogoff($conn);
}
ociSelect($data);
if ($hitNo < MAX_REDIRECTS) {
header("Location: ".$SCRIPT_NAME."?hitNo=".$hitNo);
exit;
} else echo $hitNo." HTTP redirects passed ok.<br> <a
href='".$SCRIPT_NAME."'>Click to test it again.</a><br>";
?>
------------------------------------------------------------------------
[2001-05-23 00:03:30] [EMAIL PROTECTED]
Can't reproduce. Please include short scripts and instructions how to
reproduce this.
--Jani
------------------------------------------------------------------------
[2001-05-21 14:54:12] [EMAIL PROTECTED]
After form data is submitted to the script i have up to 3
header('Location: '.$newPage);
http redirects. In case i hit 3rd page where i have constant defined it
is full with garbage !?!?!
define("CONSTANT","value");
if (CONSTANT != "value") die("Why is that?!?");
If i hit this page with same parameters but not from http redirect or
using PHP 4.0.4pl1 everything is woking fine.
I can not expose entire script here because is quite big (2000 lines
+).
I'm using IE 5.5 SP1.
Linux Mandrake 7.2
PHP 4.0.5 compiled --with-apxs --with-mysql --with-oci8
using egcs-2.91.66
libc-5.3.12
glibc-2.1.3
apache 1.3.14
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=10997&edit=1
