I humbly thanks to you all. On Wed, Nov 16, 2011 at 4:30 PM, <[email protected]> wrote: > Send users mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.kannel.org/mailman/listinfo/users > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users digest..." > > > Today's Topics: > > 1. Re: Re: Regarding mysql table crash; (Mohammed Saleem) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 16 Nov 2011 10:06:34 +0200 > From: Mohammed Saleem <[email protected]> > To: Para <[email protected]> > Cc: [email protected], Vijay kumar Dadhich > <[email protected]>, [email protected] > Subject: Re: Re: Regarding mysql table crash; > Message-ID: > <cameewlqmjyjojlfwxylxvjh4u_jx1yhm1sjsamjiz+m23rm...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > 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 >>> >>> >> >> >> > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://www.kannel.org/pipermail/users/attachments/20111116/3143b449/attachment-0001.html> > > ------------------------------ > > _______________________________________________ > users mailing list > [email protected] > http://www.kannel.org/mailman/listinfo/users > > > End of users Digest, Vol 63, Issue 38 > ************************************* >
-- Thanks & Regards, -Vijay Kumar Dadhich Plot No.40 , F.I.E., 1st Floor Patparganj Industrial Area, Delhi - 110092 ( INDIA) Cell No.:- 09891993899
