Автор Тема: MySQL. Проблемы при запуске демона после dist-upgrade.  (Прочитано 2016 раз)

Оффлайн Sciurus

  • Участник
  • *
  • Сообщений: 41
apt-get dist-upgrade
Спойлер
Чтение списков пакетов...
Построение дерева зависимостей...
Следующие пакеты будут ОБНОВЛЕНЫ:
  MySQL-bench MySQL-client MySQL-server MySQL-server-perl file glib2
  glib2-locales gsettings-desktop-schemas libaprutil1 libgio libmagic
  libmysqlclient16 libogg pciids tzdata usbids
Следующие НОВЫЕ пакеты будут установлены:
  gsettings-desktop-schemas-data
16 будет обновлено, 1 новых установлено, 0 пакетов будет удалено и 0 не будет обновлено.
Необходимо получить 10,5MB архивов.
После распаковки потребуется дополнительно 1306kB дискового пространства.
Продолжить? [Y/n] Получено: 1 ftp://ftp.altlinux.org noarch/classic MySQL-bench 5.1.62-alt0.M60T.1 [344kB]
Получено: 2 ftp://ftp.altlinux.org i586/classic MySQL-client 5.1.62-alt0.M60T.1 [3410kB]
Получено: 3 ftp://ftp.altlinux.org noarch/classic MySQL-server-perl 5.1.62-alt0.M60T.1 [65,3kB]
Получено: 4 ftp://ftp.altlinux.org i586/classic libmysqlclient16 5.1.62-alt0.M60T.1 [523kB]
Получено: 5 ftp://ftp.altlinux.org i586/classic MySQL-server 5.1.62-alt0.M60T.1 [3282kB]

Получено: 6 ftp://ftp.altlinux.org i586/classic file 4.26-alt8.M60P.1 [235kB]
Получено: 7 ftp://ftp.altlinux.org i586/classic libmagic 4.26-alt8.M60P.1 [44,8kB]
Получено: 8 ftp://ftp.altlinux.org i586/classic libgio 2.32.3-alt0.M60P.1 [431kB]
Получено: 9 ftp://ftp.altlinux.org noarch/classic glib2-locales 2.32.3-alt0.M60P.1 [792kB]
Получено: 10 ftp://ftp.altlinux.org i586/classic glib2 2.32.3-alt0.M60P.1 [535kB]
Получено: 11 ftp://ftp.altlinux.org noarch/classic gsettings-desktop-schemas-data 3.4.2-alt0.M60P.1 [115kB]
Получено: 12 ftp://ftp.altlinux.org i586/classic gsettings-desktop-schemas 3.4.2-alt0.M60P.1 [2569B]
Получено: 13 ftp://ftp.altlinux.org i586/classic libaprutil1 1.5.1-alt0.M60P.1 [68,7kB]
Получено: 14 ftp://ftp.altlinux.org i586/classic libogg 1.3.0-alt1 [17,0kB]
Получено: 15 ftp://ftp.altlinux.org noarch/classic pciids 20130318-alt1 [166kB]
Получено: 16 ftp://ftp.altlinux.org noarch/classic tzdata 2013b-alt1 [327kB]
Получено: 17 ftp://ftp.altlinux.org noarch/classic usbids 20130311-alt1 [145kB]
Получено 10,5MB за 17s (605kB/s).
Совершаем изменения...
Preparing...                 ##################################################
libmysqlclient16             ##################################################
MySQL-client                 ##################################################
MySQL-server                 #################################################warning: /var/lib/mysql/my.cnf created as /var/lib/mysql/my.cnf.rpmnew
#
  WARNING: if InnoDB is used, please examine /var/lib/mysql/my.cnf*
  and ensure that the innodb plugin is loaded

