| Summary: | [rhevm-reports] - ETL copies the templates images as disks | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | David Botzer <dbotzer> | ||||
| Component: | ovirt-engine-dwh | Assignee: | Yaniv Lavi <ylavi> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | David Botzer <dbotzer> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | low | ||||||
| Version: | 3.0.0 | CC: | acathrow, dyasny, ecohen, iheim, pstehlik, Rhev-m-bugs, yeylon, ykaul | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | infra | ||||||
| Fixed In Version: | SI15 - rhevm-dwh-3.1.0-9.el6ev.noarch.rpm | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2012-12-04 19:58:39 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Attachments: |
|
||||||
I checked and this is indeed the case. This is a Z stream candidate to my opinion. Yaniv Seems that issue starts at the RHEVM DB, in the rhevm DB the vm_interface_configuration & vm_disk_confiuguration info is kept for both VMs & Templates Thus the ETL copies the wrong data into history DB, a non-relevant info (the templates as NICs & Disks) The issue is that the information of both VMs & Templates is kept together at the same tables, under rhevm DB This was fixed upstream in patch: http://gerrit.ovirt.org/1234 Yaniv 3.1/si13.2 I have 1Host & 1 VM (and 1 template) I see two pairs of VM disks in v3_1_vm_disk_configuration_view Please advise, Fail QA this and I'll take a look. Yaniv Not Fixed 3.1/si14 should remove template disks from v3_1_vm_disk_configuration_view *** Bug 848045 has been marked as a duplicate of this bug. *** Not Fixed 3.1/si15 should remove template disks from v3_1_latest_vm_disk_configuration_view Not Fixed 3.1/si15 Fixed 3.1/si15 remove template disks from v3_1_latest_vm_disk_configuration_view Fixed 3.1/si15 |
Created attachment 555451 [details] ETL-History_Tables Description of problem: in a setup where the vm has only 1 disk I see in the configuration history & vm_disk..._history tables more than 1 disk. These disks belong to the template images - the disks are extracted by image id Version-Release number of selected component (if applicable): IC154, reports3.0.2-2 How reproducible: Always Steps to Reproduce: 1.Create setup with 1Host 1VM - 1Disk 1NIC 2.Run the ETL for a day 3.check the rhevm_history tables for vm_disk... Actual results: The following tables on rhevm_history are keeping info on template images as disks vm_disk_configuration, vm_disk_daily_history, vm_disk_hourly_history, vm_disk_samples_history Expected results: should have record for the 1 disk of the vm Additional info: