Listing of clients in SUSE Manager Server webUI results in "Request has timeout, please reload the page"
This document (000020868) is provided subject to the disclaimer at the end of this document.
SUSE Manager 4.3 Server
If that does not help, try checking that `tomcat` is allowed to use enough memory. The parameter can be found in `/etc/sysconfig/tomcat`. Trying to increase the `-Xmx` parameter up to 8G may also help.
When none of above helps, another option is to perform a vacuum analyze of the database and re-index the tables that are likely to be impacted the most. Additional information provides details how to find out tables to re-index.
> date && time spacewalk-sql --select-mode - <<< "vacuum ANALYZE;" > date && time spacewalk-sql --select-mode - <<< "REINDEX table rhnPackage;" > date && time spacewalk-sql --select-mode - <<< "REINDEX table rhnServerNeededCache;"
It is also recommended to reduce number of items being listed within SUSE Manager Server webUI.
Add the following line to `/var/lib/pgsql/data/postgresql.conf`:
log_min_duration_statement = 10000
spacewalk-sql --select-mode - <<<"SELECT pg_reload_conf();"
After the problem is reproduced, collect the following information and add this to the support case:
- content of file '/var/lib/pgsql/data/postgresql.conf'
- 3 or 4 more recent files from folder `/var/lib/pgsql/data/log/*.log`
- or upload a new supportconfig
This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:000020868
- Creation Date: 21-Nov-2022
- Modified Date:13-Dec-2022
- SUSE Manager Server
- SUSE Manager
For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com