Почему не запускается сервер MySQL?

Question

[Павел Петров]

Стоит комп именованный "сервером", на котором стоит виртуалка с запущенным окружением битрикса. после некорректного перезапуска "сервера" не запускается сервер MySQL. Память проверял, место на диске есть
Вот результаты проверки статуса работы процесса:

spoiler

[root@server init.d]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: activating (start) since Пт 2020-12-25 10:50:24 +06; 4s ago
Docs: man:mysqld(8)
dev.mysql.com/doc/refman/en/using-systemd.html
Process: 3860 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Control: 3888 (mysqld)
CGroup: /system.slice/mysqld.service
├─3888 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
└─3891 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

дек 25 10:50:24 server systemd[1]: Starting MySQL Server...
[root@server init.d]# journalctl -xe
-- Subject: Начинается запуск юнита mysqld.service
-- Defined-By: systemd
-- Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Начат процесс запуска юнита mysqld.service.
дек 25 10:50:30 server mysqld[3888]: Initialization of mysqld failed: 0
дек 25 10:50:30 server systemd[1]: mysqld.service: control process exited, code=exited status=1
дек 25 10:50:30 server systemd[1]: Failed to start MySQL Server.
-- Subject: Ошибка юнита mysqld.service
-- Defined-By: systemd
-- Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Произошел сбой юнита mysqld.service.
--
-- Результат: failed.
дек 25 10:50:30 server systemd[1]: Unit mysqld.service entered failed state.
дек 25 10:50:30 server systemd[1]: mysqld.service failed.
дек 25 10:50:30 server systemd[1]: mysqld.service holdoff time over, scheduling restart.
дек 25 10:50:30 server systemd[1]: Stopped MySQL Server.
-- Subject: Завершена остановка юнита mysqld.service.
-- Defined-By: systemd
-- Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Процесс остановки юнита mysqld.service был завершен.
дек 25 10:50:30 server systemd[1]: Starting MySQL Server...
-- Subject: Начинается запуск юнита mysqld.service
-- Defined-By: systemd
-- Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Начат процесс запуска юнита mysqld.service.
дек 25 10:50:36 server mysqld[3953]: Initialization of mysqld failed: 0
дек 25 10:50:36 server systemd[1]: mysqld.service: control process exited, code=exited status=1
дек 25 10:50:37 server systemd[1]: Failed to start MySQL Server.
-- Subject: Ошибка юнита mysqld.service
-- Defined-By: systemd
-- Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Произошел сбой юнита mysqld.service.
--
-- Результат: failed.
дек 25 10:50:37 server systemd[1]: Unit mysqld.service entered failed state.
дек 25 10:50:37 server systemd[1]: mysqld.service failed.
дек 25 10:50:37 server systemd[1]: mysqld.service holdoff time over, scheduling restart.
дек 25 10:50:37 server systemd[1]: Stopped MySQL Server.
-- Subject: Завершена остановка юнита mysqld.service.
-- Defined-By: systemd
-- Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Процесс остановки юнита mysqld.service был завершен.
дек 25 10:50:37 server systemd[1]: Starting MySQL Server...
-- Subject: Начинается запуск юнита mysqld.service
-- Defined-By: systemd
-- Support: lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Начат процесс запуска юнита mysqld.service.
дек 25 10:50:37 server sshd[3986]: Invalid user 113.53.251.125 from 142.93.169.136 port 51602
дек 25 10:50:37 server sshd[3986]: input_userauth_request: invalid user 113.53.251.125 [preauth]
дек 25 10:50:37 server sshd[3986]: pam_unix(sshd:auth): check pass; user unknown
дек 25 10:50:37 server sshd[3986]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=142.93.169.136
дек 25 10:50:39 server sshd[3986]: Failed password for invalid user 113.53.251.125 from 142.93.169.136 port 51602 ssh2
дек 25 10:50:39 server sshd[3986]: Received disconnect from 142.93.169.136 port 51602:11: Normal Shutdown, Thank you for playing [preauth]
дек 25 10:50:39 server sshd[3986]: Disconnected from 142.93.169.136 port 51602 [preauth]

