Persist problem with "Entity has identity through a foreign entity" #5725

New Issue

Closed

opened 2026-01-22 15:15:40 +01:00 by admin · 4 comments

admin commented 2026-01-22 15:15:40 +01:00

Owner

Copy Link

Originally created by @va5ja on GitHub (Oct 3, 2017).

Originally assigned to: @Ocramius on GitHub.

Hi guys,

I'm having a hard time understanding why Doctrine (version 2.5.3) won't handle the following schemas as expected. I made two example entities Test and TestTranslated. In the first example the TestTranslated table has a dedicated primary key and in the second example the TestTranslated entity has a compound primary key build out of two foreign keys.

...Bundle\Entity\Test:
    type: entity
    table: test
    id:
        id:
            type: integer
            nullable: false
            id: true
            generator:
                strategy: AUTO
    fields:
        datetime:
            type: datetime
            nullable: false
        city:
            type: string
            nullable: false
            length: 45
            fixed: false
    oneToMany:
        testTranslation:
            targetEntity: TestTranslation
            mappedBy: test
            indexBy: language_id
            cascade: ["persist"]

Example1:

...Bundle\Entity\TestTranslation:
    type: entity
    table: testtranslation
    id:
        id:
            type: integer
            nullable: false
            id: true
            generator:
                strategy: AUTO
    fields:
        location:
            type: text
            nullable: true
            length: 255
            fixed: false
        metaTitle:
            type: string
            nullable: true
            length: 75
            fixed: false
            column: meta_title
        metaDescription:
            type: string
            nullable: true
            length: 210
            fixed: false
            column: meta_description
        metaKeyword:
            type: string
            nullable: true
            length: 150
            fixed: false
            column: meta_keyword
        slug:
            type: string
            nullable: false
            length: 255
            fixed: false
    manyToOne:
        test:
            targetEntity: Test
            joinColumns:
                test_id:
                    referencedColumnName: id
        language:
            targetEntity: Language
            joinColumns:
                language_id:
                    referencedColumnName: id

In this case everything works as expected. Running the code:

$em = $this->getDoctrine()->getEntityManager();

$a = new Test();
$a->setCity('Berlin');
$a->setDatetime(new \DateTime());

$c = $em->getRepository(Language::class)->findOneById('en');
$b = new TestTranslation();
$b->setTest($a);
$b->setLanguage($c);
$b->setLocation('Ljubljana');
$b->setMetaDescription('Meta description');
$b->setMetaKeyword('Meta keyword');
$b->setMetaTitle('Meta title');
$b->setSlug('ljubljana');

$a->addTestTranslation($b);

$em->persist($a);
$em->flush();

I get MySQL entries in both Test and TestTranslated entities with one flush. So all good.

Example2:

...Bundle\Entity\TestTranslation:
    type: entity
    table: testtranslation
    id:
        test:
            associationKey: true
        language:
            associationKey: true
    fields:
        location:
            type: text
            nullable: true
            length: 255
            fixed: false
        metaTitle:
            type: string
            nullable: true
            length: 75
            fixed: false
            column: meta_title
        metaDescription:
            type: string
            nullable: true
            length: 210
            fixed: false
            column: meta_description
        metaKeyword:
            type: string
            nullable: true
            length: 150
            fixed: false
            column: meta_keyword
        slug:
            type: string
            nullable: false
            length: 255
            fixed: false
    manyToOne:
        test:
            targetEntity: Test
            inversedBy: testTranslation
            joinColumns:
                test_id:
                    referencedColumnName: id
                    nullable: false
        language:
            targetEntity: Language
            inversedBy: testTranslation
            joinColumns:
                language_id:
                    referencedColumnName: id
                    nullable: false

In this case I get an error:
Entity of type ...Bundle\Entity\TestTranslation has identity through a foreign entity ...Bundle\Entity\Test, however this entity has no identity itself. You have to call EntityManager#persist() on the related entity and make sure that an identifier was generated before trying to persist '...Bundle\Entity\TestTranslation'. In case of Post Insert ID Generation (such as MySQL Auto-Increment or PostgreSQL SERIAL) this means you have to call EntityManager#flush() between both persist operations.

What I can do is run the code in the following way:

$em = $this->getDoctrine()->getEntityManager();

$a = new Test();
$a->setCity('Berlin');
$a->setDatetime(new \DateTime());

$em->persist($a);
$em->flush();

$c = $em->getRepository(Language::class)->findOneById('en');
$b = new TestTranslation();
$b->setTest($a);
$b->setLanguage($c);
$b->setLocation('Ljubljana');
$b->setMetaDescription('Meta description');
$b->setMetaKeyword('Meta keyword');
$b->setMetaTitle('Meta title');
$b->setSlug('ljubljana');

$a->addTestTranslation($b);

$em->flush();

but I don't understand why in this case Doctrine isn't that smart to deal with insert sequence. Meaning that it would first save Test entity and then TestTranslated. It works as expected with Example1 but not with Example2 although there's almost no difference in table schema. The only difference is the compound primary key.

I personally don't see any reason why Doctrine wouldn't act the same. Is there a reason behind this behavior or is it just expected that every table has a dedicated primary key? I prefer having a compound primary key.

