mirror of
https://github.com/doctrine/orm.git
synced 2026-03-23 22:42:18 +01:00
DDC-887: Schema tool can throw errno 121 when creating or dropping indexes #1102
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @doctrinebot on GitHub (Nov 22, 2010).
Originally assigned to: @beberlei on GitHub.
Jira issue originally created by user ccapndave:
When changing the model in such a way that the schema tool tries to create or drop an index which is also a foreign key an error is sometimes thrown like:
[PDOException]
SQLSTATE[HY000]: General error: 1025 Error on rename of '.\mydb#sql-10d8_19' to '.\mydb\auth' (errno: 121)
This seems to be caused by MySQL trying to re-use indexes and I think it depends on exactly what has happened before in this table so I can't give an exact case to reproduce. However, it seems to be InnoDB specific and I'm pretty sure its this bug: http://bugs.mysql.com/bug.php?id=15317
@doctrinebot commented on GitHub (Nov 22, 2010):
Comment created by ccapndave:
Another report of the issue at http://bugs.mysql.com/bug.php?id=14347
@doctrinebot commented on GitHub (Jun 19, 2011):
Comment created by @beberlei:
Fixed
@doctrinebot commented on GitHub (Jun 19, 2011):
Issue was closed with resolution "Fixed"