Bug 1554180
Summary: | [downstream clone 4.2.2] MacPool fails to initialize when it contains duplicates and user disallows duplicates | |||
---|---|---|---|---|
Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Germano Veit Michel <gveitmic> | |
Component: | ovirt-engine | Assignee: | eraviv | |
Status: | CLOSED ERRATA | QA Contact: | Michael Burman <mburman> | |
Severity: | high | Docs Contact: | ||
Priority: | high | |||
Version: | 4.1.9 | CC: | apinnick, danken, eraviv, gveitmic, lsurette, mburman, mkalinin, rbalakri, Rhev-m-bugs, srevivo, ykaul, ylavi | |
Target Milestone: | ovirt-4.2.2 | Keywords: | ZStream | |
Target Release: | --- | |||
Hardware: | x86_64 | |||
OS: | Linux | |||
Whiteboard: | ||||
Fixed In Version: | Doc Type: | If docs needed, set a value | ||
Doc Text: |
This update prevents the user from clearing the "Allow Duplicates" check box in the Edit MAC Address Pool dialog or via a corresponding REST request if duplicate MAC addresses exist.
|
Story Points: | --- | |
Clone Of: | ||||
: | 1561080 1561081 1561865 (view as bug list) | Environment: | ||
Last Closed: | 2018-05-15 17:48:31 UTC | Type: | Bug | |
Regression: | --- | Mount Type: | --- | |
Documentation: | --- | CRM: | ||
Verified Versions: | Category: | --- | ||
oVirt Team: | Network | RHEL 7.3 requirements from Atomic Host: | ||
Cloudforms Team: | --- | Target Upstream Version: | ||
Embargoed: | ||||
Bug Depends On: | ||||
Bug Blocks: | 1561080, 1561081, 1561865 |
Description
Germano Veit Michel
2018-03-12 01:48:09 UTC
Just to document here the way out of this: 1) reinitialize engine (thankfully allow duplicate macs is still enabled in the DB), so macpool will initialize fine if we restart the engine. 2) remove duplicate mac To find them: /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select vm_static.vm_name,mac_addr,creation_date from vm_interface,vm_static where vm_interface.vm_guid = vm_static.vm_guid and mac_addr in (select mac_addr from vm_interface group by mac_addr having (count(*) >1)) order by mac_addr;" 3) uncheck allow duplicates (In reply to Germano Veit Michel from comment #1) > Just to document here the way out of this: > > 1) reinitialize engine (thankfully allow duplicate macs is still enabled in > the DB), so macpool will initialize fine if we restart the engine. > > 2) remove duplicate mac > To find them: > /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select > vm_static.vm_name,mac_addr,creation_date from vm_interface,vm_static where > vm_interface.vm_guid = vm_static.vm_guid and mac_addr in (select mac_addr > from vm_interface group by mac_addr having (count(*) >1)) order by mac_addr;" Can you contribute this script? > > 3) uncheck allow duplicates (In reply to Yaniv Kaul from comment #3) > Can you contribute this script? This was already contributed in a much better form here as a tool to detect and fix duplicate macs: https://gerrit.ovirt.org/#/c/83415/ Looks like it may ship with 4.3 if it gets merged someday. Or do you have something else in mind where such logic would be useful? (In reply to Germano Veit Michel from comment #4) > This was already contributed in a much better form here as a tool to detect > and fix duplicate macs: https://gerrit.ovirt.org/#/c/83415/ > Looks like it may ship with 4.3 if it gets merged someday. We can merge and ship your script even earlier, but it needs to be Verfied+1, CI+1 (and make sure it is really shipped in ovirt-engine.rpm) Moving back to POST status since referenced patch https://gerrit.ovirt.org/#/c/89578/ has not been merged yet. Being 4.2.2 already released, please re-target to 4.2.3 or later http://gerrit.ovirt.org/89578 is not strictly required to make sure this bug does not reproduce. The 4.2.2-merged validation patch http://gerrit.ovirt.org/89513 is enough for that. This bug can, and should be, tested by QA now. Hi What about a fix for 4.1? it was originally reported for 4.1 BZ1561080 is for 4.1 Validation is added when trying to unset the 'Allow Duplicates' when MAC pool contains duplicate MACs. 'Error while executing action: Cannot edit MAC Pool. Cannot unset 'Allow Duplicates' when mac pool contains duplicate macs.' Bug can't reproduced. After removing the duplicate MAC and unsettling the 'Allow Duplicates' , engine behaves as expected. Verified on - 4.2.2.6-0.1.el7 Eitan, i would like to change the summary of this bug to it's correct fix, which is validation of duplicate MACs..what you think? Avital: a sibling bug BZ1561080 has passed doc text review by Byron Gravenorst. The doc text should be the same here. Michael: agreed, but then let's change its siblings (1561865 1561080) as well for consistency and searchability Thanks Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHEA-2018:1488 BZ<2>Jira Resync |