Edit report at http://bugs.php.net/bug.php?id=53716&edit=1
ID: 53716 User updated by: anthon dot pang at gmail dot com Reported by: anthon dot pang at gmail dot com Summary: segfault in $stmt->execute() -Status: Feedback +Status: Open Type: Bug Package: PDO related Operating System: Ubuntu 10.04 PHP Version: 5.3.5 Block user comment: N Private report: N New Comment: I'm in the middle of a project. For reference, the segfault occurs in r3717: http://dev.piwik.org/trac/changeset/3717/trunk?old_path=%2F&format=zip Please keep this ticket open until I have some free time to troubleshoot and isolate a smaller test case. (I can already tell you it'll require database access and be more than the arbitrary 20 line limit.) Additional info: Same code doesn't crash when using MYSQLI or php 5.2.17. (Tested/segfaulted with 5.3.2, 5.3.3, 5.3.4, and 5.3.5. These are all vanilla builds using source downloads from php.net.) Previous Comments: ------------------------------------------------------------------------ [2011-01-12 12:00:33] paj...@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2011-01-12 07:27:41] anthon dot pang at gmail dot com Description: ------------ The snippet of code shown used is a method from a class that subclasses Zend_Db_Adapter_Abstract. We make a lot of query() calls, so caching prepared statements reportedly gives us a 10% performance improvement. #! /bin/sh # # Created by configure './configure' \ '--with-mysqli=mysqlnd' \ '--with-pdo-mysql=mysqlnd' \ '--with-zlib' \ '--enable-zip' \ '--with-gd' \ '--with-curl' \ '--enable-mbstring' \ '--enable-debug' \ "$@" Test script: --------------- public function query($sql, $bind = array()) { static $cachePreparedStatement = array(); if(isset($cachePreparedStatement[$sql])) { if (!is_array($bind)) { $bind = array($bind); } $stmt = $cachePreparedStatement[$sql]; $stmt->execute($bind); return $stmt; } $stmt = parent::query($sql, $bind); $cachePreparedStatement[$sql] = $stmt; return $stmt; } Expected result: ---------------- No crash. Actual result: -------------- Program received signal SIGSEGV, Segmentation fault. 0x003c7816 in ?? () from /lib/tls/i686/cmov/libc.so.6 (gdb) bt #0 0x003c7816 in ?? () from /lib/tls/i686/cmov/libc.so.6 #1 0x082818c6 in do_fetch (stmt=0x99cb938, do_bind=1, return_value=0x8f5c78c, how=PDO_FETCH_ASSOC, ori=PDO_FETCH_ORI_NEXT, offset=0, return_all=0x0) at /home/apang/work/php/php-5.3.5/ext/pdo/pdo_stmt.c:1044 #2 0x082825a2 in zim_PDOStatement_fetch (ht=3, return_value=0x8f5c78c, return_value_ptr=0x0, this_ptr=0xb7ecba54, return_value_used=1) at /home/apang/work/php/php-5.3.5/ext/pdo/pdo_stmt.c:1316 #3 0x08501e58 in zend_do_fcall_common_helper_SPEC (execute_data=0x8bd0dc0) at /home/apang/work/php/php-5.3.5/Zend/zend_vm_execute.h:316 #4 0x08502415 in ZEND_DO_FCALL_BY_NAME_SPEC_HANDLER (execute_data=0x8bd0dc0) at /home/apang/work/php/php-5.3.5/Zend/zend_vm_execute.h:421 #5 0x085014f5 in execute (op_array=0x971d190) at /home/apang/work/php/php-5.3.5/Zend/zend_vm_execute.h:107 #6 0x084c6e07 in zend_call_function (fci=0xbfffce28, fci_cache=0xbfffce4c) at /home/apang/work/php/php-5.3.5/Zend/zend_execute_API.c:964 #7 0x083849e1 in zif_call_user_func_array (ht=2, return_value=0x9a03db0, return_value_ptr=0x0, this_ptr=0x0, return_value_used=0) at /home/apang/work/php/php-5.3.5/ext/standard/basic_functions.c:4796 #8 0x08501e58 in zend_do_fcall_common_helper_SPEC (execute_data=0x8bcffdc) at /home/apang/work/php/php-5.3.5/Zend/zend_vm_execute.h:316 #9 0x08505918 in ZEND_DO_FCALL_SPEC_CONST_HANDLER (execute_data=0x8bcffdc) at /home/apang/work/php/php-5.3.5/Zend/zend_vm_execute.h:1606 #10 0x085014f5 in execute (op_array=0x8e7bd1c) ---Type <return> to continue, or q <return> to quit--- at /home/apang/work/php/php-5.3.5/Zend/zend_vm_execute.h:107 #11 0x084d488e in zend_execute_scripts (type=8, retval=0x0, file_count=3) at /home/apang/work/php/php-5.3.5/Zend/zend.c:1194 #12 0x0846a4ee in php_execute_script (primary_file=0xbffff2e4) at /home/apang/work/php/php-5.3.5/main/main.c:2265 #13 0x08592c71 in main (argc=2, argv=0xbffff474) at /home/apang/work/php/php-5.3.5/sapi/cli/php_cli.c:1193 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=53716&edit=1
