Resolved Backup failed: pmm utility 'PMMCli' raised an exception. Error code is: -9

[DLM]

Hello,

all backups under Plesk Onxy failed. Error: pmm utility 'PMMCli' raised an exception. Error code is: -9

Thanks for you help!

Daniel

 

[Sergey Prohorov]

Hello, Daniel.
Could you please provide more details about the error from '/var/log/plesk/PMM/pmmcli.log'

 

[DLM]

Hello Sergey,

here is the file. Thanks!

 

[Sergey Prohorov]

Could you try to run following command:

/usr/bin/perl /opt/psa/admin/bin/plesk_agent_manager server --get-size --incremental --session-path=/opt/psa/PMM/sessions/2016-11-01-092159.326 < /dev/null

 

[DLM]

DBD::mysql::st execute failed: Table 'performance_schema.session_variables' doesn't exist at /opt/psa/PMM/agents/shared/Db/MysqlDbiBackend.pm line 69.

 

[Sergey Prohorov]

It looks like broken MySQL installation. Could you please run following command and then re-run backup:

mysql_upgrade --user=admin --password=`cat /etc/psa/.psa.shadow` --force --verbose

 

[DLM]

Hey Sergey,

this helps a little bit! Thanks! The backup was created, but I received the message that there are some problems. For more information see the file attached.

 

[Sergey Prohorov]

Have you tried to restart mysql after mysql_upgrade? It is required in this case.

It seems Plesk db has some broken references. Could you please run following commands (after restart mysql):

plesk db "UPDATE domains SET displayName = name WHERE displayName IS NULL OR displayName = '';"

plesk bin repair --db

The first fixes inconsistency between name and displayName in psa.domains tablse. The second one checks Plesk DB for a lot of other inconsistencies and tries to fix them in interactive mode.

 

[DLM]

Thanks a lot! This fixes the problems!