I see up there you seems to be on a Mac…
Easiest way is to start your database again… from scratch.
if you answer my post before this one… you can wait for another answer from me or others, if not, do that here
Big text, but fast doing it…
Remove duplicates by deleting those files…
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…
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.
Starting new:
Go in Audirvana preferences panel then remove your sync folder(s) there (all the folder(s) of music you have there) delete them with minus sign.
Close Audirvana.
Go to User… Your 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), don’t back it up… it as doubles
Restart Mac.
Open Audirvana, choose a music folder to sync at first it will sync in top middle of main window… 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
Then when finished, shut down Audirvana, yes close it before playing a song… That way you will have your database from scratch saved without crashing, Then copy the .sqlite file to somewhere else as a backup, after open Audirvana, and try to play a song. it will to install System Optimizer…
When all is set, import back your playlists that you saved earlier, you can reload them in one shot selecting first and last in the window. Then, when loaded, you can shut down again Audirvana… copy the database .sqlite again as a NEW backup…
if something go wrong AGAIN… you just have to put the database backup to replace to faulty one… it will reopen at the time of your last database backup… so do it regurlaly if you do often editing… When you put a backup database .sqlite, you will lose all the play counts of music files that played between the one you trash and the backup you put to replace… so i backup up a lot the .sqlite file