Silvio Picano writes:
> Hi,
>
> Been running mysql-3.22.32 / Solaris / Sun / dual-processor:
> Mysql.pm 1.2214 + DBI 1.14 + perl 5.004_04
> Database with 40 tables.
> Biggest table has 2,131,447 rows in it.
> No problems for 6 months.
>
>
> Recently ported to mysql-3.23.35 / Linux 2.2.12-20smp / dual-processor.
> Mysql.pm 1.2215 + DBI 1.14 + perl 5.005_03
> Similar database tables.
> Biggest table has 1,297,237 rows in it. (the "tbl_status" above).
> Once every 36 hours or so, I receive the above error message from the
> DBI.
>
>
> After receiving the error, & then running interactively, commands
> that peek into the table gives me the same error. I simply drop
> the table, and my program rebuilds the table in a few hours. [I
> have not tried to chk the table.]
>
>
> SQL commands on this table include:
> CREATE TABLE
> DROP TABLE
> LOAD DATA INFILE ... REPLACE ...
> SELECT COUNT(*)
> ALTER TABLE ... RENAME ...
> SELECT
> DELETE ... WHERE ...
>
> Table structure:
> (increment BIGINT NOT NULL AUTO_INCREMENT,
> tsource CHAR(10) NOT NULL,
> prid CHAR(8) NOT NULL,
> status_word CHAR(64),
> status_message TEXT,
> PRIMARY KEY (increment),
> INDEX (tsource),
> INDEX (prid))";
>
>
> I tried the last mysql-3.22.XY version and same result occurs.
> Did not seem to find appropriate error message in manual or the
> mail list archives.
>
> Any help or debug suggestions is much appreciated. Thanks.
> Silvio
>
> PS ... I am not on the official email lists so please reply with my
> work address in the meantime.
Hi!
The above is very unusual error. .frm files are only read, never
written and should not be corrupted. You do not need to restore a
table. Just copy .frm file somewhere and when in good shape, and when
you get the above error just copy it back. .frm file is changed only
in ALTER TABLE. And even then old .frm file is not changed, but new
one is created.
Also check file size of *.MYI(D) files. Unlike Solaris , Linux can
support only up to 2 Gb file sizes, with 2.2.* kernel that is.
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
