Автор Тема: p8 / Не стартует MySQL [решено]  (Прочитано 3098 раз)

Оффлайн berkut_174

  • Мастер
  • ***
  • Сообщений: 6 994
    • Email
Всем привет!
Может кто подскажет, почему не стартует:
# systemctl status mysqld
● mysqld.service - MySQL database server
   Loaded: loaded (/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mysqld.service.d
           └─user.conf
   Active: failed (Result: exit-code) since Tue 2019-11-12 18:15:37 +05; 32s ago
  Process: 10612 ExecStart=/usr/sbin/mysqld -C $CHSET $OPT (code=exited, status=1/FAILURE)
  Process: 10111 ExecStartPre=/etc/chroot.d/mysql.all (code=exited, status=0/SUCCESS)
  Process: 10110 ExecStartPre=/bin/sh -c if [ ! -d /var/lib/mysql/db/mysql ]; then /usr/sbin/mysqld -C $CHSET --initialize-insecure --user=mysql; fi (code=exited, status=0/SUCCESS)
 Main PID: 10612 (code=exited, status=1/FAILURE)

ноя 12 18:15:36 server.firma.zn systemd[1]: Starting MySQL database server...
ноя 12 18:15:37 server.firma.zn systemd[1]: Started MySQL database server.
ноя 12 18:15:37 server.firma.zn systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
ноя 12 18:15:37 server.firma.zn systemd[1]: mysqld.service: Failed with result 'exit-code'.

# cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
sql_mode = NO_ENGINE_SUBSTITUTION
« Последнее редактирование: 12.11.2019 17:00:32 от berkut_174 »
Сноси Винду, переходи на Линукс ! :)

Оффлайн berkut_174

  • Мастер
  • ***
  • Сообщений: 6 994
    • Email
Re: p8 / Не стартует MySQL
« Ответ #1 : 12.11.2019 16:42:41 »
#  cat mysqld.log
2019-11-12T13:40:29.653262Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-11-12T13:40:29.653339Z 0 [Warning] Can't create test file /db/server.lower-test
2019-11-12T13:40:29.653505Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.24-alt1) starting as process 12333 ...
2019-11-12T13:40:29.656372Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2019-11-12T13:40:29.656377Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2019-11-12T13:40:29.656761Z 0 [Warning] CA certificate /db/ca.pem is self signed.
2019-11-12T13:40:29.656780Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2019-11-12T13:40:29.670321Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-11-12T13:40:29.670333Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-11-12T13:40:29.670337Z 0 [Note] InnoDB: Uses event mutexes
2019-11-12T13:40:29.670340Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-11-12T13:40:29.670343Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-11-12T13:40:29.670346Z 0 [Note] InnoDB: Using Linux native AIO
2019-11-12T13:40:29.670502Z 0 [Note] InnoDB: Number of pools: 1
2019-11-12T13:40:29.670571Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-11-12T13:40:29.671505Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-11-12T13:40:29.676124Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-12T13:40:29.677515Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-11-12T13:40:29.688799Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-11-12T13:40:29.689563Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 35262856324
2019-11-12T13:40:29.692559Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 35262930432
2019-11-12T13:40:29.692924Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 35262856324 and the end 35262930432.
2019-11-12T13:40:29.692932Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-11-12T13:40:30.293962Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-11-12T13:40:30.294021Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-11-12T13:40:30.294035Z 0 [ERROR] Failed to initialize builtin plugins.
2019-11-12T13:40:30.294043Z 0 [ERROR] Aborting

2019-11-12T13:40:30.294055Z 0 [Note] Binlog end
2019-11-12T13:40:30.294159Z 0 [Note] Shutting down plugin 'CSV'
2019-11-12T13:40:30.295209Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Сноси Винду, переходи на Линукс ! :)

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 5 758
Re: p8 / Не стартует MySQL
« Ответ #2 : 12.11.2019 16:48:41 »
https://www.google.ru/search?q=Ignoring+the+redo+log+due+to+missing+MLOG_CHECKPOINT+between

есть какие-то советы приводящие к успеху, но возможна потеря части данных...

Оффлайн berkut_174

  • Мастер
  • ***
  • Сообщений: 6 994
    • Email
Re: p8 / Не стартует MySQL
« Ответ #3 : 12.11.2019 17:00:10 »
Этот совет подошёл https://dba.stackexchange.com/questions/163445/innodb-ignoring-the-redo-log-due-to-missing-mlog-checkpoint
Только эти фалы были в /var/lib/mysql/db/

[решено]
Сноси Винду, переходи на Линукс ! :)