SymptomsWhen trying to browse resource alerts in PVA, you might encounter this application error:
The server has encountered an internal error or misconfiguration.
Contact your support representative.
CauseThe problem may occur when the InnoDB log is too large:
[root@pva ~]# ll -h /var/lib/mysql/
-rw-rw---- 1 mysql mysql 8.1G May 29 13:55 ibdata1
ResolutionRe-create VZAgentDB after removing binary log data:
NOTE: IF THERE ARE OTHER DATABASES ON THE SERVER, ALL OF THE DATA IN THESE DATABASES WILL BE LOST.
- Follow the instructions in KB 115268 to back up VZAgentDB up to point 2 in the "Restore" section.
Create a backup as per point 2:
tar -cvzf backup_mysql.tgz /var/lib/mysql
Remove InnoDB data:
- Proceed with database restoration from point 3.