Silvio Picano writes:
> Received the error again this morning;
> I was able to copy an older copy of <>.frm file into
> tbl_status.frm (via Sinisa's response), and the problems
> went away; all data appears to be intact.
>
> [Largest *.MYD files is 186 mbytes & *.MYI is 32 mbytes.
> Note that all database directories & files reside on an
> NFS automounted file-system, and not a local disk.]
>
>
> Then tried to reproduce the problem interactively.
>
> mysql> ALTER TABLE tbl_status RENAME tbl_status_bac;
> Query OK, 0 rows affected (0.02 sec)
>
> mysql> ALTER TABLE tbl_status_bac RENAME tbl_status;
> ERROR 1033: Incorrect information in file: './ts1/tbl_status_bac.frm'
>
>
> Hmmm, so I restored the above <>.frm file again.
> Then shutdown the server:
> $ ./bin/mysqladmin -u ...... -p........ shutdown
>
> Tried to restart, and now cannot restart the server:
> $ ./bin/safe_mysqld &
> Starting mysqld daemon with databases from ...
> 010330 10:18:14 mysqld ended
>
> $ less var/p
> 010330 10:18:14 mysqld started
> 010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld:
> Incorrect information in file: './mysql/host.frm'
>
> 010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld: Normal
> shutdown
> 010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld:
> Shutdown Complete
> 010330 10:18:14 mysqld ended
>
>
> Might the NFS dependence be a problem?
>
> Silvio
>
Yes, it could , particularly if you do not have --skip-locking as
mysqld startup or if some other processes access the files.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
