Bug 1576937
Summary: | Value too long for type character varying(50) for host_interface_configuration and vm_interface_configuration | ||
---|---|---|---|
Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Bimal Chollera <bcholler> |
Component: | ovirt-engine-dwh | Assignee: | Shirly Radco <sradco> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Lucie Leistnerova <lleistne> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | 4.1.11 | CC: | fgarciad, lsurette, lsvaty, pbrilla, rbalakri, Rhev-m-bugs, sradco, srevivo, ykaul, ylavi |
Target Milestone: | ovirt-4.2.4 | Keywords: | ZStream |
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | ovirt-engine-dwh-4.2.4 | Doc Type: | Bug Fix |
Doc Text: |
Cause:
Value of network_name length in engine db was updated to support up to 256 characters, but dwh was not updated and was still 50 characters.
Consequence:
Error in DWH
Fix:
Updated network_name length in dwh.
Result:
No errors about Value too long for type character varying(50) for host_interface_configuration and vm_interface_configuration
|
Story Points: | --- |
Clone Of: | Environment: | ||
Last Closed: | 2018-06-28 07:24:46 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | Metrics | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: | |||
Bug Depends On: | |||
Bug Blocks: | 1581854, 1631202 |
Description
Bimal Chollera
2018-05-10 19:14:44 UTC
Problem is also seen on 4.2 as well. Engine db has: v_network_name VARCHAR(256), dwh db has: network_name VARCHAR(50), Thanks Shirly, Tested the fix. - Bimal. After upgrade, problem still persist and error appears in dwh log from upgrade log: Running upgrade sql script '/usr/share/ovirt-engine-dwh/dbscripts/upgrade/04_02_0030_update_network_name_length.sql'... but no change done ovirt_engine_history=# \d host_interface_configuration ... logical_network_name | character varying(50) | ovirt_engine_history=# \d vm_interface_configuration ... logical_network_name | character varying(50) | tested in ovirt-engine-dwh-4.2.4-1.el7ev.noarch If you have upgraded or installed ovirt-engine-dwh 4.2.4 or master you will need to run the following commands directly on the ovirt_engine_history db to fix this bug. ALTER TABLE host_interface_configuration ALTER COLUMN logical_network_name TYPE varchar(256); ALTER TABLE vm_interface_configuration ALTER COLUMN logical_network_name TYPE varchar(256); QE please test upgrading from 4.2.3.z and below and not from 4.2.4 to build. Thank you. so according to last change in this bug, should be this re-target to 4.3? (In reply to Pavol Brilla from comment #13) > so according to last change in this bug, should be this re-target to 4.3? No. Sorry. It is already fixed in the ovirt-engine-dwh-4.2.4.1. The issue was in the ovirt-engine-dwh-4.2.4 build. After upgrade 4.1 -> 4.2.4 DWH works ok with long network name on host and VM. The same for upgrade 4.2.3 -> 4.2.4 verified in ovirt-engine-dwh-4.2.4.3-1.el7ev.noarch ovirt-engine-dbscripts-4.2.4.5-0.1.el7_3.noarch BZ<2>Jira Resync |