Re: MyISAM table gets locked permanently?
Hi Dmitriy,
I do not understand what happens. You issue an INSERT. But what does it mean that the content gets not added? Can you run a SELECT and it does not show the inserted row? Or is the table locked so that you cannot even run a SELECT? If you can run SELECT, does the next INSERT block? So what does it mean that the table gets locked permanently? Did you try an UNLOCK TABLES after the insert? When a command "locks up", can you please issue SHOW PROCESSLIST on another session?
Regards, Ingo
Subject
Views
Written By
Posted
2834
August 22, 2005 05:25PM
Re: MyISAM table gets locked permanently?
1757
August 23, 2005 01:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.