I get a really strange, meaningless and completely random error when I take strings from a resource (query) using PHP.
My development machine is Windows XP SP3 with Apache 2.2, while MySQL runs on a virtual machine using ubuntu 10.04, with 768 MB of RAM, 100 GB of hard drive and 4 logical cores (Intel q6600). However, this problem is not related to PHP on Windows, because I get the same error when running the code on the database machine.
I use the extension mysql(not mysqlior mysqlnd), but looking back, I based the patch on this error related to the mysqlnd extension, so probably I should try.
The main problem is that when I execute this query (a really big query with several views and more than 20 connections) and quickly processes the results, and everything goes well, but when my code spent about 15/20 seconds to process the block strings (I need to build an object from a block of strings connected between them in a really certain way, I can’t change it, the database is not mine, but some PDF files from this object) after a while (random time) I get this error " Empty body pack eta rows. "
I use unbuffered queries to reduce memory consumption (if I turn on buffering, I get about 260 MB of used memory), but this should not be a problem.