Hi-

I have been using MySQL on my linux box for a while without problems
until I loaded a page that references some tables this morning and I
got this:

"Mysql::Error: Can't create/write to file '/var/lib/mysql/
#sql_146a_0.MYI' (Errcode: 30)"

Anyone know what this means, and how to fix it?

Thanks!

pete wrote:
> Hi-
>
> I have been using MySQL on my linux box for a while without problems
> until I loaded a page that references some tables this morning and I
> got this:
>
> "Mysql::Error: Can't create/write to file '/var/lib/mysql/
> #sql_146a_0.MYI' (Errcode: 30)"
>
> Anyone know what this means, and how to fix it?

Which file system do you use? jfs will by default make itself read only if
there happens something that can cause trouble, this to give you the chance to
recover lost data.

--

//Aho

On Feb 4, 6:01 pm, "J.O. Aho" <u...@example.net> wrote:
> pete wrote:
> > Hi-
>
> > I have been using MySQL on my linux box for a while without problems
> > until I loaded a page that references some tables this morning and I
> > got this:
>
> > "Mysql::Error: Can't create/write to file '/var/lib/mysql/
> > #sql_146a_0.MYI' (Errcode: 30)"
>
> > Anyone know what this means, and how to fix it?
>
> Which file system do you use? jfs will by default make itself read only if
> there happens something that can cause trouble, this to give you the chance to
> recover lost data.
>
> --
>
> //Aho

This issue was caused by a hardware failure...the disk crashed so the
rest of the machine could not see it.

Thanks for your .

pete <peterbattaglia@gmail.com> wrote:
>
> "Mysql::Error: Can't create/write to file '/var/lib/mysql/
> #sql_146a_0.MYI' (Errcode: 30)"
>
> Anyone know what this means, and how to fix it?

~ $perror 30
OS error code 30: Read-only file system


Error codes may differ, so better run perror on your machine.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/