From: adobrovolskii <adobrovolskii@gmail.com>
To: ALT Linux Community general discussions <community@lists.altlinux.org>
Subject: Re: [Comm] mysql in p6
Date: Wed, 29 Feb 2012 16:45:48 +0200
Message-ID: <CAEv1UXzEpRh5sUF+kCBR0xPBaLdqrR0OWbAWdKwVwjjrebn7bg@mail.gmail.com> (raw)
In-Reply-To: <201202291819.58568.cas@altlinux.ru>
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
next prev parent reply other threads:[~2012-02-29 14:45 UTC|newest]
Thread overview: 13+ messages / expand[flat|nested] mbox.gz Atom feed top
2012-02-28 18:32 Andrii Dobrovol`s`kii
2012-02-28 19:57 ` Anton Gorlov
2012-02-29 9:19 ` Андрей Черепанов
2012-02-29 11:43 ` adobrovolskii
2012-02-29 11:53 ` adobrovolskii
2012-02-29 12:19 ` Андрей Черепанов
2012-02-29 13:36 ` adobrovolskii
2012-02-29 14:17 ` adobrovolskii
2012-02-29 14:19 ` Андрей Черепанов
2012-02-29 14:45 ` adobrovolskii [this message]
2012-02-29 15:18 ` adobrovolskii
2012-03-02 7:03 ` Sergey
2012-02-28 20:23 ` Michael Shigorin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=CAEv1UXzEpRh5sUF+kCBR0xPBaLdqrR0OWbAWdKwVwjjrebn7bg@mail.gmail.com \
--to=adobrovolskii@gmail.com \
--cc=community@lists.altlinux.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
ALT Linux Community general discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 community community/ http://lore.altlinux.org/community \
mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
public-inbox-index community
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.community
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git