Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 2.1.4
    • Fix Version/s: 2.1.6, 2.2
    • Component/s: None
    • Security Level: All
    • Labels:
      None
    • Environment:
      PHP 5.3.6

      Description

      After upgrading to 2.1.4 (from 2.1.2), the following dql started creating way more queries than necessary :
      SELECT m, p, s, c, o
      FROM FERMainBundle:Menu m
      LEFT JOIN m.page p
      LEFT JOIN m.section s
      LEFT JOIN m.children c
      LEFT JOIN s.position o
      ORDER BY m.lft

      Details to the code here:
      http://pastie.textmate.org/private/z9gtgqe1odwenxcmudywqa
      The model looks like that:
      http://pastie.textmate.org/private/przxzfimsfyua02cxqcv9a

      http://pastie.textmate.org/private/ob1jqiekv89e4xj9bq06q
      First query is executed, it should in fact retrieve everything there is about the menu, but then it runs the second query for every menu element I have, generating a lot of queries that didn't occur before.

      1. trace.txt
        5.94 MB
        Pascal Burkhard
      2. trace.txt
        40 kB
        Pascal Burkhard

        Issue Links

          Activity

          Pascal Burkhard created issue -
          Benjamin Eberlei made changes -
          Field Original Value New Value
          Priority Major [ 3 ] Critical [ 2 ]
          Pascal Burkhard made changes -
          Attachment trace.txt [ 11133 ]
          Pascal Burkhard made changes -
          Attachment trace.txt [ 11134 ]
          Benjamin Eberlei made changes -
          Link This issue is duplicated by DDC-1573 [ DDC-1573 ]
          Benjamin Eberlei made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 2.1.6 [ 10182 ]
          Fix Version/s 2.2 [ 10157 ]
          Resolution Fixed [ 1 ]
          Benjamin Eberlei made changes -
          Workflow jira [ 13250 ] jira-feedback [ 15139 ]
          Benjamin Eberlei made changes -
          Workflow jira-feedback [ 15139 ] jira-feedback2 [ 17003 ]
          Benjamin Eberlei made changes -
          Workflow jira-feedback2 [ 17003 ] jira-feedback3 [ 19256 ]
          Miha Vrhovnik made changes -
          Comment [ Ca I get a face palm :P ]

            People

            • Assignee:
              Benjamin Eberlei
              Reporter:
              Pascal Burkhard
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: