ConstraintViolation when inserting external audio track

https://appcenter.ms/orgs/videolan/apps/VLC-for-iOS-production/crashes/errors/1393879281u/overview

INSERT INTO AudioTrack(codec, bitrate, samplerate, nb_channels, language, description, media_id, attached_file_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?)] aborted due to constraint violation (UNIQUE constraint failed: AudioTrack.media_id, AudioTrack.attached_file_id)

Most likely we don't properly cleanup when rescanning a media with external audio tracks, this should be reproducible with a functional test.

This will need to be backported to %0.10.x

Edited Nov 17, 2021 by Hugo Beauzée-Luyssen

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information