Krishna:
> Just check it up that any active transaction is still there in innodb
> internal data dictionary.
Acutally I figured it out.
There was a constraint on that column as well.
Once I dropped the constraint, I was able to drop the index.
Thanks for the help,
Neil
--
Neil Aggarwal,
Hi Neil,
Just check it up that any active transaction is still there in innodb
internal data dictionary.
Execute show engine innodb status\G
Check for active transaction related to the current table. If it's there
kill that transaction id and try again.
_Krishna
On Fri, Apr 2, 2010 at 10:35
sam wun wrote:
Hi,
I created an index on a foreign in a table before. I need to drop this
index. but I got the following error:
mysql> alter table transaction drop index prodcode;
ERROR 1025 (HY000): Error on rename of './datacube/#sql-30e8_3' to
'./datacube/transaction' (errno: 150)
- you need t
