Archive Engine Crash MySQL 5.1 with Range Partitioning

[Grant Gavares]

Hi,
I am using MySQL 5.1.14-beta. I've created a schema composed of 19 tables using Engine=Archive and Partitioning like 'PARTITION BY RANGE ( TO_DAYS(endtime))' where endtime is a datetime field.

When running "LOAD DATA LOCAL INFILE" from a remote machine, I'm getting error messages indicating that the target table has crashed.

'Table 'some_table_name' is marked as crashed and should be repaired'

This doesn't happen every time I load into the table, but I load 400 files per hour, and no hour will complete without this error showing up. Oddly, if I rerun the load command, it will succeed.

Some notes about the table: Rows are very large. ~50 columns mostly varchar 10 - 20.

Any help or references to known bugs is appreciated.



Edited 1 time(s). Last edit at 01/05/2007 01:09PM by Grant Gavares.