Morning, yvanzo (and other interested parties). Just wanted to let you know that I successfully completed a reindex overnight. It took about 16 hours, up from around 12. It looks to me that artist indexing is significantly slower than it used to be. But that's just a sample size of one ;)
lucifer[m]
mglubb: there are a couple of unreleased PRs that improve the indexing time.
especially, artist core.
for us, it halves the indexing time for artist core from ~20 mins to 10 mins.
mglubb[m]
Thanks, lucifer . I'll wait for them to be merged into main then give it a whirl. As it happens, I'm seeing similar slowness in ongoing indexing. Hopefully they'll help that?
lucifer[m]
yes, i think the live indexing should be faster too with that.
Maxr1998 joined the channel
Maxr1998_ has quit
mthax has quit
mthax joined the channel
yvanzo[m]
Hi lucifer, yes.
It took ~5h.
lucifer[m]
the mb docker numbers i have for it are 7-8h. so seems a across the board improvement.
Also I stopped the live indexer for reindexing the whole collections.
So there are some messages to be processed now.
lucifer: I just left a comment to your last PR for the retry strategy.
outsidecontext[m
mayhem, zas: I'd like to tag a libdiscid release. Can one of you help me with getting the release files copied to the MB file servers afterwards?
There is not much changes, but a CMake fix that is waiting to be released for two years now, and also the binaries for Windows and macOS get code-signed now.
mayhem[m]
not a problem.
outsidecontext[m
ok, great. then I'll tag the release and ping you when its ready.
looks like I'm accidental de-facto maintainer of libdiscid since a few years. Not sure how this happened
lucifer[m]
yvanzo: done.
yvanzo: is it fine i disable the sir jenkins jobs?
[@_discord_410549040392962058:chatbrainz.org](https://matrix.to/#/@_discord_410549040392962058:chatbrainz.org) when did you send the messages? I'll check.
adhawkins[m]
10:33:41 (BST) and 11:38:35 (again BST)
s/BST/GMT + 1/, s/BST/GMT + 1/
lucifer[m]
adhawkins[m]: [@bitmap:chatbrainz.org](https://matrix.to/#/@bitmap:chatbrainz.org) and [@yvanzo:chatbrainz.org](https://matrix.to/#/@yvanzo:chatbrainz.org) got the same issue yesterday. while waiting for their response you can check the chatlogs from last night/early morning.
adhawkins[m]
Will do. Thanks.
rayyan_seliya123 has quit
There is talk of rebuilding images and the like. Wonder if that's been done?
I'll wait for bitmap or yvanzo to respond. For now, lunch time!
yvanzo[m]
adhawkins: Apparently, an additional command can be required (depending on your Docker Compose version?), see the updated step 4.
adhawkins[m]
Thanks, will double check.
yvanzo[m]
(the build command)
Patched live indexing sir container for production SolrCloud 9 cluster.
texke has quit
petitminion has quit
petitminion joined the channel
lucifer_ joined the channel
lucifer_
testing irc bridge.
lucifer[m]
adhawkins: the irc bridge seems to be working, can you check you sent the message to right channel on the right network?
petitminion has quit
adhawkins[m] uploaded an image: (87KiB) < https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/acQOtOwHvWSzvMCvwYYNWoOj/image.png >
adhawkins[m]
Done that, and now the upgrade seems to be progressing. Thanks.
adhawkins: i see you in the channel but don't see your message or the dm.
adhawkins[m]
Odd...
lucifer[m] uploaded an image: (197KiB) < https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/gNLHDuShluTWaOiiuCUSlGQM/image.png >
lucifer[m]
thanks yvanzo!
adhawkins[m]
I've just disconnected and reconnected. Anything?
lucifer[m]
nothing in the channel but sent you a dm
i didn't see a part/join in irc for your username either fwiw
adhawkins[m]
Ok, let me restart my bouncer.
lucifer[m]
maybe an issue with your ircclient or bouncer?
adhawkins has quit
adhawkins joined the channel
fettuccinae[m]
mayhem: can you please help me with this [test case fail](https://github.com/metabrainz/metabrainz.org/actions/runs/15162692322/job/42632388438?pr=506#step:6:1049). The uuid-ossp extension was already added and it still fails.
adhawkins
Any joy now?
lucifer_
hey hey hey
adhawkins
Testing testing
mayhem[m]
@fettuccinae:matrix.org: do the tests pass locally?
fettuccinae[m]
mayhem[m]: no, the same "no function matches" error
fwiw we are on pg 16 in production so you can use gen_random_uuid without uuid-ossp too. i intend to do that in LB once timescale is migrated to 16 or 17.
lucifer_ has left the channel
fettuccinae[m]
lucifer[m]: ill do that.
<lucifer[m]> "change the column type to uuid" <- i was type casting it back to test locally `uuid_generate_v4()::text` and was still getting the same error.
s/test/text/
<lucifer[m]> "fwiw we are on pg 16 in producti..." <- I think we are still on pg12.3 in [MeB](https://github.com/metabrainz/metabrainz.org/blob/19acb9456d20ab873afdd08aa2595c9991f7d3cb/docker/docker-compose.test.yml#L17), im getting the same error with `gen_random_uuid()`
An MB API questions: In release results mediums have a field track-offset. What exactly does this indicate, and in which cases is it something other than 0?
outsidecontext: I believe this is used for continuous numbering across mediums. So for example if you have songs 1 - 10 spread on two mediums, you will get tracks 1-5 on each medium.
track offset allows you to define that medium 2 track 1 is actually track 6
(although please correct me if I'm wrong)
mshahnawaz1[m] has quit
outsidecontext[m
monkey: I'd assume something like this. But can this actually be set for releases on MB? I had seen this field before, but never questioned it :)
monkey[m]
Didn't realize you can't set it on the website
outsidecontext[m
Actually it looks to me as if this field is actually unused. I guess the intention was as you described. But in practice it isn't in use. Something like the case with different numbering would just have the track "number" strings set differently from the position. E.g. on https://musicbrainz.org/ws/2/release/805cc5b2-1...
