From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: To: sisyphus@lists.altlinux.org From: Andrey Khavryuchenko Organization: KDS Software Group X-Attribution: AVK Date: Mon, 04 Jun 2007 23:08:46 +0300 Message-ID: User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.0.97 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=koi8-u Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at kds.com.ua Subject: [sisyphus] mysql broken: X-BeenThere: sisyphus@lists.altlinux.org X-Mailman-Version: 2.1.9rc1 Precedence: list Reply-To: ALT Linux Sisyphus discussion list List-Id: ALT Linux Sisyphus discussion list List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Jun 2007 20:08:54 -0000 Archived-At: List-Archive: List-Post: Привет, При обновлении 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/