Originally created by @va5ja on GitHub (Oct 3, 2017). Originally assigned to: @Ocramius on GitHub. Hi guys, I'm having a hard time understanding why Doctrine (version 2.5.3) won't handle the following schemas as expected. I made two example entities `Test` and `TestTranslated`. In the first example the `TestTranslated` table has a dedicated primary key and in the second example the `TestTranslated` entity has a compound primary key build out of two foreign keys. ```yaml ...Bundle\Entity\Test: type: entity table: test id: id: type: integer nullable: false id: true generator: strategy: AUTO fields: datetime: type: datetime nullable: false city: type: string nullable: false length: 45 fixed: false oneToMany: testTranslation: targetEntity: TestTranslation mappedBy: test indexBy: language_id cascade: ["persist"] ``` Example1: ```yaml ...Bundle\Entity\TestTranslation: type: entity table: testtranslation id: id: type: integer nullable: false id: true generator: strategy: AUTO fields: location: type: text nullable: true length: 255 fixed: false metaTitle: type: string nullable: true length: 75 fixed: false column: meta_title metaDescription: type: string nullable: true length: 210 fixed: false column: meta_description metaKeyword: type: string nullable: true length: 150 fixed: false column: meta_keyword slug: type: string nullable: false length: 255 fixed: false manyToOne: test: targetEntity: Test joinColumns: test_id: referencedColumnName: id language: targetEntity: Language joinColumns: language_id: referencedColumnName: id ``` In this case everything works as expected. Running the code: ```php $em = $this->getDoctrine()->getEntityManager(); $a = new Test(); $a->setCity('Berlin'); $a->setDatetime(new \DateTime()); $c = $em->getRepository(Language::class)->findOneById('en'); $b = new TestTranslation(); $b->setTest($a); $b->setLanguage($c); $b->setLocation('Ljubljana'); $b->setMetaDescription('Meta description'); $b->setMetaKeyword('Meta keyword'); $b->setMetaTitle('Meta title'); $b->setSlug('ljubljana'); $a->addTestTranslation($b); $em->persist($a); $em->flush(); ``` I get MySQL entries in both `Test` and `TestTranslated` entities with one flush. So all good. Example2: ```yaml ...Bundle\Entity\TestTranslation: type: entity table: testtranslation id: test: associationKey: true language: associationKey: true fields: location: type: text nullable: true length: 255 fixed: false metaTitle: type: string nullable: true length: 75 fixed: false column: meta_title metaDescription: type: string nullable: true length: 210 fixed: false column: meta_description metaKeyword: type: string nullable: true length: 150 fixed: false column: meta_keyword slug: type: string nullable: false length: 255 fixed: false manyToOne: test: targetEntity: Test inversedBy: testTranslation joinColumns: test_id: referencedColumnName: id nullable: false language: targetEntity: Language inversedBy: testTranslation joinColumns: language_id: referencedColumnName: id nullable: false ``` In this case I get an error: ` Entity of type ...Bundle\Entity\TestTranslation has identity through a foreign entity ...Bundle\Entity\Test, however this entity has no identity itself. You have to call EntityManager#persist() on the related entity and make sure that an identifier was generated before trying to persist '...Bundle\Entity\TestTranslation'. In case of Post Insert ID Generation (such as MySQL Auto-Increment or PostgreSQL SERIAL) this means you have to call EntityManager#flush() between both persist operations. ` What I can do is run the code in the following way: ```php $em = $this->getDoctrine()->getEntityManager(); $a = new Test(); $a->setCity('Berlin'); $a->setDatetime(new \DateTime()); $em->persist($a); $em->flush(); $c = $em->getRepository(Language::class)->findOneById('en'); $b = new TestTranslation(); $b->setTest($a); $b->setLanguage($c); $b->setLocation('Ljubljana'); $b->setMetaDescription('Meta description'); $b->setMetaKeyword('Meta keyword'); $b->setMetaTitle('Meta title'); $b->setSlug('ljubljana'); $a->addTestTranslation($b); $em->flush(); ``` but I don't understand why in this case Doctrine isn't that smart to deal with insert sequence. Meaning that it would first save `Test` entity and then `TestTranslated`. It works as expected with Example1 but not with Example2 although there's almost no difference in table schema. The only difference is the compound primary key. I personally don't see any reason why Doctrine wouldn't act the same. Is there a reason behind this behavior or is it just expected that every table has a dedicated primary key? I prefer having a compound primary key.

admin added the BugDuplicate labels 2026-01-22 15:15:40 +01:00

admin closed this issue 2026-01-22 15:15:41 +01:00

admin commented 2026-01-22 15:15:41 +01:00

Author

Owner

Copy Link

@lcobucci commented on GitHub (Nov 26, 2017):

This seems to be related to https://github.com/doctrine/doctrine2/pull/6701 (and duplicates #6531 and #6043).

@va5ja you can use a pre-generated value as ID in order to solve this for now (UUID, for example).

@lcobucci commented on GitHub (Nov 26, 2017): This seems to be related to https://github.com/doctrine/doctrine2/pull/6701 (and duplicates #6531 and #6043). @va5ja you can use a pre-generated value as ID in order to solve this for now (UUID, for example).

admin commented 2026-01-22 15:15:42 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Feb 27, 2018):

@va5ja please verify if this is actually a duplicate - we merged all related changes and will release 2.6.1 with them.

@Ocramius commented on GitHub (Feb 27, 2018): @va5ja please verify if this is actually a duplicate - we merged all related changes and will release `2.6.1` with them.

admin commented 2026-01-22 15:15:42 +01:00

Author

Owner

Copy Link

@va5ja commented on GitHub (Mar 1, 2018):

I don't get the above error anymore. Both examples work fine so obviously the problem has been fixed and this issue is a duplicate.

@va5ja commented on GitHub (Mar 1, 2018): I don't get the above error anymore. Both examples work fine so obviously the problem has been fixed and this issue is a duplicate.

admin commented 2026-01-22 15:15:43 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Mar 1, 2018):

@va5ja thanks!

@Ocramius commented on GitHub (Mar 1, 2018): @va5ja thanks!

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 Duplicate

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#5725