syncMedia causing Integrity constraint violation: 1062 Duplicate entry

[dbateson]

Im using syncMedia to replace a media attachment, however sometimes its causing a Integrity constraint violation: 1062 Duplicate entry error.

Code I'm using is:

if ($request->has('main_image')) { $product->syncMedia($request->input('main_image')['original']['id'], 'main_image'); }

[frasmage]

syncMedia performs two steps:

1. detaches all media for a given tag(s)
2. attaches the provided media identifier to the given tag(s)

My first guess would be that if you have multiple simultaneous requests modifying the same media and/or tags, you could potentially get a race condition where request A detaches the media, then request B attaches the media, then request A attempts to attach the media to the same tag. The most common approach to address this kind of problem is to wrap any such requests in a database transaction, which will hold write locks to any rows modified until the transaction is committed, preventing other requests from attempting to modify the same rows.

[dbateson]

Thanks for the reply.

There definitely is not multiple requests being made to modify the record. There is only one admin.

[sgtcoder]

I have the same issue even with just uploadFile. I thought this would be fixed by now, been having this issue for years.

onDuplicateIncrement