#33383 [Opn->Fbk]: PHP crashes while retrieving data from Oracle

ID: 33383 Updated by: tony2001@php.net Reported By: johnny at gorilla dot com dot tw -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Solaris 9 PHP Version: 5.0.4 New Comment: Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. And please try fresh snapshot from http://snaps.php.net Previous Comments: ------------------------------------------------------------------------ [2005-06-17 13:05:18] johnny at gorilla dot com dot tw Description: ------------ I think this bug is simular to Bug #6561 but in Solaris I've test 3 different version of php in CGI/CLI mode all happended. Here is my enviornment & configuration: Sun V240(sparc) Solaris 9 gcc 3.4.2 Oracle 9.2.0.4 php 4.3.11 CFLAGS="getconf LFS_CFLAGS" ./configure --prefix=/usr/local/php4 --with-oci8=/data/oracle/OraHome1 --with-ncurses=/usr/local/lib --enable-pcntl --with-readline=/usr/local/lib --enable-mbstring=all php 5.0.3 CFLAGS="getconf LFS_CFLAGS" ./configure --prefix=/usr/local/php5 --with-oci8=/data/oracle/OraHome1 --with-ncurses=/usr/local/lib --enable-pcntl --with-readline=/usr/local/lib --enable-mbstring=all php 5.0.4 CFLAGS="getconf LFS_CFLAGS" ./configure --prefix=/usr/local/php5 --with-oci8=/data/oracle/OraHome1 --with-ncurses=/usr/local/lib --enable-mbstring=all (cannot build with --enable-pcntl --with-readline=/usr/local/lib) modified 1. <phpdir>/configure 2. <phpdir>/ext/oci8/config.m4 OCI8_DIR/lib -> OCI8_DIR/lib32 OCI8_DIR/rdbms/lib -> OCI8_DIR/rdbms/lib32 CGI/CLI crashed (core dumped) at some CLOB field at ociFetchInto when ociFetchInto with OCI_RETURN_LOBS, and crashed at ->load() when ociFetchInto without OCI_RETURN_LOBS, same code runs fine is PHP4/PHP5 on windows Reproduce code: --------------- Very hard to reproduce exactly. It happens while retrieving data from an Oracle 8 database. The same code works fine in Windows Environment. Expected result: ---------------- $query = "SELECT field1, clob1, field2 FROM table1"; $stmt = OCIParse ($conn, $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"; } echo "\n"; } Actual result: -------------- Key: xxxx Val: yyyyyy Key: xxxx Val: yyyyyy Key: xxxx Val: yyyyyy Key: xxxx Val: yyyyyy .... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=33383&edit=1