Table is read only error

[johnnyfoxtrot]

We recently started using MySql as the db behind some java and cold fusion applications. A couple times we've gotten an error that says the table is read only. Stopping services and closing all open sessions does not correct the problem. We use Mysql Control Center as our GUI, and the repair functions there also give us the same error. The only thing that seems to work is rebooting the server. Anyone run across this before? Help would be appreciated.

 

[sleipnir214]

What are the permissions on the MySQL database directory and table files?

The user as which MySQL runs should be the owner of the file and that user should have exclusive R/W permissions.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[johnnyfoxtrot]

All users have R/W access.

 

[sleipnir214]

I'm assmuming you're running Win32.

You might go ahead and specify that only MySQL's user have access.

Also, do you have any kind of antivirus, backup, or other software that might be touching those files?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[johnnyfoxtrot]

You assume correctly as far was Win32. The users accessing it are either on WinNT or Win2000. Server is Win 2003 server. There is no antivirus program that should be touching these. Also, we've been using MySql since January, and this has happened only 3 times, so it's not real frequent. All backups run at night, so that shouldn't be a possibility either.

 

[sleipnir214]

What version of MySQL?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[johnnyfoxtrot]

MySQL version 4.0.12.