mysqli loses connection to server randomly during multiple stored procedure calls

[markjrubin]

I am running

PHP Version 5.1.6
Mysqli driver version 5.0.24a
MySQL 5.something
Apache 2.0

on Windows XP Pro

I have some code that I can call 20 times in a row and 15 of those times during the middle of the code, the mysqli object I've created will error out saying, "Lost connection to MySQL server during query." My coworkers can't seem to get it on their machines running identical versions of all of the above software and my test code.

Can you think of anything to check that might be different on my machine than my coworkers machines?

Mark

[MarkR]

Well, the data in your database may be different.

I think this problem may be because you haven't entirely read all of the result sets returned by the query. If you do a batch query (or call a SP), multiple results may be returned. You MUST read all of them before issuing the next statement. This is a known issue.

Mark