SUSE Manager database migration takes too long during the upgrade from 4.X to 4.2
This document (000020290) is provided subject to the disclaimer at the end of this document.
The last step consists in running a script in order to migrate the underlying database from postgresql 10.X (SUSE Manager 4.0) or 12.X (SUSE Manager 4.1) to 13.X. The problem that can be observed (however, not necessarily), is that the process simply takes too long, and no progress is displayed in the screen. This can lead to customers worrying about some problem going on. Anyway, there is a message in the screen warning about this, in addition to the release notes. Quoting these release notes:
"Please note the database migration from PostgreSQL 10 (if migrating from SUSE Manager 4.0) or PostgreSQL 12 (if migrating from SUSE Manager 4.1) will rebuild the database indices. This may take several hours if you have thousands of software channels."
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:000020290
- Creation Date: 17-Jun-2021
- Modified Date:18-Jun-2021
- SUSE Manager Server
For questions or concerns with the SUSE Knowledgebase please contact: firstname.lastname@example.org