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
