I've run into this a few times now, where on a release there's composer and arranger credits given for some tracks but no specific track artist. Which should I be using in cases like this?
2023-10-24 29728, 2023
yayako
or better yet, do we have a style guide for this sort of thing?
Hi ! I have an issue with our replication (that started yesterday). I saw a constraint violation on tag_idx_name. I thought I did something wrong so I recreated the db using recreatedb.sh but I have the same problem. Is it a known issue ? Did I do anything wrong ?
2023-10-24 29742, 2023
Matthieu52
The impacted package seems to be: "This packet was produced (or begins) at 2023-10-23 16:03:16.672738+00"
2023-10-24 29727, 2023
Souler2 joined the channel
2023-10-24 29744, 2023
Souler has quit
2023-10-24 29724, 2023
yvanzo
Hi Matthieu52, the database has been moved to a new server yesterday, so it is more likely an issue on our side, thanks for reporting.
2023-10-24 29710, 2023
Matthieu52
I saw that this replication packet is indeed the one that was generated right after the planned maintenance
yeah, a tag index was corrupted in the main DB yesterday, which allowed some tags with duplicate names to be added...I will work on fixing the replication packet in about an hour when I'm awake (?)
MBS-13333: Replication is blocked by tag duplicates
2023-10-24 29730, 2023
bitmap
yvanzo: thanks, was there a replicated mirror somewhere on our infrastructure that I could test with?
2023-10-24 29718, 2023
yvanzo
bitmap: no, the one on wolf is out-of-sync, I can update it though.
2023-10-24 29716, 2023
Omm joined the channel
2023-10-24 29757, 2023
bitmap
alright, I'll set one up locally too
2023-10-24 29724, 2023
bitmap
fixing the packets by hand is possible, but it won't help people who have the packet half-applied (up until the broken seqid). so I think the best option is to simply have the replication script drop tag_idx_name before applying this sequence and then re-create it after the last broken packet is applied. users will have to update their code
2023-10-24 29754, 2023
bitmap
people using mbslave (I'm not sure how many that is) will require manual intervention
2023-10-24 29706, 2023
bitmap
maybe I'll think of a better solution while I'm setting up my mirror
2023-10-24 29733, 2023
yvanzo
currently recreating the mirror DB on wolf
2023-10-24 29741, 2023
bitmap
thanks...I actually don't have enough space here to create another DB
2023-10-24 29743, 2023
bitmap
maybe I can get away with only importing the derived dump
2023-10-24 29716, 2023
bitmap
in the meantime I'm writing a script to reindex all indexes in production that are using either the default or musicbrainz collation...I already did this for UNIQUE indexes yesterday (the ones that could cause replication issues) but I'll do the rest now
2023-10-24 29718, 2023
bitmap
ok, everything reindexed
2023-10-24 29735, 2023
Omm has quit
2023-10-24 29740, 2023
Matthieu52 is now known as MatthieuPlex
2023-10-24 29707, 2023
ijc has quit
2023-10-24 29719, 2023
ijc joined the channel
2023-10-24 29709, 2023
MatthieuPlex has quit
2023-10-24 29713, 2023
Matthieu3 joined the channel
2023-10-24 29717, 2023
Matthieu3 is now known as MatthieuPlex
2023-10-24 29754, 2023
MatthieuPlex has quit
2023-10-24 29747, 2023
MeatPupp3t has quit
2023-10-24 29754, 2023
MeatPupp3t joined the channel
2023-10-24 29704, 2023
lolek1 joined the channel
2023-10-24 29707, 2023
lolek1 has left the channel
2023-10-24 29715, 2023
Souler2 has quit
2023-10-24 29704, 2023
Sciencentistguy
atj: I'm getting 403s from atisket when i'm connected to my VPN - I assume this is intentional, for spam reasons?
2023-10-24 29704, 2023
petitminion joined the channel
2023-10-24 29717, 2023
atj
Sciencentistguy: can you have a look at the forum thread? I posted about it. If you use the same VPN server I can remove that specific IP from the blocklist.
2023-10-24 29739, 2023
Sciencentistguy
ah, yeah sorry i forgot there was a forum thread - its fine, i can just switch server temporarily while the ban-evader persists
2023-10-24 29753, 2023
Matthieu41 joined the channel
2023-10-24 29758, 2023
Matthieu41 is now known as MatthieuPlex
2023-10-24 29758, 2023
duncaen has quit
2023-10-24 29745, 2023
duncaen joined the channel
2023-10-24 29713, 2023
petitminion has quit
2023-10-24 29722, 2023
petitminion joined the channel
2023-10-24 29746, 2023
jeffbyrnes has quit
2023-10-24 29746, 2023
relaxoMob has quit
2023-10-24 29759, 2023
relaxoMob joined the channel
2023-10-24 29726, 2023
petitminion has quit
2023-10-24 29723, 2023
relaxoMob has quit
2023-10-24 29712, 2023
relaxoMob joined the channel
2023-10-24 29758, 2023
jeffbyrnes joined the channel
2023-10-24 29751, 2023
relaxoMob has quit
2023-10-24 29746, 2023
relaxoMob joined the channel
2023-10-24 29751, 2023
relaxoMob has quit
2023-10-24 29726, 2023
MatthieuPlex has quit
2023-10-24 29729, 2023
relaxoMob joined the channel
2023-10-24 29732, 2023
yayako
Hi yvanzo, thanks! It's a soundtrack release, so style says I should use the composer, but it feels a little weird to leave out the arranger especially when a feat. vocalist is involved with the arrangement. Here's the credits for the release: https://media.vgm.io/albums/83/119138/119138-8c0a…
2023-10-24 29749, 2023
wargreen has quit
2023-10-24 29753, 2023
yayako
Do you think it'd still be best to relegate vocalist and arranger to the recording relationship in this case?
2023-10-24 29704, 2023
yayako
I'm actually not sure if in a case like this the arranger is intended to be the track artist, because that's how some other Japanese soundtrack releases on MB seem to be...
2023-10-24 29741, 2023
jeffbyrnes has quit
2023-10-24 29730, 2023
wargreen joined the channel
2023-10-24 29747, 2023
elr1c has quit
2023-10-24 29713, 2023
elr1c joined the channel
2023-10-24 29743, 2023
jeffbyrnes joined the channel
2023-10-24 29751, 2023
petitminion joined the channel
2023-10-24 29707, 2023
Lotheric_ joined the channel
2023-10-24 29742, 2023
jeffbyrnes has quit
2023-10-24 29728, 2023
Lotheric has quit
2023-10-24 29727, 2023
jeffbyrnes joined the channel
2023-10-24 29722, 2023
user23 joined the channel
2023-10-24 29741, 2023
lolek joined the channel
2023-10-24 29750, 2023
lolek has left the channel
2023-10-24 29741, 2023
aerozol
yayako: you might have misunderstood yvanzo - it only should have the composer in the assist field if it's a classical release:)
2023-10-24 29730, 2023
aerozol
In pretty much every other instance we do 'as credited' on the release
2023-10-24 29739, 2023
aerozol
*artist field
2023-10-24 29703, 2023
yano has quit
2023-10-24 29739, 2023
yano joined the channel
2023-10-24 29752, 2023
jeffbyrnes has quit
2023-10-24 29759, 2023
Zed82 joined the channel
2023-10-24 29733, 2023
jeffbyrnes joined the channel
2023-10-24 29712, 2023
yayako
aerozol: I checked the Soundtrack style page which says "If there are no track artists, use the release artist instead.", what gives me pause with a release like this is that it does specify "arranger" on the album art, and Japanese releases on MB seem to be split on whether arranger should be used in the artist field of a recording/track... that I've seen
2023-10-24 29720, 2023
yayako
I think arranger is probably the most suitable here, unless you mean I make the track credits something like "compose:name arrange:name"?
2023-10-24 29727, 2023
yayako
precisely as written, I mean
2023-10-24 29718, 2023
petitminion has quit
2023-10-24 29745, 2023
petitminion joined the channel
2023-10-24 29749, 2023
yayako
I don't think I can do it like that though, since I can't prefix the first name with a join phrase
2023-10-24 29755, 2023
relaxoMob has quit
2023-10-24 29720, 2023
Zed82 has quit
2023-10-24 29757, 2023
relaxoMob joined the channel
2023-10-24 29746, 2023
aerozol
Hmm, sorry, I can’t read Japanese so I didn’t see that. You can prefix the first name, but it’s clunky imo. I’ll see if there’s any JP editors on the Discord who’ve come afcross this
2023-10-24 29735, 2023
ttpcodes has quit
2023-10-24 29729, 2023
ttpcodes joined the channel
2023-10-24 29732, 2023
yayako
no problem, thanks!!
2023-10-24 29704, 2023
mrmonday has quit
2023-10-24 29753, 2023
mrmonday joined the channel
2023-10-24 29727, 2023
Zed77 joined the channel
2023-10-24 29712, 2023
user23 has quit
2023-10-24 29705, 2023
petitminion has quit
2023-10-24 29711, 2023
yvanzo
yayako: I know neither about soundtracks nor about Japanese releases. You might have better chances asking on the forums. In any case, adding relationships is worth it.
2023-10-24 29751, 2023
yayako
Definitely will be adding the proper composer/arranger relationships once I get the release in, for sure! I always try to put as much data as I can when I work on a release
