Hide Forgot
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:
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