Bug 1561081
| Summary: | [downstream clone - 4.1.11] MacPool fails to initialize when it contains duplicates and user disallows duplicates | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | RHV bug bot <rhv-bugzilla-bot> |
| Component: | ovirt-engine | Assignee: | eraviv |
| Status: | CLOSED DUPLICATE | QA Contact: | Meni Yakove <myakove> |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 4.1.9 | CC: | danken, gveitmic, lsurette, mburman, ratamir, rbalakri, Rhev-m-bugs, srevivo, ykaul, ylavi |
| Target Milestone: | ovirt-4.1.11 | Keywords: | ZStream |
| Target Release: | --- | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | 1554180 | Environment: | |
| Last Closed: | 2018-03-27 15:14:59 UTC | Type: | --- |
| 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: | 1554180, 1561865 | ||
| Bug Blocks: | |||
|
Description
RHV bug bot
2018-03-27 15:07:59 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 (Originally by Germano Veit Michel) (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 (Originally by Yaniv Kaul) (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? (Originally by Germano Veit Michel) (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) (Originally by danken) oops, I've ran the clone job twice. *** This bug has been marked as a duplicate of bug 1561080 *** BZ<2>Jira Resync |