Uploaded image for project: 'Doctrine 2 - ORM'
  1. Doctrine 2 - ORM
  2. DDC-3221

Invalid binding for primary key of entity relation


    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.4.3
    • Fix Version/s: None
    • Component/s: None
    • Security Level: All
    • Labels:



      We use doctrine2 ORM with doctrine/doctrine-bundle in our symfony2 based project. We developed functionality which is similar to some kind of import process.

      And we have an issue that appears from time to time in different points during the import.

      Issue is following:
      Lets imagine we have 3 entities Account, Contact, Contact Address.
      Account has many to one relation on contact and contact has one to many relation on contact address.

      Our import creates all 3 entities and persist only Account, contact and address are persisted via cascade persist.
      We have writer that contains following code

          public function write(array $items)
              try {
                  foreach ($items as $item) {
              } catch (\Exception $exception) {
                  throw $exception;

      So we clear EntityManager for each batch in order to avoid high memory consumption.
      Import fails during different entities insert, but errors are very similar.
      Example of error is

      > [error] An exception occurred while executing 'INSERT INTO ... VALUES (?, ?, ?, ?, ?)' with params ["__start__", "2014-07-21 00:55:35", 0, null, 21]:
      > SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`DB`.`account`, CONSTRAINT `FK_B3D57B301023C4EE` FOREIGN KEY (`contact_id`) REFERENCES `contact` (`id`) ON DELETE CASCADE)

      After debugging I found that problem is in BasicEntityPersister#prepareUpdateData


      returns oid that is real one, but UOW contains not the same ID as in $newVal entity. It seems like spl_object_hash duplicates oid.

      Any help is appreciated.
      Thanks in advance.


        There are no comments yet on this issue.


          • Assignee:
            beberlei Benjamin Eberlei
            to0n1 Alexandr Smaga
          • Votes:
            0 Vote for this issue
            1 Start watching this issue


            • Created: