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 > >
