PHP unexpected memory usage [duplicate]

Question

I am just developing my website, but I got an error

"Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4294967296 bytes) in...".

The odd thing is that it works fine and my memory usage is about 500,000 right up until a single line in my code:

 echo'<script>alert("'."X-".memory_get_usage(true).'");</script>';
 $queryX = "SELECT `data`,`image`,`date` FROM messages WHERE toX = ? or fromX = ?";
 echo'<script>alert("'."X2-".memory_get_usage(true).'");</script>';
 $stmtX = $connection->prepare($queryX);
 echo'<script>alert("'."X3-".memory_get_usage(true).'");</script>';
 $stmtX->bind_param('ss',$idlistX[$i],$idlistX[$i]);
 echo'<script>alert("'."X4-".memory_get_usage(true).'");</script>';
 $stmtX->bind_result($dataT,$imageT,$dateT);

I have those alerts in to track it. Does anyone know how that last line is causing trouble?

Answer 1

Do you happen to have a blob column?

4294967296 shows that you're trying to allocated memory, coincidently or not, that's the max length of a blob column.

It may as well but a bug, and not a leak, and it could come from the bind statements.

If you do have a blob column, try casting it to varchar in your select statement.