Doctrine second level result caching not working with deep fetch join query #5598

New Issue

Open

opened 2026-01-22 15:12:24 +01:00 by admin · 6 comments

admin commented 2026-01-22 15:12:24 +01:00

Owner

Copy Link

Originally created by @aimfeld on GitHub (Jul 4, 2017).

I have posted this question on stackoverflow here. It might be a doctrine bug (or a known limitation), so I hope it's okay if I ask here as well.

I have the following query in a doctrine repository:

/**
 * @return AbstractSurveyPage[]
 */
public function getResultCacheTestPages(): array
{
    $select = $this->createQueryBuilder('page')
        ->select(['page', 'pageGroup', 'groupLabelText'])
        ->leftJoin('page.group', 'pageGroup')
        ->leftJoin('pageGroup.labelText', 'groupLabelText');

    // Both useResultCache(true) and setCacheable(true) is needed
    return $select->getQuery()->useResultCache(true)
                  ->setCacheable(true)->getResult();
}

The query fetches page objects, their group objects and the group label eagerly.

However, I get the following error:

File /home/vagrant/web-projects/blueprint/vendor/doctrine/orm/lib/Doctrine/ORM/Cache/DefaultQueryCache.php:263
Message Undefined index: labelText

It seems that doctrine cannot find the labelText association of the group object. When I remove 'groupLabelText' from the select clause, the query and the second level result caching work fine (but the group label objects are not fetched eagerly anymore). When I disable caching with setCacheable(false), the query works fine.

It seems that doctrine is unable to cache results of fetch join queries with joins of more than one level.

Is there a way to get this working? Or should I not use deep fetch join queries, and use lazy fetching for the joined objects? Entity and association second level caching works fine for me, so maybe the performance hit is not that bad. Also, the code would become easier, since the fetch join queries are quite complicated (I use up to 25 joins and elements in the select clause in real code).

