Форум русскоязычного сообщества Ubuntu


Увидели сообщение с непонятной ссылкой, спам, непристойность или оскорбление?
Воспользуйтесь ссылкой «Сообщить модератору» рядом с сообщением!

Автор Тема: Checking for corrupt, not cleanly closed and upgrade needing tables..  (Прочитано 4218 раз)

0 Пользователей и 1 Гость просматривают эту тему.

Оффлайн EvilDev

  • Автор темы
  • Любитель
  • *
  • Сообщений: 66
    • Просмотр профиля
Всем привет!
Debian 6 сервер. На нем MariaDB (mysql)
Постоянно при рестарте (старте) выпадает вот это.
Checking for corrupt, not cleanly closed and upgrade needing tables..

Перепробовал уже все советы, что в нэте нашел
Например
mysqlcheck --check-upgrade --all-databases --auto-repair -u root -p
mysql_upgrade --force -u root -p
Там везде OK

cat /var/log/mysql/mysql.log
/usr/sbin/mysqld, Version: 5.2.7-MariaDB-mariadb101~squeeze-log ((MariaDB - http://mariadb.com/)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
110728 18:17:01     1 Connect debian-sys-maint@localhost as anonymous on
    1 Quit
    2 Connect debian-sys-maint@localhost as anonymous on
    2 Quit
    3 Connect debian-sys-maint@localhost as anonymous on mysql
    3 Query select @@version_comment limit 1
    3 Query show variables like 'datadir'
    3 Quit
    4 Connect debian-sys-maint@localhost as anonymous on
    4 Query select @@version_comment limit 1
    4 Query SELECT count(*) FROM mysql.user WHERE user='root' and password=''
    4 Quit
    5 Connect debian-sys-maint@localhost as anonymous on
    5 Query select @@version_comment limit 1
    5 Query select concat('select count(*) into @discard from `',
                    TABLE_SCHEMA, '`.`', TABLE_NAME, '`')
      from information_schema.TABLES where ENGINE='MyISAM'
    5 Quit
    6 Connect debian-sys-maint@localhost as anonymous on
    6 Query select @@version_comment limit 1
    6 Query select count(*) into @discard from `mysql`.`columns_priv`
    6 Quit
    7 Connect debian-sys-maint@localhost as anonymous on
    7 Query select @@version_comment limit 1
    7 Query select count(*) into @discard from `mysql`.`db`
    7 Quit
    8 Connect debian-sys-maint@localhost as anonymous on
    8 Query select @@version_comment limit 1
    8 Query select count(*) into @discard from `mysql`.`event`
    8 Quit
    9 Connect debian-sys-maint@localhost as anonymous on
    9 Query select @@version_comment limit 1
    9 Query select count(*) into @discard from `mysql`.`func`
    9 Quit
   10 Connect debian-sys-maint@localhost as anonymous on
   10 Query select @@version_comment limit 1
   10 Query select count(*) into @discard from `mysql`.`help_category`
   10 Quit
   11 Connect debian-sys-maint@localhost as anonymous on
   11 Query select @@version_comment limit 1
   11 Query select count(*) into @discard from `mysql`.`help_keyword`
   11 Quit
   12 Connect debian-sys-maint@localhost as anonymous on
   12 Query select @@version_comment limit 1
   12 Query select count(*) into @discard from `mysql`.`help_relation`
   12 Quit
   13 Connect debian-sys-maint@localhost as anonymous on
   13 Query select @@version_comment limit 1
   13 Query select count(*) into @discard from `mysql`.`help_topic`
   13 Quit
   14 Connect debian-sys-maint@localhost as anonymous on
   14 Query select @@version_comment limit 1
   14 Query select count(*) into @discard from `mysql`.`host`
   14 Quit
   15 Connect debian-sys-maint@localhost as anonymous on
   15 Query select @@version_comment limit 1
   15 Query select count(*) into @discard from `mysql`.`ndb_binlog_index`
   15 Quit
   16 Connect debian-sys-maint@localhost as anonymous on
   16 Query select @@version_comment limit 1
   16 Query select count(*) into @discard from `mysql`.`plugin`
   16 Quit
   17 Connect debian-sys-maint@localhost as anonymous on
   17 Query select @@version_comment limit 1
   17 Query select count(*) into @discard from `mysql`.`proc`
   17 Quit
   18 Connect debian-sys-maint@localhost as anonymous on
   18 Query select @@version_comment limit 1
   18 Query select count(*) into @discard from `mysql`.`procs_priv`
   18 Quit
   19 Connect debian-sys-maint@localhost as anonymous on
   19 Query select @@version_comment limit 1
   19 Query select count(*) into @discard from `mysql`.`servers`
   19 Quit
   20 Connect debian-sys-maint@localhost as anonymous on
   20 Query select @@version_comment limit 1
   20 Query select count(*) into @discard from `mysql`.`tables_priv`
   20 Quit
   21 Connect debian-sys-maint@localhost as anonymous on
   21 Query select @@version_comment limit 1
   21 Query select count(*) into @discard from `mysql`.`time_zone`
   21 Quit
   22 Connect debian-sys-maint@localhost as anonymous on
   22 Query select @@version_comment limit 1
   22 Query select count(*) into @discard from `mysql`.`time_zone_leap_second`
   22 Quit
   23 Connect debian-sys-maint@localhost as anonymous on
   23 Query select @@version_comment limit 1
   23 Query select count(*) into @discard from `mysql`.`time_zone_name`
   23 Quit
   24 Connect debian-sys-maint@localhost as anonymous on
   24 Query select @@version_comment limit 1
   24 Query select count(*) into @discard from `mysql`.`time_zone_transition`
   24 Quit
   25 Connect debian-sys-maint@localhost as anonymous on
   25 Query select @@version_comment limit 1
   25 Query select count(*) into @discard from `mysql`.`time_zone_transition_type`
   25 Quit
   26 Connect debian-sys-maint@localhost as anonymous on
   26 Query select @@version_comment limit 1
   26 Query select count(*) into @discard from `mysql`.`user`
   26 Quit
Ребят, помогите исправить.
Заранее благодарен!

Оффлайн EvilDev

  • Автор темы
  • Любитель
  • *
  • Сообщений: 66
    • Просмотр профиля
Re: Checking for corrupt, not cleanly closed and upgrade needing tables..
« Ответ #1 : 01 Августа 2011, 09:10:32 »
up..

 

Страница сгенерирована за 0.016 секунд. Запросов: 21.