* [sisyphus] mysql broken:
@ 2007-06-04 20:08 Andrey Khavryuchenko
2007-06-05 12:46 ` Igor Zubkov
0 siblings, 1 reply; 8+ messages in thread
From: Andrey Khavryuchenko @ 2007-06-04 20:08 UTC (permalink / raw)
To: sisyphus
Привет,
При обновлении mysql на i586/classic MySQL-server 5.0.41-alt1 он развалился
следующим образом:
4: MySQL-server warning: /etc/sysconfig/mysqld created as /etc/sysconfig/mysqld.rpmnew
########################################### [100%]
Stopping mysqld service: [ DONE ]
Installing all prepared tables
070604 22:50:11 [Warning] '/tmp/#sql1654_1_0' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
070604 22:50:11 [Warning] '/tmp/#sql1654_1_0' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
ERROR: 1136 Column count doesn't match value count at row 1
070604 22:50:11 [ERROR] Aborting
070604 22:50:11 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql/log for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql/log that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Adjusting environment for mysqld: [ DONE ]
Starting mysqld service: [ DONE ]
Service mysqld is not running.[PASSED]
Installing all prepared tables
070604 22:50:11 [Warning] '/tmp/#sql16e9_1_0' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
070604 22:50:11 [Warning] '/tmp/#sql16e9_1_0' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
ERROR: 1136 Column count doesn't match value count at row 1
070604 22:50:11 [ERROR] Aborting
070604 22:50:12 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql/log for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql/log that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Adjusting environment for mysqld: [ DONE ]
Starting mysqld service: [ DONE ]
Please run mysql_fix_username_length script if you
want use db usernames longer than char(16)!
See README.ALT-ru_RU.KOI8-R for additional details.
после чего любые попытки его рестартовать приводят к подобной ругани.
akhavr@netmaster /tmp $ sudo service mysqld restart
Service mysqld is not running. [PASSED]
Installing all prepared tables
ERROR: 1136 Column count doesn't match value count at row 1
070604 22:59:49 [ERROR] Aborting
070604 22:59:49 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql/log for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql/log that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Adjusting environment for mysqld: [ DONE ]
Unable to find proper charset from system locale, setting 'latin1'.
Please edit mysqld init script and set proper charset.
Starting mysqld service: [ DONE ]
При этом он таки работает:
akhavr@netmaster /tmp $ mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.0.41-log ALT Linux MySQL RPM
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> Bye
Где были неправы мои руки?
--
Andrey V Khavryuchenko
Software Development Company http://www.kds.com.ua/
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: [sisyphus] mysql broken:
2007-06-04 20:08 [sisyphus] mysql broken: Andrey Khavryuchenko
@ 2007-06-05 12:46 ` Igor Zubkov
2007-06-05 13:08 ` Andrey Khavryuchenko
2007-06-05 13:16 ` Victor Forsyuk
0 siblings, 2 replies; 8+ messages in thread
From: Igor Zubkov @ 2007-06-05 12:46 UTC (permalink / raw)
To: ALT Linux Sisyphus discussion list
В сообщении от Monday 04 June 2007 23:08:46 Andrey Khavryuchenko написал(а):
> Привет,
>
> При обновлении mysql на i586/classic MySQL-server 5.0.41-alt1 он развалился
> следующим образом:
[skipped]
> Где были неправы мои руки?
У меня похожее.
[icesik@iceberg ~]$ rpm -qa | grep -i mysql
mysqlcc-0.9.4-alt2
libMySQL-devel-5.0.22-alt1
php5-mysqli-5.2.2-alt1
MySQL-server-5.0.22-alt1
php5-mysql-5.2.2-alt1
MySQL-client-5.0.22-alt1
php5-pdo_mysql-5.2.2-alt1
libMySQL-5.0.22-alt1
mysql-connector-jdbc-5.0.4-alt2
libqt3-mysql-3.3.8-alt6
php-mysql-4.4.6-alt2
perl-DBD-mysql-4.001-alt1
[icesik@iceberg ~]$
Из-за этого я поставил весь MySQL на hold. Как я понимаю, проблема кроется в
не соответсвии кодировок. Думаю, если откатить назад, починить кодировки и
обновить mysql обратно, всё заработает.
--
icesik
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: [sisyphus] mysql broken:
2007-06-05 12:46 ` Igor Zubkov
@ 2007-06-05 13:08 ` Andrey Khavryuchenko
2007-06-05 13:27 ` Igor Zubkov
2007-06-05 13:16 ` Victor Forsyuk
1 sibling, 1 reply; 8+ messages in thread
From: Andrey Khavryuchenko @ 2007-06-05 13:08 UTC (permalink / raw)
To: sisyphus
IZ> Из-за этого я поставил весь MySQL на hold. Как я понимаю, проблема
IZ> кроется в не соответсвии кодировок.
Разбирательства на другой машине показали что если в /etc/sysconfig/mysqld
убрать (закомментировать)
CHSET=utf8
то обновление пройдёт чисто. У меня оно оставалось от предыдущих попыток
перевести базу в utf8.
IZ> Думаю, если откатить назад, починить кодировки и обновить mysql
IZ> обратно, всё заработает.
Это проверено или?
--
Andrey V Khavryuchenko
Software Development Company http://www.kds.com.ua/
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: [sisyphus] mysql broken:
2007-06-05 12:46 ` Igor Zubkov
2007-06-05 13:08 ` Andrey Khavryuchenko
@ 2007-06-05 13:16 ` Victor Forsyuk
2007-06-05 19:53 ` Konstantin A. Lepikhov
1 sibling, 1 reply; 8+ messages in thread
From: Victor Forsyuk @ 2007-06-05 13:16 UTC (permalink / raw)
To: ALT Linux Sisyphus discussion list
On Tue, Jun 05, 2007 at 03:46:09PM +0300, Igor Zubkov <igor.zubkov@gmail.com> wrote:
>
> Из-за этого я поставил весь MySQL на hold. Как я понимаю, проблема кроется в
> не соответсвии кодировок. Думаю, если откатить назад, починить кодировки и
> обновить mysql обратно, всё заработает.
У меня про кодировки ничего не говорится. Тем не менее мускуль тоже
накрылся при очередном дистапгрейде:
Get:1 http://10.0.3.8 i586/classic libMySQL-devel 5.0.41-alt1 [710kB]
Get:2 http://10.0.3.8 i586/classic libMySQL 5.0.41-alt1 [1387kB]
Get:3 http://10.0.3.8 i586/classic MySQL-client 5.0.41-alt1 [4889kB]
Get:4 http://10.0.3.8 i586/classic MySQL-server 5.0.41-alt1 [7612kB]
Fetched 14.6MB in 3s (3972kB/s)
Committing changes...
Preparing...
###################################################################################################
[100%]
1: libMySQL
###################################################################################################
[ 25%]
2: libMySQL-devel
###################################################################################################
[ 50%]
3: MySQL-client
###################################################################################################
[ 75%]
4: MySQL-server
###################################################################################################
[100%]
Stopping mysqld service: [ DONE ]
Installing all prepared tables
ERROR: 1136 Column count doesn't match value count at row 1
070530 11:10:40 [ERROR] Aborting
070530 11:10:40 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql/log for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql/log that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Adjusting environment for mysqld: [ DONE ]
Starting mysqld service: [ DONE ]
Service mysqld is not running.[PASSED]
Installing all prepared tables
ERROR: 1136 Column count doesn't match value count at row 1
070530 11:10:41 [ERROR] Aborting
070530 11:10:41 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql/log for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql/log that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Adjusting environment for mysqld: [ DONE ]
Starting mysqld service: [ DONE ]
Done.
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: [sisyphus] mysql broken:
2007-06-05 13:16 ` Victor Forsyuk
@ 2007-06-05 19:53 ` Konstantin A. Lepikhov
2007-06-05 20:57 ` Andrey Khavryuchenko
2007-06-06 15:05 ` Victor Forsyuk
0 siblings, 2 replies; 8+ messages in thread
From: Konstantin A. Lepikhov @ 2007-06-05 19:53 UTC (permalink / raw)
To: ALT Linux Sisyphus discussion list
Hi Victor!
Tuesday 05, at 04:16:27 PM you wrote:
> У меня про кодировки ничего не говорится. Тем не менее мускуль тоже
> накрылся при очередном дистапгрейде:
> ERROR: 1136 Column count doesn't match value count at row 1
> 070530 11:10:40 [ERROR] Aborting
попробуйте сначала запустить mysql_fix_privilege_tables, а уже потом сам
сервер.
PS И что все-таки оно сказало в /var/log/mysql/info?
--
WBR et al.
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: [sisyphus] mysql broken:
2007-06-05 19:53 ` Konstantin A. Lepikhov
@ 2007-06-05 20:57 ` Andrey Khavryuchenko
2007-06-06 15:05 ` Victor Forsyuk
1 sibling, 0 replies; 8+ messages in thread
From: Andrey Khavryuchenko @ 2007-06-05 20:57 UTC (permalink / raw)
To: ALT Linux Sisyphus discussion list
KAL> Hi Victor!
KAL> Tuesday 05, at 04:16:27 PM you wrote:
>> У меня про кодировки ничего не говорится. Тем не менее мускуль тоже
>> накрылся при очередном дистапгрейде:
>> ERROR: 1136 Column count doesn't match value count at row 1
>> 070530 11:10:40 [ERROR] Aborting
KAL> попробуйте сначала запустить mysql_fix_privilege_tables, а уже потом сам
KAL> сервер.
Хм...
akhavr@netmaster /tmp $ sudo /usr/bin/mysql_fix_privilege_tables
This script updates all the mysql privilege tables to be usable by
the current version of MySQL
done
akhavr@netmaster /tmp $ sudo service mysqld restart
Stopping mysqld service: [ DONE ]
Installing all prepared tables
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Adjusting environment for mysqld: [ DONE ]
Unable to find proper charset from system locale, setting 'latin1'.
Please edit mysqld init script and set proper charset.
Starting mysqld service: [ DONE ]
Вроде уже не ругается.
KAL> PS И что все-таки оно сказало в /var/log/mysql/info?
У меня - ничего.
akhavr@netmaster /tmp $ ll /var/log/mysql/info
-rw-r--r-- 1 root root 0 Чер 5 04:02 /var/log/mysql/info
--
Andrey V Khavryuchenko
Software Development Company http://www.kds.com.ua/
^ permalink raw reply [flat|nested] 8+ messages in thread
* Re: [sisyphus] mysql broken:
2007-06-05 19:53 ` Konstantin A. Lepikhov
2007-06-05 20:57 ` Andrey Khavryuchenko
@ 2007-06-06 15:05 ` Victor Forsyuk
1 sibling, 0 replies; 8+ messages in thread
From: Victor Forsyuk @ 2007-06-06 15:05 UTC (permalink / raw)
To: ALT Linux Sisyphus discussion list
On Tue, Jun 05, 2007 at 11:53:53PM +0400, Konstantin A. Lepikhov <lakostis@unsafe.ru> wrote:
> Hi Victor!
>
> Tuesday 05, at 04:16:27 PM you wrote:
>
> > У меня про кодировки ничего не говорится. Тем не менее мускуль тоже
> > накрылся при очередном дистапгрейде:
>
> > ERROR: 1136 Column count doesn't match value count at row 1
> > 070530 11:10:40 [ERROR] Aborting
> попробуйте сначала запустить mysql_fix_privilege_tables, а уже потом сам
> сервер.
Запустил (но при запущенном сервере, разумеется), полечило. Это-то понятно.
Я к тому, что лучше сделать это за пользователя, а не оставлять такие
подарки...
> PS И что все-таки оно сказало в /var/log/mysql/info?
Ничего.
^ permalink raw reply [flat|nested] 8+ messages in thread
end of thread, other threads:[~2007-06-06 15:05 UTC | newest]
Thread overview: 8+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2007-06-04 20:08 [sisyphus] mysql broken: Andrey Khavryuchenko
2007-06-05 12:46 ` Igor Zubkov
2007-06-05 13:08 ` Andrey Khavryuchenko
2007-06-05 13:27 ` Igor Zubkov
2007-06-05 13:16 ` Victor Forsyuk
2007-06-05 19:53 ` Konstantin A. Lepikhov
2007-06-05 20:57 ` Andrey Khavryuchenko
2007-06-06 15:05 ` Victor Forsyuk
ALT Linux Sisyphus discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/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 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \
sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru
public-inbox-index sisyphus
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.sisyphus
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git