This sequence causes the same errors:
ALTER TABLE postsearch DISABLE KEYS;
delete from postsearch where postId=65031 limit 1;
ALTER TABLE postsearch ENABLE KEYS;
#1034 - Incorrect key file for table: 'postsearch'. Try to repair it
Could this be a bug, as hinted at here by people using 4.1:
http://b
gerald_clark wrote:
Hardware?
Celeron 1.3Ghz, IDE drive, 512Mb RAM
OS and version?
GNU/Linux, 2.4.20-8 kernel
MySql version?
4.0.17
Size of data file?
Size of index file?
postsearch.frm 8.7K
postsearch.MYD 3.5G
postsearch.MYI 1.0G
postsearch.TMD 3.5G
Filesystem type?
ext3
Sorry 'bout that!
Also,
Hardware?
OS and version?
MySql version?
Size of data file?
Size of index file?
Filesystem type?
Jim Nachlin wrote:
I have a table with several keys. When I try to delete anything from
this table, I get data corruption and have to repair it with
myisamchk. Selects, updates work fine.
Here's th
I have a table with several keys. When I try to delete anything from
this table, I get data corruption and have to repair it with myisamchk.
Selects, updates work fine.
Here's the create table statement:
CREATE TABLE `postsearch` (
`postId` int(11) NOT NULL default '0',
`weblogId` int(11)
