Duplicate entry errors in derivative generation

Description

Example error here shows that storage path is redundant.

Duplicate entry '/d6029f61-a985-4274-b853a2b4a3062389/admincropping_1846f13baa077' for key 'ux_asset_derivative_assetpath'

I can see the storage path structure is the combination of repeating existing unique indexes like
assetID/derivativeLabel_derivativeConfigHash/assetName

Yet it's also unique index for asset derivative table.

Can we just remove the storage_path from uniqueindex? These error could pop up when same cropping / focus point updated. (Happen when`static` URL not generated yet. )

Environment

None

Activity

Show:
Seb Duggan
February 3, 2021, 11:25 AM

The first part should be fixed in 10.14.

Both fixes should then be patched into 10.11, 10.12 and 10.13.

Seb Duggan
February 3, 2021, 11:23 AM

Issue is actually being caused, it seems, by derivatives being added to the generation queue without their config hash, which has knock-on effects.

Should also backport the enhanced check for whether the item already exists in the queue, rather than just relying on the DB’s unique constraint (which ignores null values).

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Unassigned

Reporter

Johnson Cheng

Accepted

Yes