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
Hello:
When I try to drop an index from an InnoDB table:
drop index company_n56 on company;
I get this error:
ERROR 1025 (HY000): Error on rename of './thymeleweb/#sql-788_1218' to
'./thymeleweb/company' (errno: 150)
Look at the index using: show keys from company\G
gives me this info for that
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
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)
mysql>
mysql> show index f
