Solved Problem in upgrade mariadb

[Banisaeed]

hello everyone

I want to upgrade mariadb 10.5 to 10.6 from custombuild2, but I get the following error, what is the problem?

Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
Restarting MySQL.
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Installation completed.

Of course, there is also this problem when updating via ssh!

os: centos stream 8

 

[Richard G]

See "systemctl status mariadb.service" and "journalctl -xe" for details.

And what is the output of these commands?

 

[Banisaeed]

And what is the output of these commands?

systemctl status mariadb.service :

  Loaded: loaded (/etc/systemd/system/mariadb.service; enabled; vendor preset:>
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Mon 2021-08-23 03:36:06 +0430; 19s >
  Process: 288480 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $>
  Process: 288410 ExecStartPre=/bin/sh -c [ -x /usr/bin/galera_recovery ] || ex>
  Process: 288408 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_ST>
 Main PID: 288480 (code=exited, status=127)

Aug 23 03:36:06 server.site.com systemd[1]: Starting MariaDB database serv>
Aug 23 03:36:06 server.site.com systemd[1]: mariadb.service: Main process >
Aug 23 03:36:06 server.site.com systemd[1]: mariadb.service: Failed with r>
Aug 23 03:36:06 server.site.com systemd[1]: Failed to start MariaDB databa>

journalctl -xe :

-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- The unit mariadb.service has entered the 'failed' state with result 'exit-co>
Aug 23 03:37:06 server.site.com systemd[1]: Failed to start MariaDB databa>
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 23 03:37:14 server.site.com kernel: Firewalled packet:IN=eth0 OUT= MAC>
Aug 23 03:37:15 server.site.com named[69783]: client @0x7f2ef40bfb30 87.24>
Aug 23 03:37:19 server.site.com kernel: Firewalled packet:IN=eth0 OUT= MAC>
Aug 23 03:37:22 server.site.com named[69783]: client @0x7f2ef40bfb30 87.24>
Aug 23 03:37:26 server.site.com kernel: Firewalled packet:IN=eth0 OUT= MAC>
Aug 23 03:37:33 server.site.com named[69783]: client @0x7f2ef40bfb30 195.9>
Aug 23 03:37:33 server.site.com pure-ftpd[288664]: ([email protected]) [IN>
Aug 23 03:37:33 server.site.com pure-ftpd[288664]: ([email protected]) [IN>
Aug 23 03:37:34 server.site.com named[69783]: client @0x7f2ef40bfb30 195.9>
Aug 23 03:37:34 server.site.com named[69783]: client @0x7f2ef40bfb30 195.9>
Aug 23 03:37:35 server.site.com named[69783]: client @0x7f2ef40bfb30 195.9>