Hi Shrini, > Query Failed:SELECT tracker.* from tracker WHERE user_id='max_id' > ORDER BY id DESC LIMIT 0,10::MySQL error 1030: Got error 134 from > storage engine > > To solve the issue, I have to repair the table 'tracker' everytime, by > the following command in mysql. > repair table tracker;
Looks like either abrupt database shutdown (kill -9 ?), possible filesystem corruption (I had faced similar issues earlier on a large database using MyISAM storage engine running on RHEL5 with XFS filesystem) or maybe there could be some issue with hard disk. In any case, backup your existing tables. Then, try migrating all tables to InnoDB storage engine and check if this fixes the problem for now. InnoDB provides automatic row checksum and repair feature and it works pretty well. Also check for mysqld error logs (you can check where the error logs are stored by typing "SHOW VARIABLES LIKE 'log_error';" at the mysql prompt) to get a hint on whether the server has detected any storage engine crashes or other issues. Cheers, Chandrashekar. -- http://www.chandrashekar.info/ http://www.slashprog.com/ _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
