#metabrainz

/

      • ashwanig has quit
      • 2018-03-31 09036, 2018

      • bukwurm has quit
      • 2018-03-31 09044, 2018

      • MajorLurker joined the channel
      • 2018-03-31 09000, 2018

      • MajorLurker has quit
      • 2018-03-31 09001, 2018

      • sentriz has quit
      • 2018-03-31 09050, 2018

      • ashwanig joined the channel
      • 2018-03-31 09000, 2018

      • Gazooo has quit
      • 2018-03-31 09003, 2018

      • Gazooo joined the channel
      • 2018-03-31 09014, 2018

      • github joined the channel
      • 2018-03-31 09014, 2018

      • github
        [picard] sambhav closed pull request #892: PICARD-1252: properly escape strings used to build a regexp (master...script_parse) https://git.io/vxrrz
      • 2018-03-31 09014, 2018

      • github has left the channel
      • 2018-03-31 09038, 2018

      • travis-ci joined the channel
      • 2018-03-31 09039, 2018

      • travis-ci
        metabrainz/picard#3397 (master - 942127f : Sambhav Kothari): The build passed.
      • 2018-03-31 09039, 2018

      • travis-ci
      • 2018-03-31 09039, 2018

      • travis-ci
      • 2018-03-31 09039, 2018

      • travis-ci has left the channel
      • 2018-03-31 09054, 2018

      • travis-ci joined the channel
      • 2018-03-31 09055, 2018

      • travis-ci
        metabrainz/picard#3397 (master - 942127f : Sambhav Kothari): The build passed.
      • 2018-03-31 09055, 2018

      • travis-ci
      • 2018-03-31 09055, 2018

      • travis-ci
      • 2018-03-31 09055, 2018

      • travis-ci has left the channel
      • 2018-03-31 09057, 2018

      • drsaunde has quit
      • 2018-03-31 09015, 2018

      • iliekcomputers
        ruaok: I get this when I try to ssh into the vm
      • 2018-03-31 09021, 2018

      • iliekcomputers
      • 2018-03-31 09003, 2018

      • bukwurm joined the channel
      • 2018-03-31 09045, 2018

      • ruaok
        Oh, that right it only allows key logins. Will fix soon, getting up in a minute.
      • 2018-03-31 09035, 2018

      • i7c has quit
      • 2018-03-31 09012, 2018

      • ruaok
        iliekcomputers: now fixing logins. does that script make sense?
      • 2018-03-31 09001, 2018

      • iliekcomputers
        ruaok: yes, i get the basic idea
      • 2018-03-31 09028, 2018

      • iliekcomputers
        would like to take a look at the data once
      • 2018-03-31 09049, 2018

      • ruaok
        coming right up
      • 2018-03-31 09025, 2018

      • ruaok
        try now
      • 2018-03-31 09044, 2018

      • ruaok
        ferbncode: you should upload an SSH key to github
      • 2018-03-31 09047, 2018

      • iliekcomputers
        ok, trying
      • 2018-03-31 09033, 2018

      • ruaok finds iliekcomputers MB key
      • 2018-03-31 09046, 2018

      • iliekcomputers
        ruaok: still getting the same
      • 2018-03-31 09047, 2018

      • ruaok
        didn't work, did it?
      • 2018-03-31 09055, 2018

      • ferbncode
        ruaok: okay, on it
      • 2018-03-31 09004, 2018

      • i7c joined the channel
      • 2018-03-31 09039, 2018

      • iliekcomputers
        ruaok: nope
      • 2018-03-31 09025, 2018

      • iliekcomputers
        ruaok: is password auth not possible considering it's just a temporary VM?
      • 2018-03-31 09032, 2018

      • ruaok
        passwd auth is not possible at all. I'm setting they key from the MeB server-setup
      • 2018-03-31 09015, 2018

      • iliekcomputers
        alright
      • 2018-03-31 09027, 2018

      • ruaok
        key ending in "RIP+iEw7cTlmR+B param@krypton" is in place.
      • 2018-03-31 09035, 2018

      • ferbncode
        ruaok: https://paste.ubuntu.com/p/pZTfWMjKbD/ (my ssh public key)
      • 2018-03-31 09013, 2018

      • iliekcomputers
        still getting the same `Permission denied (publickey)` error
      • 2018-03-31 09012, 2018

      • ruaok
        ok, removed accounts, readded param and ferbncode as per public keys.
      • 2018-03-31 09015, 2018

      • ruaok
        try again.
      • 2018-03-31 09021, 2018

      • ferbncode
        ruaok: works now, thanks
      • 2018-03-31 09047, 2018

      • ruaok
        iliekcomputers?
      • 2018-03-31 09054, 2018

      • iliekcomputers
        nope
      • 2018-03-31 09010, 2018

      • iliekcomputers
      • 2018-03-31 09011, 2018

      • iliekcomputers
        :/
      • 2018-03-31 09018, 2018

      • ruaok
        yep
      • 2018-03-31 09013, 2018

      • ruaok
        google cloud is weird in that if you ever try to set a passwd, the login seems to fail forever.
      • 2018-03-31 09051, 2018

      • ruaok
        I've now added a virgin account with name "iliekcomputers" and key ... RIP+iEw7cTlmR+B
      • 2018-03-31 09017, 2018

      • sentriz joined the channel
      • 2018-03-31 09040, 2018

      • iliekcomputers
      • 2018-03-31 09041, 2018

      • iliekcomputers
        :(
      • 2018-03-31 09059, 2018

      • iliekcomputers
        me and ferbncode are sitting in the same room, so it's okay if we want to move to better things to do
      • 2018-03-31 09034, 2018

      • ruaok
        let's do that.
      • 2018-03-31 09040, 2018

      • ruaok
        try running the script.
      • 2018-03-31 09053, 2018

      • ruaok
        meh, I didn't hit the save button.
      • 2018-03-31 09008, 2018

      • ruaok
        try the new account again, just for science.
      • 2018-03-31 09034, 2018

      • iliekcomputers
        got in
      • 2018-03-31 09036, 2018

      • iliekcomputers
        🎉
      • 2018-03-31 09005, 2018

      • iliekcomputers
        i ran it and it's logging a lot of stuff :-)
      • 2018-03-31 09021, 2018

      • ruaok
        loads and loads/
      • 2018-03-31 09031, 2018

      • ruaok
        it will fail making recommendations -- that is the first step to fix.
      • 2018-03-31 09049, 2018

      • ruaok
        I need to go food shopping -- I have nothing in the house.
      • 2018-03-31 09001, 2018

      • ruaok
        then I can get started on the cluster.
      • 2018-03-31 09015, 2018

      • iliekcomputers
        alright, we'll take a look at recommendations
      • 2018-03-31 09015, 2018

      • ruaok
        you two ok working on the part that does recommendations while I am out?
      • 2018-03-31 09019, 2018

      • ruaok
        kewl.
      • 2018-03-31 09020, 2018

      • iliekcomputers
        in the meanwhile
      • 2018-03-31 09021, 2018

      • ruaok
        bbiab
      • 2018-03-31 09033, 2018

      • iliekcomputers
        ✋🏽
      • 2018-03-31 09041, 2018

      • bukwurm
        LordSputnik: Any special reason to use camelcase in bb-data? Postgres uses case-insensitive identifiers with underscores, it simply converts camelcase to lower case.
      • 2018-03-31 09027, 2018

      • bukwurm
        That's an issue, because it reduces readability when I get raw query results.
      • 2018-03-31 09007, 2018

      • LordSputnik
        bukwurm: because when they end up as JS objects, we want them to be camelCase since that's the convention
      • 2018-03-31 09035, 2018

      • bukwurm
        LordSputnik: Ok
      • 2018-03-31 09010, 2018

      • bukwurm
        LordSputnik: Also,
      • 2018-03-31 09038, 2018

      • bukwurm
        > I was looking into adding raw queries into bb-data.
      • 2018-03-31 09038, 2018

      • bukwurm
        > raw queries are safe - http://knexjs.org/#Raw
      • 2018-03-31 09038, 2018

      • bukwurm
        > Moreover, knex.raw executes only one single query at a time
      • 2018-03-31 09038, 2018

      • bukwurm
        > However, I wanted to talk about query constructing.
      • 2018-03-31 09038, 2018

      • bukwurm
        > Will using `SELECT * FROM ${entity}` be ok or do I escape `entity`?
      • 2018-03-31 09038, 2018

      • bukwurm
        > It will all be escaped later, I think, when we run knex.raw.
      • 2018-03-31 09000, 2018

      • iliekcomputers
      • 2018-03-31 09003, 2018

      • iliekcomputers
        ruaok: ^^
      • 2018-03-31 09023, 2018

      • iliekcomputers
        ruaok: it says you'll like 'all i want for christmas is you' :D
      • 2018-03-31 09022, 2018

      • ruaok
        oh, lol.
      • 2018-03-31 09031, 2018

      • ruaok
        not sure if that is better than baseline. :)
      • 2018-03-31 09059, 2018

      • ruaok
        ok, great. that's progress already. :)
      • 2018-03-31 09016, 2018

      • ruaok
        so, in order to improve that we need to run all of the data.
      • 2018-03-31 09031, 2018

      • ruaok
        which is why we need to figure out how to load larger data sets and massage them.
      • 2018-03-31 09015, 2018

      • ruaok
        commit that code and let's move on to phase 2?
      • 2018-03-31 09024, 2018

      • iliekcomputers
        cool
      • 2018-03-31 09026, 2018

      • iliekcomputers
        one pr coming up
      • 2018-03-31 09045, 2018

      • ruaok
        don't worry about PRs for this codebase this weekend.
      • 2018-03-31 09048, 2018

      • ruaok
        just commit it.
      • 2018-03-31 09005, 2018

      • ruaok
        let me know if you don't have commit access, I haven't looked at perms closely.
      • 2018-03-31 09033, 2018

      • iliekcomputers
        okay
      • 2018-03-31 09010, 2018

      • bukwurm
        LordSputnik: Also, please could you add Immutable as dependency in the bb-data project and push to master? If I'll do it, it'll mess up the lock file with system specific dependencies. :)
      • 2018-03-31 09013, 2018

      • iliekcomputers
        ruaok: pushed to master
      • 2018-03-31 09015, 2018

      • bukwurm
        Updating knex in the lock file would also be a good idea, they've changed how raw queries return response (changed from simple tuple to js object)
      • 2018-03-31 09008, 2018

      • ruaok
        great. I'll start working on a getting a cluster going. can you two start working on load-data.py? that one should be pretty straightforward.
      • 2018-03-31 09058, 2018

      • iliekcomputers
        ruaok: load_data.py would just create a (user_id, recording_id, ts) RDD and persist it, yes?
      • 2018-03-31 09009, 2018

      • iliekcomputers
        from the LB dumps
      • 2018-03-31 09013, 2018

      • bukwurm
        That done, I'll be ready to send a PR which can extract the recent revisions and return Immutable object as `List [ Map { "editorName", "aliasName", "revisionId", "createdAt", "parentId", "action" }` as soon as I figure out how to test it. :D
      • 2018-03-31 09024, 2018

      • ruaok
        load-data just loads the data without transformations.
      • 2018-03-31 09041, 2018

      • ruaok
        prepare-data would do the user_id and recording_id transformations.
      • 2018-03-31 09008, 2018

      • ruaok
        not 100% certain they make sense in two steps, but I am guessing at a lot of things right now. :)
      • 2018-03-31 09004, 2018

      • iliekcomputers
      • 2018-03-31 09023, 2018

      • iliekcomputers
      • 2018-03-31 09029, 2018

      • ruaok
        zas: FYI: I'm going to rent 4 cloud instances on hetzner cloud for our recommendation project.
      • 2018-03-31 09058, 2018

      • Gazooo has quit
      • 2018-03-31 09037, 2018

      • Gazooo joined the channel
      • 2018-03-31 09014, 2018

      • CatQuest
        i thought we had a manko on more 'brainz :P
      • 2018-03-31 09015, 2018

      • iliekcomputers
        ruaok: we've lost electricity so taking a break for a bit 😅😅
      • 2018-03-31 09036, 2018

      • CatQuest
        #codinginindia
      • 2018-03-31 09036, 2018

      • CatQuest
        :P
      • 2018-03-31 09005, 2018

      • CatQuest
        hmm maybe also #coodingonamountaininnorwayduingstorms :D
      • 2018-03-31 09014, 2018

      • CatQuest
        but that's a bit long
      • 2018-03-31 09016, 2018

      • CatQuest
        :D
      • 2018-03-31 09016, 2018

      • iliekcomputers
        CatQuest: yep 😓
      • 2018-03-31 09022, 2018

      • CatQuest
        :D
      • 2018-03-31 09031, 2018

      • iliekcomputers
        No storms but codinginthemountains is accurate
      • 2018-03-31 09041, 2018

      • ruaok
        lol
      • 2018-03-31 09057, 2018

      • ruaok
        I've commissioned machines, but still trying to get logged in. :(
      • 2018-03-31 09039, 2018

      • CatQuest
        it's finally starting to spring here so I'm a bit delerious (also I am wondering how much flood is gonna happen soon (after all the mountains are so full of snow the gov are worried 😵))
      • 2018-03-31 09013, 2018

      • ruaok
        iliekcomputers: are you have to test a ssh login right now?
      • 2018-03-31 09018, 2018

      • iliekcomputers
        Yeah
      • 2018-03-31 09007, 2018

      • LordSputnik
        bukwurm: bit busy today and tomorrow so might have to wait until Monday, I'm afraid
      • 2018-03-31 09029, 2018

      • ruaok
        iliekcomputers: can you log into rec-master.listenbrainz.org ?
      • 2018-03-31 09038, 2018

      • ruaok
        it asks me for a password. :(
      • 2018-03-31 09045, 2018

      • ruaok
        should be for param@
      • 2018-03-31 09051, 2018

      • iliekcomputers
        Asks me for a password too
      • 2018-03-31 09058, 2018

      • ruaok
        k, thx
      • 2018-03-31 09003, 2018

      • bukwurm
        LordSputnik: No problem
      • 2018-03-31 09047, 2018

      • bukwurm
        I'll open PR which will work assuming Immutable and Knex (upgraded) are there :)
      • 2018-03-31 09016, 2018

      • LordSputnik
        bukwurm: ok, what are you working on at the moment?
      • 2018-03-31 09000, 2018

      • bukwurm
        LordSputnik: Few days back I saw that the most recent revisions showed some weird output
      • 2018-03-31 09018, 2018

      • bukwurm
        If an entity was deleted, it showed up in the search as `unnamed`
      • 2018-03-31 09036, 2018

      • bukwurm
        And in the recent revisions as `unnamed`
      • 2018-03-31 09004, 2018

      • bukwurm
        So, first I opened a PR to delete the index in ES also when entity was deleted
      • 2018-03-31 09010, 2018

      • ruaok
        oh, the ssh keys I set were all for root. I get it now.
      • 2018-03-31 09029, 2018

      • bukwurm
        Next, I found out that the delete entity action doesn't update parent_revision
      • 2018-03-31 09036, 2018

      • bukwurm
        So, that was next
      • 2018-03-31 09047, 2018

      • CatQuest
        🕑