#22724 [Opn->Fbk]: OCIParse

ID: 22724 Updated by: sniper@php.net Reported By: admin at iut-info dot ens dot univ-reims dot fr -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: HP-UX 11.11 PHP Version: 4.3.2RC1 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-03-31 03:04:41] admin at iut-info dot ens dot univ-reims dot fr No backtrace because no crash. With OCIInternalDebug(1); The first time the page is called (just after apache start) the result is ok. Here is the output : ---------------------------------------------- OCIDebug: _oci_open_server new conn=0 dname=bd8 OCIDebug: _oci_open_session new sess=3 user=collet OCIDebug: oci_do_connect: id=4 OCILogon Ok Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production OCIDebug: oci_parse "SELECT * FROM essai" id=5 conn=4 2 Records Selected OCIDebug: START php_rshutdown_oci OCIDebug: END php_rshutdown_oci OCIDebug: START _oci_stmt_list_dtor: id=5 last_query="SELECT * FROM essai" OCIDebug: START _oci_column_hash_dtor: REF OCIDebug: END _oci_column_hash_dtor: REF OCIDebug: START _oci_column_hash_dtor: LIB OCIDebug: END _oci_column_hash_dtor: LIB OCIDebug: START _oci_conn_list_dtor: id=4 OCIDebug: nothing to do.. OCIDebug: END _oci_conn_list_dtor: id=4 OCIDebug: END _oci_stmt_list_dtor: id=5 OCIDebug: START _oci_close_session: logging-off sess=3 OCIDebug: START _oci_close_server: detaching conn=2 dbname=bd8 ---------------------------------------------- And the page still works for a while.. Here is the output of the error : ---------------------------------------------- OCIDebug: _oci_open_server new conn=0 dname=bd8 OCIDebug: _oci_open_session new sess=3 user=collet OCIDebug: oci_do_connect: id=4 OCILogon Ok Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production Warning: ociparse() [function.ociparse]: OCIParse: ORA-00001: unique constraint (%s.%s) violated in /home/prof/collet/public_html/testoci8.php on line 13 Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in /home/prof/collet/public_html/testoci8.php on line 14 OCIDebug: START php_rshutdown_oci OCIDebug: END php_rshutdown_oci OCIDebug: START _oci_conn_list_dtor: id=4 OCIDebug: nothing to do.. OCIDebug: END _oci_conn_list_dtor: id=4 OCIDebug: START _oci_close_session: logging-off sess=3 OCIDebug: START _oci_close_server: detaching conn=2 dbname=bd8 ---------------------------------------------- It's very strange in fact. When the error occurs one time, then it's happen each time the page is call. Cordially. P.S. : sorry for the feedback time... (some holidays) ------------------------------------------------------------------------ [2003-03-31 01:56:21] sniper@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2003-03-26 05:50:26] maxim@php.net 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. can you try to do the same test with the code that has OCIInternalDebug(1); function on top. Please post the output here. ------------------------------------------------------------------------ [2003-03-15 03:51:53] admin at iut-info dot ens dot univ-reims dot fr ----- CONFIGURE ------ ./configure \ --with-oci8 \ --with-apache=../apache_1.3.27 \ --with-gd \ --with-pdflib=/opt/pdflib \ --with-jpeg-dir \ --with-png-dir \ --with-tiff-dir \ --with-zlib \ --with-bz2 \ --enable-sigchild \ --with-mysql=/opt/mysql4 \ --with-pgsql=/opt/pgsql \ --with-tsrm-pthreads \ --with-dom \ --enable-ftp \ --enable-sockets ----- testoci8.php ---------------------------------- <HTML><HEAD><TITLE>Test de connexion PHP - Oracle 8i</TITLE></HEAD> <BODY> <PRE><?php putenv("ORACLE_HOME=/oracle/app/oracle/product/8.1.7"); $conn = OCILogon("collet", "pass", "bd8"); if ($conn ) { echo "OCILogon Ok\n"; echo "Server Version: " . OCIServerVersion($conn) . "\n"; $st=OCIParse($conn, "SELECT * FROM essai"); if (OCIExecute($st)) { $nrows = OCIFetchStatement($st,$results); print "<BR>$nrows Records Selected<BR>\n"; } OCILogOff($conn); } else echo " OCILogon ERREUR\n"; ?> </PRE></BODY></HTML> ---- Result with PHP-4.3.0 ------- OCILogon Ok Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production 2 Records Selected ---- Result with PHP-4.3.2 ----- OCILogon Ok Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production Warning: ociparse() [function.ociparse]: OCIParse: ORA-00001: unique constraint (%s.%s) violated in /home/prof/collet/public_html/testoci8.php on line 12 Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in /home/prof/collet/public_html/testoci8.php on line 13 ------------------ Cordialy. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22724&edit=1