Spaser
08-11-2021, 18:58
Доброго времени суток. Работаю на OpenSUSE. После обновления операционки с версии 15.0 на версию 15.3 перестала запускаться база данный MariaDB. При попытке запуска выдаёт следующее:
localhost:~ # systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Смотрим журналы. В них следующее:
localhost:~ # systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2021-11-08 18:34:26 MSK; 35s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 7264 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
Process: 7270 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=1/FAILURE)
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Trying to run upgrade of MySQL databases...
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Stale files from previous upgrade detected, cleaned them up
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Running protected MySQL...
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Waiting for MySQL to start
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7289]: 2021-11-08 18:33:25 0 [Note] /usr/sbin/mysqld (mysqld 10.5.8-MariaDB) starting as process 728>
Nov 08 18:34:26 localhost.localdomain mysql-systemd-helper[7270]: MySQL is still dead
Nov 08 18:34:26 localhost.localdomain mysql-systemd-helper[7270]: MySQL didn't start, can't continue
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Control process exited, code=exited, status=1/FAILURE
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Failed with result 'exit-code'.
Nov 08 18:34:26 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
localhost:~ # journalctl -xe
Nov 08 18:34:26 localhost.localdomain mysql-systemd-helper[7270]: MySQL didn't start, can't continue
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Control process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ An ExecStartPre= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Nov 08 18:34:26 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 18611 and the job result is failed.
Пробовал переустановить полностью базу данных и апач. В конце установки выдалось предупреждение:
Уведомления от пакетов
У вас есть уведомления от следующих пакетов:
mariadb
Это сообщение будет доступно в /var/adm/update-messages/mariadb-10.5.8-1.5-something
WARNING: You are upgrading from different stable version of MySQL!
Your database will be migrated automatically during next restart of MySQL.
Before you do that make sure you have up to date backup of your data. It
should be mainly in /var/lib/mysql directory.
И дополнительно после переустановки перестала запускаться самба. Выдаёт следующую ошибку:
* smb.service - Samba SMB Daemon
Loaded: loaded (/usr/lib/systemd/system/smb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2021-11-08 18:39:48 MSK; 1min 1s ago
Docs: man:smbd(8)
man:samba(7)
man:smb.conf(5)
Process: 10500 ExecStartPre=/usr/share/samba/update-apparmor-samba-profile (code=exited, status=0/SUCCESS)
Process: 10504 ExecStart=/usr/sbin/smbd --foreground --no-process-group $SMBDOPTIONS (code=exited, status=255/EXCEPTION)
Main PID: 10504 (code=exited, status=255/EXCEPTION)
Status: "Starting process..."
Nov 08 18:39:47 localhost.localdomain systemd[1]: Starting Samba SMB Daemon...
Nov 08 18:39:48 localhost.localdomain smbd[10504]: [2021/11/08 18:39:48.226180, 0] ../../source3/auth/auth_util.c:1411(make_new_session_info_guest)
Nov 08 18:39:48 localhost.localdomain smbd[10504]: create_local_token failed: NT_STATUS_INVALID_PARAMETER_MIX
Nov 08 18:39:48 localhost.localdomain smbd[10504]: [2021/11/08 18:39:48.226392, 0] ../../source3/smbd/server.c:2055(main)
Nov 08 18:39:48 localhost.localdomain smbd[10504]: ERROR: failed to setup guest info.
Nov 08 18:39:48 localhost.localdomain systemd[1]: smb.service: Main process exited, code=exited, status=255/EXCEPTION
Nov 08 18:39:48 localhost.localdomain systemd[1]: smb.service: Failed with result 'exit-code'.
Nov 08 18:39:48 localhost.localdomain systemd[1]: Failed to start Samba SMB Daemon.
Куда копнуть?
localhost:~ # systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Смотрим журналы. В них следующее:
localhost:~ # systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2021-11-08 18:34:26 MSK; 35s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 7264 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS)
Process: 7270 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=1/FAILURE)
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Trying to run upgrade of MySQL databases...
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Stale files from previous upgrade detected, cleaned them up
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Running protected MySQL...
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7270]: Waiting for MySQL to start
Nov 08 18:33:25 localhost.localdomain mysql-systemd-helper[7289]: 2021-11-08 18:33:25 0 [Note] /usr/sbin/mysqld (mysqld 10.5.8-MariaDB) starting as process 728>
Nov 08 18:34:26 localhost.localdomain mysql-systemd-helper[7270]: MySQL is still dead
Nov 08 18:34:26 localhost.localdomain mysql-systemd-helper[7270]: MySQL didn't start, can't continue
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Control process exited, code=exited, status=1/FAILURE
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Failed with result 'exit-code'.
Nov 08 18:34:26 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
localhost:~ # journalctl -xe
Nov 08 18:34:26 localhost.localdomain mysql-systemd-helper[7270]: MySQL didn't start, can't continue
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Control process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ An ExecStartPre= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Nov 08 18:34:26 localhost.localdomain systemd[1]: mariadb.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Nov 08 18:34:26 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 18611 and the job result is failed.
Пробовал переустановить полностью базу данных и апач. В конце установки выдалось предупреждение:
Уведомления от пакетов
У вас есть уведомления от следующих пакетов:
mariadb
Это сообщение будет доступно в /var/adm/update-messages/mariadb-10.5.8-1.5-something
WARNING: You are upgrading from different stable version of MySQL!
Your database will be migrated automatically during next restart of MySQL.
Before you do that make sure you have up to date backup of your data. It
should be mainly in /var/lib/mysql directory.
И дополнительно после переустановки перестала запускаться самба. Выдаёт следующую ошибку:
* smb.service - Samba SMB Daemon
Loaded: loaded (/usr/lib/systemd/system/smb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2021-11-08 18:39:48 MSK; 1min 1s ago
Docs: man:smbd(8)
man:samba(7)
man:smb.conf(5)
Process: 10500 ExecStartPre=/usr/share/samba/update-apparmor-samba-profile (code=exited, status=0/SUCCESS)
Process: 10504 ExecStart=/usr/sbin/smbd --foreground --no-process-group $SMBDOPTIONS (code=exited, status=255/EXCEPTION)
Main PID: 10504 (code=exited, status=255/EXCEPTION)
Status: "Starting process..."
Nov 08 18:39:47 localhost.localdomain systemd[1]: Starting Samba SMB Daemon...
Nov 08 18:39:48 localhost.localdomain smbd[10504]: [2021/11/08 18:39:48.226180, 0] ../../source3/auth/auth_util.c:1411(make_new_session_info_guest)
Nov 08 18:39:48 localhost.localdomain smbd[10504]: create_local_token failed: NT_STATUS_INVALID_PARAMETER_MIX
Nov 08 18:39:48 localhost.localdomain smbd[10504]: [2021/11/08 18:39:48.226392, 0] ../../source3/smbd/server.c:2055(main)
Nov 08 18:39:48 localhost.localdomain smbd[10504]: ERROR: failed to setup guest info.
Nov 08 18:39:48 localhost.localdomain systemd[1]: smb.service: Main process exited, code=exited, status=255/EXCEPTION
Nov 08 18:39:48 localhost.localdomain systemd[1]: smb.service: Failed with result 'exit-code'.
Nov 08 18:39:48 localhost.localdomain systemd[1]: Failed to start Samba SMB Daemon.
Куда копнуть?