#metabrainz

livestream overlay is good to go. Can’t wait for technical issues to muck it up! https://usercontent.irccloud-cdn.com/file/I4Kia...

oops, chat window does actually show IRC https://usercontent.irccloud-cdn.com/file/ZG6M5...

fish

I've just added EAA and BB CAA to the summit agenda with the names of the people who I feel should be involved. Feel free to add or remove yourself :)

bitmap, reosarevok, yvanzo I added a hack session to fix MB PRs

The display ones specifically you mean, right?

mayhem: Yep, doable with a title element: https://usercontent.irccloud-cdn.com/file/HEMuB...

i.e. native browser tooltip

O H OH OHOHOHOHOHOHH YISSS! <3

https://tickets.metabrainz.org/browse/LB-1354 is the "follow" API endpoint still available so i could e.g. just curl it for now

LB-1354: follow button has disappeared from the user page

(im looking through source code for listenbrainz-server meanwhile)

https://api.listenbrainz.org/1/user/Thrall317/f... seems like

sounds about right.

Hi opal, yes you should be able to hit the API endpoint. That being said, the missing button issue has been fixed, it is just waiting to be deployed

Which we can do now :)

nice

good plan, monkey

[listenbrainz-server] release 03v-2023-09-26.0 has been published by 14github-actions[bot]: https://github.com/metabrainz/listenbrainz-serv...

:D

opal: New version deployed, follow button is back, sorry for the trouble.

!m monkey

You're doing good work, monkey!

no problem, someone else noticed it for me haha

now i just have to patch wylt to fix https://github.com/hirigaray/wylt/issues/5 so we get MBIDs with submissions

Nice!

Just checked to make sure wylt is in this list: https://listenbrainz.org/add-data/

apparently the rust implementation listenbrainz-mpd opts to go around its elbow to get to its thumb by making an api request, when mpd already exports MBIDs in metadata so we can just query that instead, lol

"opts to go around its elbow to get to its thumb" <3

the funnier thing here is how LB does do its own lookup server-side if that info is missing

so that kinda pisses me off the rust impl is even doing that

that page of LB enabled apps is finally no longer depressing. great to see that. :)

>Inspect listen

oh thats a nice feature

[listenbrainz-server] 14phw opened pull request #2587 (03master…extend-app-list): Extend LB supporting app list https://github.com/metabrainz/listenbrainz-serv...

reosarevok: is support at had a phone line, I think the hold song should be: https://musicbrainz.org/recording/64c3ea30-d288...

(it has a refrain of "what the fuck is wrong with you?")

:D

Good old last minute "oh, wait, I do *not* have checked luggage for this trip" :D

Well, I think it'll all fit anyway

then you didn't buy enough chocolate. :)

I always have to move some bars from the suitcase to hand luggage. .7Kg over? move 7 bars, good to go.

[listenbrainz-server] 14mayhem merged pull request #2587 (03master…extend-app-list): Extend LB supporting app list https://github.com/metabrainz/listenbrainz-serv...

Well, I do hope they don't weigh the hand luggage :P But they barely ever do

if it's still too much chocolate you just need to eat it right at the checkin until it fits

It is known

swiss weighs them in ZRH -- at least prior to the pandemic.

there is a very simple solution: when you see the dude with the scale appear, walk to the next gate and watch for the actual boarding process to start. once people start boarding, the guy takes off, so then its safe to return.

totes not speaking from experience, of course.

“anything to declare?” “just some brown powder, good product, casted into bars…”

yvanzo, bitmap: ping :)

pang

akshaaatt: thanks, I clarified it is about UI

i had to pay $200 for a friend's overweight baggage simply because she was too disarrayed to, you know, pack a third bag

yvanzo: did you have anything in particular you wanted to check? :)

Or should we just look at stuff in general?

reosarevok: yes but it's not ready :x

haha

Well, we can wait a bit? How not-ready is it, an hour or a week? :D

let's review and merge as much as we can :)

