#metabrainz

/

      • zas
        bitmap: use ncdu , if not installed, just apt it
      • 2020-05-18 13934, 2020

      • ZaphodBeeblebrox is now known as CatQuest
      • 2020-05-18 13936, 2020

      • bitmap
        zas: magic, thanks :)
      • 2020-05-18 13959, 2020

      • bitmap
        /root/pgdata-bowie is the culprit then
      • 2020-05-18 13915, 2020

      • bitmap
        pretty sure we can remove that now
      • 2020-05-18 13947, 2020

      • 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-server…
      • 2020-05-18 13926, 2020

      • yvanzo
        I can drop MB VMs (~25G) from ftp if that helps too.
      • 2020-05-18 13911, 2020

      • alastairp
        tykling_: huh, I didn't know that invocation, cool! I always did it manually
      • 2020-05-18 13926, 2020

      • bitmap
        yvanzo: should be good now, was mainly just a space oddity on bowie
      • 2020-05-18 13945, 2020

      • MusicbrainzB0T joined the channel
      • 2020-05-18 13910, 2020

      • 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.
      • 2020-05-18 13947, 2020

      • ishaanshah[m]
        iliekcomputers: Hi
      • 2020-05-18 13906, 2020

      • iliekcomputers
        Hey
      • 2020-05-18 13906, 2020

      • ishaanshah[m]
        No questions as such
      • 2020-05-18 13916, 2020

      • ishaanshah[m]
        Just wanted to update you
      • 2020-05-18 13922, 2020

      • MusicbrainzB0T2 has quit
      • 2020-05-18 13912, 2020

      • ishaanshah[m]
        I have addressed your comments on the PR
      • 2020-05-18 13920, 2020

      • bitmap
        looks like our cluster grew ~19G since the bowie switch then
      • 2020-05-18 13940, 2020

      • iliekcomputers
        ishaanshah[m]: oh awesome.
      • 2020-05-18 13942, 2020

      • ishaanshah[m]
        Fixed the integration and unit tests for LB
      • 2020-05-18 13902, 2020

      • ishaanshah[m]
        I am now working on fixing the spark tests
      • 2020-05-18 13925, 2020

      • ishaanshah[m]
        Should be done in an hour or two
      • 2020-05-18 13926, 2020

      • iliekcomputers
        OK, great! I'll review it today.
      • 2020-05-18 13938, 2020

      • travis-ci joined the channel
      • 2020-05-18 13938, 2020

      • travis-ci
        Project bookbrainz-site build #2970: errored in 1 min 23 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13938, 2020

      • travis-ci has left the channel
      • 2020-05-18 13945, 2020

      • ruaok
        > was mainly just a space oddity on bowie
      • 2020-05-18 13947, 2020

      • ishaanshah[m]
        Also sorry for the huge PR
      • 2020-05-18 13949, 2020

      • ruaok
        👏
      • 2020-05-18 13953, 2020

      • ruaok
        well done!
      • 2020-05-18 13907, 2020

      • ishaanshah[m]
        I had to change the test data again
      • 2020-05-18 13925, 2020

      • iliekcomputers
        ishaanshah[m]: no worries. I think it's understandable.
      • 2020-05-18 13950, 2020

      • iliekcomputers
        I'd add a lot of tests to your timestamp functions, the ones which calculate the time range of data to query on
      • 2020-05-18 13925, 2020

      • ishaanshah[m]
        Yes, I am thinking of creating a testdata folder for spark too
      • 2020-05-18 13910, 2020

      • iliekcomputers
        OK, awesome.
      • 2020-05-18 13930, 2020

      • ishaanshah[m]
        Also I found a much easier way to update the jsonb
      • 2020-05-18 13935, 2020

      • c1e0 joined the channel
      • 2020-05-18 13950, 2020

      • ishaanshah[m]
        The query is not as complicated as before now
      • 2020-05-18 13937, 2020

      • bitmap
        whoops, s/on/from/ lol
      • 2020-05-18 13941, 2020

      • ishaanshah[m]
        I will branch off the current PR and update the API endpoint
      • 2020-05-18 13909, 2020

      • iliekcomputers
        Great, yeah, that sounds reasonable.
      • 2020-05-18 13900, 2020

      • ishaanshah[m]
        Great, thats all I had for today, thanks :D
      • 2020-05-18 13906, 2020

      • iliekcomputers
        I'm really excited about releasing this!
      • 2020-05-18 13910, 2020

      • iliekcomputers
        Nice work. :)
      • 2020-05-18 13921, 2020

      • ishaanshah[m]
        Yep, me too :D
      • 2020-05-18 13926, 2020

      • Mr_Monkey
        Has anyone got experience with PG12 + travis, specifically authenticating with user 'postgres' and no password?
      • 2020-05-18 13913, 2020

      • ruaok
        set a password.
      • 2020-05-18 13927, 2020

      • ruaok
        I've given up trying to get auth with no password to work.
      • 2020-05-18 13947, 2020

      • Mr_Monkey
        Ah? That's a pain.
      • 2020-05-18 13901, 2020

      • bitmap
        if you can change pg_hba.conf there, replacing the entire contents of that file with "local all all trust" may work
      • 2020-05-18 13918, 2020

      • Mr_Monkey
        I was just reading the 'trust' configuration
      • 2020-05-18 13926, 2020

      • bitmap
        (should be fine for a test env)
      • 2020-05-18 13952, 2020

      • Mr_Monkey
        And restarting pg after changing the file, I assume?
      • 2020-05-18 13914, 2020

      • Mr_Monkey
        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.
      • 2020-05-18 13941, 2020

      • bitmap
        yeah, restarting pg or SIGHUP should work
      • 2020-05-18 13947, 2020

      • Mr_Monkey
        Thanks.
      • 2020-05-18 13925, 2020

      • Mr_Monkey
        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/blo…
      • 2020-05-18 13903, 2020

      • alastairp
        ruaok: we were going to talk about project priorities this afternoon, but with upgrade perhaps it's not the best time?
      • 2020-05-18 13929, 2020

      • shivam-kapila
        \
      • 2020-05-18 13915, 2020

      • jmp_music has quit
      • 2020-05-18 13954, 2020

      • bitmap
        yvanzo: you're still taking care of updating https://github.com/metabrainz/musicbrainz-docker/… right?
      • 2020-05-18 13909, 2020

      • bitmap
        lmk if I should look into it, I plan to include this in the blog instructions today
      • 2020-05-18 13924, 2020

      • CatQuest
        bleh. I wish we had a separate proj. for bookbrainz(style)
      • 2020-05-18 13955, 2020

      • CatQuest
        since we have a separate style for mb, doesnt that make sense?
      • 2020-05-18 13928, 2020

      • reosarevok
        I guess it would make sense once there's a community to use it :D
      • 2020-05-18 13903, 2020

      • 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
      • 2020-05-18 13906, 2020

      • CatQuest
        i mean i guess
      • 2020-05-18 13920, 2020

      • ruaok
        alastairp: let's do it tomorrow, shall we?
      • 2020-05-18 13921, 2020

      • CatQuest
        (I also feel dodgy about creating "style" tickets now)
      • 2020-05-18 13941, 2020

      • CatQuest
        tere are already several
      • 2020-05-18 13943, 2020

      • reosarevok
        I mean, right now style is also run by the devs :)
      • 2020-05-18 13949, 2020

      • reosarevok
        So they should see both, no?
      • 2020-05-18 13950, 2020

      • CatQuest
        exactly
      • 2020-05-18 13956, 2020

      • CatQuest
        yeh. i guess
      • 2020-05-18 13958, 2020

      • reosarevok
        Until they have a separate process for that
      • 2020-05-18 13915, 2020

      • CatQuest
        but also i feel most style tickets will be moot once site is up and out of alpha-beta
      • 2020-05-18 13926, 2020

      • alastairp
        ruaok: fine by me
      • 2020-05-18 13944, 2020

      • CatQuest
        reosarevok: i fig i'm part of this "they" in your sentence .. idk?
      • 2020-05-18 13921, 2020

      • 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
      • 2020-05-18 13933, 2020

      • reosarevok
        Whether it is "all goes to a vote" or "the dev team chooses" or something else :)
      • 2020-05-18 13937, 2020

      • CatQuest
        i have a ticket up like that already infact :D
      • 2020-05-18 13927, 2020

      • CatQuest
        I fear i am slowly fixing myself up to become "style-dude of bb" wich is.. a lot of work? :DDD
      • 2020-05-18 13950, 2020

      • yvanzo
        bitmap: Yes, I'm reworking Dockerfile a bit at the same time.
      • 2020-05-18 13926, 2020

      • 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.
      • 2020-05-18 13933, 2020

      • alastairp
        oh yeah, it'll be interesting to see how long these types of aggregate/stats queries will take to run
      • 2020-05-18 13948, 2020

      • bitmap
        yvanzo: maybe the Dockerfile rework can wait until after? :) or will it be ready by the time the upgrade is done?
      • 2020-05-18 13948, 2020

      • yvanzo
        bitmap: it is, will push it.
      • 2020-05-18 13905, 2020

      • bitmap
        thx
      • 2020-05-18 13905, 2020

      • yvanzo
        (just needed to test it locally to be safe)
      • 2020-05-18 13929, 2020

      • yvanzo
        bitmap: btw, should we draft some blog posts already?
      • 2020-05-18 13936, 2020

      • bitmap
        just didn't want to have to tell people to checkout some pr in the blog
      • 2020-05-18 13948, 2020

      • bitmap
        I'm working on the upgrade instructions one already
      • 2020-05-18 13905, 2020

      • bitmap
        should be ready for review soon
      • 2020-05-18 13940, 2020

      • yvanzo
        bitmap: will musicbrainz-server be tagged v-2020-05-18-postgres12 (as we use to prefix noticeable release like schema change)?
      • 2020-05-18 13901, 2020

      • yvanzo
        (or -pg12 or nothing)
      • 2020-05-18 13908, 2020

      • bitmap
        we could do that
      • 2020-05-18 13920, 2020

      • bitmap
        -postgres12 worksforme
      • 2020-05-18 13934, 2020

      • yvanzo
        +1
      • 2020-05-18 13956, 2020

      • yvanzo
        will use that in musicbrainz-docker then
      • 2020-05-18 13918, 2020

      • bitmap
        yep, I"m updating references in the blog to use v-2020-05-18-postgres12
      • 2020-05-18 13919, 2020

      • cloverfield has quit
      • 2020-05-18 13956, 2020

      • cloverfield joined the channel
      • 2020-05-18 13903, 2020

      • bitmap wonders if there's a "non-inline" code block in wordpress or any way to change the font
      • 2020-05-18 13908, 2020

      • bitmap
        nvm I figured out how to switch to the code editor
      • 2020-05-18 13942, 2020

      • reosarevok
        Tweeted, set banner
      • 2020-05-18 13957, 2020

      • bitmap
        I started a barman backup of floyd about 20 mins ago
      • 2020-05-18 13924, 2020

      • ishaanshah[m]
        iliekcomputers: I couldn't get the spark tests done, I will do that first thing tomorrow
      • 2020-05-18 13903, 2020

      • sumedh joined the channel
      • 2020-05-18 13946, 2020

      • iliekcomputers
        no worries.
      • 2020-05-18 13905, 2020

      • iliekcomputers
        i'll still review the PR today.
      • 2020-05-18 13959, 2020

      • travis-ci joined the channel
      • 2020-05-18 13959, 2020

      • travis-ci
        Project bookbrainz-site build #2973: errored in 1 min 35 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13959, 2020

      • travis-ci has left the channel
      • 2020-05-18 13952, 2020

      • travis-ci joined the channel
      • 2020-05-18 13952, 2020

      • travis-ci
        Project bookbrainz-site build #2974: errored in 1 min 26 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13952, 2020

      • travis-ci has left the channel
      • 2020-05-18 13937, 2020

      • reosarevok
        Freso, ruaok: FWIW we seem to have 29495 rows on a query of email addresses used by 2 or more editors
      • 2020-05-18 13910, 2020

      • ruaok
        oh fun.
      • 2020-05-18 13947, 2020

      • ruaok
        lol
      • 2020-05-18 13955, 2020

      • travis-ci joined the channel
      • 2020-05-18 13955, 2020

      • travis-ci
        Project bookbrainz-site build #2976: failed in 2 min 49 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13955, 2020

      • travis-ci has left the channel
      • 2020-05-18 13930, 2020

      • 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)
      • 2020-05-18 13932, 2020

      • c1e0_ joined the channel
      • 2020-05-18 13904, 2020

      • v6lur_ joined the channel
      • 2020-05-18 13941, 2020

      • reosarevok
        bitmap: are we already stopping the cron jobs etc?
      • 2020-05-18 13945, 2020

      • bitmap
        yvanzo: I have a rough draft of the upgrade instructions blog post. the docker section could probably use some help
      • 2020-05-18 13959, 2020

      • bitmap
        reosarevok: yup, doing that now
      • 2020-05-18 13911, 2020

      • reosarevok
        Ok, just strikethrough what is done on the gdoc I guess :)
      • 2020-05-18 13941, 2020

      • reosarevok
        (why the hell did they make strikethrough so complicated - alt shift 5, wtf? :D )
      • 2020-05-18 13952, 2020

      • c1e0 has quit
      • 2020-05-18 13958, 2020

      • c1e0 joined the channel
      • 2020-05-18 13921, 2020

      • bitmap
        cmd+shift+x for me :)
      • 2020-05-18 13927, 2020

      • Kode is now known as Guest2078
      • 2020-05-18 13927, 2020

      • Guest2078 has quit
      • 2020-05-18 13935, 2020

      • Kode_ joined the channel
      • 2020-05-18 13928, 2020

      • c1e0_ has quit
      • 2020-05-18 13940, 2020

      • travis-ci joined the channel
      • 2020-05-18 13940, 2020

      • travis-ci
        Project bookbrainz-site build #2977: failed in 2 min 38 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13940, 2020

      • travis-ci has left the channel
      • 2020-05-18 13922, 2020

      • BrainzGit
        [musicbrainz-server] mwiencek merged pull request #1493 (master…pg12): PostgreSQL 12 changes https://github.com/metabrainz/musicbrainz-server/…
      • 2020-05-18 13911, 2020

      • travis-ci joined the channel
      • 2020-05-18 13911, 2020

      • travis-ci
        Project bookbrainz-site build #2979: passed in 2 min 48 sec: https://travis-ci.org/bookbrainz/bookbrainz-site/…
      • 2020-05-18 13911, 2020

      • travis-ci has left the channel
      • 2020-05-18 13925, 2020

      • 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`
      • 2020-05-18 13946, 2020

      • bitmap
        nice
      • 2020-05-18 13924, 2020

      • BrainzGit
        [bookbrainz-site] MonkeyDo opened pull request #426 (master…pg-12-update): chore: Update to Postgres 12 https://github.com/bookbrainz/bookbrainz-site/pul…
      • 2020-05-18 13908, 2020

      • reosarevok
        "cpanm --install Devel::GlobalDestruction"
      • 2020-05-18 13912, 2020

      • reosarevok
        Not ominous at all
      • 2020-05-18 13901, 2020

      • yvanzo
        bitmap: “This block contains unexpected or invalid content” is intended?