ID: 37292 User updated by: crescentfreshpot at yahoo dot com Reported By: crescentfreshpot at yahoo dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: WinXP PHP Version: 5.1.3 New Comment:
Verified, my reproduce code does not crash anymore on windows with latest win32 snap. Just to confirm, does the non-usage of OCILobRead2 on windows mean that bug #36934 is now present on windows again? Thanks very much. Previous Comments: ------------------------------------------------------------------------ [2006-05-15 08:38:32] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip Please try next snapshot. I disabled OCILobRead2() support on windows. Unfortunately it seems to be broken there, but working fine on *nix. ------------------------------------------------------------------------ [2006-05-13 17:32:16] gert dot sommerer at ipms dot fraunhofer dot de built of php_oci8.dll in windows with undefined HAVE_OCI_LOB_READ2 works! Hence the error seems to be related to OCILOBRead2 (>4GB Support). ------------------------------------------------------------------------ [2006-05-12 09:10:43] ignacio at esviza dot com Same problem on: - PHP 5.1.4 (ISAPI Server API) - Windows XP Professional w/SP2 - Bundled IIS PHP Crashes when trying to load() / read() a CLOB. ------------------------------------------------------------------------ [2006-05-09 12:58:40] gert dot sommerer at ipms dot fraunhofer dot de on Sun-Solaris the OCI-LOB->load() or OCI-LOB->read(..) returns an string(0) for BLOB's in all cases and on Windows XP makes Apache crash. Seems to be a the same issue with OCILOBRead2? <?php oci_internal_debug(1); $dbh=oci_new_connect("anonymous","huhu","ora2"); $rs=oci_parse($dbh,"select WaferImage from prodab.wafermap where maskid=21 and mapno=1"); oci_execute($rs); $row = oci_fetch_assoc($rs); $wi=$row['WAFERIMAGE']; var_dump($wi); $len=$wi->size(); echo "<br>size=$len"; //$pic=$wi->load(); $pic=$wi->read(100); echo "<br>after load<br>"; //$row->WaferImage->free(); var_dump( $pic); ?> OCI8 DEBUG: OCINlsEnvironmentVariableGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:995) OCI8 DEBUG: OCIEnvNlsCreate at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1151) OCI8 DEBUG: OCIHandleAlloc at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1176) OCI8 DEBUG: OCIServerAttach at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1185) OCI8 DEBUG: OCIHandleAlloc at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1195) OCI8 DEBUG: OCIHandleAlloc at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1204) OCI8 DEBUG: OCIHandleAlloc at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1213) OCI8 DEBUG: OCIAttrSet at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1223) OCI8 DEBUG: OCIAttrSet at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1234) OCI8 DEBUG: OCIAttrSet at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1244) OCI8 DEBUG: OCIAttrSet at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1253) OCI8 DEBUG: OCISessionBegin at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1284) OCI8 DEBUG: OCIHandleAlloc at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:61) OCI8 DEBUG: OCIStmtPrepare2 at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:65) OCI8 DEBUG: OCIAttrSet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:119) OCI8 DEBUG: OCIAttrSet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:128) OCI8 DEBUG: OCIAttrGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:297) OCI8 DEBUG: OCIStmtExecute at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:321) OCI8 DEBUG: OCIAttrGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:350) OCI8 DEBUG: OCIParamGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:372) OCI8 DEBUG: OCIAttrGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:381) OCI8 DEBUG: OCIAttrGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:391) OCI8 DEBUG: OCIAttrGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:404) OCI8 DEBUG: OCIAttrGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:414) OCI8 DEBUG: OCIAttrGet at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:424) OCI8 DEBUG: OCIDescriptorFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:432) OCI8 DEBUG: OCIDescriptorAlloc at (/usr/local/source/php-5.1.3/ext/oci8/oci8_lob.c:73) OCI8 DEBUG: OCIDefineByPos at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:557) OCI8 DEBUG: OCIStmtFetch at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:147) object(OCI-Lob)#1 (1) { ["descriptor"]=> resource(4) of type (oci8 descriptor) } OCI8 DEBUG: OCILobGetLength at (/usr/local/source/php-5.1.3/ext/oci8/oci8_lob.c:124) <br>size=10902OCI8 DEBUG: OCILobCharSetId at (/usr/local/source/php-5.1.3/ext/oci8/oci8_lob.c:200) OCI8 DEBUG: OCILobRead2 at (/usr/local/source/php-5.1.3/ext/oci8/oci8_lob.c:242) <br>after load<br>string(0) "" OCI8 DEBUG: OCIStmtRelease at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:589) OCI8 DEBUG: OCIHandleFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8_statement.c:601) OCI8 DEBUG: OCIDescriptorFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8_lob.c:546) OCI8 DEBUG: OCISessionEnd at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1448) OCI8 DEBUG: OCIHandleFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1452) OCI8 DEBUG: OCIServerDetach at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1456) OCI8 DEBUG: OCIHandleFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1460) OCI8 DEBUG: OCIHandleFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1464) OCI8 DEBUG: OCIHandleFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1468) OCI8 DEBUG: OCIHandleFree at (/usr/local/source/php-5.1.3/ext/oci8/oci8.c:1472) ------------------------------------------------------------------------ [2006-05-08 10:55:34] sswpwp at poczta dot onet dot pl I have the same problem. After fix for bug #36934 PHP crashes when reading BFILES with OCI8. I receive the same backtrace as crescentfreshpot. Here is the code to reproduce the bug: $conn = oci_connect('rtg_owner', 'rtg', $tnsname); $stmt = oci_parse($conn, "SELECT BFILE FROM IMAGES WHERE IMAGE_ID = 3872"); oci_execute($stmt); $row = oci_fetch_assoc($stmt); $img = $row['BFILE']; var_dump($img); $img->read(128); // this line causes a crash echo $img->tell(); I'm using PHP 5CVS-2006-05-08(snap), Apache 2.0.55 and Oracle Instant Client 10.2.0 ------------------------------------------------------------------------ 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/37292 -- Edit this bug report at http://bugs.php.net/?id=37292&edit=1
