spacewalk-schema-upgrade fails with "relation "suseimageinfopackage" does not exist"
This document (7022839) is provided subject to the disclaimer at the end of this document.
[...]While looking at /var/log/spacewalk/schema-upgrade/schema-from-20180410-174141-to-susemanager-schema-3.0.25.log the following error is found:
Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/schema-from-20180410-174141-to-susemanager-schema-3.0.25.log].
(1/7) apply upgrade [susemanager-schema-3.0.22-to-susemanager-schema-3.0.23/001-may_take_long-fix-rhn_pe_v_r_e_uq.sql.postgresql]
Upgrade failed, please see log [/var/log/spacewalk/schema-upgrade/schema-from-20180410-174141-to-susemanager-schema-3.0.25.log].
psql:<stdin>:88: ERROR: relation "suseimageinfopackage" does not exist
LINE 1: update suseImageInfoPackage set evr_id = original.id where e...
QUERY: update suseImageInfoPackage set evr_id = original.id where evr_id = duplicate.id
CONTEXT: PL/pgSQL function fix_rhn_pe_v_r_e_uq() line 70 at SQL statement
- Remove update of not existing table (bsc#1087131)
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:7022839
- Creation Date: 11-Apr-2018
- Modified Date:03-Mar-2020
- SUSE Manager
For questions or concerns with the SUSE Knowledgebase please contact: firstname.lastname@example.org