[Comm] mysql in p6
adobrovolskii
adobrovolskii на gmail.com
Ср Фев 29 18:45:48 MSK 2012
On Wed, Feb 29, 2012 at 4:19 PM, Андрей Черепанов <cas на altlinux.ru> wrote:
> 29 февраля 2012 adobrovolskii написал:
>> On Wed, Feb 29, 2012 at 2:19 PM, Андрей Черепанов <cas на altlinux.ru> wrote:
>> > Попробуйте
>> >
>> > http://www.ovaistariq.net/490/a-step-by-step-guide-to-upgrading-to-mysql-
>> > 5-5/
>>
>> Что именно предлагается попробовать?
>> Я запустил сервер с --skip-grant-tables Он стартанул. Теперь если
>> посмотреть
>>
>> mysql> SHOW PLUGINS;
>> +------------+--------+----------------+---------------------+---------+
>>
>> | Name | Status | Type | Library | License |
>>
>> +------------+--------+----------------+---------------------+---------+
>>
>> | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
>> | InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb_plugin.so | GPL |
>>
>> +------------+--------+----------------+---------------------+---------+
>> 9 rows in set (0.00 sec)
>>
>> Почему активны все а указатель есть только на принудительно
>> загруженный плагин? Потому что остальные встроенные?
> Потому что нет поддержки. mysql_upgrade запустили?
>
Пытался. Он обламывается.
В интерактивном режиме таблица не лечится почему-то...
mysql> REPAIR TABLE columns_priv
-> ;
+--------------------+--------+----------+---------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+--------------------+--------+----------+---------------------------------------------------------------+
| mysql.columns_priv | repair | Error | Incorrect key file for
table 'columns_priv'; try to repair it |
| mysql.columns_priv | repair | error | Corrupt
|
+--------------------+--------+----------+---------------------------------------------------------------+
2 rows in set (0.01 sec)
mysql> CHECK TABLE columns_priv;
+--------------------+-------+----------+---------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+--------------------+-------+----------+---------------------------------------------------------------+
| mysql.columns_priv | check | Error | Incorrect key file for table
'columns_priv'; try to repair it |
| mysql.columns_priv | check | error | Corrupt
|
+--------------------+-------+----------+---------------------------------------------------------------+
2 rows in set (0.01 sec)
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
......
Repairing tables
mysql.columns_priv
Error : Incorrect key file for table 'columns_priv'; try to repair it
error : Corrupt
mysql.db
Error : Incorrect key file for table 'db'; try to repair it
error : Corrupt
mysql.func
Error : Incorrect key file for table 'func'; try to repair it
error : Corrupt
mysql.host
Error : Incorrect key file for table 'host'; try to repair it
error : Corrupt
mysql.tables_priv
Error : Incorrect key file for table 'tables_priv'; try to repair it
error : Corrupt
mysql.user
Error : Incorrect key file for table 'user'; try to repair it
error : Corrupt
ra.cache_page
Error : Incorrect key file for table 'cache_page'; try to repair it
error : Corrupt
ra.node
Error : Incorrect key file for table 'node'; try to repair it
error : Corrupt
ra.term_synonym
Error : Incorrect key file for table 'term_synonym'; try to repair it
error : Corrupt
Running 'mysql_fix_privilege_tables'...
ERROR 1034 (HY000) at line 132: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 136: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 138: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 139: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 140: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 143: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 144: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 145: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 151: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 156: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 161: Incorrect key file for table
'tables_priv'; try to repair it
ERROR 1034 (HY000) at line 164: Incorrect key file for table
'tables_priv'; try to repair it
ERROR 1034 (HY000) at line 173: Incorrect key file for table
'tables_priv'; try to repair it
ERROR 1034 (HY000) at line 188: Incorrect key file for table
'columns_priv'; try to repair it
ERROR 1034 (HY000) at line 192: Incorrect key file for table
'columns_priv'; try to repair it
ERROR 1034 (HY000) at line 202: Incorrect key file for table
'columns_priv'; try to repair it
ERROR 1034 (HY000) at line 210: Incorrect key file for table 'func';
try to repair it
ERROR 1034 (HY000) at line 218: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 220: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 231: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 237: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 247: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 250: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 254: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 257: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 258: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 259: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 260: Incorrect key file for table 'func';
try to repair it
ERROR 1034 (HY000) at line 264: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 268: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 293: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 298: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 312: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 316: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 330: Incorrect key file for table 'func';
try to repair it
ERROR 1034 (HY000) at line 332: Incorrect key file for table 'func';
try to repair it
ERROR 1034 (HY000) at line 370: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 375: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 376: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 378: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 379: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 381: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 382: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 387: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 388: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 390: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 391: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 393: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 394: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 399: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 405: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 410: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 411: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 413: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 414: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 416: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 417: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 422: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 423: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 425: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 426: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 428: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 429: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 431: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 432: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 434: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 435: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 440: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 441: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 442: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 447: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 454: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 456: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 457: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 458: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 603: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 605: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 606: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 608: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 610: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 611: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 693: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 695: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 696: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 698: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 699: Incorrect key file for table 'host';
try to repair it
ERROR 1034 (HY000) at line 701: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 702: Incorrect key file for table 'db'; try
to repair it
ERROR 1034 (HY000) at line 704: Incorrect key file for table 'user';
try to repair it
ERROR 1034 (HY000) at line 710: Incorrect key file for table 'host';
try to repair it
FATAL ERROR: Upgrade failed
Весь вывод длиннее. И часть таблиц конвертятся нормально. Несколько
пользовательских баз проскакивают без замечаний.
--
Regards,
Andrii Dobrovol`s`kyj
Подробная информация о списке рассылки community