Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-3221

Invalid binding for primary key of entity relation

    Details

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

      Description

      Hello.

      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 {
                  $this->entityManager->beginTransaction();
                  foreach ($items as $item) {
                      $this->entityManager->persist($item);
                  }
                  $this->entityManager->commit();
              } catch (\Exception $exception) {
                  $this->entityManager->rollback();
      
                  throw $exception;
              }
              $this->entityManager->flush();
              $this->entityManager->clear();
          }
      

      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

      $uow->getEntityIdentifier($newVal);


      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.

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated: