Hi i try to upgrade MariaDB from 10.4 to 10.5 and I got:
I need to revert and compile 10.4 and revert /etc/systemd/system/mysqld.service to version before upgrade, reload systemd to run mysql server again.
Debian 10 on VPS.
Any suggestions?
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package rpcsvc-proto
########################################################################################################################################## 100.0%
Stopping mysqld ...
Service didn't get stopped, sleeping for 20 secs and re-trying ...
Stopping mysqld ...
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
Giving mysqld a few seconds to start up...
Giving mysqld a another few seconds to start up...
Giving mysqld last 20 seconds to start up...
Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/data/mysql.sock' (2)
FATAL ERROR: Upgrade failed
Error running '/usr/local/mysql/bin/mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --skip-version-check'
Restarting MySQL.
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
Installation completed.
root@server:/etc/systemd/system# systemctl status mysqld.service
● mysqld.service - MySQL database server
Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Tue 2022-08-16 17:28:25 CEST; 47s ago
Process: 27231 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=226/NAMESPACE)
Aug 16 17:28:25 server.webdragon.pl systemd[1]: Starting MySQL database server...
Aug 16 17:28:25 server.webdragon.pl systemd[27231]: mysqld.service: Failed to set up mount namespacing: No such file or directory
Aug 16 17:28:25 server.webdragon.pl systemd[27231]: mysqld.service: Failed at step NAMESPACE spawning /bin/sh: No such file or directory
Aug 16 17:28:25 server.webdragon.pl systemd[1]: mysqld.service: Control process exited, code=exited, status=226/NAMESPACE
Aug 16 17:28:25 server.webdragon.pl systemd[1]: mysqld.service: Failed with result 'exit-code'.
Aug 16 17:28:25 server.webdragon.pl systemd[1]: Failed to start MySQL database server.
I need to revert and compile 10.4 and revert /etc/systemd/system/mysqld.service to version before upgrade, reload systemd to run mysql server again.
Debian 10 on VPS.
Any suggestions?