Bug 1178976 - SCVMM error when saving a vm or template [ActiveRecord::RecordNotUnique]
Summary: SCVMM error when saving a vm or template [ActiveRecord::RecordNotUnique]
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Insight
Version: 5.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: GA
: 5.3.3
Assignee: Bronagh Sorota
QA Contact: Milan Falešník
URL:
Whiteboard:
Depends On: 1173251
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-01-05 19:43 UTC by Bronagh Sorota
Modified: 2015-03-23 16:21 UTC (History)
7 users (show)

Fixed In Version: 5.3.3
Doc Type: Bug Fix
Doc Text:
Clone Of: 1173251
Environment:
Last Closed: 2015-02-25 16:11:59 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2015:0261 0 normal SHIPPED_LIVE cfme (5.3.3) bug fix and enhancement update 2015-02-25 21:09:28 UTC

Comment 2 CFME Bot 2015-01-05 20:36:21 UTC
New commit detected on cfme/5.3.z:
https://code.engineering.redhat.com/gerrit/gitweb?p=cfme.git;a=commitdiff;h=6f003c280dd4a78e31b807d19054116fb16eea93

commit 6f003c280dd4a78e31b807d19054116fb16eea93
Author:     Bronagh Sorota <bsorota>
AuthorDate: Mon Dec 15 14:09:03 2014 -0500
Commit:     Bronagh Sorota <bsorota>
CommitDate: Mon Jan 5 15:30:30 2015 -0500

    SCVMM - DB error VM with multiple VHDs on volume
    
    Make sure the VM's storages hash does not contain duplicates.
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1178976

 vmdb/app/models/ems_refresh/parsers/scvmm.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

Comment 4 Milan Falešník 2015-02-23 17:23:23 UTC
Verified in 5.3.3.2.20150217120931_a465215 against 5.3.1.10.20141112120709_c36c424


5.3.1.10:
# cat /var/www/miq/vmdb/log/evm.log | grep PGError
[----] E, [2015-02-23T17:15:21.888271 #8251:b5480c] ERROR -- : MIQ(abstract_adapter) Name: [], Message: [PGError: ERROR:  duplicate key value violates unique constraint "index_storages_vms_on_vm_id_and_storage_id"
[----] E, [2015-02-23T17:15:21.961054 #8251:b5480c] ERROR -- : MIQ(abstract_adapter) Name: [], Message: [PGError: ERROR:  duplicate key value violates unique constraint "index_storages_vms_on_vm_id_and_storage_id"
[----] E, [2015-02-23T17:17:31.758830 #8251:b5480c] ERROR -- : MIQ(abstract_adapter) Name: [], Message: [PGError: ERROR:  duplicate key value violates unique constraint "index_storages_vms_on_vm_id_and_storage_id"
[----] E, [2015-02-23T17:17:31.818846 #8251:b5480c] ERROR -- : MIQ(abstract_adapter) Name: [], Message: [PGError: ERROR:  duplicate key value violates unique constraint "index_storages_vms_on_vm_id_and_storage_id"

5.3.3.2:
[root@dhcp-8-59-97 ~]# cat /var/www/miq/vmdb/log/evm.log | grep PGError
nothing

I have added the SCVMM system into CFME and then added a VM with 2 disks inside the SCVMM itself and watched logs and UI. 5.3.1.10 did not add the VM and logged the ERRORs. 5.3.3.2 worked without problems.

Comment 6 errata-xmlrpc 2015-02-25 16:11:59 UTC
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://rhn.redhat.com/errata/RHBA-2015-0261.html


Note You need to log in before you can comment on or make changes to this bug.