php/symfony/doctrine memory leak?

by

Tried doing 

$cupo->save();
$cupo->free();
$cupo = null;

(But substituting my code) And I’m still getting memory overflows. Any other ideas, SO?

Update:

I created a new environment in my databases.yml, that looks like:

all:
  doctrine:
    class: sfDoctrineDatabase
    param:
      dsn: 'mysql:host=localhost;dbname=.......'
      username: .....
      password: .....
      profiler: false

The profiler: false entry disables doctrine’s query logging, that normally keeps a copy of every query you make. It didn’t stop the memory leakage, but I was able to get about twice as far through my data importing as I was without it.

Update 2

I added 

Doctrine_Manager::connection()->setAttribute(Doctrine_Core::ATTR_AUTO_FREE_QUERY_OBJECTS, true );

before running my queries, and changed

$cupo = null;

to 

unset($cupo);

And now my script has been churning away happily. I’m pretty sure it will finish without running out of RAM this time.

Update 3

Yup. That’s the winning combo.

More Related Contents:

  1. PHP ORMs: Doctrine vs. Propel
  2. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  3. Diagnosing Memory Leaks – Allowed memory size of # bytes exhausted
  4. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  5. Efficiently counting the number of lines of a text file. (200mb+)
  6. Why doesn’t MySQL support millisecond / microsecond precision?
  7. Doctrine Query Language get Max/Latest Row Per Group
  8. Symfony: Clear doctrine cache
  9. PHPUnit Mock Objects and Static Methods
  10. How to re-save the entity as another row in Doctrine 2
  11. Generating a single Entity from existing database using symfony2 and doctrine
  12. How to specify Composer install path?
  13. Symfony error The class XXX was not found in the chain configured namespaces XXX
  14. Doctrine – How to print out the real sql, not just the prepared statement?
  15. Execute raw SQL using Doctrine 2
  16. Can I access discriminator field from php in doctrine2?
  17. How to force Doctrine to update array type fields?
  18. DOMDocument PHP Memory Leak
  19. What is the safest way of passing arguments from server-side PHP to client-side JavaScript [duplicate]
  20. How can I use DATE() in Doctrine 2 DQL?
  21. Needle in a Haystack for Php [closed]
  22. String with array structure to Array [duplicate]
  23. Use php to set cron jobs in Windows
  24. How to run php files on my computer
  25. Get image color
  26. Setting document root for Laravel project on Apache virtual host
  27. String comparison using ‘==’ or ‘===’ vs. ‘strcmp()’
  28. definitive way to get user ip address php [duplicate]
  29. Getting first weekday in a month with strtotime
  30. How do I detect non-ASCII characters in a string?

Leave a Comment