[vz-users] MariaDB startet nicht

Wolfgang Jordan wolfgang-jordan at t-online.de
Sa Dez 28 20:57:56 CET 2024 

Hallo,

ich kann meine Datenbank nicht mehr starten, sehe aber nicht, woran das 
liegt. Ich zeige mal ein paar Ergebnisse und hoffe, dass jemand das 
Problem lokalisieren kann.

pi at raspberrypi:~ $ sudo 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.
=============
pi at raspberrypi:~ $ sudo systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.48 database server
    Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor 
preset: enabled)
    Active: failed (Result: exit-code) since Sat 2024-12-28 20:54:36 
CET; 27s ago
      Docs: man:mysqld(8)
            https://mariadb.com/kb/en/library/systemd/
   Process: 1480 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS 
$_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Process: 1402 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery 
] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 
0 ]   && systemctl set-environment _WSRE
   Process: 1398 ExecStartPre=/bin/sh -c systemctl unset-environment 
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
   Process: 1395 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root 
-d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Main PID: 1480 (code=exited, status=1/FAILURE)
    Status: "MariaDB server is down"

Dez 28 20:54:32 raspberrypi systemd[1]: Starting MariaDB 10.1.48 
database server...
Dez 28 20:54:33 raspberrypi mysqld[1480]: 2024-12-28 20:54:33 1995964208 
[Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0+deb9u1) starting as 
process 1480 ...
Dez 28 20:54:36 raspberrypi systemd[1]: mariadb.service: Main process 
exited, code=exited, status=1/FAILURE
Dez 28 20:54:36 raspberrypi systemd[1]: Failed to start MariaDB 10.1.48 
database server.
Dez 28 20:54:36 raspberrypi systemd[1]: mariadb.service: Unit entered 
failed state.
Dez 28 20:54:36 raspberrypi systemd[1]: mariadb.service: Failed with 
result 'exit-code'.
lines 1-18/18 (END)
=============
pi at raspberrypi:~ $ journalctl -xe
Dez 28 20:43:54 raspberrypi sudo[1221]:       pi : TTY=pts/0 ; 
PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl status mariadb.service
Dez 28 20:43:54 raspberrypi sudo[1221]: pam_unix(sudo:session): session 
opened for user root by pi(uid=0)
Dez 28 20:44:16 raspberrypi sudo[1221]: pam_unix(sudo:session): session 
closed for user root
Dez 28 20:44:23 raspberrypi sudo[1230]:       pi : TTY=pts/0 ; 
PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl start mariadb.service
Dez 28 20:44:23 raspberrypi sudo[1230]: pam_unix(sudo:session): session 
opened for user root by pi(uid=0)
Dez 28 20:44:23 raspberrypi systemd[1]: Starting MariaDB 10.1.48 
database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has begun starting up.
Dez 28 20:44:25 raspberrypi mysqld[1323]: 2024-12-28 20:44:25 1996037936 
[Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0+deb9u1) starting as 
process 1323 ...
Dez 28 20:44:28 raspberrypi systemd[1]: mariadb.service: Main process 
exited, code=exited, status=1/FAILURE
Dez 28 20:44:28 raspberrypi systemd[1]: Failed to start MariaDB 10.1.48 
database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Dez 28 20:44:28 raspberrypi systemd[1]: mariadb.service: Unit entered 
failed state.
Dez 28 20:44:28 raspberrypi systemd[1]: mariadb.service: Failed with 
result 'exit-code'.
Dez 28 20:44:28 raspberrypi sudo[1230]: pam_unix(sudo:session): session 
closed for user root
Dez 28 20:44:37 raspberrypi sudo[1352]:       pi : TTY=pts/0 ; 
PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl status mariadb.service
Dez 28 20:44:37 raspberrypi sudo[1352]: pam_unix(sudo:session): session 
opened for user root by pi(uid=0)
Dez 28 20:45:12 raspberrypi sudo[1352]: pam_unix(sudo:session): session 
closed for user root
Dez 28 20:52:22 raspberrypi systemd[1]: Starting Cleanup of Temporary 
Directories...
-- Subject: Unit systemd-tmpfiles-clean.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit systemd-tmpfiles-clean.service has begun starting up.
Dez 28 20:52:22 raspberrypi systemd[1]: Started Cleanup of Temporary 
Directories.
-- Subject: Unit systemd-tmpfiles-clean.service has finished start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit systemd-tmpfiles-clean.service has finished starting up.
--
-- The start-up result is done.
Dez 28 20:54:32 raspberrypi sudo[1389]:       pi : TTY=pts/0 ; 
PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl start mariadb.service
Dez 28 20:54:32 raspberrypi sudo[1389]: pam_unix(sudo:session): session 
opened for user root by pi(uid=0)
Dez 28 20:54:32 raspberrypi systemd[1]: Starting MariaDB 10.1.48 
database server...
-- Subject: Unit mariadb.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has begun starting up.
Dez 28 20:54:33 raspberrypi mysqld[1480]: 2024-12-28 20:54:33 1995964208 
[Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0+deb9u1) starting as 
process 1480 ...
Dez 28 20:54:36 raspberrypi systemd[1]: mariadb.service: Main process 
exited, code=exited, status=1/FAILURE
Dez 28 20:54:36 raspberrypi systemd[1]: Failed to start MariaDB 10.1.48 
database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Dez 28 20:54:36 raspberrypi systemd[1]: mariadb.service: Unit entered 
failed state.
Dez 28 20:54:36 raspberrypi systemd[1]: mariadb.service: Failed with 
result 'exit-code'.
Dez 28 20:54:36 raspberrypi sudo[1389]: pam_unix(sudo:session): session 
closed for user root
Dez 28 20:55:03 raspberrypi sudo[1512]:       pi : TTY=pts/0 ; 
PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl status mariadb.service
Dez 28 20:55:03 raspberrypi sudo[1512]: pam_unix(sudo:session): session 
opened for user root by pi(uid=0)
Dez 28 20:55:32 raspberrypi sudo[1512]: pam_unix(sudo:session): session 
closed for user root
lines 1548-1612/1612 (END)


Gruß, Wolfgang

Mehr Informationen über die Mailingliste volkszaehler-users