В логах задачи виртуалки битрикса указано это:
PLAY [bitrix-hosts] ************************************************************

TASK [setup] *******************************************************************
ok: [server]

TASK [mysql : include variables from mysql group] ******************************
ok: [server]

TASK [mysql : include variables from web group] ********************************
ok: [server]

TASK [mysql : include variables from temporary config] *************************
ok: [server]

TASK [mysql : additional gathering facts] **************************************
ok: [server]

TASK [mysql : set_fact] ********************************************************

TASK [mysql : gathering facts about installed sites] ***************************

TASK [mysql : set_fact] ********************************************************

TASK [mysql : debug] ***********************************************************

TASK [mysql : create variable bx_sites_info] ***********************************

TASK [mysql : debug] ***********************************************************

TASK [mysql : include] *********************************************************

TASK [mysql : include] *********************************************************

TASK [mysql : include] *********************************************************
included: /etc/ansible/roles/mysql/tasks/mysql-start_service.yml for server

TASK [mysql : include] *********************************************************
included: /etc/ansible/roles/mysql/tasks/mysql-enable_service.yml for server

TASK [mysql : defined bx_system variable] **************************************
ok: [server]

TASK [mysql : recreate links] **************************************************

TASK [mysql : reload systemd configuration] ************************************

TASK [mysql : start mysql service] *********************************************
fatal: [server]: FAILED! => {"changed": false, "failed": true, "msg": "Unable to start service mysqld: Job for mysqld.service failed because the control process exited with error code. See \"systemctl $

NO MORE HOSTS LEFT *************************************************************
to retry, use: --limit @/etc/ansible/mysql.retry

PLAY RECAP *********************************************************************
server : ok=8 changed=0 unreachable=0 failed=1

Прошу прощения за кашу во всем этом, так как в своей организации и швец и жнец. Нормального опыта в работе не имею пока.

Comments

[Sand]

А что в логах мускла? Systemd не оч. интересно

[Павел Петров]

Sand, 2020-12-25T05:19:33.916919Z 0 [Note] Binlog end
2020-12-25T05:19:33.917733Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-12-25T05:19:34.875669Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
2020-12-25T05:19:34.875998Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
2020-12-25T05:19:35.032930Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-12-25T05:19:35.033957Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 22039 ...
2020-12-25T05:19:35.039554Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-12-25T05:19:35.039598Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-25T05:19:35.039602Z 0 [Note] InnoDB: Uses event mutexes
2020-12-25T05:19:35.039605Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-12-25T05:19:35.039608Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-12-25T05:19:35.039611Z 0 [Note] InnoDB: Using Linux native AIO
2020-12-25T05:19:35.039798Z 0 [Note] InnoDB: Number of pools: 1
2020-12-25T05:19:35.039883Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-12-25T05:19:35.041640Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
2020-12-25T05:19:35.097806Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-25T05:19:35.111665Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-25T05:19:35.131587Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2020-12-25T05:19:35.169615Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-12-25T05:19:35.178493Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
2020-12-25T05:19:35.178533Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
2020-12-25T05:19:35.178672Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
2020-12-25T05:19:35.178864Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-12-25T05:19:40.304649Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-12-25T05:19:40.304702Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-25T05:19:40.304713Z 0 [ERROR] Failed to initialize builtin plugins.
2020-12-25T05:19:40.304723Z 0 [ERROR] Aborting

2020-12-25T05:19:40.304775Z 0 [Note] Binlog end
2020-12-25T05:19:40.305459Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-12-25T05:19:41.362784Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
2020-12-25T05:19:41.363125Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
2020-12-25T05:19:41.517045Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-12-25T05:19:41.518182Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 22104 ...
2020-12-25T05:19:41.524651Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-12-25T05:19:41.524696Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-25T05:19:41.524700Z 0 [Note] InnoDB: Uses event mutexes
2020-12-25T05:19:41.524704Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-12-25T05:19:41.524708Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-12-25T05:19:41.524711Z 0 [Note] InnoDB: Using Linux native AIO
2020-12-25T05:19:41.524887Z 0 [Note] InnoDB: Number of pools: 1
2020-12-25T05:19:41.524995Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-12-25T05:19:41.526750Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
2020-12-25T05:19:41.596871Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-25T05:19:41.613012Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-25T05:19:41.641097Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2020-12-25T05:19:41.680034Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-12-25T05:19:41.689377Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
2020-12-25T05:19:41.689428Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
2020-12-25T05:19:41.689582Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
2020-12-25T05:19:41.689791Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

[Павел Петров]

Sand, нашел это: https://dba.stackexchange.com/questions/163445/inn...
но не могу найти файл конфигурации. Нашел только файл ~/.my.cnf но при его просмотре увидел только
# Ansible managed
[client]
user=root
password='Тут пароль'
socket=/var/lib/mysqld/mysqld.sock

[Sand]

Павел Петров, /etc/my.cnf
тут нет?

[Павел Петров]

Sand, есть такой файл, но это все имеющиеся параметры которые что то говорят об innodb. Или Вам лучше все настройки сообщить?
# InnoDB parameters
innodb_file_per_table
innodb_buffer_pool_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 64M
innodb_flush_method = O_DIRECT
innodb_strict_mode = OFF
Или можно добавлять недостающие настройки?

[Sand]

Павел Петров, конечно можно

[Sand]

innodb_log_checksums = ON, по Вашей ссылке должно сработать

[Павел Петров]

Sand, по указанному вопросу там имеются эти пункты в решении проблемы
Set innodb_log_checksums = ON on master and slave.
Remove rm /var/lib/mysql/ib_logfile*.
Restart.

Remove rm /var/lib/mysql/ib_logfile*.

опасно данное удаление чем-либо?

[Sand]

Павел Петров, лучше переместите куда-нить, на всякий случай
mv /var/lib/mysql/ib_logfile* ~/

[Павел Петров]

Sand, нашел два таких файла. Удалять их всех?

[Sand]

Павел Петров, волнуетесь?

[Sand]

Павел Петров,

опасно данное удаление чем-либо?

Please be aware that when you remove these files you are deleting the redo log, which means if the server was very active when it went down you will lose transactions and possibly corrupt the server. Some have reported that "it works for me" because it's harmless on a server with no load, but in production trying to start a crashed server by removing the innodb log files will almost certainly result in data loss and other problems.

Потому и говорю, на всякий случай переместите, не удаляйте. Но, судя по

Стоит комп именованный "сервером", на котором стоит виртуалка с запущенным окружением битрикса. после некорректного перезапуска "сервера" не запускается сервер MySQL

волноваться не о чем

[Павел Петров]

Sand, конечно) не хотелось бы по причине собственной криворукости что то сломать

