alastairp: I dont have comparison numbers to hand.
CatQuest
apparently others disagree
strongly
alastairp
CatQuest: oddly, the top duplicate-sumitted track on AB is some B-side from a beatles single
ruaok
this was a pretty simple query I suspect that spark will be more flexible in the long run
CatQuest
oh ye?
what ?
alastairp
yeah, it was werid. I had never heard of it
CatQuest
what was it called?
is it that one with jimi hendrix on guitar? :D
alastairp
ruaok: right, but I guess spark requires shipping the whole database there too, before we can run any stats on it
bitmap
vacuumdb done!
alastairp
I guess it's no different to running timescale queries on a db replica
CatQuest
or that one super early instrumental one called tide something
alastairp
CatQuest: I don't recall, and I don't have the data easily to hand, sorry
CatQuest
ah. no worries. but if you do come over it again, i'd be interested in the name
Mr_Monkey
CatQuest: Sgt. Peppers for me !
alastairp
that data may have changed since I computed it again
CatQuest
hah my point exactly :D
alastairp
one of my near-term goals for AB is to get this kind of stats running
CatQuest
neeeat
bitmap
database seems to be operating normally, I'll take it out of consul maint mode
ruaok
alastairp: spark already has the whole DB.
bitmap: vacuum done already??
bitmap
yupp
crazy
ruaok
wow, yes
CatQuest
oh i remembered another "popular" and I thought was alright (listened one album): Pearl Jam
CatQuest almost wrote "Perl Jam"
alastairp
ruaok: yeah, right. so in order to perform any kind of stats in spark we have to keep an entire duplicate of the db there, in addition to whatever other db we use primarily?
ruaok
yes.
spark is considered disposable.
bitmap
leaving pink down since I need to resync that later
CatQuest
reosarevok: insert a pokemongo refrence (spark eg?)
alastairp
sure. it's not like we'd want to run background tasks on the main production database anyway I guess
in order to prevent it from overloading
ruaok
yep.
rdswift also likes Great Big Sea.
alastairp
so it's not like it's any more "innefficient" than any other way that we'd have to set up a stats infrastructure
ruaok
I'm so happy the stats infra is getting squared away.
iliekcomputers
it's been pretty stable the last few days.
i'm just waiting for a new data dump to complete so that we can import it.
bitmap
started sir-prod back up without issue
starting caa-indexer
ruaok
time to start other services?
bitmap
yup
ruaok
doing trille, lemmy and hip
bitmap
done with serge
ruaok
LB up
Mr_Monkey
Done prince. BB looks fine (beta, prod and test)
bitmap
I'll do cage, ludwig, pink
iliekcomputers
for perf, our spark cluster takes around 6 min to calculate all artist listen counts for ALL users with basically no tuning rn.
ruaok
CB up, MeB up.
iliekcomputers
with some smart data partitioning, i'm pretty sure we could bring that down.
ruaok
MSB up.
bitmap wonders if the "down": "yes" stuff never worked since he didn't revert that yet,heh
bitmap
guess so
Mr_Monkey
I guess so.
CatQuest
reosarevok: you've actually added quite a lot of BB-tickets for things I was going to do (but ofcoursely you've enunciated yourself much more eloquently than I could ever)
ruaok
wow, that took pretty much 1.5 hours.
!m bitmap
BrainzBot
You're doing good work, bitmap!
bitmap
w00t
jlh
thanks for the hard work y'all!
Mr_Monkey
!m bitmap, smooth
BrainzBot
You're doing good work, bitmap, smooth!
c1e0 joined the channel
CatQuest
there should be a script that writes !m bitmap in the chhan every so often by default :P
<3
yvanzo
something like BrainzThanksBitmapBot?
CatQuest
:D
c1e0_ has quit
Freso
So given that you’ve just finished the db upgrade, do you want to call off meeting today? Otherwise we’re go in 12 min and I need to prepare. :)
zas
bitmap: did you restart telegraf on pink & floyd yet?
bitmap
nope, thanks for the reminder
I'll do it
done (though postgres-pink is still down for now)
zas
k, I'll recheck after a while if metrics are showing up
Freso
ruaok: Your call: meeting or no?
iliekcomputers
sentry is still down btw
rdswift
Can take down the banner on mb.o
Freso
Looks like there’s still some clean up going on, so maybe no?
*Sounds
CatQuest
Mr_Monkey: can we have a jira component "add/editing pages" (or add/editing interface) or similar?
Freso: personally I have nothing to report so...
(well other thna creating tickets and partying yesterday)
yvanzo
We want to know about the party.
CatQuest
17 Mai. look it up :P
Freso prepares for meeting until being told otherwise anyway
c1e0 has quit
bitmap
iliekcomputers: oh, I see what's wrong. will fix
cleo joined the channel
Freso
yvanzo: It was World Telecommunication and Information Society Day yesterday, clearly a day of much rejoicing.
People up for reviews: pristine__, Freso, reosarevok, zas, yvanzo, alastairp, bitmap, ruaok, Mr_Monkey, ishaanshah[m], shivam-kapila, Cyna[m], _lucifer – anyone else who wants to give a review, please let me know ASAP!
pristine__: Go!
alastairp
cool, if that's possible then that'd be a great future improvement
CatQuest
...
Freso
No pristine__? reosarevok, go!
reosarevok
Hi!
CatQuest
hi
reosarevok
Last week I mostly worked on making it so that when a URL is rejected as a relationship
The user is actually told why in cases that can be confusing
"why can't I add this allmusic link on the release" "why can't I add a bandcamp album to the artist" etc
That's the main thing, although I also did some refactoring and whatnot and some reviews
CatQuest: wanna go at all? If not Freso
CatQuest
hi
I don't have anything except adding tickets for BB (and commenting on reosarevoks tickets :P) and aprtying yesterday
partying*
next freso?
Freso
🙋
Spent a good chunk of time looking into and dealing with reported editors. Also was around and about.
fin.
zas: Go!
zas
Hey
Not much to say, usual supervision, upgrades and maintenance
also reviewed a lot of Picard PRs stuff (mainly an incoming patch that will boost UI reactivity)
fin. yvanzo ?
yvanzo
Hi!
Last week, I published the first release of MusicBrainz Docker Compose files.
Freso
(People still up for reviews: alastairp, bitmap, ruaok, Mr_Monkey, ishaanshah[m], shivam-kapila, Cyna[m], _lucifer – anyone else who wants to give a review, please let me know ASAP!)