ID: 40589
Updated by: andrey@php.net
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] tony2001@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.
------------------------------------------------------------------------
[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