i suggest that you can check mysql log to see why the database was down At 2011-11-16 16:06:34,"Mohammed Saleem" <[email protected]> wrote:
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
