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