Page 1 of 1

Mysql Errors

Posted: Tue Apr 30, 2013 8:09 am
by us-brazzers
Добрый день

Вот что увидел в логах мускуля
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired
130429 21:04:04 [ERROR] /usr/libexec/mysqld: Table './scj_sextubews/out_ips2trader' is marked as crashed and should be repaired


Такие записи несколько раз в минуту сыплются в лог MySQL

В чем может быть проблема и как ее решить?

Спасибо

Re: Mysql Errors

Posted: Tue Apr 30, 2013 8:14 am
by us-brazzers
Если пытаюсь посмотреть статистику по IP у любго из трейдеров то вижу
Mysql error:: 0 () in query select ip, SUM(num) as my_sum from out_ips2trader where 1=1 and trader = 'niceyoungteens.com' group by ip having my_sum > '1' order by my_sum desc .

Re: Mysql Errors

Posted: Tue Apr 30, 2013 11:36 am
by admin
значит в mysql побилась таблица out_ips2trader
надо попросить админа ее пофиксить