Audirvana shows duplicate tracks of the sam album

With different albums Audirvana Mac 3.5.29 shows certain tracks twice. These tracks miss album artwork or show wrong album artwork. The adempt to play such a track produces the feedback “No track could be found”.
Manual sync, integrity check and new indizes don´t change the problem.
Any ideas to solve the problem? Thank you.

I’ve just noticed the same, unfortunately this is a serious bug.

The path reference in the database table ‘tracks’ seems to have changed, leaving a row with the old relative path behind, which results in a double. Where ‘Volumes/x’ was previously not part of the relative path, it now is; The change is good, but somehow old rows aren’t always (or ever?) updated or deleted properly in the conversion.

The easiest fix may well be to drop the library and add it again - but that’s if deleting a library now actually works. If not, delete the whole database and start from scratch… Or wait for D. & co. to release a fix.

Playing a track converts it’s and it’s neighbours database entries to the new path format, but syncing the library uses old deeply relative paths and creates double records.

Hello @jannek, are you using a NAS to store your data?

Hello Damien
I use an external USB harddisk. The itunes library file is on this harddisk.
In my case the double entries didn’t go away, how jannek discribed that in his post of Jan 13.
The behaviour of showing wrong or no artwork lead me to the question, where Audirvana gets the ID3 informations from. So I deleted the whole album in iTunes. It disapeered in Audirvana totaly. Then I reimported the whole album: same problem again with double entries. It seems, that there are old informations stored somewhere.

Same here; For Audirvana, I keep a copy on an external USB drive so I can take the whole library with me where ever I go (independent of the net); Mine is a 1 TB Sandisk Extreme Portable SSD with exFAT as the fs (I need it to be compatible with Mac/Win/linux).

Possibly important: I don’t use iTunes on my Mac, my library currently consists of one monitored folder.

It really seems that different parts of Audirvana now treat paths in conflicting ways.

That SSD is reasonably fast, scanning all 625 GB of FLAC’s from scratch isn’t such a big thing and I could well drop the whole database and start from zero - but I’d still rather just fix the paths with SQL. But… Can’t be fixed, the duplicates come back either way.

.
PS.

At least optionally, strictly relative paths would still be good; We could point the library to a symlink and have the data where ever, even switch it around easily. Mount from a NAS, connect a drive, no difference.

Also big on the library wish list: Multiple libraries and the ability to easily (temporarily) exclude them, and/or the same for monitored folders.

Thought I’d just revisit my situation as simply as possible…

  • Only path configured in library: /Volumes/usbssd/flac
  • Tracks before playing with 3.5.29 show path as: flac/collection/artist/album/track
  • Start playing album, track path updates to: Volumes/usbssd/flac/collection/artist/album…
  • Next two or so tracks are updated as well
  • Hit sync in library settings -> duplicate tracks appear with the old path flac/collection/artist/album
  • The duplicates are not removed if played again, probably because the new path version of the track now already exists.
  • Both “views” of the same track work, ie. can be played, so after a while, all tracks play twice…

Clearly, on-playback metadata checking updates the track path to a different one than the library scan does. Armed with all this, it shouldn’t be too hard to find the bug, which probably lurks in some change between 3.5.26 and 3.5.29, unless the sub-minor os update brought it up.

Let’s get dirty:

sqlite> .mode quote
sqlite> select  t.album_id, a.parent_dev_uuid, a.parent_folder, t.location_dev_uuid, t.location_rel_path, t.location_type from tracks t left join albums a on t.album_id = a.album_id  where location_rel_path like '%a_silver_mt_zion%' order by t.track_number ;
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/01-broken_chords_can_sing_a_little.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/01-broken_chords_can_sing_a_little.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/02-sit_in_the_middle_of_three_galloping_dogs.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/02-sit_in_the_middle_of_three_galloping_dogs.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/03-stumble_then_rise_on_some_awkward_morning.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/03-stumble_then_rise_on_some_awkward_morning.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/04-movie-never_made.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/04-movie-never_made.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/05-13_angels_standing_guard_around_the_side_of_your_bed.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/05-13_angels_standing_guard_around_the_side_of_your_bed.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/06-long_march_rocket_or_doomed_airliner.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/06-long_march_rocket_or_doomed_airliner.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/07-blown-out_joy_from_heavenas_mercied_hole.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/07-blown-out_joy_from_heavenas_mercied_hole.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','Volumes/jk_1TB_SSD/flac/jk/a_silver_mt_zion/he_has_left_us_alone/08-for_wanda.flac',1
9,'/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone','/dev/disk2s1','flac/jk/a_silver_mt_zion/he_has_left_us_alone/08-for_wanda.flac',1
sqlite>

