Tables "In Use" and Can't Get Rid of Them

[Glowball]

I have a few MySQL tables marked "In Use" in phpMyAdmin and they haven't been used in a very long time. They have also been "In Use" for months. I'd like to delete them but I can't.

If I try to drop a table it says it's an unknown table. If I UNLOCK TABLES it says it was successful but the "In Use" status remains. If I try to repair a table it says "Can't open file: 'tablename.InnoDB'. (errno: 1..."

Any other ideas? I'd like to get rid of these tables.

TIA

 

[TonyGroves]

Did you try restarting the server, which would release any locks that might have been left in place accidentally?

 

[Glowball]

I'm on a shared host so I'll ask at some point.

In phpMyAdmin I can SHOW PROCESSLIST and see one that can be killed. I kill it and I get something like "phpMyAdmin was unable to kill thread 2226767. It probably has already been closed." In the process list I see another process with a different ID. I kill it and get the same thing, then another ID. This keeps going on and on.

???

I'm thinking it's time to open a support ticket with my host.