ID: 40589 Updated by: [EMAIL PROTECTED] Reported By: pegasus at nerv dot eu dot org Status: Feedback Bug Type: MySQLi related Operating System: Linux PHP Version: 5.2.1 New Comment:
Hi, can you specify which version of libmysql do you use, phpinfo() page should say what is the version of the headers. It seems like http://bugs.mysql.com/bug.php?id=12744 , but it could be another place in libmysql where similar crash occurs. Your help is very appreciated! Regards, Andrey Previous Comments: ------------------------------------------------------------------------ [2007-02-22 10:53:49] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [2007-02-22 09:42:16] pegasus at nerv dot eu dot org Forgot to mention that this only happens when using prepared statements. ------------------------------------------------------------------------ [2007-02-22 08:55:01] pegasus at nerv dot eu dot org Description: ------------ If you set mysql timeouts (in my.cnf) to some short times, like: set-variable = connect_timeout=3 set-variable = interactive_timeout=5 set-variable = wait_timeout=10 And then have a script, that opens mysql connection via mysqli, sleeps for 20 seconds and then tries to do something with that connection, php crashes. Reproduce code: --------------- Simple enough to reproduce from the comment above Actual result: -------------- Segfault: #0 0xb7638542 in net_clear () from /usr/lib/./libmysqlclient.so.15 #1 0xb7613df3 in cli_stmt_execute () from /usr/lib/./libmysqlclient.so.15 #2 0xb76142b3 in mysql_stmt_execute () from /usr/lib/./libmysqlclient.so.15 #3 0x081e806c in zif_mysqli_stmt_execute () #4 0x0842a8ea in execute () #5 0x0842ada6 in execute () #6 0x0842a516 in execute () #7 0x0840c9da in zend_execute_scripts () #8 0x083ca2f4 in php_execute_script () #9 0x0846c701 in main () ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40589&edit=1