Sample Header Ad - 728x90

unable to start mysqld

1 vote
3 answers
672 views
I'm getting the following after I try to start mysql: $ sudo systemctl start mysqld Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. [pi@raspi ~]$ systemctl status mysqld * mariadb.service - MariaDB 10.5.5 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Sun 2020-08-23 08:34:44 PDT; 9s ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Process: 466 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 467 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/S> Process: 479 ExecStart=/usr/bin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Main PID: 479 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Aug 23 08:34:44 raspi mariadbd: 2020-08-23 8:34:44 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.14. Aug 23 08:34:44 raspi mariadbd: 2020-08-23 8:34:44 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error Aug 23 08:34:44 raspi mariadbd: 2020-08-23 8:34:44 0 [Note] InnoDB: Starting shutdown... Aug 23 08:34:44 raspi mariadbd: 2020-08-23 8:34:44 0 [ERROR] Plugin 'InnoDB' init function returned error. Aug 23 08:34:44 raspi mariadbd: 2020-08-23 8:34:44 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Aug 23 08:34:44 raspi mariadbd: 2020-08-23 8:34:44 0 [ERROR] Unknown/unsupported storage engine: InnoDB Aug 23 08:34:44 raspi mariadbd: 2020-08-23 8:34:44 0 [ERROR] Aborting Aug 23 08:34:44 raspi systemd: mariadb.service: Main process exited, code=exited, status=1/FAILURE Aug 23 08:34:44 raspi systemd: mariadb.service: Failed with result 'exit-code'. Aug 23 08:34:44 raspi systemd: Failed to start MariaDB 10.5.5 database server. lines 1-21/21 (END) I don't see any information from syslog-ng in /var/log/messages.log either.... I'm not sure what's going on, can anybody help me out with this? :o As @tetech suggested, I should downgrade to a previous version of my mariadb package. So I tried: [pi@raspi pkg]$ sudo pacman -U /var/cache/pacman/pkg/mariadb-10.4.14-1-aarch64.pkg.tar.xz [sudo] password for pi: loading packages... warning: downgrading package mariadb (10.5.5-1 => 10.4.14-1) resolving dependencies... warning: cannot resolve "mariadb-clients=10.4.14", a dependency of "mariadb" :: The following package cannot be upgraded due to unresolvable dependencies: mariadb :: Do you want to skip the above package for this upgrade? [y/N] n error: failed to prepare transaction (could not satisfy dependencies) :: unable to satisfy dependency 'mariadb-clients=10.4.14' required by mariadb [pi@raspi pkg]$ sudo pacman -U /var/cache/pacman/pkg/mariadb-clients-10.4.14-1-aarch64.pkg.tar.xz loading packages... warning: downgrading package mariadb-clients (10.5.5-1 => 10.4.14-1) resolving dependencies... warning: cannot resolve "mariadb-libs=10.4.14", a dependency of "mariadb-clients" :: The following package cannot be upgraded due to unresolvable dependencies: mariadb-clients :: Do you want to skip the above package for this upgrade? [y/N] error: failed to prepare transaction (could not satisfy dependencies) :: unable to satisfy dependency 'mariadb-libs=10.4.14' required by mariadb-clients [pi@raspi pkg]$ sudo pacman -U /var/cache/pacman/pkg/mariadb-libs-10.4.14-1-aarch64.pkg.tar.xz loading packages... warning: downgrading package mariadb-libs (10.5.5-1 => 10.4.14-1) resolving dependencies... looking for conflicting packages... error: failed to prepare transaction (could not satisfy dependencies) :: installing mariadb-libs (10.4.14-1) breaks dependency 'mariadb-libs=10.5.5' required by mariadb-clients [pi@raspi pkg]$ sudo pacman -U /var/cache/pacman/pkg/mariadb-clients-10.4.14-1-aarch64.pkg.tar.xz loading packages... warning: downgrading package mariadb-clients (10.5.5-1 => 10.4.14-1) resolving dependencies... warning: cannot resolve "mariadb-libs=10.4.14", a dependency of "mariadb-clients" :: The following package cannot be upgraded due to unresolvable dependencies: mariadb-clients :: Do you want to skip the above package for this upgrade? [y/N] error: failed to prepare transaction (could not satisfy dependencies) :: unable to satisfy dependency 'mariadb-libs=10.4.14' required by mariadb-clients But it seems like mariadb-libs is complaining about mariadb-clients and vice-versa. How do I get thenm downgraded? I'm now thinking it might just be easier to re-init my db instead....
Asked by BitFreak (225 rep)
Aug 23, 2020, 03:38 PM
Last activity: Aug 26, 2020, 04:20 PM