From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Date: Tue, 5 Jun 2007 16:16:27 +0300 From: Victor Forsyuk To: ALT Linux Sisyphus discussion list Message-ID: <20070605131627.GA8497@mail.gu.net> References: <200706051546.10851.igor.zubkov@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200706051546.10851.igor.zubkov@gmail.com> User-Agent: Mutt/1.4.1i Sender: Victor Forsyuk Subject: Re: [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: Tue, 05 Jun 2007 13:16:37 -0000 Archived-At: List-Archive: List-Post: On Tue, Jun 05, 2007 at 03:46:09PM +0300, Igor Zubkov 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.