DDC-3105: Doctrine Console Error (ORMPurger)

[doctrinebot]

Jira issue originally created by user inhack20:

In symfony2 the command doctrine:fixtures:load Fails One-To-Many, Self-referencing using Doctrine\Common\DataFixtures\Purger\ORMPurger in example:

class DescriptionArea
{ 
//..
/****
* @ORM\OneToMany(targetEntity="DescriptionArea", mappedBy="parent")
*/
protected $descriptionAreas;

/****
 * @ORM\ManyToOne(targetEntity="DescriptionArea", inversedBy="descriptionAreas")
 */
protected $parent;
//..
}

Throw error:
[Doctrine\DBAL\DBALException]

An exception occurred while executing 'DELETE FROM prefix_DescriptionArea':

SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (sigtec*dev.prefix*DescriptionArea,

CONSTRAINT FK*7265873E727ACA70 FOREIGN KEY (parent_id) REFERENCES prefix*DescriptionArea (id))

Before running the query should delete the index when the table has self-reference.

[DannyvdSluijs]

I'm having the same for but not or a self referencing relation.

/**
 * @ORM\OneToMany(targetEntity="Person", mappedBy="organisationalUnit")
 **/
private $persons;

/**
 * @ORM\ManyToOne(targetEntity="OrganisationalUnit", inversedBy="persons")
 * @ORM\JoinColumn(name="organisational_unit_id",  nullable=false)
 */
private $organisationUnit;

[Ocramius]

To be tracked in doctrine/data-fixtures#127 instead.

Closing as duplicate

[DannyvdSluijs]

Actually mine fails with Postgres 9.4.5 and not with MySQL.

[Ocramius]

@DannyvdSluijs consider looking into the doctrine/data-fixtures issue tracker first anyway :)