Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-2090

MultiTableUpdateExecutor works incorrect with query cache enabled

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: Git Master
    • Fix Version/s: 2.4, 2.3.3
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None

      Description

      Doctrine\ORM\Query\Exec\MultiTableUpdateExecutor works incorrect with query cache enabled.
      I execute two similar update-queries with different parameters, but the second query is never executed in database.

      There is todo-task in code:

      //FIXME (URGENT): With query cache the parameter is out of date. Move to execute() stage.

      This is important issue. Much time spent in debugging.

        Activity

        Valera Leontyev created issue -
        Hide
        Valera Leontyev added a comment -

        Workaround is to disable query cache per every multitable update query: http://stackoverflow.com/questions/12969460/doctrine-query-cache-update

        Show
        Valera Leontyev added a comment - Workaround is to disable query cache per every multitable update query: http://stackoverflow.com/questions/12969460/doctrine-query-cache-update
        Fabio B. Silva made changes -
        Field Original Value New Value
        Assignee Benjamin Eberlei [ beberlei ] Fabio B. Silva [ fabio.bat.silva ]
        Show
        Fabio B. Silva added a comment - Fixed : https://github.com/doctrine/doctrine2/commit/60b8bc63a1a4819cf112cfbbc7cca06b5792aba6
        Fabio B. Silva made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.4 [ 10321 ]
        Resolution Fixed [ 1 ]
        Benjamin Eberlei made changes -
        Fix Version/s 2.3.3 [ 10329 ]
        Hide
        Benjamin Eberlei added a comment -

        Merged into 2.3 for release with 2.3.3

        Show
        Benjamin Eberlei added a comment - Merged into 2.3 for release with 2.3.3

        This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

        • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DDC-2090, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

          • Assignee:
            Fabio B. Silva
            Reporter:
            Valera Leontyev
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: