slimserver icon indicating copy to clipboard operation
slimserver copied to clipboard

Published 20 hours ago • verified publisher icon LMS-Community

Deleted artist entry not deleted from contributor_album

Open frank1969b opened this issue 3 years ago • 9 comments

I see many "empty" entries in my database again - this should result from not deleting artist's entry from "contributor_album".

I describe my tests:

=> I had a song called "1 mit dir" by 3 (track) artists: Karat, Jeanette, Jeanette Biedermann (btw: album artist is "Karat") => I deleted the "Jeanette"-entry so it had 2 (track) artists: Karat, Jeanette Biedermann => I did a new&changed => After the new&changed the track is still found under all 3 artists while browsing: Karat, Jeanette Biedermann, Jeanette(!) => If You click on the track from the "Karat" or "Jeanette Biedermann" browsing, You see full track info => If You click on the track from the "Jeanette" browsing, You only see album info and the word "empty" instead of any track info => If You browse for the album, You see all 3 (including Jeanette) named as track artists, but there is no track with the (track) artist "Jeanette"

So I examined library.db after the n&c:

=> contributor_track looks fine - no sign of the gone "Jeanette" artist (#3674) BUT => on contributor_album there is still an entry for the "Jeanette" artist on the album with role "6".

So obviously n&c did "only" delete the entry on contributor_track table but not an contributor_album.

Beneath the scanner.log entries from the n&c concerning this track:

If it should be helpful:

contributor ids: #3674 = Jeanette #6236 = Karat #42953 = Jeanette Biedermann

track id: #869207 = 1 mit dir

album id: #62198 = Labyrinth

[22-04-30 17:38:31.8796] Slim::Utils::Scanner::Local::Async::ANON (148) Found M:\K\Karat\2018 - Labyrinth\03 - Karat; Jeanette; Jeanette Biedermann - 1 mit dir.mp3

[22-04-30 18:19:22.9680] Slim::Utils::Scanner::Local::changed (975) Handling changed audio track file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 [22-04-30 18:19:22.9694] Slim::Schema::updateOrCreateBase (1840) Merging entry for file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 readTags is: [1] [22-04-30 18:19:22.9697] Slim::Music::Info::typeFromPath (1555) mp3 file type for M:\K\Karat\2018 - Labyrinth\03 - Karat; Jeanette; Jeanette Biedermann - 1 mit dir.mp3 [22-04-30 18:19:22.9980] Slim::Formats::readTags (275) Report for file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3: [22-04-30 18:19:22.9983] Slim::Formats::readTags (332) . SIZE : 8970448 [22-04-30 18:19:22.9985] Slim::Formats::readTags (332) . APIC : ARRAY(0x11bac2ec) [22-04-30 18:19:22.9986] Slim::Formats::readTags (332) . OFFSET : 91453 [22-04-30 18:19:22.9988] Slim::Formats::readTags (332) . COVER_LENGTH : 88970 [22-04-30 18:19:22.9990] Slim::Formats::readTags (332) . YEAR : 2018 [22-04-30 18:19:22.9991] Slim::Formats::readTags (332) . ARTIST : ARRAY(0x11bb3384) [22-04-30 18:19:22.9994] Slim::Formats::readTags (332) . SECS : 224.235 [22-04-30 18:19:22.9996] Slim::Formats::readTags (332) . TIMESTAMP : 1651329728 [22-04-30 18:19:22.9998] Slim::Formats::readTags (332) . TRACKNUM : 03/15 [22-04-30 18:19:22.9999] Slim::Formats::readTags (332) . TCOP : (c) 2018 Electrola [22-04-30 18:19:23.0001] Slim::Formats::readTags (332) . COMPOSER : ARRAY(0x11e06964) [22-04-30 18:19:23.0003] Slim::Formats::readTags (332) . ALBUMARTIST : Karat [22-04-30 18:19:23.0004] Slim::Formats::readTags (332) . TMED : Download [22-04-30 18:19:23.0005] Slim::Formats::readTags (332) . FILESIZE : 9061901 [22-04-30 18:19:23.0006] Slim::Formats::readTags (332) . PRIV : ARRAY(0x11dff2fc) [22-04-30 18:19:23.0007] Slim::Formats::readTags (332) . ALBUM : Labyrinth [22-04-30 18:19:23.0008] Slim::Formats::readTags (332) . TITLE : 1 mit dir [22-04-30 18:19:23.0011] Slim::Schema::_preCheckAttributes (2728) Report for file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3: [22-04-30 18:19:23.0012] Slim::Schema::_preCheckAttributes (2729) * Attributes * [22-04-30 18:19:23.0013] Slim::Schema::_preCheckAttributes (2731) .. LOSSLESS : 0 [22-04-30 18:19:23.0014] Slim::Schema::_preCheckAttributes (2731) .. DLNA_PROFILE : MP3 [22-04-30 18:19:23.0015] Slim::Schema::_preCheckAttributes (2731) .. STEREO : 1 [22-04-30 18:19:23.0016] Slim::Schema::_preCheckAttributes (2731) .. TITLESORT : 1 MIT DIR [22-04-30 18:19:23.0017] Slim::Schema::_preCheckAttributes (2731) .. TRACKNUM : 3 [22-04-30 18:19:23.0018] Slim::Schema::_preCheckAttributes (2731) .. TCOP : (c) 2018 Electrola [22-04-30 18:19:23.0019] Slim::Schema::_preCheckAttributes (2731) .. AUDIO_SIZE : 8970448 [22-04-30 18:19:23.0020] Slim::Schema::_preCheckAttributes (2731) .. AUDIO : 1 [22-04-30 18:19:23.0021] Slim::Schema::_preCheckAttributes (2731) .. TMED : Download [22-04-30 18:19:23.0022] Slim::Schema::_preCheckAttributes (2731) .. CONTENT_TYPE : mp3 [22-04-30 18:19:23.0023] Slim::Schema::_preCheckAttributes (2731) .. REMOTE : 0 [22-04-30 18:19:23.0024] Slim::Schema::_preCheckAttributes (2731) .. PRIV : ARRAY(0x11dff2fc) [22-04-30 18:19:23.0025] Slim::Schema::_preCheckAttributes (2731) .. TITLE : 1 mit dir [22-04-30 18:19:23.0026] Slim::Schema::_preCheckAttributes (2731) .. LAYER_ID : 1 [22-04-30 18:19:23.0027] Slim::Schema::_preCheckAttributes (2731) .. YEAR : 2018 [22-04-30 18:19:23.0028] Slim::Schema::_preCheckAttributes (2731) .. CHANNELS : 2 [22-04-30 18:19:23.0028] Slim::Schema::_preCheckAttributes (2731) .. SECS : 224.235 [22-04-30 18:19:23.0029] Slim::Schema::_preCheckAttributes (2731) .. RATING : 0 [22-04-30 18:19:23.0030] Slim::Schema::_preCheckAttributes (2731) .. TIMESTAMP : 1651329728 [22-04-30 18:19:23.0031] Slim::Schema::_preCheckAttributes (2731) .. AUDIO_OFFSET : 91453 [22-04-30 18:19:23.0032] Slim::Schema::_preCheckAttributes (2731) .. DRM : 0 [22-04-30 18:19:23.0033] Slim::Schema::_preCheckAttributes (2731) .. TAGVERSION : ID3v2.4.0 [22-04-30 18:19:23.0034] Slim::Schema::_preCheckAttributes (2731) .. BLOCK_ALIGNMENT : 1 [22-04-30 18:19:23.0035] Slim::Schema::_preCheckAttributes (2731) .. urlmd5 : c79d9fe3505d652612168d68af18f169 [22-04-30 18:19:23.0036] Slim::Schema::_preCheckAttributes (2731) .. TITLESEARCH : 1 MIT DIR [22-04-30 18:19:23.0037] Slim::Schema::_preCheckAttributes (2731) .. FILESIZE : 9061901 [22-04-30 18:19:23.0038] Slim::Schema::_preCheckAttributes (2731) .. SAMPLERATE : 44100 [22-04-30 18:19:23.0039] Slim::Schema::_preCheckAttributes (2731) .. BITRATE : 320000 [22-04-30 18:19:23.0040] Slim::Schema::_preCheckAttributes (2731) .. COVER : 88970 [22-04-30 18:19:23.0041] Slim::Schema::_preCheckAttributes (2738) * Deferred Attributes * [22-04-30 18:19:23.0042] Slim::Schema::_preCheckAttributes (2740) .. ALBUM : Labyrinth [22-04-30 18:19:23.0042] Slim::Schema::_preCheckAttributes (2740) .. APIC : ARRAY(0x11bac2ec) [22-04-30 18:19:23.0043] Slim::Schema::_preCheckAttributes (2740) .. ALBUMARTIST : Karat [22-04-30 18:19:23.0044] Slim::Schema::_preCheckAttributes (2740) .. GENRE : Pop [22-04-30 18:19:23.0045] Slim::Schema::_preCheckAttributes (2740) .. ARTIST : ARRAY(0x11bb3384) [22-04-30 18:19:23.0046] Slim::Schema::_preCheckAttributes (2740) .. COMMENT : ARRAY(0x11e0925c) [22-04-30 18:19:23.0047] Slim::Schema::_preCheckAttributes (2740) .. COMPOSER : ARRAY(0x11e06964) [22-04-30 18:19:23.0048] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : lossless to 0 [22-04-30 18:19:23.0050] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : dlna_profile to MP3 [22-04-30 18:19:23.0051] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : titlesort to 1 MIT DIR [22-04-30 18:19:23.0053] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : tracknum to 3 [22-04-30 18:19:23.0054] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : audio_size to 8970448 [22-04-30 18:19:23.0055] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : audio to 1 [22-04-30 18:19:23.0056] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : content_type to mp3 [22-04-30 18:19:23.0057] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : remote to 0 [22-04-30 18:19:23.0058] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : title to 1 mit dir [22-04-30 18:19:23.0060] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : year to 2018 [22-04-30 18:19:23.0061] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : channels to 2 [22-04-30 18:19:23.0062] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : secs to 224.235 [22-04-30 18:19:23.0063] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : timestamp to 1651329728 [22-04-30 18:19:23.0064] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : audio_offset to 91453 [22-04-30 18:19:23.0066] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : drm to 0 [22-04-30 18:19:23.0067] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : tagversion to ID3v2.4.0 [22-04-30 18:19:23.0068] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : block_alignment to 1 [22-04-30 18:19:23.0069] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : urlmd5 to c79d9fe3505d652612168d68af18f169 [22-04-30 18:19:23.0070] Slim::Schema::updateOrCreateBase (1872) Updating persistent file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : urlmd5 to c79d9fe3505d652612168d68af18f169 [22-04-30 18:19:23.0072] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : titlesearch to 1 MIT DIR [22-04-30 18:19:23.0073] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : filesize to 9061901 [22-04-30 18:19:23.0075] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : updated_time to 1651335562 [22-04-30 18:19:23.0076] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : samplerate to 44100 [22-04-30 18:19:23.0077] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : bitrate to 320000 [22-04-30 18:19:23.0078] Slim::Schema::updateOrCreateBase (1864) Updating file:///M:/K/Karat/2018%20-%20Labyrinth/03%20-%20Karat%3B%20Jeanette%3B%20Jeanette%20Biedermann% 20-%201%20mit%20dir.mp3 : cover to 88970 [22-04-30 18:19:23.0082] Slim::Music::Info::splitTag (1059) Splitting Pop by ; = Pop [22-04-30 18:19:23.0084] Slim::Music::Info::splitTag (1059) Splitting Pop by \x00 = Pop [22-04-30 18:19:23.0085] Slim::Schema::_mergeAndCreateContributors (2950) -- Contributor 'ARRAY(0x11bb3384)' of role 'ARTIST' transformed to role 'TRACKARTIST' [22-04-30 18:19:23.0087] Slim::Music::Info::splitTag (1059) Splitting Karat by ; = Karat [22-04-30 18:19:23.0088] Slim::Music::Info::splitTag (1059) Splitting Karat by \x00 = Karat [22-04-30 18:19:23.0091] Slim::Schema::_mergeAndCreateContributors (2977) -- Track has contributor 'Karat' of role 'ALBUMARTIST' [22-04-30 18:19:23.0096] Slim::Schema::_mergeAndCreateContributors (2977) -- Track has contributor 'ARRAY(0x11e06964)' of role 'COMPOSER' [22-04-30 18:19:23.0098] Slim::Schema::_mergeAndCreateContributors (2977) -- Track has contributor 'ARRAY(0x11bb3384)' of role 'TRACKARTIST' [22-04-30 18:19:23.0099] Slim::Schema::_mergeAndCreateContributors (2985) -- Track has 3 contributor(s) [22-04-30 18:19:23.0109] Slim::Schema::_createOrUpdateAlbum (1302) -- Updating album 'Labyrinth' (id: [62198]) with columns: [22-04-30 18:19:23.0110] Slim::Schema::_createOrUpdateAlbum (1309) --- artwork : 4e953649 [22-04-30 18:19:23.0111] Slim::Schema::_createOrUpdateAlbum (1309) --- titlesort : LABYRINTH [22-04-30 18:19:23.0112] Slim::Schema::_createOrUpdateAlbum (1309) --- id : 62198 [22-04-30 18:19:23.0113] Slim::Schema::_createOrUpdateAlbum (1309) --- contributor : 6236 [22-04-30 18:19:23.0114] Slim::Schema::_createOrUpdateAlbum (1309) --- titlesearch : LABYRINTH [22-04-30 18:19:23.0115] Slim::Schema::_createOrUpdateAlbum (1309) --- title : Labyrinth [22-04-30 18:19:23.0116] Slim::Schema::_createOrUpdateAlbum (1309) --- year : 2018 [22-04-30 18:19:23.0118] Slim::Schema::_createOrUpdateAlbum (1330) Not a Comp : Labyrinth

frank1969b avatar May 02 '22 09:05 frank1969b

I can't reproduce this issue. Here's what I tried

  • added "me;myself;myself included" as artists to a track
  • "myself included" to be similar to your case where there's another artist with the same first name in addition to the last name
  • removed "myself"
  • run "rescan"
  • can't find "myself" in the contributor table any more (nor in the UI, obviously)

Are you sure the file isn't tagged with "Jeannette" in another additional role? In the above snippet (little useful) references to a contributor list exist with roles Composer and Trackartist.

michaelherger avatar May 03 '22 05:05 michaelherger

Oh, does your file have multiple ARTIST tags, rather than a single tag which would be split by separator (I was using ;). I'm not even able to do this with my tagging tool... what are you using?

michaelherger avatar May 03 '22 05:05 michaelherger

Sounds like exactly the same what I did (despite I'm using the default "\" as separator, but I have configured my tagging tool (mp3tag, by the way, that I could use also ";" or "; ", so this should not mind).

I GUESS the difference is, that You have no other track linked to the "myself"-artist in your db so it clears the "myself"-artist from the contributor's table? Maybe You may try the same with a second track linked to the "myself" artist that stays in the db after You delete "myself" from the other track?

(by the way: No, of course it is ONE "artist" tag, but with different VALUES (split by \) to say it exactly...)

frank1969b avatar May 03 '22 07:05 frank1969b

Did some more testing and it definitely depends on if the artist, is deleted from this ONE track, is still in the DB on another track. If it is NOT it works fine. If is it, You have the issue I described (at least as far as my testings show...)

frank1969b avatar May 05 '22 08:05 frank1969b

I'm sorry, I still can't reproduce this. What are your settings for "Eigene Musik"? The roles to include as artists?

michaelherger avatar May 06 '22 11:05 michaelherger

Eigene-Musik

Sry, been to Turin for 10 days without my db ;) Attached my setting - will test some further constellations till/on weekend :)

frank1969b avatar May 18 '22 08:05 frank1969b

Sry, been to Turin for 10 days without my db ;)

The big music craze?

Thanks, those settings are pretty different from what I'm using. I'll give it another try.

michaelherger avatar May 19 '22 12:05 michaelherger

Yes, this one (Some work and some fun). OK, maybe You could reproduce it using "my" settings already?

frank1969b avatar May 19 '22 16:05 frank1969b

All I can say right now is that something's really wrong.

Track 1:

  • Track artists A, B, and C
  • No Album artist

Track 2:

  • Track artist D
  • Album artists D and C

After a fresh scan all three artists are listed as "Artists", with each one the album and track you'd expect.

Now I remove C from Track 1, rescan. B disappears from the Artists list.

In my testing the problem seems to be that more data disappears than is left behind... I still can't reproduce the issue you describe. But overall this feels like fix one case, break another one 😞 .

mherger avatar May 19 '22 18:05 mherger