Originally created by @aimfeld on GitHub (Jul 4, 2017). I have posted this question on stackoverflow [here](https://stackoverflow.com/questions/44900551/doctrine-second-level-result-caching-not-working-with-deep-fetch-join-query). It might be a doctrine bug (or a known limitation), so I hope it's okay if I ask here as well. I have the following query in a doctrine repository: ``` /** * @return AbstractSurveyPage[] */ public function getResultCacheTestPages(): array { $select = $this->createQueryBuilder('page') ->select(['page', 'pageGroup', 'groupLabelText']) ->leftJoin('page.group', 'pageGroup') ->leftJoin('pageGroup.labelText', 'groupLabelText'); // Both useResultCache(true) and setCacheable(true) is needed return $select->getQuery()->useResultCache(true) ->setCacheable(true)->getResult(); } ``` The query fetches page objects, their group objects and the group label eagerly. However, I get the following error: > File /home/vagrant/web-projects/blueprint/vendor/doctrine/orm/lib/Doctrine/ORM/Cache/DefaultQueryCache.php:263 > Message Undefined index: labelText It seems that doctrine cannot find the labelText association of the group object. When I remove `'groupLabelText'` from the select clause, the query and the second level result caching work fine (but the group label objects are not fetched eagerly anymore). When I disable caching with `setCacheable(false)`, the query works fine. It seems that doctrine is unable to cache results of fetch join queries with joins of more than one level. Is there a way to get this working? Or should I not use deep fetch join queries, and use lazy fetching for the joined objects? Entity and association second level caching works fine for me, so maybe the performance hit is not that bad. Also, the code would become easier, since the fetch join queries are quite complicated (I use up to 25 joins and elements in the select clause in real code).

admin added the BugMissing Tests labels 2026-01-22 15:12:24 +01:00

admin commented 2026-01-22 15:12:26 +01:00

Author

Owner

Copy Link

@lcobucci commented on GitHub (Aug 6, 2017):

@aimfeld sorry for taking that long to get back to you... is this happening on v2.5.x or v2.6.x-dev? We have some known bugs related to L2C on v2.5.x that got fixed on v2.6.x-dev only (due to multiple reasons).

If the issue still happens on v2.6.x-dev, could you please send us a failing test case that reproduces that behaviour? It would help us a lot to identify and fix the issue you're describing.

You can find examples on 388afb46d0/tests/Doctrine/Tests/ORM/Functional/Ticket

@lcobucci commented on GitHub (Aug 6, 2017): @aimfeld sorry for taking that long to get back to you... is this happening on `v2.5.x` or `v2.6.x-dev`? We have some known bugs related to L2C on `v2.5.x` that got fixed on `v2.6.x-dev` only (due to multiple reasons). If the issue still happens on `v2.6.x-dev`, could you please send us a failing test case that reproduces that behaviour? It would help us a lot to identify and fix the issue you're describing. You can find examples on https://github.com/doctrine/doctrine2/tree/388afb46d0cb3ed0c51332e8df0de9e942c2690b/tests/Doctrine/Tests/ORM/Functional/Ticket

admin commented 2026-01-22 15:12:26 +01:00

Author

Owner

Copy Link

@aimfeld commented on GitHub (Aug 6, 2017):

@lcobucci The problem occurs with v2.5.6. I have now tried v2.6.x-dev and I don't get the exception anymore. The query result can now be cached and retrieved properly.

However, when I checked with the debugger I noticed that only the main objects (page) and the object of the first join (pageGroup) are actually retrieved from the cached query result. The objects of the second join (groupLabelText) are only retrieved as proxy objects, they don't seem to be included in the cached query result. So I don't think there's a difference if I include 'groupLabelText' in the select query.

I have already removed the fetch join queries from my code. I guess they don't result in much of a performance gain anyway, if I have all the associations cached.

@aimfeld commented on GitHub (Aug 6, 2017): @lcobucci The problem occurs with `v2.5.6`. I have now tried `v2.6.x-dev` and I don't get the exception anymore. The query result can now be cached and retrieved properly. However, when I checked with the debugger I noticed that only the main objects (`page`) and the object of the first join (`pageGroup`) are actually retrieved from the cached query result. The objects of the second join (`groupLabelText`) are only retrieved as proxy objects, they don't seem to be included in the cached query result. So I don't think there's a difference if I include `'groupLabelText'` in the select query. I have already removed the fetch join queries from my code. I guess they don't result in much of a performance gain anyway, if I have all the associations cached.

admin commented 2026-01-22 15:12:26 +01:00

Author

Owner

Copy Link

@lcobucci commented on GitHub (Aug 6, 2017):

@aimfeld that's kind of weird, all the associations - that are mapped as cached - should have been correctly fetched from the cache layer. Would it be possible to send PR that reproduces that scenario?

@lcobucci commented on GitHub (Aug 6, 2017): @aimfeld that's kind of weird, all the associations - that are mapped as cached - should have been correctly fetched from the cache layer. Would it be possible to send PR that reproduces that scenario?

admin commented 2026-01-22 15:12:27 +01:00

Author

Owner

Copy Link

@aimfeld commented on GitHub (Aug 7, 2017):

@lcobucci I don't have the time to set up the environment and write a test right now, but here are my stripped down models, hope these help (I'm working with MappedSuperclass):

/**
 * @ORM\MappedSuperclass
 */
abstract class AbstractSurveyPage extends AbstractEntity implements SkippableInterface
{
    /**
     * @var AbstractSurveyGroup|null
     *
     * @ORM\Cache("READ_ONLY")
     * @ORM\ManyToOne(targetEntity="Survey\Db\Entity\AbstractSurveyGroup")
     * @ORM\JoinColumn(name="groupID", referencedColumnName="groupID")
     */
    protected $group;
}


/**
 * @ORM\Table(name="survey_pages")
 * @ORM\Entity(repositoryClass="Survey\Db\Repository\SurveyPageRepo", readOnly=true)
 * @ORM\Cache(usage="READ_ONLY")
 */
class SurveyPage extends AbstractSurveyPage
{

}

/**
 * @ORM\MappedSuperclass
 */
abstract class AbstractSurveyGroup extends AbstractEntity
{
    /**
     * @var AbstractText|null
     *
     * @ORM\Cache("READ_ONLY")
     * @ORM\ManyToOne(targetEntity="Survey\Db\Entity\AbstractText")
     * @ORM\JoinColumn(name="labelTextID", referencedColumnName="textID")
     */
    protected $labelText;
}

/**
 * @ORM\Table(name="survey_groups")
 * @ORM\Entity(readOnly=true)
 * @ORM\Cache(usage="READ_ONLY")
 */
class SurveyGroup extends AbstractSurveyGroup
{

}

/**
 * @ORM\MappedSuperclass
 */
abstract class AbstractText extends AbstractEntity
{
    /**
     * @var string|null
     *
     * @ORM\Column(name="sourceText", type="text", length=65535, nullable=true)
     */
    protected $sourceText;
}

