#metabrainz

/

      • nedko
        restart does not help
      • 2016-07-29 21144, 2016

      • nedko
        first request is 277ms, following ones take about 200
      • 2016-07-29 21106, 2016

      • nedko
        if psql reads in 8k blocks, i'm not surprised
      • 2016-07-29 21122, 2016

      • ruaok
        does the artist table have indexes?
      • 2016-07-29 21147, 2016

      • nedko
        i don't know. how do i check?
      • 2016-07-29 21105, 2016

      • ruaok
        \dt musicbrainz.artist
      • 2016-07-29 21108, 2016

      • ruaok
        should do it, I think.
      • 2016-07-29 21137, 2016

      • hellska joined the channel
      • 2016-07-29 21120, 2016

      • hellska
        gentlecat: I cannot use current_app to access the config, or I do not get how to do it!
      • 2016-07-29 21120, 2016

      • Gentlecat
        keep in mind that you can do that only in webserver (Flask)
      • 2016-07-29 21146, 2016

      • Gentlecat
        otherwise you'll just have to import it directly
      • 2016-07-29 21109, 2016

      • hellska
        …every time I post a question I found the solution :P
      • 2016-07-29 21115, 2016

      • Gentlecat
        would be nice to have a universal system that would support default configuration as well
      • 2016-07-29 21125, 2016

      • Gentlecat
        heh, happens to me all the time :)
      • 2016-07-29 21132, 2016

      • Freso
      • 2016-07-29 21141, 2016

      • chirlu joined the channel
      • 2016-07-29 21101, 2016

      • hellska
        nice Freso! I’ll definitely use a pig from my collection for that!!!
      • 2016-07-29 21152, 2016

      • nedko
        ruaok: with index it is fast. shame on me
      • 2016-07-29 21129, 2016

      • KodeStar has quit
      • 2016-07-29 21100, 2016

      • D4RK-PH0ENiX has quit
      • 2016-07-29 21132, 2016

      • Freso finds himself referring to https://musicbrainz.org/release/d938c2d2-f482-4eda-befd-d05d03596e1d far too frequently these last few days :p
      • 2016-07-29 21101, 2016

      • nedko
        in what units the track lenghts are stored in the database?
      • 2016-07-29 21121, 2016

      • ruaok
        ms
      • 2016-07-29 21129, 2016

      • nedko
        thanks
      • 2016-07-29 21110, 2016

      • drsaunde joined the channel
      • 2016-07-29 21104, 2016

      • MBJenkins
        Project acousticbrainz-server build #208: SUCCESS in 8 min 18 sec: https://ci.metabrainz.org/job/acousticbrainz-serv…
      • 2016-07-29 21105, 2016

      • KodeStar joined the channel
      • 2016-07-29 21142, 2016

      • MBJenkins
        Project listenbrainz-server build #158: SUCCESS in 1 min 10 sec: https://ci.metabrainz.org/job/listenbrainz-server…
      • 2016-07-29 21113, 2016

      • ruaok
        Gentlecat: do you know if it is possible to use the equivalent of "docker exec" using docker-compose?
      • 2016-07-29 21133, 2016

      • Gentlecat
        there's a "run" command
      • 2016-07-29 21149, 2016

      • ruaok
        yes, but it seems to start another copy of the container.
      • 2016-07-29 21150, 2016

      • ruaok
        I want to run a command in the container created by the up command.
      • 2016-07-29 21130, 2016

      • Gentlecat
        ah, don't know then
      • 2016-07-29 21118, 2016

      • Gentlecat
        why not use "docker exec" directly?
      • 2016-07-29 21118, 2016

      • D4RK-PH0ENiX joined the channel
      • 2016-07-29 21140, 2016

      • ruaok
        then I have to grep for the id of the running container.
      • 2016-07-29 21148, 2016

      • ruaok
        which I can do, but I am wondering if there is a better way
      • 2016-07-29 21105, 2016

      • Gentlecat
        what are you trying to do?
      • 2016-07-29 21122, 2016

      • ruaok
        run a script inside a running container.
      • 2016-07-29 21127, 2016

      • hellska has quit
      • 2016-07-29 21129, 2016

      • ruaok
        set replication token and then replicate.
      • 2016-07-29 21133, 2016

      • ruaok
      • 2016-07-29 21137, 2016

      • lazka joined the channel
      • 2016-07-29 21102, 2016

      • MBJenkins
        Project listenbrainz-server build #159: SUCCESS in 1 min 20 sec: https://ci.metabrainz.org/job/listenbrainz-server…
      • 2016-07-29 21135, 2016

      • github joined the channel
      • 2016-07-29 21135, 2016

      • github
        [listenbrainz-server] pinkeshbadjatiya opened pull request #101: Add pytest.ini file (master...add-pytest.ini) https://git.io/vKpx2
      • 2016-07-29 21135, 2016

      • github has left the channel
      • 2016-07-29 21142, 2016

      • MBJenkins
        Project listenbrainz-server build #160: SUCCESS in 1 min 15 sec: https://ci.metabrainz.org/job/listenbrainz-server…
      • 2016-07-29 21152, 2016

      • drsaunde has quit
      • 2016-07-29 21143, 2016

      • kartikgupta0909 has quit
      • 2016-07-29 21116, 2016

      • travis-ci joined the channel
      • 2016-07-29 21117, 2016

      • travis-ci
        Project bookbrainz-data-js build #614: passed in 2 min 31 sec: https://travis-ci.org/bookbrainz/bookbrainz-data-…
      • 2016-07-29 21117, 2016

      • travis-ci has left the channel
      • 2016-07-29 21122, 2016

      • ZarkBit has quit
      • 2016-07-29 21130, 2016

      • ruaok
        https://github.com/metabrainz/musicbrainz-vm now supports immediate replication and replication token setting
      • 2016-07-29 21136, 2016

      • ruaok
        cron based replication is next
      • 2016-07-29 21157, 2016

      • alastairp
        hi
      • 2016-07-29 21129, 2016

      • Freso
        jduke: Hi! :D
      • 2016-07-29 21137, 2016

      • Freso
        What client are you using?
      • 2016-07-29 21149, 2016

      • ruaok waves at alastairp
      • 2016-07-29 21118, 2016

      • alastairp
        how's it going, ruaok? back to work?
      • 2016-07-29 21132, 2016

      • ruaok
        yep. enjoying AC at the office. :)
      • 2016-07-29 21134, 2016

      • ruaok
        you?
      • 2016-07-29 21152, 2016

      • alastairp
        just finished spanish class today, so feeling a lot less weight
      • 2016-07-29 21111, 2016

      • alastairp
        hackin' on AcousticBrainz for ISMIR, etc
      • 2016-07-29 21112, 2016

      • ruaok
        nice. thanks for your input on the lb stuff while I was out with the hippies.
      • 2016-07-29 21125, 2016

      • ruaok
        getting closer. now there is a PR for a Vagrant VM.
      • 2016-07-29 21128, 2016

      • alastairp
        yeah, no worries
      • 2016-07-29 21144, 2016

      • jduke
        Hello Freso. So, on the forums you said to chat with you in the IRC. So here I am.
      • 2016-07-29 21146, 2016

      • alastairp
        it was generally OK, but lots of caveats which were missed the first time around
      • 2016-07-29 21159, 2016

      • jduke
        How do I add a topic to the weekly meeting?
      • 2016-07-29 21105, 2016

      • ruaok
        yeah, we knew it was going to be an iterative process.
      • 2016-07-29 21112, 2016

      • alastairp
        I'm much happier with it now, but it's pretty messy in terms of working out how to merge
      • 2016-07-29 21133, 2016

      • Freso
        jduke: Hold on :) I'm just trying to find mIRC documentation. :) I would imagine that mIRC has a GUI way to do it.
      • 2016-07-29 21135, 2016

      • ruaok
        I've been prodding armalcolite to rebase branches frequently, so I think we're ok.
      • 2016-07-29 21137, 2016

      • alastairp
        we have something like 3 database structures, and code in 3 differnt PRs touching the same queries, etc
      • 2016-07-29 21144, 2016

      • alastairp
        yeah, the rebase was a good idea
      • 2016-07-29 21101, 2016

      • alastairp
        I think we're probably ready to merge at least 1 of them asap
      • 2016-07-29 21109, 2016

      • ruaok
        but we're getting a nice dependency stack going again, so we really need to get the api-compat merged soon.
      • 2016-07-29 21116, 2016

      • alastairp
        yep
      • 2016-07-29 21123, 2016

      • jduke
        Oh, so it's an IRC thing. I had no idea you used IRC capabilities to form the agenda.
      • 2016-07-29 21124, 2016

      • alastairp
        it still needs some work, imo
      • 2016-07-29 21137, 2016

      • ruaok
        yeah, I'm thinking we ought to note the open issues with api-compat, enter them as bugs, and then merge.
      • 2016-07-29 21143, 2016

      • alastairp
        jduke: we put the agenda in the topic of the channel
      • 2016-07-29 21151, 2016

      • alastairp
        ruaok: yeah, that's probably the easiest way
      • 2016-07-29 21119, 2016

      • alastairp
        I thought of you when we found and fixed the import error
      • 2016-07-29 21128, 2016

      • ruaok
        then we can merge the others that are open and then loop back 'round to the open tickets.
      • 2016-07-29 21129, 2016

      • alastairp
        which only happens when you have a now playing song on last.fm
      • 2016-07-29 21151, 2016

      • alastairp
        I only found it by luck too, because I was scrobbling at that moment, and I normally don't
      • 2016-07-29 21154, 2016

      • ruaok
        I did catch that when I was online for a brief moment hacking on my art project.
      • 2016-07-29 21116, 2016

      • Freso
        jduke: http://www.mirc.com/ircintro.html - see #27, the /topic command.
      • 2016-07-29 21139, 2016

      • Freso
        The agenda for the coming meeting is given in the topic of the channel.
      • 2016-07-29 21149, 2016

      • ruaok
        I gotta say, git is amazing.
      • 2016-07-29 21103, 2016

      • QuoraUK
        ^ this is how I was feeling tuesday :P
      • 2016-07-29 21112, 2016

      • ruaok
        coupled with github, the shit we're doing today was simply not possible a few years ago.
      • 2016-07-29 21141, 2016

      • ruaok
        Gentlecat: have you had a chance to run the vagrant LB stuff yet?
      • 2016-07-29 21149, 2016

      • QuoraUK
        once i figured out rebase I finally got the whole point :P
      • 2016-07-29 21151, 2016

      • ruaok
        not sure why PG is so angry there.
      • 2016-07-29 21159, 2016

      • ruaok
        QuoraUK: yep. :)
      • 2016-07-29 21124, 2016

      • alastairp
        hmm. I was going to bring that up some meeting
      • 2016-07-29 21130, 2016

      • alastairp
        what's our timeline for jira upgrades?
      • 2016-07-29 21145, 2016

      • ruaok
        jira is not going to be touched until we're at newhost.
      • 2016-07-29 21147, 2016

      • alastairp
        honestly, we do so much discussion on github with PRs, having tickets on jira is annoying me
      • 2016-07-29 21124, 2016

      • ruaok
        yeah.
      • 2016-07-29 21127, 2016

      • alastairp
        (e.g., our discussion about playing now timeouts, We decided to add the result of our irc discussion to jira, but you missed it because there was other discussion happening on github(
      • 2016-07-29 21121, 2016

      • ruaok
        canonical problem of too many mediums of discussion.
      • 2016-07-29 21127, 2016

      • alastairp
        yep
      • 2016-07-29 21130, 2016

      • armalcolite
        we can use github issues instead of jira, it would also be easier to refer things and quite handy.
      • 2016-07-29 21149, 2016

      • alastairp
        armalcolite: unfortunately it's not as easy as saying "let's just change"
      • 2016-07-29 21150, 2016

      • ruaok
        armalcolite: not yet. as alastairp suggested, this is something we should discuss as a team.
      • 2016-07-29 21102, 2016

      • alastairp
        but it's definitely an option that we should consider
      • 2016-07-29 21103, 2016

      • Freso has quit
      • 2016-07-29 21107, 2016

      • armalcolite
        sure.
      • 2016-07-29 21111, 2016

      • ruaok
        and it is a huge amount of work to switch. :(
      • 2016-07-29 21123, 2016

      • alastairp
        ruaok: no it isn;t, just fix all of the open bugs ;)
      • 2016-07-29 21127, 2016

      • ruaok
        another problem is that zas is on holidays and he's become the critical path for docker work.
      • 2016-07-29 21144, 2016

      • armalcolite
        ruaok: does that mean taking all the issues on jira to github?
      • 2016-07-29 21146, 2016

      • ruaok
        and the jira upgrade path is stooopid.
      • 2016-07-29 21100, 2016

      • alastairp
        I actually like related tickets in jira
      • 2016-07-29 21102, 2016

      • ruaok
        armalcolite: it could, but for MB that would be a huge undertaking.
      • 2016-07-29 21104, 2016

      • Freso joined the channel
      • 2016-07-29 21113, 2016

      • alastairp
        github issues are good for something that has never had issue tracking
      • 2016-07-29 21125, 2016

      • alastairp
        but if you use all the features of a more complex tool, it's laughable
      • 2016-07-29 21152, 2016

      • ruaok
        I suspect that upgrading jira is a better first step. if only is wasn't so much freaking work.
      • 2016-07-29 21115, 2016

      • ruaok
        who was it who wanted to volunteer for that, but we couldn't because of confidentiality?
      • 2016-07-29 21119, 2016

      • alastairp
        yeah, I think a new version will provide better integrations
      • 2016-07-29 21121, 2016

      • alastairp
        not me
      • 2016-07-29 21132, 2016

      • ruaok
        I wanna say it was Leo_Verto.
      • 2016-07-29 21158, 2016

      • ruaok
        christina was so opposed to no value contract that bound the person to confidentiality.
      • 2016-07-29 21108, 2016

      • alastairp
        ah
      • 2016-07-29 21116, 2016

      • ruaok
        that or a no-value contract that handles the confidentiality.
      • 2016-07-29 21123, 2016

      • ruaok
        well, that road-block is removed now.
      • 2016-07-29 21135, 2016

      • ruaok
        Leo_Verto: was that you who was wanting to help?
      • 2016-07-29 21123, 2016

      • ruaok
        if we can find a volunteer, I will work out a contract and setup a google VM to get this done.
      • 2016-07-29 21131, 2016

      • alastairp
        I remember that the problem was that we can't do a direct upgrade? or the hosted jira service was dying on our dump? Do we have an idea of what to do instead? incremental upgrades?
      • 2016-07-29 21145, 2016

      • ruaok
        a few things:
      • 2016-07-29 21146, 2016

      • alastairp
        though was there also the problem that the incremental versions of jira we need aren't available
      • 2016-07-29 21156, 2016

      • ruaok
        1) incremental upgrade was required to self host.
      • 2016-07-29 21101, 2016

      • colbydray joined the channel
      • 2016-07-29 21103, 2016

      • ruaok
        2) to get SSO we need to self host.
      • 2016-07-29 21116, 2016

      • alastairp
        ah, sso. that was the other thing
      • 2016-07-29 21127, 2016

      • ruaok
        3) if we want no SSO, then we can use the online version which actually worked after some tinkering.
      • 2016-07-29 21153, 2016

      • ruaok
        I think in the end we agreed that self hosted, SSO was the way to go, even though it was a horrible upgrade path.
      • 2016-07-29 21157, 2016

      • colbydray
        just updated my RequestBrainz Page. new feature: FormList and new style
      • 2016-07-29 21158, 2016

      • ruaok
        things may have changed.
      • 2016-07-29 21159, 2016

      • colbydray
      • 2016-07-29 21114, 2016

      • alastairp
        how easy is it to go from online version back to self-hosted?
      • 2016-07-29 21120, 2016

      • ruaok
        in particular, I wonder if there is an export feature from the online version that can be used to import into self hosting.
      • 2016-07-29 21122, 2016

      • ruaok
        :)
      • 2016-07-29 21125, 2016

      • ruaok
        colbydray: :)