[jira] [Commented] (VCL-921) changing owner of an image can cause a duplicate key error on resourcegroupmembers

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/VCL-921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15036576#comment-15036576 ] 

ASF subversion and git services commented on VCL-921:
-----------------------------------------------------

Commit 1717680 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1717680 ]

VCL-921 - changing owner of an image can cause a duplicate key error on resourcegroupmembers

image.php - modified addImagePermissions: changed query that inserts into resourcegroupmembers to be "INSERT IGNORE" instead of just "INSERT"

> changing owner of an image can cause a duplicate key error on resourcegroupmembers
> ----------------------------------------------------------------------------------
>
>                 Key: VCL-921
>                 URL: https://issues.apache.org/jira/browse/VCL-921
>             Project: VCL
>          Issue Type: Bug
>          Components: web gui (frontend)
>            Reporter: Josh Thompson
>             Fix For: 2.5
>
>
> When changing the owner of an image, permissions are automatically set up so that the new owner will be able to make a reservation for the image in case it has not yet been assigned to any additional image groups. As part of this, a query that inserts a record into the resourcegroupmembers table can cause a duplicate primary key error if the permissions have already been set up for the new owner. Changing "INSERT" to "INSERT IGNORE" will fix the problem.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)