/**
 * @ORM\Table(name="texts")
 * @ORM\Entity(readOnly=true)
 * @ORM\Cache(usage="READ_ONLY")
 */
class Text extends AbstractText
{

}

And this is the query:

$select = $pageRepo->createQueryBuilder('page')
    ->select(['page', 'pageGroup', 'groupLabelText'])
    ->leftJoin('page.group', 'pageGroup')
    ->leftJoin('pageGroup.labelText', 'groupLabelText');

$pages = $select->getQuery()->useResultCache(true)->setCacheable(true)->getResult();```

@aimfeld commented on GitHub (Aug 7, 2017): @lcobucci I don't have the time to set up the environment and write a test right now, but here are my stripped down models, hope these help (I'm working with `MappedSuperclass`): ``` /** * @ORM\MappedSuperclass */ abstract class AbstractSurveyPage extends AbstractEntity implements SkippableInterface { /** * @var AbstractSurveyGroup|null * * @ORM\Cache("READ_ONLY") * @ORM\ManyToOne(targetEntity="Survey\Db\Entity\AbstractSurveyGroup") * @ORM\JoinColumn(name="groupID", referencedColumnName="groupID") */ protected $group; } /** * @ORM\Table(name="survey_pages") * @ORM\Entity(repositoryClass="Survey\Db\Repository\SurveyPageRepo", readOnly=true) * @ORM\Cache(usage="READ_ONLY") */ class SurveyPage extends AbstractSurveyPage { } ``` ``` /** * @ORM\MappedSuperclass */ abstract class AbstractSurveyGroup extends AbstractEntity { /** * @var AbstractText|null * * @ORM\Cache("READ_ONLY") * @ORM\ManyToOne(targetEntity="Survey\Db\Entity\AbstractText") * @ORM\JoinColumn(name="labelTextID", referencedColumnName="textID") */ protected $labelText; } /** * @ORM\Table(name="survey_groups") * @ORM\Entity(readOnly=true) * @ORM\Cache(usage="READ_ONLY") */ class SurveyGroup extends AbstractSurveyGroup { } ``` ``` /** * @ORM\MappedSuperclass */ abstract class AbstractText extends AbstractEntity { /** * @var string|null * * @ORM\Column(name="sourceText", type="text", length=65535, nullable=true) */ protected $sourceText; } /** * @ORM\Table(name="texts") * @ORM\Entity(readOnly=true) * @ORM\Cache(usage="READ_ONLY") */ class Text extends AbstractText { } ``` And this is the query: ``` $select = $pageRepo->createQueryBuilder('page') ->select(['page', 'pageGroup', 'groupLabelText']) ->leftJoin('page.group', 'pageGroup') ->leftJoin('pageGroup.labelText', 'groupLabelText'); $pages = $select->getQuery()->useResultCache(true)->setCacheable(true)->getResult();```

admin commented 2026-01-22 15:12:28 +01:00

Author

Owner

Copy Link

@githoober commented on GitHub (Jun 27, 2018):

Since nobody responded and looked into the OP's issue, I see no point to present another use case, but essentially I have a similar issue, where a *ToOne association is incorrectly determined and passed to \Doctrine\ORM\UnitOfWork::getEntityIdentifier with an error spl_object_hash() expects parameter 1 to be object, array given. I am on v2.6.

@githoober commented on GitHub (Jun 27, 2018): Since nobody responded and looked into the OP's issue, I see no point to present another use case, but essentially I have a similar issue, where a *ToOne association is incorrectly determined and passed to `\Doctrine\ORM\UnitOfWork::getEntityIdentifier` with an error `spl_object_hash() expects parameter 1 to be object, array given`. I am on v2.6.  

admin commented 2026-01-22 15:12:28 +01:00

Author

Owner

Copy Link

@githoober commented on GitHub (Jun 28, 2018):

I filed a new issue for my case: https://github.com/doctrine/doctrine2/issues/7277

@githoober commented on GitHub (Jun 28, 2018): I filed a new issue for my case: https://github.com/doctrine/doctrine2/issues/7277

admin referenced this issue 2026-01-22 16:05:01 +01:00

[PR #5599] Fix #5598 issue with /, * in DQL not translating query components properly #9663

admin referenced this issue 2026-01-22 16:05:01 +01:00

[PR #5598] HAVING clause with variable and *, / math operators #9664

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label Bug Missing Tests

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5598