Announcement

Collapse
No announcement yet.

Errors in DB

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Errors in DB

    Hello!
    Why does my Centreon continuously generates in /var/log/mysqld.log such errors:
    100826 12:49:26 [ERROR] /usr/libexec/mysqld: Table './centreon2_storage/data_bin' is marked as crashed and should be repaired
    100826 12:49:26 [ERROR] /usr/libexec/mysqld: Table './centreon2_storage/data_bin' is marked as crashed and should be repaired
    100826 12:49:26 [ERROR] /usr/libexec/mysqld: Table './centreon2_storage/data_bin' is marked as crashed and should be repaired
    100826 12:49:26 [ERROR] /usr/libexec/mysqld: Table './centreon2_storage/data_bin' is marked as crashed and should be repaired

    Command
    myisamchk -r -q /var/lib/mysql/centreon2_storage/data_bin.MYI
    helps, but how to fix it permanently?

  • #2
    # mysql -u root -p -e "REPAIR TABLE centreon2_storage.data_bin;"
    Centreon Syslog Module Manager/Developper
    Centreon E2S Module Manager/Developper
    Centreon Enterprise Server (2.x / 3.x) : Centreon Engine 1.3.x / 1.4.x, Centreon Broker 2.6.x / 2.8.x , Centreon 2.x, Centreon-Syslog 1.5.x, Centreon E2S 2.0
    Nagios 3.x et NDOutil 1.x

    Comment


    • #3
      Originally posted by AkHeNaToN View Post
      # mysql -u root -p -e "REPAIR TABLE centreon2_storage.data_bin;"
      Isn't it the same with above?

      Comment

      Working...
      X