Hi @Damien3
Maybe something that is connected to that topic: If you choose an album Audirvana (german) shows the album artist in the artist field. If you choose a track Audirvana shows the composer (how the ID 3 tag is set) as the artist. The album artist, which in the german version is called misinterpretative artist too is correctly shown (but can’t be changed - why?)

Hello @Damien3
A next observation: if I close Audirvana and iTunes and then change the ID 3 tags with Yate, Audirvana is able to read all tags, included the grouping tag, correctly; No double tracks :slight_smile: By the way iTunes does not read the grouping tag set with Yate.
So the change of ID 3 tags with both iTunes and Audirvana open produces double tracks, which don’t disapear with no means. Why?

Hello @Damien3
A next grouping tag observation: in this example only the 2nd track has a grouping tag, which is correctly displayed. In the line below the componist of the 3rd track is displayed even though there is no grouping tag used in the 3rd track.

I’m getting duplicate albums and duplicate tracks on a MacBook Pro running Catalina 10.15.2. My db is local as is my music collection, in my Music folders.

The more I try to fix it, by deleting my music folders and copying them back to my local drive, the more deeply entrenched the problem becomes. Audirvana is almost workable now with all the dupes. How do I drop the library? How do I delete the database? Will that help?

Big text, but fast doing it… try this for duplicates.

If you have Playlists that are important export them first to desktop and save them in a folder… when Audirvana is reset, you can re-import them back in one shot. sadly to this day, the folders they were in if so, are not back, you have to do them again…

Before doing this, maybe you should not connect after deleting those files to Roon, Tidal or others… Install Audirvana alone with your database… if working, log to Roon or else after.

Apple hide the Home Folder in User Library at some time depending on OS System…
When you have clicked your Home Folder, and cannot see the Library Folder in there,
just do a ‘‘cmd J’’ to show the folder settings preferences and see at the bottom…
click Show Library Folder and then you’ll have access to the rest forever.

Delete your music folder(s) in your Audirvana preferences window with minus sign…

Close Audirvana.

Go to User… Home Folder… Library… Applications Support… Audirvana Folder…
Trash All the files in that folder (that is your database of music, back it up! or not).

Restart MAC.

Open Audirvana, choose a library music folder and LET IT GO, even better don’t try to adjust windows or edit files, even playing music while it is not finished… you’ll see the progress bar going… Could be long the first time depending on how large your library is, and MAC is fast or not… go to sleep if it is too long ! :slight_smile: Then when sync is finished, shut down Audirvana, yes, close it before playing a song… that way, you will have your database new from scratch saved without crashing or with doubles.

Then copy the .sqlite file to somewhere else from that folder…
Home Folder… Library… Applications Support… Audirvana Folder…
as a backup in a folder like dated as today, then open Audirvana.

Now open Audirvana and play some music without doubles :slight_smile:

Like that, if you enter a bug you can always close Audirvana, put the latest perfect backup .sqlite in the same folder, and restart mac, then Audirvana… you’ll be at that latest backup… if you have put something else there or edit songs in between, it will sync the new files, but you will only lose your play counts of those files played in between backups.

With the now obvious internal inconsistency of track path handling, I don’t think anything but a bugfix will help; Maybe try the previous version in the mean time, if someone has the installation package available. It might be useful to find out whether the errant behaviour started with an OS update or an Audirvana update.