Welcome Guest, Not a member yet? Register   Sign In
[solved]oci8_result memory leak?
#1

[eluser]regal2157[/eluser]
Mod, please delete

Hi guys,

I am running a file, which queries databases at different points. Currently, I am stuck on the third query. I run two, and after I am done processing the info, I do a $var->free_result(); call.

When I run the third though, I keep getting this error

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 42 bytes) in /usr/apps/webdata/framework/system/database/drivers/oci8/oci8_result.php on line 155

I've run larger queries than this, so I am quite lost as to why now it is happening.

Code:
<?php
$more_sql = $this->db2->query("QUERY HERE");
foreach($more_sql->result() as $row)
{
    #Do Stuff
}
?>

The query works, as I test all in SQLDeveloper first. I only set a variable currently in the foreach loop, but I keep getting the memory exhausted error.

Mod, please delete




Theme © iAndrew 2016 - Forum software by © MyBB