Bug 2097232
| Summary: | Null values in column 'default_value' of 'vdc_options' prevents upgrade of HE from 4.3 to 4.4 SP1 | ||
|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Petr Kubica <pkubica> |
| Component: | General | Assignee: | bugs <bugs> |
| Status: | CLOSED DUPLICATE | QA Contact: | Guilherme Santos <gdeolive> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.5.0.8 | CC: | bugs, mperina |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2022-06-16 08:11:22 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Fixed in 4.5.1 *** This bug has been marked as a duplicate of bug 2077387 *** |
Description of problem: psql:/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql:22: NOTICE: column "default_value" of relation "vdc_options" already exists, skipping psql:/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql:1454: ERROR: column "default_value" contains null values CONTEXT: SQL statement "ALTER TABLE vdc_options ALTER COLUMN default_value SET NOT NULL" PL/pgSQL function fn_db_change_column_null(character varying,character varying,boolean) line 10 at EXECUTE FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql 2022-06-15 11:28:37,389+0300 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:530 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql 2022-06-15 11:28:37,390+0300 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 532, in _misc raise RuntimeError(_('Engine schema refresh failed')) RuntimeError: Engine schema refresh failed 2022-06-15 11:28:37,394+0300 ERROR otopi.context context._executeMethod:154 Failed to execute stage 'Misc configuration': Engine schema refresh failed engine=# select * from vdc_options where default_value is null engine-# ; option_id | option_name | option_value | version | default_value -----------+----------------------------------------+----------------------------------------------------------------+---------+--------------- 1 | AuthenticationMethod | LDAP | general | 7 | LDAPServerPort | 389 | general | 8 | LDAPQueryTimeout | 30 | general | 10 | LdapQueryPageSize | 1000 | general | 11 | MaxLDAPQueryPartsNumber | 100 | general | 73 | CARhevmKey | /etc/pki/rhevm/private/ca.pem | general | 1246 | SupportBridgesReportByVDSM | true | 3.1 | 104 | VMMinMemorySizeInMB | 256 | general | 112 | MaxDiskSize | 16384 | general | 1258 | GlusterTunedProfile | rhs-high-throughput,rhs-virtualization | 3.0 | 1259 | GlusterTunedProfile | rhs-high-throughput,rhs-virtualization | 3.1 | 1260 | GlusterTunedProfile | rhs-high-throughput,rhs-virtualization | 3.2 | 1261 | GlusterTunedProfile | rhs-high-throughput,rhs-virtualization | 3.3 | 1262 | GlusterTunedProfile | rhs-high-throughput,rhs-virtualization | 3.4 | 1263 | GlusterTunedProfile | rhs-high-throughput,rhs-virtualization | 3.5 | 149 | BootstrapInstallerFileName | /usr/share/rhevm/scripts/vds_installer.py | general | 253 | RedirectServletReportsPage | /ovirt-engine-reports | general | 217 | RHEVMEARLib | /var/lib/jbossas/server/rhevm-slimmed/deploy/rhevm.ear | general | 294 | VmPoolVmNameZeroPad | true | general | 338 | LDAPConnectTimeout | 30 | general | 339 | LDAPOperationTimeout | 30 | general | 591 | UserSessionTimeOutInvalidationInterval | 30 | general | 255 | LdapServers | | general | 340 | LDAPProviderTypes | | general | 478 | WebAdminUpperRightButtonURL | http://marketplace.redhat.com/rhev?origin=rhevm-$EngineVersion | general | 1329 | GlusterTunedProfile | virtual-host,rhgs-sequential-io,rhgs-random-io | 4.1 | 707 | EnableVdsHaReservation | true | general | 4 | AdUserName | | general | 5 | AdUserPassword | | general | 142 | AdUserId | | general | 2 | LDAPSecurityAuthentication | | general | 3 | DomainName | | general | 1554 | GlusterTunedProfile | virtual-host,rhgs-sequential-io,rhgs-random-io | 4.2 | 1133 | AdminDomain | internal | general | 1135 | AllowDuplicateMacAddresses | false | general | 1136 | DefaultWorkgroup | WORKGROUP | general | 1137 | KeystoneAuthUrl | | general | 1144 | LicenseCertificateFingerPrint | AA BB AA BB AA BB AA BB AA BB AA BB AA BB AA BB AA BB AA BB | general | 1145 | MacPoolRanges | 00:11:22:33:44:55-00:11:22:33:44:66 | general | 1146 | MaxMacsCountInPool | 100000 | general | 1154 | VdsFenceOptions | | general | (41 rows) RHV environment upgraded from 3.x through many years currently upgrading from 4.3 to 4.4 SP1 Version-Release number of selected component (if applicable): ovirt-engine-4.3.11.4-0.1.el7.noarch to rhvm-appliance-4.5-20220603.1.el8ev.x86_64 How reproducible: - Steps to Reproduce: 1. 2. 3. Actual results: Crashing upgrade to 4.4 SP1