Sackgasse nach MariaDB Update [Ubuntu 18.04.6]

S

SentinelKnight

New Member
Guten Tag zusammen.

ich habe mich anscheinend in eine Update-Sackgasse navigiert und komme da alleine nicht mehr raus. Folgende Problemstellung:

Auf einem seit 1,5 Jahren gut laufenden Webtropia "Root Server M" läuft eine Keyhelp Installation, ein Webshop und eine NextCloud-Lösung.
Ein NextCloud-Update erforderte das Update der MariaDB v. 10.1 auf Minimum 10.3. - hier begannen die ersten Schwierigkeiten. Nach erfolgreichem Backup der Datenbank habe ich nach Anleitung (https://mariadb.com/docs/operations/upgrades/upgrade-community-server-cs10-3-ubuntu18/) die Datenbank deinstalliert und wollte dann MariaDB 10.3 aufspielen.

Hier flogen schon die ersten Fehlermeldungen raus:

E: The repository 'http://repo.myloc.de/ubuntu bionic InRelease' is not signed.
W: GPG error: http://repo.myloc.de/ubuntu bionic-updates InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
Click to expand...

Nach längerem Probieren, ich weiß nicht mehr genau wann und wieso, installierte sich tatsächlich MariaDB - allerdings auf die Version 10.6. - was eine Inkompatibiität mit Keyhelp und dem Mailserver auslöste. Ich deinstallierte daraufhin die Datenbank erneut. Nun kann ich aber gar keine Version mehr aufspielen, mit

sudo apt-get update

bekomme ich jede Menge Fehler zu den Pubkeys ausgeworfen:

Get:1 http://repo.myloc.de/ubuntu bionic InRelease [242 kB]
Get:2 http://repo.myloc.de/ubuntu bionic-updates InRelease [88.7 kB]
Get:3 http://repo.myloc.de/ubuntu-security bionic-security InRelease [88.7 kB]
Get:5 https://mirror.wtnet.de/mariadb/repo/10.6/ubuntu bionic InRelease [6,265 B]
Hit:6 https://downloads.mariadb.com/MariaDB/mariadb-10.3/repo/ubuntu bionic InRelease
Err:1 http://repo.myloc.de/ubuntu bionic InRelease
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
Hit:4 https://downloads.mariadb.com/Tools/ubuntu bionic InRelease
Ign:7 http://mirror.timeweb.ru/mariadb/repo/10.3/ubuntu bionic InRelease
Hit:8 https://downloads.mariadb.com/MaxScale/6.1.4/apt bionic InRelease
Err:2 http://repo.myloc.de/ubuntu bionic-updates InRelease
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
Err:10 http://mirror.timeweb.ru/mariadb/repo/10.3/ubuntu bionic Release
404 Not Found [IP: 92.53.116.114 80]
Get:9 http://archive.canonical.com/ubuntu bionic InRelease [10.2 kB]
Err:3 http://repo.myloc.de/ubuntu-security bionic-security InRelease
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
Err:9 http://archive.canonical.com/ubuntu bionic InRelease
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
Reading package lists... Done
W: GPG error: http://repo.myloc.de/ubuntu bionic InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
E: The repository 'http://repo.myloc.de/ubuntu bionic InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
W: GPG error: http://repo.myloc.de/ubuntu bionic-updates InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
E: The repository 'http://repo.myloc.de/ubuntu bionic-updates InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
E: The repository 'http://mirror.timeweb.ru/mariadb/repo/10.3/ubuntu bionic Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
W: GPG error: http://repo.myloc.de/ubuntu-security bionic-security InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
E: The repository 'http://repo.myloc.de/ubuntu-security bionic-security InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
W: GPG error: http://archive.canonical.com/ubuntu bionic InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 3B4FE6ACC0B21F32
E: The repository 'http://archive.canonical.com/ubuntu bionic InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
Click to expand...

Ich bin inzwischen so verwirrt, ich stehe total auf dem Schlauch. Ein

sudo apt install mariadb-server

führt zu:

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
mariadb-server : Depends: mariadb-server-10.3 (>= 1:10.3.31+maria~bionic) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
Click to expand...

Kann mir bitte geholfen werden?
Herzlichen Dank!
 
Hey,

du hast aktuell drei Probleme:

1. Abhänigkeitsprobleme -> Schau mal diesbezüglich den Befehl "apt install -f" an. Eventuell reicht das in diesem Fall schon. Wird allerdings erst funktionieren, wenn du Punkt 2. behoben hast.
2. Dir fehlen die public Keys zu dem/den Repos. Schau dir dazu mal den Befehl "apt-key add" an.
3. Ubuntu will, sofern du Punkt 1. & 2. erledigt hast, MariaDB 10.6 installieren. Die default Repos für Ubuntu 18.04 bringen eig. nur MariaDB 10.1 mit. Kann es sein dass du bei der Anleitung https://mariadb.com/docs/operations/upgrades/upgrade-community-server-cs10-3-ubuntu18/ den Punkt "./mariadb_repo_setup --mariadb-server-version="mariadb-10.3" ohne den Parameter ausgeführt hast?

Solltest du alleine nicht weiterkommen, kannst du mir auch gerne ein PN schicken.

Viele Grüße
Jonathan
 
Executing: /tmp/apt-key-gpghome.nfFKChzeHV/gpg.1.sh --recv-keys --keyserver keyserver.ubuntu.com 3B4FE6ACC0B21F32
gpg: key 3B4FE6ACC0B21F32: 21 signatures not checked due to missing keys
gpg: key 3B4FE6ACC0B21F32: "Ubuntu Archive Automatic Signing Key (2012) <ftpmaster@ubuntu.com>" 18 new signatures
gpg: failed to start agent '/usr/bin/gpg-agent': No such file or directory
gpg: can't connect to the agent: No such file or directory
gpg: Total number processed: 1
gpg: new signatures: 18
Click to expand...
 
Demmerle IT said:
Hey,

du hast aktuell drei Probleme:

1. Abhänigkeitsprobleme -> Schau mal diesbezüglich den Befehl "apt install -f" an. Eventuell reicht das in diesem Fall schon. Wird allerdings erst funktionieren, wenn du Punkt 2. behoben hast.
2. Dir fehlen die public Keys zu dem/den Repos. Schau dir dazu mal den Befehl "apt-key add" an.
3. Ubuntu will, sofern du Punkt 1. & 2. erledigt hast, MariaDB 10.6 installieren. Die default Repos für Ubuntu 18.04 bringen eig. nur MariaDB 10.1 mit. Kann es sein dass du bei der Anleitung https://mariadb.com/docs/operations/upgrades/upgrade-community-server-cs10-3-ubuntu18/ den Punkt "./mariadb_repo_setup --mariadb-server-version="mariadb-10.3" ohne den Parameter ausgeführt hast?

Solltest du alleine nicht weiterkommen, kannst du mir auch gerne ein PN schicken.

Viele Grüße
Jonathan
Click to expand...

Bei ""apt-key add"" sucht er nach einer Datei, die ich nicht habe. Ich bin davon ausgegangen, dass bei dem Befehl

apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 3B4FE6ACC0B21F32 40976EAF437D05B5

(das waren die Keys, die immer wieder gefordert wurden) alle Einträge in den Repos vorgenommen werden. Nirgends, und ich habe einige Anleitungen dazu gelesen, war ein Hinweis auf eine andere Vorgehensweise zu sehen.

Bez. P3 - Ja, Parameter ist mit angegeben worden.
 
Ich bin jetzt einen Schritt weiter.

sudo apt install mariadb-server mariadb-backup

führte nun zu einer Installation, ich habe dann versucht das Backup der DB einzuspielen. Die Datenbank schmeisst das hier raus:

Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@keyhelp:~# sudo systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.31 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Fri 2021-10-29 17:56:18 CEST; 28s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 2345 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 2109 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $
Process: 2107 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2106 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 2345 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [Note] InnoDB: Starting shutdown...
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Aborting
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: mariadb.service: Failed with result 'exit-code'.
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: Failed to start MariaDB 10.3.31 database server.
root@keyhelp:~# ^C
root@keyhelp:~# journalctl -xe
Oct 29 17:56:16 keyhelp.myci-cloud.de postfix/master[1879]: warning: process /usr/lib/postfix/sbin/smtpd pid 2099 exit status 1
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] /usr/sbin/mysqld (mysqld 10.3.31-MariaDB-1:10.3.31+maria~bionic-log) starting as
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 13130
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Using Linux native AIO
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Uses event mutexes
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Number of pools: 1
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size =
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with Backup 10.6.4
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [Note] InnoDB: Starting shutdown...
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Aborting
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: mariadb.service: Failed with result 'exit-code'.
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: Failed to start MariaDB 10.3.31 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.
--
-- The result is RESULT.
Oct 29 17:56:18 keyhelp.myci-cloud.de sudo[2103]: pam_unix(sudo:session): session closed for user root
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/smtpd[2097]: connect from e7e79d9d.centralus.cloudapp.azure.com[13.89.238.203]
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionar
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_alias_domains: mysql:/etc/postfix/mysql-virtual-alias-maps.cf: table lookup
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf is unavailable. unsupported dict
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_mailbox_domains: mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf: table
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionar
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_alias_domains: mysql:/etc/postfix/mysql-virtual-alias-maps.cf: table lookup
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_alias_domains lookup failure
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/smtpd[2097]: NOQUEUE: reject: RCPT from e7e79d9d.centralus.cloudapp.azure.com[13.89.238.203]: 451 4.3.0 <info@sangit
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/smtpd[2097]: disconnect from e7e79d9d.centralus.cloudapp.azure.com[13.89.238.203] ehlo=1 mail=1 rcpt=0/1 data=0/1 qu
Oct 29 17:56:37 keyhelp.myci-cloud.de dovecot[908]: auth: Fatal: Unknown database driver 'mysql'
Oct 29 17:56:37 keyhelp.myci-cloud.de dovecot[572]: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 29 17:56:47 keyhelp.myci-cloud.de sudo[2360]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mariadb.service
Oct 29 17:56:47 keyhelp.myci-cloud.de sudo[2360]: pam_unix(sudo:session): session opened for user root by root(uid=0)
Oct 29 17:57:01 keyhelp.myci-cloud.de CRON[2363]: pam_unix(cron:session): session opened for user root by (uid=0)
Oct 29 17:57:01 keyhelp.myci-cloud.de CRON[2364]: (root) CMD (nice -n 5 php /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php)
Oct 29 17:57:01 keyhelp.myci-cloud.de CRON[2363]: pam_unix(cron:session): session closed for user root
Oct 29 17:57:01 keyhelp.myci-cloud.de sudo[2360]: pam_unix(sudo:session): session closed for user root
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/pickup[1880]: D2D1436C0D77: uid=5001 from=<admin@myci-cloud.de>
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: D2D1436C0D77: message-id=<B4RsQiqewzEM6kCExh7tmR4j2z4vJVVuRZbAsAWQ@www.myci.biz>
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionary type:
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf lookup error for "r.schellhammer@myci.biz"
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: warning: D2D1436C0D77: virtual_alias_maps map lookup problem for r.schellhammer@myci.biz -- message n
lines 1989-2042/2042 (END)
Oct 29 17:56:16 keyhelp.myci-cloud.de postfix/master[1879]: warning: process /usr/lib/postfix/sbin/smtpd pid 2099 exit status 1
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] /usr/sbin/mysqld (mysqld 10.3.31-MariaDB-1:10.3.31+maria~bionic-log) starting as process 2345 ...
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 131307)
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Using Linux native AIO
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Uses event mutexes
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Number of pools: 1
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: Completed initialization of buffer pool
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with Backup 10.6.4-MariaDB.
Oct 29 17:56:17 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:17 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [Note] InnoDB: Starting shutdown...
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Plugin 'InnoDB' init function returned error.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 29 17:56:18 keyhelp.myci-cloud.de mysqld[2345]: 2021-10-29 17:56:18 0 [ERROR] Aborting
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: mariadb.service: Failed with result 'exit-code'.
Oct 29 17:56:18 keyhelp.myci-cloud.de systemd[1]: Failed to start MariaDB 10.3.31 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.
--
-- The result is RESULT.
Oct 29 17:56:18 keyhelp.myci-cloud.de sudo[2103]: pam_unix(sudo:session): session closed for user root
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/smtpd[2097]: connect from e7e79d9d.centralus.cloudapp.azure.com[13.89.238.203]
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionary type: mysql
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_alias_domains: mysql:/etc/postfix/mysql-virtual-alias-maps.cf: table lookup problem
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf is unavailable. unsupported dictionary type: mysql
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_mailbox_domains: mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf: table lookup problem
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionary type: mysql
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_alias_domains: mysql:/etc/postfix/mysql-virtual-alias-maps.cf: table lookup problem
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/trivial-rewrite[1886]: warning: virtual_alias_domains lookup failure
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/smtpd[2097]: NOQUEUE: reject: RCPT from e7e79d9d.centralus.cloudapp.azure.com[13.89.238.203]: 451 4.3.0 <info@sangit-bazar.de>: Temporary lookup failure; from=<> to=<info
Oct 29 17:56:37 keyhelp.myci-cloud.de postfix/smtpd[2097]: disconnect from e7e79d9d.centralus.cloudapp.azure.com[13.89.238.203] ehlo=1 mail=1 rcpt=0/1 data=0/1 quit=1 commands=3/5
Oct 29 17:56:37 keyhelp.myci-cloud.de dovecot[908]: auth: Fatal: Unknown database driver 'mysql'
Oct 29 17:56:37 keyhelp.myci-cloud.de dovecot[572]: master: Error: service(auth): command startup failed, throttling for 60 secs
Oct 29 17:56:47 keyhelp.myci-cloud.de sudo[2360]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mariadb.service
Oct 29 17:56:47 keyhelp.myci-cloud.de sudo[2360]: pam_unix(sudo:session): session opened for user root by root(uid=0)
Oct 29 17:57:01 keyhelp.myci-cloud.de CRON[2363]: pam_unix(cron:session): session opened for user root by (uid=0)
Oct 29 17:57:01 keyhelp.myci-cloud.de CRON[2364]: (root) CMD (nice -n 5 php /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php)
Oct 29 17:57:01 keyhelp.myci-cloud.de CRON[2363]: pam_unix(cron:session): session closed for user root
Oct 29 17:57:01 keyhelp.myci-cloud.de sudo[2360]: pam_unix(sudo:session): session closed for user root
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/pickup[1880]: D2D1436C0D77: uid=5001 from=<xxxxxxx>
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: D2D1436C0D77: message-id=<xxxxxxx>
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionary type: mysql
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: warning: mysql:/etc/postfix/mysql-virtual-alias-maps.cf lookup error for "xxxxxxx"
Oct 29 17:57:05 keyhelp.myci-cloud.de postfix/cleanup[1885]: warning: D2D1436C0D77: virtual_alias_maps map lookup problem for xxxxxxx -- message not accepted, try again later
Click to expand...
 
