Doctrine 2 - ORM

MultiTableUpdateExecutor works incorrect with query cache enabled

Details

  • Type: Bug Bug
  • Status: Resolved 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

Ascending order - Click to sort in descending order
Hide
Permalink
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 ]
Hide
Permalink
Fabio B. Silva added a comment -

Fixed : https://github.com/doctrine/doctrine2/commit/60b8bc63a1a4819cf112cfbbc7cca06b5792aba6

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
Permalink
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[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Fabio B. Silva
    Reporter:
    Valera Leontyev
Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: