DDC-887: Schema tool can throw errno 121 when creating or dropping indexes #5411

Closed
doctrinebot opened this Issue Nov 22, 2010 · 3 comments

2 participants

@doctrinebot

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

Comment created by ccapndave:

Another report of the issue at http://bugs.mysql.com/bug.php?id=14347

@doctrinebot

Comment created by @beberlei:

Fixed

@doctrinebot

Issue was closed with resolution "Fixed"

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot added this to the 2.1 milestone Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@doctrinebot doctrinebot added the Bug label Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment