#47034 [Opn]: Prepared-Statement fails when MySQL-Server under load
ID: 47034
User updated by: raphithom at gmx dot ch
Reported By: raphithom at gmx dot ch
Status: Open
Bug Type: MySQLi related
Operating System: FreeBSD 6.3-RELEASE-p5
PHP Version: 5.2.8
New Comment:
I forgot to mention, that the mysqldumps are running on other
databases, not on the one where I'm executing the prepared statement.
Previous Comments:
------------------------------------------------------------------------
[2009-01-08 08:57:44] raphithom at gmx dot ch
Description:
------------
Hello
As backup-procedure we use 4 concurrent mysql-dump processes. When
these processes are running, MySQLi-Prepared-Statements can't be
executed and the following error appears:
Errno: 1615
Message: Prepared statement needs to be re-prepared
In my opinion it doesn't seem to be a mysql-problem because
prepared-statements with PDO and "normal" mysql_query() or
mysqli->query() work as expected. The error doesn't occur if no
mysqldumps are running.
Reproduce code:
---------------
http://tmp.raphis.ch/mysqli_problem.phps
Expected result:
----------------
All queries should return the same texts.
Actual result:
--------------
mysqli-select, mysql_select and PDO work as expected. mysqli-prepared
statements exits with:
Errno: 1615
Message: Prepared statement needs to be re-prepared
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=47034&edit=1
Thread (3 messages)