Memory leaks Symfony2 Doctrine2 / exceed memory limit

by

As stated by the Doctrine Configuration Reference by default logging of the SQL connection is set to the value of kernel.debug, so if you have instantiated AppKernel with debug set to true the SQL commands get stored in memory for each iteration.

You should either instantiate AppKernel to false, set logging to false in you config YML, or either set the SQLLogger manually to null before using the EntityManager

$em->getConnection()->getConfiguration()->setSQLLogger(null);

More Related Contents:

  1. What is the difference between fetch=”EAGER” and fetch=”LAZY” in doctrine
  2. The EntityManager is closed
  3. Doctrine 2 ArrayCollection filter method
  4. What is the “N+1 selects problem” in ORM (Object-Relational Mapping)?
  5. Count Rows in Doctrine QueryBuilder
  6. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  7. On delete cascade with doctrine2
  8. How do I map lists of nested objects with Dapper
  9. Default value in Doctrine
  10. Symfony2 file upload step by step
  11. Symfony2-Doctrine: ManyToMany relation is not saved to database
  12. How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?
  13. Using Relationships with Multiple Entity Managers
  14. symfony2: how to use group_concat in QueryBuilder
  15. What are the advantages of using an ORM? [closed]
  16. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  17. How to set up entity (doctrine) for database view in Symfony 2
  18. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  19. How to setup table prefix in symfony2
  20. Symfony 2: Creating a service from a Repository
  21. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  22. Symfony 2.0 getting service inside entity
  23. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  24. Dapper.Rainbow VS Dapper.Contrib
  25. Doctrine query builder using inner join with conditions
  26. INNER JOIN Results from Select Statement using Doctrine QueryBuilder
  27. What is an Object-Relational Mapping Framework? [duplicate]
  28. How to configure naming strategy in Doctrine 2
  29. Primary key of owning side as a join column
  30. How can I use DATE() in Doctrine 2 DQL?

Leave a Comment