gsettings-desktop-schemas-dat##################################################
glib2-locales                ##################################################
glib2                        ##################################################
libmagic                     ##################################################
file                         ##################################################
MySQL-server-perl            ##################################################
MySQL-bench                  ##################################################
usbids                       ##################################################
tzdata                       ##################################################
pciids                       ##################################################
libogg                       ##################################################
libaprutil1                  ##################################################
libgio                       ##################################################
Running /usr/lib/rpm/posttrans-filetriggers
warning: Schema 'org.gnome.system.locale' has path '/system/locale/'.  Paths starting with '/apps/', '/desktop/' or '/system/' are deprecated.
warning: Schema 'org.gnome.system.proxy' has path '/system/proxy/'.  Paths starting with '/apps/', '/desktop/' or '/system/' are deprecated.
warning: Schema 'org.gnome.system.proxy.http' has path '/system/proxy/http/'.  Paths starting with '/apps/', '/desktop/' or '/system/' are deprecated.
warning: Schema 'org.gnome.system.proxy.https' has path '/system/proxy/https/'.  Paths starting with '/apps/', '/desktop/' or '/system/' are deprecated.
warning: Schema 'org.gnome.system.proxy.ftp' has path '/system/proxy/ftp/'.  Paths starting with '/apps/', '/desktop/' or '/system/' are deprecated.
warning: Schema 'org.gnome.system.proxy.socks' has path '/system/proxy/socks/'.  Paths starting with '/apps/', '/desktop/' or '/system/' are deprecated.
Завершено.

В /var/log/crazylog:
Спойлер
Apr  4 12:41:43 ns1 apt-get: libmysqlclient16-5.1.62-alt0.M60T.1 installed.
Apr  4 12:41:43 ns1 apt-get: libmysqlclient16-5.1.57-alt1 removed.
Apr  4 12:41:43 ns1 apt-get: MySQL-client-5.1.62-alt0.M60T.1 installed.
Apr  4 12:41:43 ns1 apt-get: MySQL-client-5.1.57-alt1 removed.
Apr  4 12:41:44 ns1 apt-get: MySQL-server-5.1.62-alt0.M60T.1 installed.
Apr  4 12:41:45 ns1 apt-get: MySQL-server-5.1.57-alt1 removed.
Apr  4 12:41:46 ns1 apt-get: MySQL-server-perl-5.1.62-alt0.M60T.1 installed.
Apr  4 12:41:46 ns1 apt-get: MySQL-server-perl-5.1.57-alt1 removed.
Apr  4 12:41:46 ns1 apt-get: MySQL-bench-5.1.62-alt0.M60T.1 installed.
Apr  4 12:41:46 ns1 apt-get: MySQL-bench-5.1.57-alt1 removed.

Стартую mysqld: /etc/rc.d/init.d/mysqld start >/var/log/mysql/error.log 2>&1
Специально делаю вывод в отдельный лог /var/log/mysql/error.log, т.к. в логе, который ведет mysql (/var/log/mysql/info) отсутствует сообщение
130404 16:48:23 [ERROR] /usr/sbin/mysqld: unknown option '--skip-innodb'
Спойлер
Installing all prepared tables
130404 16:48:23 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 2 failed to map segment from shared object: Operation n
130404 16:48:23 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.
130404 16:48:23 [ERROR] /usr/sbin/mysqld: unknown option '--skip-innodb'
130404 16:48:23 [ERROR] Aborting