if we freeze today and release on Monday, then we can merge anything during the summit.

reosarevok: looks like there's an easy way out of the whole sql dumps :D

(unlikely to be today)

Sure

Pratha-Fish: oh?

I can just dump the actual data from the tables instead of dumping the tables as well as their schema in the dump.

reosarevok: anything you particularly want us to check?

The only issue is I woulnd't be able to test it on my current internet connection until around 2nd Oct

Focussing on the query and transformation scripts RN :D

yvanzo: I think "small things now, bigger things in person where we can hack at them" might make sense?

Pratha-Fish: it didn't import on an empty DB either?

👍

reosarevok: I didn't try importing in an empty db as it would just beat the purpose of it all :D

Why?

I thought the idea was to have a basic area DB you could test stuff against

like, just setting up the areas wouldn't have enabled the musicbrainz server to run on it. Yes, we could query areas from it, but adding and verifying areas would've been a mess

Hmm

But now that you mention it, we don't really have to check if the add_area functionality works or not, as it's already being tested in the musicbrainz_bot

You'd still need to import things in the right order (area and url before l_area_url for example)

But maybe it'd work your way, might as well try I guess

Let's give it a shot anyway :))

Just keep in mind that you want to add it in that order

area, url, link at least need to have the data in first

There might be ID conflicts though, but I guess you can try

Sure, I'll try it out

Not sure if I'd be able to reorder all the SQL commands in the dump tho. It's too big to even open in VSCode 🥲

is something up with the spotify import for LB? It hasn't imported any listens today so far for me

yvanzo: answered your comment. Similarly small are https://github.com/metabrainz/musicbrainz-serve... and https://github.com/metabrainz/musicbrainz-serve...

(from that same set of chaban comments)

outsidecontext: let me watch the logs, but at first glance seems ok.

I hadn't listened much, but a few 8 hours ago and right now for the last 20 minutes or so. but last import is from yesterday eveneing

evening

could also be some spotify issue of course and listens not showing up in their history

ah, no there was an error thrown for your account.

disconnect your spotify service and reconnect, outsidecontext

we really need to have LB notifications so that we can tell users that there was a hiccup.

I set it to "disabled" and back to "Activate both". let's see if this heals it

mayhem: all listens from today just got imported! thanks for the help

I'll remember to try this reconnect should this happen again

`2023-09-26 14:44:14,673 listenbrainz.webserver INFO imported 50 listens for outsidecontext`

indeed. P)

reosarevok: apparently the dump ain't importing even on an empty db. There's no way to run the schema commands sequentially as the file is just too large to edit

Did you try with the deactivating of the foreign keys?

Here's the error I am getting BTW

reosarevok: I tried the foreign key method as well, but apparently there isn't a single "foreign key" switch that turns off fk constraints for all tables

You have to do it manually for all tables

Anything before it?

reosarevok: nothing much. only the invalid command \n errors throughout

The snippet I posted was just the tail of it

Apparently the first line of all is the real error, and then \N is crap (see stack)

admin/sql/DropFKConstraints.sql drops all FKs fwiw

(we have similar files for other constraints if needed)

nice!

Worst case scenario, by the 2nd we'll all be in BCN together and can try to figure out something for you, though

If none of all this works

I'll try my best to figure it out if possible! But yes, if you guys can figure something out, it would be great :)

Pratha-Fish: you need to use pg_restore to restore the dump

I think I had also setup some other flags while making the dumps. Specifying the relevant options relating to those flags on import could help too

lucifer: I read somewhere you've to restore .sql files with psql or something, as restoring with pg_restore didn't work the last time I tried

I'll try once again tho

Pratha-Fish: the dump you at least the command i shared can't be restored using psql because its not sql statement dumps. you need to create a different kind of dump for that

lucifer: For this particular command: `pg_restore -d mb_area pg_area_dump.sql`

I am getting this error: `pg_restore: error: input file appears to be a text format dump. Please use psql.`

Here's the script that I used to dump the table's for reference