Can't run MariaDB upgrade to get rid of error  [SOLVED]

General discussions around KeyHelp.
Post Reply
lmarcos
Posts: 90
Joined: Sun 26. Jan 2020, 12:55

Can't run MariaDB upgrade to get rid of error

Post by lmarcos »

I can't seem to be able to run maria-upgrade command from the cli. I have tried with the Keyhelp user and with root (Access denied for user 'user'@'localhost'). Not beeing able to run things as root started happening when I upgraded the database and I had to rewrite the cron for the database user.

But yesterday night Mariadb closed with the following error:
mariadbd[12330]: 2026-11-04 18:17:13 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'provider_bzip2=>
mariadbd[12330]: 2026-11-04 18:17:13 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'provider_lz4=fo>
mariadbd[12330]: 2026-11-04 18:17:13 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'provider_lzma=f>
mariadbd[12330]: 2026-11-04 18:17:13 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'provider_lzo=fo>
mariadbd[12330]: 2026-11-04 18:17:13 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'provider_snappy>
I reinstalled the plugins and I now have the following error, which is the reason I need help.

Column count of mysql.proc is wrong. Expected 22, found 21. Created with MariaDB 101114, now running 120303. Please use mariadb-upgrade to fix this error

Keyhelp is 26.2 (Build 3756).
ps aux | grep mariadb returns a mysql and a root.
User avatar
Tobi
Community Moderator
Posts: 3770
Joined: Thu 5. Jan 2017, 13:24

Re: Can't run MariaDB upgrade to get rid of error

Post by Tobi »

https://mariadb.com/docs/server/referen ... 1599/e1558

MariaDB Login Data see „keyhelp-install-xxxx“ in root home directory.
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
otto58
Posts: 179
Joined: Thu 29. Jul 2021, 13:20

Re: Can't run MariaDB upgrade to get rid of error

Post by otto58 »

"keyhelp_login_data_xxxx" in root directory?
User avatar
Tobi
Community Moderator
Posts: 3770
Joined: Thu 5. Jan 2017, 13:24

Re: Can't run MariaDB upgrade to get rid of error

Post by Tobi »

otto58 wrote: ↑Thu 5. Nov 2026, 06:06 "keyhelp_login_data_xxxx" in root directory?
Yes
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
lmarcos
Posts: 90
Joined: Sun 26. Jan 2020, 12:55

Re: Can't run MariaDB upgrade to get rid of error  [SOLVED]

Post by lmarcos »

Thanks, the root listed did not work on the cli, but the one listed for web access did.
Post Reply