So wie sich der Fehler auf den ersten Blick liest
Bash: 
[ERROR] InnoDB: Unsupported redo log format. The redo log was created with Backup 10.6.4-MariaDB.
sieht es so aus als wäre das Backup mit einer neueren Version erstellt worden.

Hast du auch einen ganz normalen Dump der Datenbanken?
Also per mysqldump erstellt?
 
Demmerle IT said:
So wie sich der Fehler auf den ersten Blick liest
Bash: 
[ERROR] InnoDB: Unsupported redo log format. The redo log was created with Backup 10.6.4-MariaDB.
sieht es so aus als wäre das Backup mit einer neueren Version erstellt worden.

Hast du auch einen ganz normalen Dump der Datenbanken?
Also per mysqldump erstellt?
Click to expand...
Ja, stimmt - das war mein Fehler. Ich habe gerade alles auf null gesetzt, deinstalliert, neu installiert auf MariaDB 10.3.31 - das hat jetzt geklappt. Dann habe ich das Backup eingespielt, dass ich noch aus 10.1 hatte, das ist ohne Fehler durchgelaufen. Die Datenbank sollte jetzt "gefüllt" sein. Allerdings startet der Task nicht.

root@keyhelp:~# sudo systemctl restart mariadb.service
Failed to restart mariadb.service: Unit mariadb.service is masked.
Click to expand...

Mein Hirn brennt, ich sitze hier seit 2 Uhr Morgens. Klinke mich mal für 2h raus, danach gehts weiter. Ich bin sehr dankbar für Eure Hilfe, ich bin schon viel weiter als noch vor 3 Stunden!
 
sudo mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Den Pfad gibts bei mir nicht :confused:
 
Mühsam ernährt sich das Eichhörnchen.

Nach aufmerksamen lesen Eurer Beiträge, dem recherchieren und ein paar mal wild auf der Tastatur rumhauen sind die Webseiten wieder da. Puh.
Einzig die Mails verweigern ihren Dienst und lassen die Benutzer nicht auf die Konten zugreifen.
 
SentinelKnight said:
"Root Server M" läuft eine Keyhelp Installation
Click to expand...
Wenn ich mich recht erinnere, möchte Keyhelp eine Standartinstalltion haben, bzw alle Standardpakete die zu der Systemversion gehören. Wenn du da also einfach mal den DB-Server austauscht, solltest du schon wissen was du da machst.
 
You must log in or register to reply here.
Back
Top