Bug 24136 - Ошибки при service mysqld restart
Summary: Ошибки при service mysqld restart
Status: CLOSED FIXED
Alias: None
Product: Sisyphus
Classification: Development
Component: MySQL-server (show other bugs)
Version: unstable
Hardware: all Linux
: P3 normal
Assignee: Vitaly Kuznetsov
QA Contact: qa-sisyphus
URL:
Keywords:
: 24135 (view as bug list)
Depends on:
Blocks:
 
Reported: 2010-09-22 11:50 MSD by Anton Farygin
Modified: 2010-09-23 22:26 MSD (History)
5 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Anton Farygin 2010-09-22 11:50:18 MSD
# service mysqld restart
Sending TERM signal to mysqld:                                                                                                               [ DONE ]
Waiting, while mysqld actualy stopped:                                                                                                       [ DONE ]
Installing all prepared tables
100922 11:48:24 [Note] Plugin 'InnoDB' is disabled.
100922 11:48:24 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
100922 11:48:24 [ERROR] Aborting

100922 11:48:24 [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 ]
Comment 1 Andrey Rahmatullin 2010-09-22 11:53:37 MSD
Да, я тоже не понял, откуда оно взяло skip-bdb.
P.S. Два отдельных бага точно нужно?
Comment 2 Vitaly Kuznetsov 2010-09-22 12:00:35 MSD
Почему-то не сработал триггер обновления.
 /var/lib/mysql/my.cnf в студию
Comment 3 Andrey Rahmatullin 2010-09-22 12:03:24 MSD
[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
# old_passwords=1

# FIXME! bdb maybe work on x86/Linux and amd64/Linux
chroot=/var/lib/mysql
datadir=/db
#log=/log/queries
pid-file=/mysqld.pid
skip-external-locking
#skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql
Comment 4 Vitaly Kuznetsov 2010-09-22 12:05:36 MSD
*** Bug 24135 has been marked as a duplicate of this bug. ***
Comment 5 Vitaly Kuznetsov 2010-09-22 12:08:09 MSD
Судя по этому - сработал.
А что в /etc/sysconfig/mysqld?
Comment 6 Anton Farygin 2010-09-22 12:12:59 MSD
# cat /etc/sysconfig/mysqld 
# custom server charset
CHSET=

# mysqld process nice level (default 10)
NICE=

# other server opts
OPT=

# cat  /var/lib/mysql/my.cnf 
[mysqld]
chroot=/var/lib/mysql
datadir=/db
#log=/log/queries
pid-file=/mysqld.pid
skip-external-locking
skip-networking
socket=/mysql.sock
tmpdir=/tmp
user=mysql
Comment 7 Anton Farygin 2010-09-22 12:16:28 MSD
# fgrep skip-bdb /usr/sbin/mysql_install_db 
                         $mysqld --bootstrap --skip-innodb --skip-bdb --skip-ndbcluster \
                         $mysqld --bootstrap --skip-innodb --skip-bdb --skip-ndbcluster \
Comment 8 Vitaly Kuznetsov 2010-09-22 12:19:22 MSD
(In reply to comment #7)
> # fgrep skip-bdb /usr/sbin/mysql_install_db 
>                          $mysqld --bootstrap --skip-innodb --skip-bdb
> --skip-ndbcluster \
>                          $mysqld --bootstrap --skip-innodb --skip-bdb
> --skip-ndbcluster \

да, я уже нашёл. Попробуй удалить --skip-bdb и запустить. Если всё хорошо - я сейчас запатчу.
Comment 9 Vitaly Kuznetsov 2010-09-22 12:25:22 MSD
да, ndbcluster тоже лишний
Comment 10 Anton Farygin 2010-09-22 12:36:03 MSD
да, убрал - теперь перезапускается нормально
Comment 11 Vitaly Kuznetsov 2010-09-22 16:02:53 MSD
Fixed in 5.1.50-alt3
Comment 12 Michael Shigorin 2010-09-23 16:31:25 MSD
Там ещё в /usr/sbin/mysql_migrate затесалось --skip-bdb.
Comment 13 Vitaly Kuznetsov 2010-09-23 22:26:39 MSD
(In reply to comment #12)
> Там ещё в /usr/sbin/mysql_migrate затесалось --skip-bdb.

Спасибо, и это тоже поправил.