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.
---------------------------------------------------------------------
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