[
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)
