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
2023-09-26 26958, 2023
monkey
"opts to go around its elbow to get to its thumb" <3
2023-09-26 26919, 2023
opal
the funnier thing here is how LB does do its own lookup server-side if that info is missing
2023-09-26 26926, 2023
opal
so that kinda pisses me off the rust impl is even doing that
2023-09-26 26931, 2023
mayhem
that page of LB enabled apps is finally no longer depressing. great to see that. :)
Well, I do hope they don't weigh the hand luggage :P But they barely ever do
2023-09-26 26902, 2023
kurumi has quit
2023-09-26 26905, 2023
fletchto99 has quit
2023-09-26 26940, 2023
fletchto99 joined the channel
2023-09-26 26944, 2023
outsidecontext
if it's still too much chocolate you just need to eat it right at the checkin until it fits
2023-09-26 26912, 2023
reosarevok
It is known
2023-09-26 26904, 2023
fletchto99 has quit
2023-09-26 26915, 2023
mayhem
swiss weighs them in ZRH -- at least prior to the pandemic.
2023-09-26 26900, 2023
mayhem
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.
2023-09-26 26912, 2023
mayhem
totes not speaking from experience, of course.
2023-09-26 26933, 2023
yvanzo
“anything to declare?” “just some brown powder, good product, casted into bars…”
2023-09-26 26937, 2023
reosarevok
yvanzo, bitmap: ping :)
2023-09-26 26942, 2023
yvanzo
pang
2023-09-26 26918, 2023
yvanzo
akshaaatt: thanks, I clarified it is about UI
2023-09-26 26909, 2023
opal
i had to pay $200 for a friend's overweight baggage simply because she was too disarrayed to, you know, pack a third bag
2023-09-26 26950, 2023
reosarevok
yvanzo: did you have anything in particular you wanted to check? :)
2023-09-26 26956, 2023
reosarevok
Or should we just look at stuff in general?
2023-09-26 26928, 2023
yvanzo
reosarevok: yes but it's not ready :x
2023-09-26 26936, 2023
reosarevok
haha
2023-09-26 26948, 2023
reosarevok
Well, we can wait a bit? How not-ready is it, an hour or a week? :D
2023-09-26 26953, 2023
yvanzo
let's review and merge as much as we can :)
2023-09-26 26930, 2023
yvanzo
if we freeze today and release on Monday, then we can merge anything during the summit.
2023-09-26 26914, 2023
Pratha-Fish
reosarevok: looks like there's an easy way out of the whole sql dumps :D
2023-09-26 26928, 2023
yvanzo
(unlikely to be today)
2023-09-26 26943, 2023
reosarevok
Sure
2023-09-26 26949, 2023
reosarevok
Pratha-Fish: oh?
2023-09-26 26959, 2023
Pratha-Fish
I can just dump the actual data from the tables instead of dumping the tables as well as their schema in the dump.
2023-09-26 26900, 2023
yvanzo
reosarevok: anything you particularly want us to check?
2023-09-26 26932, 2023
Pratha-Fish
The only issue is I woulnd't be able to test it on my current internet connection until around 2nd Oct
2023-09-26 26944, 2023
Pratha-Fish
Focussing on the query and transformation scripts RN :D
2023-09-26 26903, 2023
reosarevok
yvanzo: I think "small things now, bigger things in person where we can hack at them" might make sense?
2023-09-26 26913, 2023
reosarevok
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
2023-09-26 26959, 2023
reosarevok
Why?
2023-09-26 26912, 2023
reosarevok
I thought the idea was to have a basic area DB you could test stuff against
2023-09-26 26937, 2023
Pratha-Fish
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
2023-09-26 26955, 2023
reosarevok
Hmm
2023-09-26 26907, 2023
Pratha-Fish
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
2023-09-26 26955, 2023
reosarevok
You'd still need to import things in the right order (area and url before l_area_url for example)
2023-09-26 26907, 2023
reosarevok
But maybe it'd work your way, might as well try I guess
2023-09-26 26921, 2023
Pratha-Fish
Let's give it a shot anyway :))
2023-09-26 26908, 2023
reosarevok
Just keep in mind that you want to add it in that order
2023-09-26 26918, 2023
reosarevok
area, url, link at least need to have the data in first
2023-09-26 26929, 2023
reosarevok
There might be ID conflicts though, but I guess you can try
2023-09-26 26905, 2023
Pratha-Fish
Sure, I'll try it out
2023-09-26 26927, 2023
Pratha-Fish
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 🥲
2023-09-26 26926, 2023
outsidecontext
is something up with the spotify import for LB? It hasn't imported any listens today so far for me
disconnect your spotify service and reconnect, outsidecontext
2023-09-26 26917, 2023
mayhem
we really need to have LB notifications so that we can tell users that there was a hiccup.
2023-09-26 26905, 2023
outsidecontext
I set it to "disabled" and back to "Activate both". let's see if this heals it
2023-09-26 26940, 2023
outsidecontext
mayhem: all listens from today just got imported! thanks for the help
2023-09-26 26905, 2023
outsidecontext
I'll remember to try this reconnect should this happen again
2023-09-26 26907, 2023
mayhem
`2023-09-26 14:44:14,673 listenbrainz.webserver INFO imported 50 listens for outsidecontext`
2023-09-26 26910, 2023
mayhem
indeed. P)
2023-09-26 26945, 2023
Pratha-Fish
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?
2023-09-26 26938, 2023
Pratha-Fish
Here's the error I am getting BTW
2023-09-26 26910, 2023
Pratha-Fish
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
reosarevok: nothing much. only the invalid command \n errors throughout
2023-09-26 26956, 2023
Pratha-Fish
The snippet I posted was just the tail of it
2023-09-26 26922, 2023
reosarevok
Apparently the first line of all is the real error, and then \N is crap (see stack)
2023-09-26 26929, 2023
reosarevok
admin/sql/DropFKConstraints.sql drops all FKs fwiw
2023-09-26 26944, 2023
reosarevok
(we have similar files for other constraints if needed)
2023-09-26 26941, 2023
Pratha-Fish
nice!
2023-09-26 26943, 2023
reosarevok
Worst case scenario, by the 2nd we'll all be in BCN together and can try to figure out something for you, though
2023-09-26 26949, 2023
reosarevok
If none of all this works
2023-09-26 26918, 2023
Pratha-Fish
I'll try my best to figure it out if possible! But yes, if you guys can figure something out, it would be great :)
2023-09-26 26907, 2023
lucifer
Pratha-Fish: you need to use pg_restore to restore the dump
2023-09-26 26912, 2023
Pratha-Fish
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
2023-09-26 26917, 2023
Pratha-Fish
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
2023-09-26 26920, 2023
Pratha-Fish
I'll try once again tho
2023-09-26 26911, 2023
lucifer
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
2023-09-26 26943, 2023
Pratha-Fish
lucifer: For this particular command: `pg_restore -d mb_area pg_area_dump.sql`
2023-09-26 26943, 2023
Pratha-Fish
I am getting this error: `pg_restore: error: input file appears to be a text format dump. Please use psql.`
