Resolved Unable to make database dump

[Ihtshama]

When every i run backup manager in Plesk, it makes the backup, but have errors like below for almost every website, i am afraid, sites are not really backedup.

OS
CentOS Linux 7.8.2003 (Core)
Product
Plesk Obsidian

ERROR in logs.

Warning: Database "booster"
Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'booster'': Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100322, now running 100324. Please use mysql_upgrade to fix this error (1558)

 

[moswak]

Quote from the error message: "Please use mysql_upgrade to fix this error"

try

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

 

[Ihtshama]

worked like a charm. thank you moswak.