130404 16:48:23 [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: ^[[150G[ ^[[1m^[[32mDONE^[[39;49m^[(B^[[m ]^M
Starting mysqld service: ^[[150G[ ^[[1m^[[32mDONE^[[39;49m^[(B^[[m ]^M

/var/log/mysql/info:
Спойлер
2013-Apr-04 16:48:19 :: execution succeded
2013-Apr-04 16:48:19 :: shutdown
2013-Apr-04 16:48:23 :: startup
130404 16:48:23 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 2 failed to map segment from shared object: Operation n
130404 16:48:23 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.

130404 16:48:23 [Note] Event Scheduler: Loaded 0 events
130404 16:48:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.62'  socket: '/mysql.sock'  port: 0  ALT Linux MySQL RPM

Дополнительно: strace -f -e trace=open /usr/sbin/mysqld
Спойлер
open("/etc/ld.so.cache", O_RDONLY)      = 3
open("/lib/libpthread.so.0", O_RDONLY)  = 3
open("/lib/libz.so.1", O_RDONLY)        = 3
open("/lib/libdl.so.2", O_RDONLY)       = 3
open("/lib/libssl.so.10", O_RDONLY)     = 3
open("/lib/libcrypto.so.10", O_RDONLY)  = 3
open("/lib/libcrypt.so.1", O_RDONLY)    = 3
open("/usr/lib/libstdc++.so.6", O_RDONLY) = 3
open("/lib/libm.so.6", O_RDONLY)        = 3
open("/lib/libgcc_s.so.1", O_RDONLY)    = 3
open("/lib/libc.so.6", O_RDONLY)        = 3
open("/lib/libkrb5.so.3", O_RDONLY)     = 3
open("/lib/libk5crypto.so.3", O_RDONLY) = 3
open("/lib/libcom_err.so.2", O_RDONLY)  = 3
open("/lib/libkrb5support.so.0", O_RDONLY) = 3
open("/lib/libkeyutils.so.1", O_RDONLY) = 3
open("/lib/libresolv.so.2", O_RDONLY)   = 3
Process 31546 attached
[pid 31546] +++ exited with 0 +++
open("/etc/localtime", O_RDONLY)        = 3
open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
open("/usr/share/mysql/english/errmsg.sys", O_RDONLY|O_LARGEFILE) = 3
open("/etc/nsswitch.conf", O_RDONLY)    = 3
open("/etc/ld.so.cache", O_RDONLY)      = 3
open("/lib/libnss_files.so.2", O_RDONLY) = 3
open("/etc/passwd", O_RDONLY|O_CLOEXEC) = 3
open("/usr/share/mysql/charsets/Index.xml", O_RDONLY|O_LARGEFILE) = 3
open("/db/ns1.lower-test", O_RDWR|O_CREAT|O_LARGEFILE, 0666) = 3
open("/db/ns1.lower-test", O_RDWR|O_CREAT|O_LARGEFILE, 0666) = 3
open("/proc/sys/kernel/ngroups_max", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/group", O_RDONLY|O_CLOEXEC)  = -1 ENOENT (No such file or directory)

open("/usr/lib/mysql/plugin/ha_innodb_plugin.so", O_RDONLY) = 4
130404 14:39:51 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_innodb_plugin.so' (errno: 2 failed to map segment from shared object: Operation n
130404 14:39:51 [ERROR] Couldn't load plugin named 'innodb' with soname 'ha_innodb_plugin.so'.

open("./mysql/plugin.frm", O_RDONLY|O_LARGEFILE) = 4
open("/db/mysql/plugin.MYI", O_RDWR|O_LARGEFILE) = 4
open("./mysql/plugin.MYD", O_RDWR|O_LARGEFILE) = 5
Process 31547 attached
[pid 31547] open("/mysqld.pid", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE, 0664) = 4
[pid 31545] open("/tmp/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY|O_CLOEXEC) = 4
[pid 31545] open("./mysql/host.frm", O_RDONLY|O_LARGEFILE) = 4
[pid 31545] open("/db/mysql/host.MYI", O_RDWR|O_LARGEFILE) = 4
[pid 31545] open("./mysql/host.MYD", O_RDWR|O_LARGEFILE) = 5
[pid 31545] open("./mysql/user.frm", O_RDONLY|O_LARGEFILE) = 6
[pid 31545] open("/db/mysql/user.MYI", O_RDWR|O_LARGEFILE) = 6
[pid 31545] open("./mysql/user.MYD", O_RDWR|O_LARGEFILE) = 8
[pid 31545] open("./mysql/db.frm", O_RDONLY|O_LARGEFILE) = 9
[pid 31545] open("/db/mysql/db.MYI", O_RDWR|O_LARGEFILE) = 9
[pid 31545] open("./mysql/db.MYD", O_RDWR|O_LARGEFILE) = 10
[pid 31545] open("./mysql/time_zone_leap_second.frm", O_RDONLY|O_LARGEFILE) = 11
[pid 31545] open("/db/mysql/time_zone_leap_second.MYI", O_RDWR|O_LARGEFILE) = 11
[pid 31545] open("./mysql/time_zone_leap_second.MYD", O_RDWR|O_LARGEFILE) = 12
[pid 31545] open("./mysql/time_zone_name.frm", O_RDONLY|O_LARGEFILE) = 13
[pid 31545] open("/db/mysql/host.MYI", O_RDWR|O_LARGEFILE) = 4
[pid 31545] open("./mysql/host.MYD", O_RDWR|O_LARGEFILE) = 5
[pid 31545] open("./mysql/user.frm", O_RDONLY|O_LARGEFILE) = 6
[pid 31545] open("/db/mysql/user.MYI", O_RDWR|O_LARGEFILE) = 6
[pid 31545] open("./mysql/user.MYD", O_RDWR|O_LARGEFILE) = 8
[pid 31545] open("./mysql/db.frm", O_RDONLY|O_LARGEFILE) = 9
[pid 31545] open("/db/mysql/db.MYI", O_RDWR|O_LARGEFILE) = 9
[pid 31545] open("./mysql/db.MYD", O_RDWR|O_LARGEFILE) = 10
[pid 31545] open("./mysql/time_zone_leap_second.frm", O_RDONLY|O_LARGEFILE) = 11
[pid 31545] open("/db/mysql/time_zone_leap_second.MYI", O_RDWR|O_LARGEFILE) = 11
[pid 31545] open("./mysql/time_zone_leap_second.MYD", O_RDWR|O_LARGEFILE) = 12
[pid 31545] open("./mysql/time_zone_name.frm", O_RDONLY|O_LARGEFILE) = 13
[pid 31545] open("/db/mysql/time_zone_name.MYI", O_RDWR|O_LARGEFILE) = 13
[pid 31545] open("./mysql/time_zone_name.MYD", O_RDWR|O_LARGEFILE) = 14
[pid 31545] open("./mysql/time_zone.frm", O_RDONLY|O_LARGEFILE) = 15
[pid 31545] open("/db/mysql/time_zone.MYI", O_RDWR|O_LARGEFILE) = 15
[pid 31545] open("./mysql/time_zone.MYD", O_RDWR|O_LARGEFILE) = 16
[pid 31545] open("./mysql/time_zone_transition_type.frm", O_RDONLY|O_LARGEFILE) = 17
[pid 31545] open("/db/mysql/time_zone_transition_type.MYI", O_RDWR|O_LARGEFILE) = 17
[pid 31545] open("./mysql/time_zone_transition_type.MYD", O_RDWR|O_LARGEFILE) = 18
[pid 31545] open("./mysql/time_zone_transition.frm", O_RDONLY|O_LARGEFILE) = 19
[pid 31545] open("/db/mysql/time_zone_transition.MYI", O_RDWR|O_LARGEFILE) = 19
[pid 31545] open("./mysql/time_zone_transition.MYD", O_RDWR|O_LARGEFILE) = 20
[pid 31545] open("./mysql/tables_priv.frm", O_RDONLY|O_LARGEFILE) = 11
[pid 31545] open("/db/mysql/tables_priv.MYI", O_RDWR|O_LARGEFILE) = 11
[pid 31545] open("./mysql/tables_priv.MYD", O_RDWR|O_LARGEFILE) = 12
[pid 31545] open("./mysql/columns_priv.frm", O_RDONLY|O_LARGEFILE) = 13
[pid 31545] open("/db/mysql/columns_priv.MYI", O_RDWR|O_LARGEFILE) = 13
[pid 31545] open("./mysql/columns_priv.MYD", O_RDWR|O_LARGEFILE) = 14
[pid 31545] open("./mysql/procs_priv.frm", O_RDONLY|O_LARGEFILE) = 15
[pid 31545] open("/db/mysql/procs_priv.MYI", O_RDWR|O_LARGEFILE) = 15
[pid 31545] open("./mysql/procs_priv.MYD", O_RDWR|O_LARGEFILE) = 16
[pid 31545] open("./mysql/servers.frm", O_RDONLY|O_LARGEFILE) = 17
[pid 31545] open("/db/mysql/servers.MYI", O_RDWR|O_LARGEFILE) = 17
[pid 31545] open("./mysql/servers.MYD", O_RDWR|O_LARGEFILE) = 18
[pid 31545] open("./mysql/func.frm", O_RDONLY|O_LARGEFILE) = 19
[pid 31545] open("/db/mysql/func.MYI", O_RDWR|O_LARGEFILE) = 19
[pid 31545] open("./mysql/func.MYD", O_RDWR|O_LARGEFILE) = 20
[pid 31545] open("./ddl_log.log", O_RDWR|O_LARGEFILE) = -1 ENOENT (No such file or directory)
[pid 31545] open("./mysql/event.frm", O_RDONLY|O_LARGEFILE) = 19
[pid 31545] open("/db/mysql/event.MYI", O_RDWR|O_LARGEFILE) = 19
[pid 31545] open("./mysql/event.MYD", O_RDWR|O_LARGEFILE) = 20
130404 14:39:51 [Note] Event Scheduler: Loaded 0 events
130404 14:39:51 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.62'  socket: '/mysql.sock'  port: 0  ALT Linux MySQL RPM
Process 31545 detached
Process 31547 detached
130404 14:40:49 [Note] /usr/sbin/mysqld: Normal shutdown

130404 14:40:49 [Note] Event Scheduler: Purging the queue. 0 events
130404 14:40:49 [Note] /usr/sbin/mysqld: Shutdown complete

 

/var/lib/mysql/my.cnf (3 последних закомментированных строки -  попытки обойти ошибку - не сработали):
Спойлер
[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

# http://dev.mysql.com/doc/refman/5.1/en/replacing-builtin-innodb.html
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so
#plugin-load=innodb= /var/lib/mysql/usr/lib/mysql/plugin
#plugin-load=innodb=/usr/lib/mysql/plugin/ha_innodb_plugin.so
#plugin-dir=/usr/lib/mysql/plugin


Опция из сообщения unknown option '--skip-innodb' ни в /etc/rc.d/init.d/mysqld, ни в /etc/sysconfig/mysql не упоминается.

Рекомендации со страницы http://dev.mysql.com/doc/refman/5.1/en/replacing-builtin-innodb.html выполнены, результата нет.
Поиск по сети тоже не дал ответа.
« Последнее редактирование: 04.04.2013 19:37:16 от Sciurus »

Оффлайн Sciurus

  • Участник
  • *
  • Сообщений: 41
Еcли убрать из конфига новые строки
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so

то демон нормально запускается (проблема с /etc/group, /proc/sys/kernel/ngroups_max из прошлого strace-лога решена в лоб, а ddl_log.log, наверное, в данной проблеме погоды не делает )
Спойлер
open("/etc/ld.so.cache", O_RDONLY)      = 3
open("/lib/libpthread.so.0", O_RDONLY)  = 3
open("/lib/libz.so.1", O_RDONLY)        = 3
open("/lib/libdl.so.2", O_RDONLY)       = 3
open("/lib/libssl.so.10", O_RDONLY)     = 3
open("/lib/libcrypto.so.10", O_RDONLY)  = 3
open("/lib/libcrypt.so.1", O_RDONLY)    = 3
open("/usr/lib/libstdc++.so.6", O_RDONLY) = 3
open("/lib/libm.so.6", O_RDONLY)        = 3
open("/lib/libgcc_s.so.1", O_RDONLY)    = 3
open("/lib/libc.so.6", O_RDONLY)        = 3
open("/lib/libkrb5.so.3", O_RDONLY)     = 3
open("/lib/libk5crypto.so.3", O_RDONLY) = 3
open("/lib/libcom_err.so.2", O_RDONLY)  = 3
open("/lib/libkrb5support.so.0", O_RDONLY) = 3
open("/lib/libkeyutils.so.1", O_RDONLY) = 3
open("/lib/libresolv.so.2", O_RDONLY)   = 3
Process 7212 attached
[pid  7212] +++ exited with 0 +++
open("/etc/localtime", O_RDONLY)        = 3
open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
open("/usr/share/mysql/english/errmsg.sys", O_RDONLY|O_LARGEFILE) = 3
open("/etc/nsswitch.conf", O_RDONLY)    = 3
open("/etc/ld.so.cache", O_RDONLY)      = 3
open("/lib/libnss_files.so.2", O_RDONLY) = 3
open("/etc/passwd", O_RDONLY|O_CLOEXEC) = 3
open("/usr/share/mysql/charsets/Index.xml", O_RDONLY|O_LARGEFILE) = 3
open("/db/ns1.lower-test", O_RDWR|O_CREAT|O_LARGEFILE, 0666) = 3
open("/db/ns1.lower-test", O_RDWR|O_CREAT|O_LARGEFILE, 0666) = 3
open("/proc/sys/kernel/ngroups_max", O_RDONLY) = 4
open("/etc/group", O_RDONLY|O_CLOEXEC)  = 4

open("./mysql/plugin.frm", O_RDONLY|O_LARGEFILE) = 4
open("/db/mysql/plugin.MYI", O_RDWR|O_LARGEFILE) = 4
open("./mysql/plugin.MYD", O_RDWR|O_LARGEFILE) = 5
open("/tmp/ibjA2b04", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = 4
open("/tmp/ibYE7bPZ", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = 4
open("/tmp/ibZebYDU", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = 4
130404 20:21:02  InnoDB: Initializing buffer pool, size = 8.0M
130404 20:21:02  InnoDB: Completed initialization of buffer pool

open("/tmp/ibq6Ys4O", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = 4
Process 7213 attached
Process 7214 attached
Process 7215 attached
Process 7216 attached
[pid  7211] open("./ibdata1", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0660) = -1 EEXIST (File exists)
[pid  7211] open("./ibdata1", O_RDWR|O_LARGEFILE) = 4
[pid  7211] open("./ib_logfile0", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0660) = -1 EEXIST (File exists)
[pid  7211] open("./ib_logfile0", O_RDWR|O_LARGEFILE) = 4
[pid  7211] open("./ib_logfile1", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0660) = -1 EEXIST (File exists)
[pid  7211] open("./ib_logfile1", O_RDWR|O_LARGEFILE) = 4
[pid  7211] open("./ibdata1", O_RDWR|O_LARGEFILE) = 4
[pid  7211] open("./ib_logfile0", O_RDWR|O_LARGEFILE) = 10
[pid  7211] open("./ib_logfile1", O_RDWR|O_LARGEFILE) = 11
[pid  7211] open("/tmp/ibfulSnK", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = 12
Process 7217 attached
[pid  7217] +++ exited with 0 +++
Process 7218 attached
Process 7219 attached
Process 7220 attached
Process 7221 attached
130404 20:21:02  InnoDB: Started; log sequence number 0 18011021
Process 7222 attached
[pid  7222] open("/mysqld.pid", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE, 0664) = 12
[pid  7211] open("/tmp/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY|O_CLOEXEC) = 12
[pid  7211] open("./mysql/host.frm", O_RDONLY|O_LARGEFILE) = 12
[pid  7211] open("/db/mysql/host.MYI", O_RDWR|O_LARGEFILE) = 12
[pid  7211] open("./mysql/host.MYD", O_RDWR|O_LARGEFILE) = 14
[pid  7211] open("./mysql/user.frm", O_RDONLY|O_LARGEFILE) = 15
[pid  7211] open("/db/mysql/user.MYI", O_RDWR|O_LARGEFILE) = 15
[pid  7211] open("./mysql/user.MYD", O_RDWR|O_LARGEFILE) = 16
[pid  7211] open("./mysql/db.frm", O_RDONLY|O_LARGEFILE) = 17
[pid  7211] open("/db/mysql/db.MYI", O_RDWR|O_LARGEFILE) = 17
[pid  7211] open("./mysql/db.MYD", O_RDWR|O_LARGEFILE) = 18
[pid  7211] open("./mysql/time_zone_leap_second.frm", O_RDONLY|O_LARGEFILE) = 19
[pid  7211] open("/db/mysql/time_zone_leap_second.MYI", O_RDWR|O_LARGEFILE) = 19
[pid  7211] open("./mysql/time_zone_leap_second.MYD", O_RDWR|O_LARGEFILE) = 20
[pid  7211] open("./mysql/time_zone_name.frm", O_RDONLY|O_LARGEFILE) = 21
[pid  7211] open("/db/mysql/time_zone_name.MYI", O_RDWR|O_LARGEFILE) = 21
[pid  7211] open("./mysql/time_zone_name.MYD", O_RDWR|O_LARGEFILE) = 22
[pid  7211] open("./mysql/time_zone.frm", O_RDONLY|O_LARGEFILE) = 23
[pid  7211] open("/db/mysql/time_zone.MYI", O_RDWR|O_LARGEFILE) = 23
[pid  7211] open("./mysql/time_zone.MYD", O_RDWR|O_LARGEFILE) = 24
[pid  7211] open("./mysql/time_zone_transition_type.frm", O_RDONLY|O_LARGEFILE) = 25
[pid  7211] open("/db/mysql/time_zone_transition_type.MYI", O_RDWR|O_LARGEFILE) = 25
[pid  7211] open("./mysql/time_zone_transition_type.MYD", O_RDWR|O_LARGEFILE) = 26
[pid  7211] open("./mysql/time_zone_transition.frm", O_RDONLY|O_LARGEFILE) = 27
[pid  7211] open("/db/mysql/time_zone_transition.MYI", O_RDWR|O_LARGEFILE) = 27
[pid  7211] open("./mysql/time_zone_transition.MYD", O_RDWR|O_LARGEFILE) = 28
[pid  7211] open("./mysql/tables_priv.frm", O_RDONLY|O_LARGEFILE) = 19
[pid  7211] open("/db/mysql/tables_priv.MYI", O_RDWR|O_LARGEFILE) = 19
[pid  7211] open("./mysql/tables_priv.MYD", O_RDWR|O_LARGEFILE) = 20
[pid  7211] open("./mysql/columns_priv.frm", O_RDONLY|O_LARGEFILE) = 21
[pid  7211] open("/db/mysql/columns_priv.MYI", O_RDWR|O_LARGEFILE) = 21
[pid  7211] open("./mysql/columns_priv.MYD", O_RDWR|O_LARGEFILE) = 22
[pid  7211] open("./mysql/procs_priv.frm", O_RDONLY|O_LARGEFILE) = 23
[pid  7211] open("/db/mysql/procs_priv.MYI", O_RDWR|O_LARGEFILE) = 23
[pid  7211] open("./mysql/procs_priv.MYD", O_RDWR|O_LARGEFILE) = 24
[pid  7211] open("./mysql/servers.frm", O_RDONLY|O_LARGEFILE) = 25
[pid  7211] open("/db/mysql/servers.MYI", O_RDWR|O_LARGEFILE) = 25
[pid  7211] open("./mysql/servers.MYD", O_RDWR|O_LARGEFILE) = 26
[pid  7211] open("./mysql/func.frm", O_RDONLY|O_LARGEFILE) = 27
[pid  7211] open("/db/mysql/func.MYI", O_RDWR|O_LARGEFILE) = 27
[pid  7211] open("./mysql/func.MYD", O_RDWR|O_LARGEFILE) = 28
[pid  7211] open("./ddl_log.log", O_RDWR|O_LARGEFILE) = 27
130404 20:21:02 [ERROR] Failed to read ddl log file in recovery

[pid  7211] open("./mysql/event.frm", O_RDONLY|O_LARGEFILE) = 27
[pid  7211] open("/db/mysql/event.MYI", O_RDWR|O_LARGEFILE) = 27
[pid  7211] open("./mysql/event.MYD", O_RDWR|O_LARGEFILE) = 28
130404 20:21:02 [Note] Event Scheduler: Loaded 0 events
130404 20:21:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.62'  socket: '/mysql.sock'  port: 0  ALT Linux MySQL RPM
Process 7211 detached
Process 7213 detached
Process 7214 detached
Process 7215 detached
Process 7216 detached
Process 7218 detached
Process 7219 detached
Process 7220 detached
Process 7221 detached
Process 7222 detached
« Последнее редактирование: 04.04.2013 19:12:13 от Sciurus »

Оффлайн Sciurus

  • Участник
  • *
  • Сообщений: 41
https://bugzilla.altlinux.org/show_bug.cgi?id=26232
Вот, возможно это частично про мой случай:
Цитировать
Действительно, в p6 попытка установить default-storage-engine=InnoDB в файле
/var/lib/mysql/my.cnf приводит к ругани при запуске сервера, поскольку скрипт
/usr/sbin/mysql_install_db вызывает mysqld с опцией --skip-innodb, которая
несовместима с default-storage-engine=InnoDB вне зависимости от наличия или
отсутствия параметра ignore-builtin-innodb. При этом ругань не мешает
последующему запуску сервера, если системные таблицы на самом деле уже были
созданы.
И ---skip-innodb живет действительно в /usr/sbin/mysql_install_db -  проверено.
Только вот что дальше делать?

Оффлайн Skull

  • Глобальный модератор
  • *****
  • Сообщений: 20 164
    • Домашняя страница
Ничего. Ждать исправления заведённого бага.
Андрей Черепанов (cas@)