Resolved Database backup error and doesn't work

[zepelin57]

Server operating system version

AlmaLinux 8.8

Plesk version and microupdate number

18.0.56

Hi all,
Backups no longer work correctly since the MariaDB 10.6 upgrade:

WARNING:(Database object 'xxxxxx_') Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: mysqldump: Couldn& execute SHOW FUNCTION STATUS WHERE Db = xxxxx;: Cannot load from mysql.proc. The table is probably corrupted (1728)
WARNING:(Database object 'xxxxxx_') Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: mysqldump: Couldn& execute SHOW FUNCTION STATUS WHERE Db = xxxxxx_;: Cannot load from mysql.proc. The table is probably corrupted (1728)

Do you have a solution to resolve the problem?
Thanks for your help.

 

[Dave W]

Repair the table mysql.proc

 

[zepelin57]

Repair the table mysql.proc

Hi,
Thanks for your help, but : -bash: repair: command not found

 

[Peter Debik]

"repair" is not a shell command, but an SQL command. You first need to open a database shell (e.g. plesk db) then you can run
> repair table mysql.proc;

 

[zepelin57]

Ok Peter, So I did what you asked in SQL, but I still got the error in the daily report last night.

 

[Peter Debik]

What was the output of the repair command?

 

[zepelin57]

mysql.proc repair status OK for all db.
If I do Check and Repair under Plesk everything is OK for all domains, strange!

 

[Peter Debik]

Have you considered running
> SHOW FUNCTION STATUS WHERE Db = xxxxx;
from PhpMyAdmin to test what it yields?

 

[zepelin57]

The problem was resolved :

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

Thank you so much!