[Павел Петров]

Sand, переместил файлы, перезапустил командой systemctl restart mysql
В ответ получаю ob for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details
Далее ввожу
[root@server ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Пт 2020-12-25 13:19:38 +06; 5min ago
Docs: man:mysqld(8)
dev.mysql.com/doc/refman/en/using-systemd.html
Process: 3002 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 2973 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
дек 25 13:19:38 server systemd[1]: mysqld.service failed.
дек 25 13:19:38 server systemd[1]: mysqld.service holdoff time over, scheduling restart.
дек 25 13:19:38 server systemd[1]: Stopped MySQL Server.
дек 25 13:19:38 server systemd[1]: start request repeated too quickly for mysqld.service
дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
дек 25 13:19:38 server systemd[1]: mysqld.service failed.

[Sand]

Павел Петров, а влогах мускла что?)

[Павел Петров]

Sand, блин. извиняюсь
Логи читал в файле
/var/log/mysql/error.log (наверное это они)
дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
дек 25 13:19:38 server systemd[1]: mysqld.service failed.
дек 25 13:19:38 server systemd[1]: mysqld.service holdoff time over, scheduling restart.
дек 25 13:19:38 server systemd[1]: Stopped MySQL Server.
дек 25 13:19:38 server systemd[1]: start request repeated too quickly for mysqld.service
дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
дек 25 13:19:38 server systemd[1]: mysqld.service failed.
[root@server ~]# cd /etc/
[root@server etc]# ls
adjtime crontab fstab issue mc os-release profile.d sasl2 system-release
aliases cron.weekly gcrypt issue.net mercurial pam.d protocols securetty system-release-cpe
aliases.db crypttab GeoIP.conf kdump.conf mime.types papersize push-server security tcsd.conf
alternatives csh.cshrc ghostscript kernel mke2fs.conf passwd python selinux terminfo
anacrontab csh.login glvnd krb5.conf modprobe.d passwd- rc0.d services tmpfiles.d
ansible dbus-1 gnupg krb5.conf.d modules-load.d pear rc1.d sestatus.conf tuned
asound.conf default GREP_COLORS ld.so.cache motd pear.conf rc2.d shadow udev
audisp depmod.d groff ld.so.conf msmtprc percona-server.cnf rc3.d shadow- vconsole.conf
audit dhcp group ld.so.conf.d mtab percona-server.conf.d rc4.d shells vimrc
authbind DIR_COLORS group- letsencrypt munin php.d rc5.d skel virc
bash_completion.d DIR_COLORS.256color grub2.cfg libaudit.conf my.cnf php.ini rc6.d ssh wgetrc
bashrc DIR_COLORS.lightbgcolor grub.d libnl my.cnf.d php.ini.201907021450 rc.d ssl wpa_supplicant
binfmt.d dkms gshadow libpaper.d mysql php.ini.202003091433 rc.local statetab X11
bitrix-my.cnf dracut.conf gshadow- libuser.conf nagios php.ini.rpmnew redhat-release statetab.d xdg
centos-release dracut.conf.d gss locale.conf nanorc php-zts.d redis.conf stunnel xinetd.conf
centos-release-upstream e2fsck.conf host.conf localtime NetworkManager pkcs11 redis-sentinel.conf subgid xinetd.d
chkconfig.d egl hostname login.defs networks pki resolv.conf subuid yum
chrony.conf environment hosts logrotate.conf nginx plymouth resolv.conf.save sudo.conf yum.conf
chrony.keys etckeeper hosts.allow logrotate.d nrpe.d pm rpc sudoers yum.repos.d
conntrackd ethertypes hosts.deny machine-id nsswitch.conf polkit-1 rpm sudoers.d
cron.d exports httpd magic nsswitch.conf.rpmnew popt.d rsyncd.conf sudo-ldap.conf
cron.daily favicon.png init.d mailcap ntp ppp rsyslog.conf sysconfig
cron.deny filesystems inittab mail.rc ntp.conf

