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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.5
• Component/s: web gui (frontend)
• Assignee: Unassigned
• Reporter: Josh Thompson
• Created: 02/Dec/15 20:38
• Updated: 02/Dec/15 20:48
• Resolved: 02/Dec/15 20:48

Description

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.