Navidrome DB Corruption #57

New Issue

sickprodigy · 2026-03-25T19:02:51-04:00

sickprodigy commented

2026-03-25 19:02:51 -04:00

Having issues with media_file db and tags table within. also participants.

sickprodigy commented

2026-03-25 19:03:46 -04:00

Navidrome issues:

i ran the following command

SELECT id, album_id, title, participants
FROM media_file
WHERE participants NOT LIKE '{%' AND participants NOT LIKE '[%';

or

SELECT id, album_id, title, participants
FROM media_file
WHERE json_valid(participants) = 0;

then ran this
UPDATE media_file SET participants = '[]' WHERE id = '0f2a81a506f95758208a8cdf08ba220b';

navidrome didn't like [] so need {}

UPDATE media_file SET participants = '{}' WHERE id = '0f2a81a506f95758208a8cdf08ba220b';

Now something wrong in media_file tags table

-- Find problematic rows:
SELECT id, tags FROM media_file WHERE tags NOT LIKE '{%';

-- Fix them (replace YOUR_ID with the actual id, or remove the WHERE clause to update all):
UPDATE media_file SET tags = '{}' WHERE tags NOT LIKE '{%';

UPDATE media_file SET tags = '{}' WHERE id = '0f2a81a506f95758208a8cdf08ba220b';

And now we are good it seems. Able to scan all folders within navidrome again.

Navidrome issues: i ran the following command ``` SELECT id, album_id, title, participants FROM media_file WHERE participants NOT LIKE '{%' AND participants NOT LIKE '[%'; ``` or ``` SELECT id, album_id, title, participants FROM media_file WHERE json_valid(participants) = 0; ``` then ran this `UPDATE media_file SET participants = '[]' WHERE id = '0f2a81a506f95758208a8cdf08ba220b';` navidrome didn't like [] so need {} `UPDATE media_file SET participants = '{}' WHERE id = '0f2a81a506f95758208a8cdf08ba220b';` Now something wrong in media_file tags table -- Find problematic rows: `SELECT id, tags FROM media_file WHERE tags NOT LIKE '{%';` -- Fix them (replace YOUR_ID with the actual id, or remove the WHERE clause to update all): `UPDATE media_file SET tags = '{}' WHERE tags NOT LIKE '{%';` `UPDATE media_file SET tags = '{}' WHERE id = '0f2a81a506f95758208a8cdf08ba220b';` And now we are good it seems. Able to scan all folders within navidrome again.

sickprodigy closed this issue

2026-03-25 19:03:46 -04:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: sickprodigy/docker-home-server#57