prelink.conf.d rsyslog.d sysctl.conf
cron.hourly firewalld inputrc makedumpfile.conf.sample openldap printcap rwtab sysctl.d
cron.monthly fonts iproute2 man_db.conf opt profile rwtab.d systemd
[root@server etc]# cd my
-bash: cd: my: Нет такого файла или каталога
[root@server etc]# cd mysql/
[root@server mysql]# ls
conf.d
[root@server mysql]# cd conf.d/
[root@server conf.d]# ls
bvat.cnf logging.cnf ystemctl status mysqld.service z_bx_custom.cnf
[root@server conf.d]# nano status
[root@server conf.d]# cd stat
-bash: cd: stat: Нет такого файла или каталога
[root@server conf.d]# cd status
-bash: cd: status: Нет такого файла или каталога
[root@server conf.d]# ls
bvat.cnf logging.cnf ystemctl status mysqld.service z_bx_custom.cnf
[root@server conf.d]# nano logging.cnf
[root@server conf.d]# nano /var/log/mysql/error.log

GNU nano 2.3.1 Файл: /var/log/mysql/error.log

2020-12-25T03:29:35.212630Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13919ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:30:49.484454Z 76714 [Note] Got an error reading communication packets
2020-12-25T03:31:01.120382Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7610ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:35:00.554429Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5991ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:35:16.222370Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4617ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:35:49.489015Z 77013 [Note] Got an error reading communication packets
2020-12-25T03:40:49.503695Z 77201 [Note] Got an error reading communication packets
2020-12-25T03:41:01.540308Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5861ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:41:24.309166Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6398ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:45:12.704478Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4696ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:45:38.206678Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6068ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:45:49.521306Z 77498 [Note] Got an error reading communication packets
2020-12-25T03:49:32.701712Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4480ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:50:49.530561Z 77646 [Note] Got an error reading communication packets
2020-12-25T03:55:49.767486Z 77818 [Note] Got an error reading communication packets
2020-12-25T03:58:36.162091Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4246ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T03:58:41.890415Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4728ms. The settings might not be optimal. (flushed=0, during the time.)
2020-12-25T10:04:08.082509Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
2020-12-25T10:04:08.082892Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
2020-12-25T10:04:08.312133Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-12-25T10:04:08.315613Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 2104 ...
2020-12-25T10:04:08.357397Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-12-25T10:04:08.357442Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-25T10:04:08.357446Z 0 [Note] InnoDB: Uses event mutexes
2020-12-25T10:04:08.357449Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-12-25T10:04:08.357464Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-12-25T10:04:08.357471Z 0 [Note] InnoDB: Using Linux native AIO
2020-12-25T10:04:08.358605Z 0 [Note] InnoDB: Number of pools: 1
2020-12-25T10:04:08.358720Z 0 [Note] InnoDB: Using

