Duplicate entry errors in derivative generation
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
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. )
The first part should be fixed in 10.14.
Both fixes should then be patched into 10.11, 10.12 and 10.13.
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).