Uncorrectable errors in AV_IMAGE (mysql)
This is possibly a mysql bug... don't know. But shows up in the AV_IMAGE table in the antville db when you add an space 0x20 at the end of the IMAGE_ALIAS field like in the following example (watch the 5th element in the second row: 'c ', if you remove the blank after the 'c' the problem is gone).
INSERT INTO AV_IMAGE VALUES (17018,1284,NULL,17019,'lec_fl5','lec_fl5','jpg',131,268,'','2004-01-30 01:07:35',2149,NULL,NULL); INSERT INTO AV_IMAGE VALUES (17024,1780,NULL,17025,'c ','c ','gif',236,471,'','2004-01-30 04:06:17',3020,NULL,3020);This is the error you get with myismacheck:
[..] myisamchk -e --force -v /usr/local/mysql/data/antville/AV_IMAGE ... myisamchk: error: Record at: 56 Can't find key for index: 3
- recovering (with sort) MyISAM-table '/usr/local/mysql/data/antville/AV_IMAGE' [..]
The index IDX_IMAGE_MXD is responsible for this. When you remove or change the INDEX_ALIAS there you get rid of the problem. This is probably harmless, can't say .. but annoying.
Any ideas on this ?