Bug #44589 [Asn->Dup]: pdo_oci crashes and aborts php script for LOB columns

Edit report at http://bugs.php.net/bug.php?id=44589&edit=1 ID: 44589 Updated by: sixd@php.net Reported by: s dot rost at ewerk dot com Summary: pdo_oci crashes and aborts php script for LOB columns -Status: Assigned +Status: Duplicate Type: Bug Package: PDO related Operating System: Debian 2.6.18.dfsg.1-18etch1 PHP Version: 5.*, 6CVS (2009-04-25) -Assigned To: cjorcl +Assigned To: sixd Block user comment: N Private report: N New Comment: Duplicate of http://pecl.php.net/bugs/bug.php?id=11320 Previous Comments: ------------------------------------------------------------------------ [2009-08-31 20:59:44] kenashkov at gmail dot com I have a very similar problem. Segfaults when executing two exactly same queries each after another. The query must contain a JOIN and one of the tables a CLOB (if it is against a single table without a join works fine). If the query is executed only once it works. ============== CODE =========== <? $db = new \PDO('oci:host=192.168.1.231;port=1521;dbname=192.168.1.231/orcl;charset=AL32UTF8','user','pass'); $q = " SELECT clob_column FROM table1 INNER JOIN table2 ON table2.tid=table1.tid WHERE main_table.tid = :tid "; $b = array('tid'=>1); $s = $db->prepare($q); $s->execute($b); $data = $s->fetchAll(); $q = " SELECT clob_column FROM table1 INNER JOIN table2 ON table2.tid=table1.tid WHERE main_table.tid = :tid "; $b = array('tid'=>1); $s = $db->prepare($q); $s->execute($b); $data = $s->fetchAll(); print 'ok';//never reached ?> =================== CONFIGURE OPTIONS =========== './configure' '--prefix=/web/php5.3-debug' '--with-apxs2=/web/apache2.2-php5.3-debug/bin/apxs' '--enable-bcmath=shared' '--with-bz2=shared' '--enable-calendar=shared' '--with-curl=shared' '--enable-dbase=shared' '--enable-dbx=shared' '--enable-exif=shared' '--with-fam=shared' '--with-gettext=shared' '--with-gmp=shared' '--with-iconv=shared' '--with-gd=shared' '--with-ttf' '--with-freetype-dir' '--enable-gd-native-ttf' '--with-jpeg-dir' '--with-png-dir' '--with-xpm-dir--with-imap-ssl' '--with-kerberos' '--with-ldap=shared' '--with-ldap-sasl' '--with-mcal=shared' '--with-mcrypt=shared' '--with-mhash=shared' '--enable-mbstring=shared' '--with-mysql=shared,/usr' '--with-mysqli=shared,/usr/bin/mysql_config' '--with-ncurses=shared' '--with-openssl=shared' '--enable-pcntl=shared' '--with-pgsql=shared,/usr/bin/pg_config' '--with-imap=shared' '--with-imap-ssl' '--with-oci8=shared,instantclient,/opt/oracle_instantclient_11,11.1.0.6.0' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--enable-sysvmsg=shared' '--enable-shmop' '--enable-mbstring' '--with-zlib=shared' '--with-bz2=shared' '--with-xsl=shared' '--with-pdo-mysql=shared' '--with-pdo-pgsql=shared' '--with-pdo-oci=shared,instantclient,/opt/oracle_instantclient_11,11.1.0.6.0' '--enable-debug' =================== BACKTRACE ============== #0 0x00002b46f4b7148c in kohfri () from /opt/oracle_instantclient_11/libclntsh.so.11.1 #1 0x00002b46f5fe1fd1 in kohfrr () from /opt/oracle_instantclient_11/libclntsh.so.11.1 #2 0x00002b46f4b710e2 in kohfrw () from /opt/oracle_instantclient_11/libclntsh.so.11.1 #3 0x00002b46f4abdbeb in kollfrfn () from /opt/oracle_instantclient_11/libclntsh.so.11.1 #4 0x00002b46f47d472e in kpufdesc2 () from /opt/oracle_instantclient_11/libclntsh.so.11.1 #5 0x00002b46f47d3ebb in kpufdesc () from /opt/oracle_instantclient_11/libclntsh.so.11.1 #6 0x00002b46f47a8af9 in OCIDescriptorFree () from /opt/oracle_instantclient_11/libclntsh.so.11.1 #7 0x00002b46f7621aa6 in oci_blob_close (stream=0xa94680, close_handle=1) at /home/DATA/temp_compile/php-5.3.0/ext/pdo_oci/oci_statement.c:652 #8 0x00002b46f0cc1105 in _php_stream_free (stream=0xa94680, close_options=11) at /home/DATA/temp_compile/php-5.3.0/main/streams/streams.c:356 #9 0x00002b46f0cc3d7d in stream_resource_regular_dtor (rsrc=0xa94868) at /home/DATA/temp_compile/php-5.3.0/main/streams/streams.c:1426 #10 0x00002b46f0d35e38 in list_entry_destructor (ptr=0xa94868) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_list.c:184 #11 0x00002b46f0d32d7b in zend_hash_del_key_or_index (ht=0x2b46f15286b0, arKey=0x0, nKeyLength=0, h=3, flag=1) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_hash.c:497 #12 0x00002b46f0d35905 in _zend_list_delete (id=3) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_list.c:58 #13 0x00002b46f0d1fd57 in _zval_dtor_func (zvalue=0xa94590, __zend_filename=0x2b46f1224d28 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_execute_API.c", __zend_lineno=435) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.c:60 #14 0x00002b46f0d0f6d5 in _zval_dtor (zvalue=0xa94590, __zend_filename=0x2b46f1224d28 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_execute_API.c", __zend_lineno=435) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.h:35 #15 0x00002b46f0d0f9fc in _zval_ptr_dtor (zval_ptr=0xa94990, __zend_filename=0x2b46f1225e80 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.c", __zend_lineno=175) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_execute_API.c:435 #16 0x00002b46f0d20106 in _zval_ptr_dtor_wrapper (zval_ptr=0xa94990) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.c:175 #17 0x00002b46f0d32ece in zend_hash_destroy (ht=0xa94458) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_hash.c:526 #18 0x00002b46f0d1fd10 in _zval_dtor_func (zvalue=0xa943e0, __zend_filename=0x2b46f1224d28 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_execute_API.c", __zend_lineno=435) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.c:43 #19 0x00002b46f0d0f6d5 in _zval_dtor (zvalue=0xa943e0, __zend_filename=0x2b46f1224d28 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_execute_API.c", __zend_lineno=435) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.h:35 #20 0x00002b46f0d0f9fc in _zval_ptr_dtor (zval_ptr=0xa94a30, __zend_filename=0x2b46f1225e80 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.c", __zend_lineno=175) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_execute_API.c:435 #21 0x00002b46f0d20106 in _zval_ptr_dtor_wrapper (zval_ptr=0xa94a30) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.c:175 #22 0x00002b46f0d32ece in zend_hash_destroy (ht=0xa94208) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_hash.c:526 #23 0x00002b46f0d1fd10 in _zval_dtor_func (zvalue=0xa93468, __zend_filename=0x2b46f1229b38 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_execute.c", __zend_lineno=698) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.c:43 #24 0x00002b46f0d5195d in _zval_dtor (zvalue=0xa93468, __zend_filename=0x2b46f1229b38 "/home/DATA/temp_compile/php-5.3.0/Zend/zend_execute.c", __zend_lineno=698) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_variables.h:35 #25 0x00002b46f0d89dee in zend_assign_to_variable (variable_ptr_ptr=0xa94b48, value=0xa929e0, is_tmp_var=0) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_execute.c:698 #26 0x00002b46f0e014e0 in ZEND_ASSIGN_SPEC_CV_VAR_HANDLER (execute_data=0x2b46fd11f090) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_vm_execute.h:27263 #27 0x00002b46f0d540ee in execute (op_array=0xa8f240) at /home/DATA/temp_compile/php-5.3.0/Zend/zend_vm_execute.h:104 #28 0x00002b46f0d229db in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /home/DATA/temp_compile/php-5.3.0/Zend/zend.c:1188 #29 0x00002b46f0ca6c6c in php_execute_script (primary_file=0x7fffc2c2ca30) at /home/DATA/temp_compile/php-5.3.0/main/main.c:2196 #30 0x00002b46f0e11fc6 in php_handler (r=0xac6878) at /home/DATA/temp_compile/php-5.3.0/sapi/apache2handler/sapi_apache2.c:648 #31 0x000000000044151c in ap_run_handler () #32 0x0000000000441db5 in ap_invoke_handler () #33 0x0000000000452600 in ap_process_request () #34 0x000000000044f5e1 in ap_process_http_connection () #35 0x000000000044a89a in ap_run_process_connection () #36 0x000000000044acd4 in ap_process_connection () #37 0x0000000000458f47 in child_main () #38 0x00000000004590ed in make_child () #39 0x000000000045915b in startup_children () #40 0x0000000000459615 in ap_mpm_run ------------------------------------------------------------------------ [2009-04-25 15:00:22] jani@php.net See also bug #44852 ------------------------------------------------------------------------ [2009-03-03 15:36:03] simong at bluhalo dot com We are receiving the same segfault in PHP 5.2.8 This is our backtrace: Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1208256752 (LWP 8743)] 0x0324e96f in kghufree () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 (gdb) bt #0 0x0324e96f in kghufree () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 #1 0x031eea1f in kohfrem () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 #2 0x031ee29c in kohfrr () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 #3 0x031eeca7 in kohfrw () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 #4 0x0308a438 in kollfrfn () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 #5 0x02b369f9 in kpufdesc () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 #6 0x02c079be in OCIDescriptorFree () from /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 #7 0x011e129c in oci_blob_close (stream=0xa11026c, close_handle=1) at /root/php-5.2.8/ext/pdo_oci/oci_statement.c:652 #8 0x013626b1 in _php_stream_free (stream=0xa11026c, close_options=56830048) at /root/php-5.2.8/main/streams/streams.c:350 #9 0x013628db in stream_resource_regular_dtor (rsrc=0xa1102f0) at /root/php-5.2.8/main/streams/streams.c:1371 #10 0x0139bc22 in list_entry_destructor (ptr=0xa1102f0) at /root/php-5.2.8/Zend/zend_list.c:184 #11 0x0139a16d in zend_hash_del_key_or_index (ht=0x151f720, arKey=0xa12cd <Address 0xa12cd out of bounds>, nKeyLength=0, h=173, flag=1) at /root/php-5.2.8/Zend/zend_hash.c:497 #12 0x0139be6c in _zend_list_delete (id=173) at /root/php-5.2.8/Zend/zend_list.c:58 #13 0x0138321f in _zval_ptr_dtor (zval_ptr=0xa110a58) at /root/php-5.2.8/Zend/zend_variables.h:35 #14 0x013993e6 in zend_hash_destroy (ht=0xa110b94) at /root/php-5.2.8/Zend/zend_hash.c:526 #15 0x0138f2c5 in _zval_dtor_func (zvalue=0xa1107bc) at /root/php-5.2.8/Zend/zend_variables.c:43 #16 0x0138321f in _zval_ptr_dtor (zval_ptr=0xa10f97c) at /root/php-5.2.8/Zend/zend_variables.h:35 #17 0x013993e6 in zend_hash_destroy (ht=0xa11051c) at /root/php-5.2.8/Zend/zend_hash.c:526 #18 0x013a7f73 in zend_object_std_dtor (object=0xa1104f0) at /root/php-5.2.8/Zend/zend_objects.c:45 #19 0x013a7fa2 in zend_objects_free_object_storage (object=0xa1104f0) at /root/php-5.2.8/Zend/zend_objects.c:122 #20 0x013ab2a9 in zend_objects_store_del_ref_by_handle (handle=156) at /root/php-5.2.8/Zend/zend_objects_API.c:206 #21 0x013ab2e8 in zend_objects_store_del_ref (zobject=0xa110504) at /root/php-5.2.8/Zend/zend_objects_API.c:168 #22 0x0138321f in _zval_ptr_dtor (zval_ptr=0xa110cec) at /root/php-5.2.8/Zend/zend_variables.h:35 #23 0x013993e6 in zend_hash_destroy (ht=0xa10fb88) at /root/php-5.2.8/Zend/zend_hash.c:526 #24 0x0138f2c5 in _zval_dtor_func (zvalue=0xa10fd88) at /root/php-5.2.8/Zend/zend_variables.c:43 #25 0x0138321f in _zval_ptr_dtor (zval_ptr=0x9f22dd0) at /root/php-5.2.8/Zend/zend_variables.h:35 #26 0x013993e6 in zend_hash_destroy (ht=0x9ee9718) at /root/php-5.2.8/Zend/zend_hash.c:526 #27 0x013a7f73 in zend_object_std_dtor (object=0x9f1832c) at /root/php-5.2.8/Zend/zend_objects.c:45 #28 0x013a7fa2 in zend_objects_free_object_storage (object=0x9f1832c) at /root/php-5.2.8/Zend/zend_objects.c:122 #29 0x013ab2a9 in zend_objects_store_del_ref_by_handle (handle=118) at /root/php-5.2.8/Zend/zend_objects_API.c:206 #30 0x013ab2e8 in zend_objects_store_del_ref (zobject=0x9f22c58) at /root/php-5.2.8/Zend/zend_objects_API.c:168 #31 0x0138321f in _zval_ptr_dtor (zval_ptr=0x9e3bab4) at /root/php-5.2.8/Zend/zend_variables.h:35 #32 0x013993e6 in zend_hash_destroy (ht=0x9e3b958) at /root/php-5.2.8/Zend/zend_hash.c:526 #33 0x013a7f73 in zend_object_std_dtor (object=0x9dcf218) at /root/php-5.2.8/Zend/zend_objects.c:45 #34 0x013a7fa2 in zend_objects_free_object_storage (object=0x9dcf218) at /root/php-5.2.8/Zend/zend_objects.c:122 #35 0x013aaecd in zend_objects_store_free_object_storage (objects=0x151f7c8) at /root/php-5.2.8/Zend/zend_objects_API.c:89 #36 0x01383a21 in shutdown_executor () at /root/php-5.2.8/Zend/zend_execute_API.c:299 #37 0x0138f833 in zend_deactivate () at /root/php-5.2.8/Zend/zend.c:860 #38 0x0134f6d7 in php_request_shutdown (dummy=0x0) at /root/php-5.2.8/main/main.c:1492 #39 0x01409946 in php_handler (r=0x99ba468) at /root/php-5.2.8/sapi/apache2handler/sapi_apache2.c:469 #40 0x0029c96d in ap_run_handler () from /usr/sbin/httpd #41 0x002a0318 in ap_invoke_handler () from /usr/sbin/httpd #42 0x002ac38e in ap_process_request () from /usr/sbin/httpd #43 0x002a916f in ap_register_input_filter () from /usr/sbin/httpd #44 0x002a483d in ap_run_process_connection () from /usr/sbin/httpd #45 0x002a493c in ap_process_connection () from /usr/sbin/httpd #46 0x002b0952 in ap_graceful_stop_signalled () from /usr/sbin/httpd #47 0x002b0bc4 in ap_graceful_stop_signalled () from /usr/sbin/httpd #48 0x002b1ad9 in ap_mpm_run () from /usr/sbin/httpd #49 0x00288147 in main () from /usr/sbin/httpd ------------------------------------------------------------------------ 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/bug.php?id=44589 -- Edit this bug report at http://bugs.php.net/bug.php?id=44589&edit=1