#metabrainz

/

      • zas
        bitmap: use ncdu , if not installed, just apt it
      • ZaphodBeeblebrox is now known as CatQuest
      • bitmap
        zas: magic, thanks :)
      • /root/pgdata-bowie is the culprit then
      • pretty sure we can remove that now
      • BrainzGit
        [listenbrainz-server] mayhem merged pull request #862 (master…public-array-sort): Schema-qualify a reference to public.array_sort https://github.com/metabrainz/listenbrainz-serv...
      • yvanzo
        I can drop MB VMs (~25G) from ftp if that helps too.
      • alastairp
        tykling_: huh, I didn't know that invocation, cool! I always did it manually
      • bitmap
        yvanzo: should be good now, was mainly just a space oddity on bowie
      • MusicbrainzB0T joined the channel
      • iliekcomputers
        ishaanshah[m]: I'm around right now if you have any questions or anything. Don't think I'll be able to make anytime before 5 GMT.
      • ishaanshah[m]
        iliekcomputers: Hi
      • iliekcomputers
        Hey
      • ishaanshah[m]
        No questions as such
      • Just wanted to update you
      • MusicbrainzB0T2 has quit
      • I have addressed your comments on the PR
      • bitmap
        looks like our cluster grew ~19G since the bowie switch then
      • iliekcomputers
        ishaanshah[m]: oh awesome.
      • ishaanshah[m]
        Fixed the integration and unit tests for LB
      • I am now working on fixing the spark tests
      • Should be done in an hour or two
      • iliekcomputers
        OK, great! I'll review it today.
      • travis-ci joined the channel
      • travis-ci
        Project bookbrainz-site build #2970: errored in 1 min 23 sec: https://travis-ci.org/bookbrainz/bookbrainz-sit...
      • travis-ci has left the channel
      • ruaok
        > was mainly just a space oddity on bowie
      • ishaanshah[m]
        Also sorry for the huge PR
      • ruaok
        👏
      • well done!
      • ishaanshah[m]
        I had to change the test data again
      • iliekcomputers
        ishaanshah[m]: no worries. I think it's understandable.
      • I'd add a lot of tests to your timestamp functions, the ones which calculate the time range of data to query on
      • ishaanshah[m]
        Yes, I am thinking of creating a testdata folder for spark too
      • iliekcomputers
        OK, awesome.
      • ishaanshah[m]
        Also I found a much easier way to update the jsonb
      • c1e0 joined the channel
      • The query is not as complicated as before now
      • bitmap
        whoops, s/on/from/ lol
      • ishaanshah[m]
        I will branch off the current PR and update the API endpoint
      • iliekcomputers
        Great, yeah, that sounds reasonable.
      • ishaanshah[m]
        Great, thats all I had for today, thanks :D
      • iliekcomputers
        I'm really excited about releasing this!
      • Nice work. :)
      • ishaanshah[m]
        Yep, me too :D
      • Mr_Monkey
        Has anyone got experience with PG12 + travis, specifically authenticating with user 'postgres' and no password?
      • ruaok
        set a password.
      • I've given up trying to get auth with no password to work.
      • Mr_Monkey
        Ah? That's a pain.
      • bitmap
        if you can change pg_hba.conf there, replacing the entire contents of that file with "local all all trust" may work
      • Mr_Monkey
        I was just reading the 'trust' configuration
      • bitmap
        (should be fine for a test env)
      • Mr_Monkey
        And restarting pg after changing the file, I assume?
      • Also, is there really a point in specifying v12 (until travis has better support)? There was no difference in setup or tests between v9 and v12.
      • bitmap
        yeah, restarting pg or SIGHUP should work
      • Mr_Monkey
        Thanks.
      • prabal: I think you forgot to push on PR 423. Still have 'collection' in entity-editor/name-section/actions.js : https://github.com/bookbrainz/bookbrainz-site/b...
      • alastairp
        ruaok: we were going to talk about project priorities this afternoon, but with upgrade perhaps it's not the best time?
      • shivam-kapila
        \
      • jmp_music has quit
      • bitmap
        yvanzo: you're still taking care of updating https://github.com/metabrainz/musicbrainz-docke... right?
      • lmk if I should look into it, I plan to include this in the blog instructions today
      • CatQuest
        bleh. I wish we had a separate proj. for bookbrainz(style)
      • since we have a separate style for mb, doesnt that make sense?
      • reosarevok
        I guess it would make sense once there's a community to use it :D
      • CatQuest
        it'd make sense now cause it'd be easier for devs to look at open ticket list and not need to filre out "style" tickets
      • i mean i guess
      • ruaok
        alastairp: let's do it tomorrow, shall we?
      • CatQuest
        (I also feel dodgy about creating "style" tickets now)
      • tere are already several
      • reosarevok
        I mean, right now style is also run by the devs :)
      • So they should see both, no?
      • CatQuest
        exactly
      • yeh. i guess
      • reosarevok
        Until they have a separate process for that
      • CatQuest
        but also i feel most style tickets will be moot once site is up and out of alpha-beta
      • alastairp
        ruaok: fine by me
      • CatQuest
        reosarevok: i fig i'm part of this "they" in your sentence .. idk?
      • reosarevok
        Well, I expect the BB team will want (with the input of the community, which nowadays is probably mostly you :p) to select a way to do style stuff
      • Whether it is "all goes to a vote" or "the dev team chooses" or something else :)
      • CatQuest
        i have a ticket up like that already infact :D
      • I fear i am slowly fixing myself up to become "style-dude of bb" wich is.. a lot of work? :DDD
      • yvanzo
        bitmap: Yes, I'm reworking Dockerfile a bit at the same time.
      • ruaok
        alastairp: as we wait for things to happen today during the downtime, I'll try some artist histogram scripts on timescale. curious to see how long that would take.
      • alastairp
        oh yeah, it'll be interesting to see how long these types of aggregate/stats queries will take to run
      • bitmap
        yvanzo: maybe the Dockerfile rework can wait until after? :) or will it be ready by the time the upgrade is done?
      • yvanzo
        bitmap: it is, will push it.
      • bitmap
        thx
      • yvanzo
        (just needed to test it locally to be safe)
      • bitmap: btw, should we draft some blog posts already?
      • bitmap
        just didn't want to have to tell people to checkout some pr in the blog
      • I'm working on the upgrade instructions one already
      • should be ready for review soon
      • yvanzo
        bitmap: will musicbrainz-server be tagged v-2020-05-18-postgres12 (as we use to prefix noticeable release like schema change)?
      • (or -pg12 or nothing)
      • bitmap
        we could do that
      • -postgres12 worksforme
      • yvanzo
        +1
      • will use that in musicbrainz-docker then
      • bitmap
        yep, I"m updating references in the blog to use v-2020-05-18-postgres12
      • cloverfield has quit
      • cloverfield joined the channel
      • bitmap wonders if there's a "non-inline" code block in wordpress or any way to change the font
      • nvm I figured out how to switch to the code editor
      • reosarevok
        Tweeted, set banner
      • bitmap
        I started a barman backup of floyd about 20 mins ago
      • ishaanshah[m]
        iliekcomputers: I couldn't get the spark tests done, I will do that first thing tomorrow
      • sumedh joined the channel
      • iliekcomputers
        no worries.
      • i'll still review the PR today.
      • travis-ci joined the channel
      • travis-ci
        Project bookbrainz-site build #2973: errored in 1 min 35 sec: https://travis-ci.org/bookbrainz/bookbrainz-sit...
      • travis-ci has left the channel
      • travis-ci joined the channel
      • Project bookbrainz-site build #2974: errored in 1 min 26 sec: https://travis-ci.org/bookbrainz/bookbrainz-sit...
      • travis-ci has left the channel
      • reosarevok
        Freso, ruaok: FWIW we seem to have 29495 rows on a query of email addresses used by 2 or more editors
      • ruaok
        oh fun.
      • lol
      • travis-ci joined the channel
      • travis-ci
        Project bookbrainz-site build #2976: failed in 2 min 49 sec: https://travis-ci.org/bookbrainz/bookbrainz-sit...
      • travis-ci has left the channel
      • TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | GSoC students start here: https://bit.ly/2NUaxgb | Channel is logged; see https://musicbrainz.org/doc/IRC for details | Meeting agenda (today is "schema change" day, might not be a meeting—stay tuned!): Reviews, 2 accounts 1 email (reo)
      • c1e0_ joined the channel
      • v6lur_ joined the channel
      • reosarevok
        bitmap: are we already stopping the cron jobs etc?
      • bitmap
        yvanzo: I have a rough draft of the upgrade instructions blog post. the docker section could probably use some help
      • reosarevok: yup, doing that now
      • reosarevok
        Ok, just strikethrough what is done on the gdoc I guess :)
      • (why the hell did they make strikethrough so complicated - alt shift 5, wtf? :D )
      • c1e0 has quit
      • c1e0 joined the channel
      • bitmap
        cmd+shift+x for me :)
      • Kode is now known as Guest2078
      • Guest2078 has quit
      • Kode_ joined the channel
      • c1e0_ has quit
      • travis-ci joined the channel
      • travis-ci
        Project bookbrainz-site build #2977: failed in 2 min 38 sec: https://travis-ci.org/bookbrainz/bookbrainz-sit...
      • travis-ci has left the channel
      • BrainzGit
        [musicbrainz-server] mwiencek merged pull request #1493 (master…pg12): PostgreSQL 12 changes https://github.com/metabrainz/musicbrainz-serve...
      • travis-ci joined the channel
      • travis-ci
        Project bookbrainz-site build #2979: passed in 2 min 48 sec: https://travis-ci.org/bookbrainz/bookbrainz-sit...
      • travis-ci has left the channel
      • Mr_Monkey
        Thanks bitmap I ended up using a pg_hba.conf file: `- printf "local all all trust\nhost all all 127.0.0.1 trust" > pg_hba.conf`
      • bitmap
        nice
      • BrainzGit
        [bookbrainz-site] MonkeyDo opened pull request #426 (master…pg-12-update): chore: Update to Postgres 12 https://github.com/bookbrainz/bookbrainz-site/p...
      • reosarevok
        "cpanm --install Devel::GlobalDestruction"
      • Not ominous at all
      • yvanzo
        bitmap: “This block contains unexpected or invalid content” is intended?