Memory leak in PHP with Symfony + Doctrine

Question

I'm using PHP with the Symfony framework (with Doctrine as my ORM) to build a spider that crawls some sites.

My problem is that the following code generates a memory leak:

$q = $this -> createQuery('Product p');

if($store) {
    $q
        -> andWhere('p.store_id = ?', $store -> getId())
        -> limit(1);
}

$q -> andWhere('p.name = ?', $name);

$data = $q -> execute();
$q -> free(true);
$data -> free(true);
return NULL;

This code is placed in a subclass of Doctrine_Table. If I comment out the execute part (and of course the $data -> free(true)) the leak stops. This has led me to the conclusion that it's the Doctrine_Collection that's causing the leak.

Answer 1

I solved my problems with Doctrine memory leaks by freeing and unseting data, did you try it?

// ...
$data->free(true) ;
unset($data) ;
// ...

Answer 2

What version of PHP are you using? If it's < 5.3 it probably has to do with the 'recursive references leak memory' bug.

You can also try to call Doctrine_Manager::connection()->clear(), which should clean up the connection and remove identity map entries

Answer 3

I'm just running into the same problem with a CLI command that runs continuously. After spending many hours to troubleshoot this issue it turns out that running my commands in prod mode actually solved the issue:

app/console my:custom:command --env=prod

Answer 4

Should you be using addWhere instead of andWhere? Also I believe a limit should be added at the end of a statement, try:

$q = $this -> createQuery('Product p') -> where('p.name = ?', $name);

 if($store) {
$q
    -> addWhere('p.store_id = ?', $store -> getId())
    -> limit(1);
 }

 $data = $q -> execute();
 $q -> free(true);
 $data -> free(true);
return NULL;