I had this problem, too. dug a lot without any luck, eventually solved it by a cronjob which repairs the table every certain time (like 2,3 hours) my tables were created using MyISAM Engine.
Didn't see this problem since Best Regards, Mohammed M I Sleem http://www.abusleem.net - Personal blog 2011/11/16 Para <[email protected]> > you need to log in mysql cli, repair table xxxxx to fix database issue at > first > > BR/Para > > > At 2011-11-15 21:41:22,"Alejandro Guerrieri" < > [email protected]> wrote: > > This is not a Kannel problem, you need to get to the root cause for the > table crash and fix it. I'd start by running a check on the hard drive. > > Regards, > > Alex > > On Tue, Nov 15, 2011 at 8:35 AM, Vijay kumar Dadhich <[email protected] > > wrote: > >> Hello to all , >> I am using gateway-1.4.3 tar and sqlbox, and today my >> mysql's all table crash and this error message show in mysqld log >> file, after that i check and repair the table, but after send the 3 >> lacs message it was in same condition, and i am again. repaired. >> >> mysqld error log: >> >> 111115 14:05:15 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms' >> is marked as crashed and should be repaired >> 111115 14:05:15 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms' >> is marked as crashed and should be repaired >> 111115 14:05:48 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms' >> is marked as crashed and should be repaired >> 111115 14:05:48 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms' >> is marked as crashed and should be repaired >> 111115 14:15:42 [ERROR] /usr/libexec/mysqld: Table >> './sms_dlr/kannel_dlr' is marked as crashed and should be repaired >> 111115 14:15:42 [ERROR] /usr/libexec/mysqld: Table >> './sms_dlr/kannel_dlr' is marked as crashed and should be repaired >> >> 111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for >> table './SQLBOX/send_sms.MYI'; try to repair it >> 111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for >> table './SQLBOX/send_sms.MYI'; try to repair it >> 111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for >> table './SQLBOX/send_sms.MYI'; try to repair it >> 111115 14:52:28 [ERROR] /usr/libexec/mysqld: Incorrect key file for >> table './SQLBOX/send_sms.MYI'; try to repair it >> >> 111115 15:11:24 mysqld started >> 111115 15:11:25 InnoDB: Started; log sequence number 0 43655 >> 111115 15:11:25 [Note] /usr/libexec/mysqld: ready for connections. >> Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 >> Source distribution >> 111115 15:12:13 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms' >> is marked as crashed and last (automatic?) repair failed >> 111115 15:12:13 [ERROR] /usr/libexec/mysqld: Table './SQLBOX/send_sms' >> is marked as crashed and last (automatic?) repair failed >> 111115 15:12:23 [Note] Found 845 of 0 rows when repairing >> './SQLBOX/send_sms' >> >> my mysql version is >> [root@localhost sbin]# mysql --version >> mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using >> readline 5.1 >> >> so please guide me what i will do for best performance. >> >> >> >> -- >> Thanks & Regards, >> >> -Vijay Kumar Dadhich >> >> Plot No.40 , F.I.E., 1st Floor Patparganj >> Industrial Area, Delhi - 110092 ( INDIA) >> Cell No.:- 09891993899 >> >> > > >
