#33383 [Asn->Csd]: PHP crashes while retrieving data from Oracle
| From: | tony2001@php.net | Date: | Mon, 10 Oct 2005 10:43:08 +0000 |
| Subject: | #33383 [Asn->Csd]: PHP crashes while retrieving data from Oracle | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-86333@lists.php.net to get a copy of this message | ||
ID: 33383
Updated by: tony2001@php.net
Reported By: johnny at ouranous dot idv dot tw
-Status: Assigned
+Status: Closed
Bug Type: OCI8 related
Operating System: Solaris 9
PHP Version: 5CVS-2005-10-06 (snap, oci8-beta)
Assigned To: tony2001
New Comment:
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Previous Comments:
------------------------------------------------------------------------
[2005-10-07 14:00:26] johnny at ouranous dot idv dot tw
Even if I remove the lines of dynamic loading and load oci8 in php.ini,
the script still crashed.
And this time it cannot even print the first record.
------------------------------------------------------------------------
[2005-10-07 09:33:45] sniper@php.net
Do not load the extension with dl()!! Put it in php.ini.
Using dl() is known to cause crashes in all usual and unusual ways..
------------------------------------------------------------------------
[2005-10-07 06:36:32] johnny at ouranous dot idv dot tw
Description:
------------
Crashed where clob field contains no data.
Reproduce code:
---------------
<?php
if (!extension_loaded('oci8'))
{
dl('oci8.so');
}
$db_connect_id = OCINLogon( "username", "passwd", "dbserver" );
$query = SELECT guid,objcontent FROM objectcontent WHERE rownum < 10";
$stmt = OCIParse ($db_connect_id, $query);
OCIExecute($stmt, OCI_DEFAULT);
while( true )
{
if( !OCIFetchInto($stmt, $arr, OCI_ASSOC|OCI_RETURN_LOBS) )
break;
while( list($key,$val)=each($arr) )
{
echo "Key:".$key."\tVal:".$val."\n";
}
}
?>
Expected result:
----------------
Key:GUID Val:0011856596F1-423F9E4F-05E6-C367-9C3C
Key:OBJCONTENT Val:¢Xþ³ ïy ¡Óa ü îûec Ä2 ®:
Key:GUID Val:0011856596F1-423F906A-0575-4A3D-F21A
Key:OBJCONTENT Val:
Key:GUID Val:0011856596F1-423F906C-01C6-8953-3638
Key:OBJCONTENT Val:
Key:GUID Val:0011856596F1-423F906E-02D6-EED9-B606
Key:OBJCONTENT Val:¢Xþ³ ïy ¡Óa ü îûec Ä2 ®:
Key:GUID Val:0011856596F1-423F9070-002C-1E4F-B904
Key:OBJCONTENT Val:¢Xþ³ ïy ¡Óa ü îûec Ä2 ®:
Key:GUID Val:0011856596F1-423F9072-022E-F935-14B2
Key:OBJCONTENT Val:¢Xþ³ ïy ¡Óa ü îûec Ä2 ®:
Key:GUID Val:0011856596F1-423F9074-0118-D30B-B890
Key:OBJCONTENT Val:¢Xþ³ ïy ¡Óa ü îûec Ä2 ®:
Key:GUID Val:0011856596F1-423F9075-0489-6151-A41E
Key:OBJCONTENT Val:¢Xþ³ ïy ¡Óa ü îûec Ä2 ®:
Actual result:
--------------
Key:GUID Val:0011856596F1-423F9E4F-05E6-C367-9C3C
Key:OBJCONTENT Val:¢Xþ³ ïy ¡Óa ü îûec Ä2 ®:
Segmentation Fault (core dumped)
------------------------------------------------------------------------
[2005-10-04 08:54:10] johnny at ouranous dot idv dot tw
oci8-beta still got crashed. And there was something I forgot to
mention. My Oracle 9i is configured to use UTF8.
------------------------------------------------------------------------
[2005-09-08 11:51:36] tony2001@php.net
Please try OCI8 v.1.1, which is available in CVS HEAD and PECL (use
pear install oci8-beta to install it).
------------------------------------------------------------------------
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/33383
--
Edit this bug report at http://bugs.php.net/?id=33383&edit=1