Diagnostics
Submitted by tanderson on Wed, 17/04/2019 - 10:28
The Diagnostics window supports viewing:
- memory use
- application caches
- system properties
- threads
- MySQL processes
- MySQL InnoDB status
- plugins
- logs
This can aid quick diagnosis of problems where access to the server or database is limited.
The buttons are:
|
Refresh the current view. |
|
Emails a snapshot of the system information. |
|
Available on the Logs tab. Re-reads the log4j.properties file in <TOMCAT-HOME>\webapps\openvpms\WEB-INF\classes and then apply the changes without having to restart Tomcat. See also Troubleshooting. |
MySQL - InnoDB
This tab displays the result of the SQL statement:
SHOW ENGINE INNODB STATUS
If the message:
Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
is displayed, it means that the MySQL user doesn't have permissions to execute the command.
This can be granted using the following SQL statement:
GRANT SELECT, PROCESS ON *.* TO 'openvpms'@'localhost';
Replace 'openvpms' and 'localhost' the actual database user name and host if they have been changed from their default values.
NOTE: this may not take effect until Tomcat has been restarted.