ID: 39759 User updated by: mike at we11er dot co dot uk Reported By: mike at we11er dot co dot uk Status: Open Bug Type: PDO related Operating System: Windows XP PHP Version: 5.2.0 Assigned To: iliaa New Comment:
OK, having tested with the commandline version of php, the error is much less frequent, 99% of the time the test script works. Running through apache however, the error happens every time, except sometimes when I have just restarted the mysql service. Previous Comments: ------------------------------------------------------------------------ [2006-12-13 11:19:07] mike at we11er dot co dot uk I'm not using the old binaries. Every time I've tested this I have rd /s'd the php directory and copied the new snapshot version across. I have tried with the latest snapshot again (Built On: Dec 13, 2006 09:30 GMT), the md5sum of the php_pdo_mysql.dll is 6460abb216e83219fb29b9e80580643a. I have tried with libmysql.dll from the php directory which gives the "SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server" and also with the libmysql.dll with my MySQL installation, which gives the unbuffered query error. So changing the libmysql.dll I use changes the error but not the cause of the problem, which must be pdo_mysql. I have no doubt it works on your machine, but there is clearly still a problem /somewhere/. Perhaps you could try (if you haven't already) it with a more recent version of mysql and libmysql.dll. Reading those pecl bug reports suggests that in some cases it doesn't happen all the time, although with me I've only ever seen it work once which was just after I started the mysql service, but then when I hit refresh it was broken again. Once again, I am /not/ using old binaries, and if there is anything I can do to assure you of this let me know. I just want to find out why the heck this is happening. It could be a bug in MySQL itself for all I know, but I don't know how I would verify that. ------------------------------------------------------------------------ [2006-12-12 15:43:27] [EMAIL PROTECTED] It definitely works fine here even with 3 stored procedures being called from one script. If as you claim you get the same unbuffered query message from the PDO it means you are still using the old binaries ------------------------------------------------------------------------ [2006-12-12 14:18:04] mike at we11er dot co dot uk I'm sorry to reopen yet again, but I still have this issue, and it's identical to these two bug reports on the PECL site: http://pecl.php.net/bugs/bug.php?id=7976 http://pecl.php.net/bugs/bug.php?id=5827 These people describe the "Lost connection to MySQL server during query" when calling multiple stored procedures, which I am having on the latest cvs snapshot. I've done a clean install of everything, and this problem persists. There is clearly still a problem somewhere with certain configurations. ------------------------------------------------------------------------ [2006-12-08 19:51:36] [EMAIL PROTECTED] This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. ------------------------------------------------------------------------ [2006-12-08 16:54:35] mike at we11er dot co dot uk When I use libmysql.dll from the php snapshot, I get the connection lost error. When I use libmysql.dll from my mysql installation, I get the unbuffered query error. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/39759 -- Edit this bug report at http://bugs.php.net/?id=39759&edit=1