CPU crc32 instructions
2020-12-25T10:04:08.377006Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
2020-12-25T10:04:08.540746Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-25T10:04:08.589226Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-25T10:04:08.672266Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2020-12-25T10:04:09.003551Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-12-25T10:04:09.087796Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
2020-12-25T10:04:09.087855Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
2020-12-25T10:04:09.088188Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
2020-12-25T10:04:09.088596Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-12-25T04:04:16.635458Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-12-25T04:04:16.635501Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-25T04:04:16.635507Z 0 [ERROR] Failed to initialize builtin plugins.
2020-12-25T04:04:16.635513Z 0 [ERROR] Aborting

[Sand]

Павел Петров,
ls -la /var/lib/mysql/ib_log*

grep inno /etc/my.cnf

[Павел Петров]

Sand, -rw-r----- 1 mysql mysql 67108864 дек 25 13:59 /var/lib/mysql/ib_logfile0
-rw-r----- 1 mysql mysql 67108864 дек 25 13:18 /var/lib/mysql/ib_logfile1

grep inno /etc/my.cnf
default-storage-engine = innodb
innodb_file_per_table
innodb_buffer_pool_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 64M
innodb_flush_method = O_DIRECT
innodb_strict_mode = OFF
innodb_log_checksums = ON
innodb_force_recovery = 4

[Sand]

systemctl stop mysqld
systemctl stop mysql
rm -rf /var/lib/mysql/ib_logfile*
systemctl start mysql

[CityCat4]

Похоже база повреждена и авторекавер не проходит. Скопировать /var/lib/mysql куда-нибудь и читать про восстановление БД. Хотя если есть свежий бэкап - проще наверное будет с него восстановиться. Ну а если как обычно - читать, можно ли восстановить и если можно, то как.

[Павел Петров]

CityCat4, Понял. Благодарю. Где то были бэкапы. Начну качать

[Антон]

Павел Петров, почему innodb_file_per_table без значения?
Для старта я бы вообще убрал всё это и потом если стартанет добавял по строчке...

default-storage-engine = innodb
innodb_file_per_table
innodb_buffer_pool_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 64M
innodb_flush_method = O_DIRECT
innodb_strict_mode = OFF
innodb_log_checksums = ON
innodb_force_recovery = 4

[Павел Петров]

Антон, на Ваш вопрос не смогу дать ответа так как запустили виртуалку с установленным на нем дистрибутивом, распаковали туда архив преоставленный битриксом и оставили как есть. С появлением каких то мелких проблем делали вкладки и ничего более

[Павел Петров]

Антон CityCat4 Sand получил после изменения в настройках по рекомендации anton99zel
MySQL Query Error: UPDATE b_user SET STORED_HASH = NULL, LAST_LOGIN = now(), TIMESTAMP_X = TIMESTAMP_X, LOGIN_ATTEMPTS = 0 , TIME_ZONE_OFFSET = 3600 WHERE ID=244[[1036]

[Антон]

Павел Петров, стартанул и ошибка на странице?

[Павел Петров]

Антон, ага

[Антон]

Павел Петров, Надо выполнить
alter table b_user add TIME_ZONE_OFFSET int(18)