maria-discuss team mailing list archive

[Jogchum Reitsma <jogchum.reitsma@xxxxxxxxx>]

Op 08-11-2022 om 22:54 schreef Daniel Black:
> On Wed, Nov 9, 2022 at 12:01 AM Jogchum Reitsma
> <jogchum.reitsma@xxxxxxxxx>  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