#40589 [Opn->Fbk]: mysqli can't handle a reconnect, crashes

ID: 40589 Updated by: tony2001@php.net Reported By: pegasus at nerv dot eu dot org -Status: Open +Status: Feedback -Bug Type: Reproducible crash +Bug Type: MySQLi related Operating System: Linux PHP Version: 5.2.1 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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