Op 08-11-2022 om 22:54 schreef Daniel Black:
On Wed, Nov 9, 2022 at 12:01 AM Jogchum Reitsma <jogchum.reitsma@gmail.com> wrote:
<...> The directory /var/run/mysql doesn't exist
2022-11-08 13:37:33 0 [ERROR] Do you already have another server running on socket: /var/run/mysql/mysql.sock ? This guess of an error should be fixed.
Well, in the meantime I have a running database, thanks to all the help I get here. But I'm not quite out of trouble yet. The last problem with starting /usr/local/mariadb-10.6.10-linux-systemd-x86_64/bin/mariadbd was solved by chmod 777 /var/run/mysql; this was needed because I start mariadb as a plain user for the moment. chmod on /var/log/msql gave me logging, too. All temporarily of course, it should be reverted to it's default state once everything runs normally. But for now, I have a running database. Alas, after stopping it with ctrl-\, I tried systemctl start mariadb.service (in the meantime the Thumbleweed version of mariadb is at 10.9.x) But with no luck. It lasted a while, then came with Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details. ######################################################################################################## systemctl status mariadb.service ×mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d └─override.conf Active: failed(Result: exit-code) since Thu 2022-11-10 10:31:15 CET; 52min ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 7671 ExecStartPre=/usr/libexec/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS) Process: 7683 ExecStartPre=/usr/libexec/mysql/mysql-systemd-helper upgrade (code=exited, status=1/FAILURE) CPU: 446ms nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Trying to run upgrade of MySQL databases... nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Stale files from previous upgrade detected, cleaned them up nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Running protected MySQL... nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Waiting for MySQL to start nov 10 10:30:15 linux-mkay mysql-systemd-helper[7707]: 2022-11-10 10:30:15 0 [Note] /usr/sbin/mysqld (server 10.9.3-MariaDB) starting as process 7707 ... nov 10 10:31:15 linux-mkay mysql-systemd-helper[7683]: MySQL is still dead nov 10 10:31:15 linux-mkay mysql-systemd-helper[7683]: MySQL didn't start, can't continue nov 10 10:31:15 linux-mkay systemd[1]: mariadb.service: Control process exited, code=exited, status=1/FAILURE nov 10 10:31:15 linux-mkay systemd[1]: mariadb.service: Failed with result 'exit-code'. nov 10 10:31:15 linux-mkay systemd[1]: Failed to start MariaDB database server. ######################################################################################################## journalctl -xeu mariadb.service nov 10 10:30:15 linux-mkay systemd[1]: Starting MariaDB database server... ░░ Subject: A start job for unit mariadb.service has begun execution ░░Defined-By: systemd ░░Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel ░░ ░░A start job for unit mariadb.service has begun execution. ░░ ░░The job identifier is 558086. nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Checking MySQL configuration for obsolete options... nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Trying to run upgrade of MySQL databases... nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Stale files from previous upgrade detected, cleaned them up nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Running protected MySQL... nov 10 10:30:15 linux-mkay mysql-systemd-helper[7683]: Waiting for MySQL to start nov 10 10:30:15 linux-mkay mysql-systemd-helper[7707]: 2022-11-10 10:30:15 0 [Note] /usr/sbin/mysqld (server 10.9.3-MariaDB) starting as process 7707 ... nov 10 10:31:15 linux-mkay mysql-systemd-helper[7683]: MySQL is still dead nov 10 10:31:15 linux-mkay mysql-systemd-helper[7683]: MySQL didn't start, can't continue nov 10 10:31:15 linux-mkay 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 10 10:31:15 linux-mkay 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 10 10:31:15 linux-mkay 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 558086 and the job result is failed. ######################################################################################################## Once again I'm at a loss here - what causes mysqld not to start? Any further help dearly appreciated.... regards, Jogchum