#metabrainz

/

      • Leo_Verto
      • 2016-05-22 14302, 2016

      • bitmap
        100%
      • 2016-05-22 14351, 2016

      • zas
        alastairp: what is the exact issue (http://tickets.musicbrainz.org/browse/LB-91) ?
      • 2016-05-22 14337, 2016

      • Freso
        chirlu: I don't understand your question. All HTTP requests go over HTTPS.
      • 2016-05-22 14319, 2016

      • bitmap
        baron slowly starting up, doing recovery
      • 2016-05-22 14319, 2016

      • chirlu
        Freso: As I said, when I open https://tickets.musicbrainz.org/ (*with* https), I‘m redirected to http://tickets.musicbrainz.org/secure/Dashboard.j… (*not* https).
      • 2016-05-22 14338, 2016

      • Freso
        chirlu: I don't get redirected.
      • 2016-05-22 14353, 2016

      • chirlu
        That’s interesting.
      • 2016-05-22 14308, 2016

      • Freso
        Or maybe I do, but then NoScript redirects the http:// → https:// :)
      • 2016-05-22 14324, 2016

      • ruaok
        bitmap: thanks for the updates. :)
      • 2016-05-22 14325, 2016

      • Freso
        chirlu: Does https://tickets.musicbrainz.org/browse/AREQ-940 redirect you to http://?
      • 2016-05-22 14337, 2016

      • chirlu
        Well, when I go to https://tickets.musicbrainz.org/secure/Dashboard.… manually, I don’t get a working dashboard.
      • 2016-05-22 14346, 2016

      • chirlu
        And individual tickets work, that’s known.
      • 2016-05-22 14307, 2016

      • chirlu
        (MBH-442)
      • 2016-05-22 14341, 2016

      • Freso
        Yep. Hence my "“works”".
      • 2016-05-22 14305, 2016

      • kanha has quit
      • 2016-05-22 14306, 2016

      • Freso
        Leftmost: Can you do the XML editing listed in https://confluence.atlassian.com/jira/integrating… to unbreak https://tickets.musicbrainz.org 's dashboard?
      • 2016-05-22 14336, 2016

      • Freso
        Not sure if there's anything for Zas to do.
      • 2016-05-22 14325, 2016

      • D4RK-PH0ENiX has quit
      • 2016-05-22 14325, 2016

      • diana_olhovyk_ joined the channel
      • 2016-05-22 14331, 2016

      • D4RK-PH0ENiX joined the channel
      • 2016-05-22 14335, 2016

      • rahulr
        bitmap: Some cons of using web view for displaying search results in picard -> https://www.evernote.com/shard/s589/sh/dca15fc5-6…. Suggestions?
      • 2016-05-22 14358, 2016

      • bitmap
        we have a javascript plugin that can sort tables
      • 2016-05-22 14310, 2016

      • bitmap
        not sure about the second point. adding configuration that no one has asked for
      • 2016-05-22 14352, 2016

      • bitmap
        if people want that, it's a good point though. on the other hand, cover art can be loaded asychronously
      • 2016-05-22 14322, 2016

      • bitmap
        fetching external resources for the page probably does make it slow, but that's why we'd have the server only return the results table
      • 2016-05-22 14304, 2016

      • bitmap
        might be that it's still slow even then. I guess we'd have to check
      • 2016-05-22 14336, 2016

      • bitmap
        the caching is a good point
      • 2016-05-22 14340, 2016

      • ruaok
        Yay, search servers were running a load and recovered normally. :-)
      • 2016-05-22 14338, 2016

      • Freso
        ruaok: 🙌
      • 2016-05-22 14353, 2016

      • Slurpee joined the channel
      • 2016-05-22 14353, 2016

      • Slurpee has quit
      • 2016-05-22 14353, 2016

      • Slurpee joined the channel
      • 2016-05-22 14328, 2016

      • rahulr
        bitmap: Yep. That preferred attributes is a mere idea. It should be relatively easy to implement in custom UI than in the web results.
      • 2016-05-22 14309, 2016

      • KodeStar
        chirlu / Freso I get redirected as well
      • 2016-05-22 14311, 2016

      • rahulr
        Someone with a metered connection (like me, presently) might not want to load covers during search at all. It might help to provide an option for that in configuration.
      • 2016-05-22 14330, 2016

      • Freso
        KodeStar: Yeah, I think we've established that it's my NoScript keeping me on HTTPS. :)
      • 2016-05-22 14352, 2016

      • Freso
        I thought I had, anyway.
      • 2016-05-22 14330, 2016

      • diana_olhovyk_ has quit
      • 2016-05-22 14321, 2016

      • bitmap
        rahulr: agreed, should be pretty simple
      • 2016-05-22 14347, 2016

      • zas
        ruaok: that's the big test, sunday evening, > 500 req/s served, ... search servers uses a lot of cpu atm
      • 2016-05-22 14345, 2016

      • ruaok
        Yeah, I saw. I think this reflects our true capacity much more.
      • 2016-05-22 14328, 2016

      • zas
        yup
      • 2016-05-22 14336, 2016

      • ruaok
        Search is still responsive though.
      • 2016-05-22 14340, 2016

      • kurros has quit
      • 2016-05-22 14343, 2016

      • zas
        yes
      • 2016-05-22 14325, 2016

      • zas
        i need to add more checks for responsivity of various services (that's somewhere in my never-ending TODO list)
      • 2016-05-22 14345, 2016

      • zas
        it will come after the big move anyway
      • 2016-05-22 14301, 2016

      • zas
        web servers are quite loaded too ;)
      • 2016-05-22 14308, 2016

      • kurros joined the channel
      • 2016-05-22 14339, 2016

      • bitmap
        baron is running with hot_standby = 'on', but isn't accepting any ro queries yet
      • 2016-05-22 14355, 2016

      • bitmap
        I guess that will happen when recovery is done, but it's taking quite a while
      • 2016-05-22 14332, 2016

      • bitmap
        happen automatically, according to the docs
      • 2016-05-22 14334, 2016

      • zas
        ruaok: check bandwidth graph, 28Mbps atm
      • 2016-05-22 14307, 2016

      • KodeStar
        ruaok / za, did you get any responses from the providers you contacted?
      • 2016-05-22 14312, 2016

      • KodeStar
        *zas
      • 2016-05-22 14312, 2016

      • ruaok
        So low. Odd.
      • 2016-05-22 14359, 2016

      • ruaok
        Yes, hetzner is updated in the spreadsheet. And it is cheap. 500€ cheaper than OVH.
      • 2016-05-22 14326, 2016

      • ruaok
        And we don't have to pay vat. \ö/
      • 2016-05-22 14301, 2016

      • ruaok
        Hetzner has startup costs but I amortized them over two years. Still very cheap.
      • 2016-05-22 14339, 2016

      • ruaok
        Ddos protection is one thing we need to consider with hetzner..
      • 2016-05-22 14349, 2016

      • rahulr
        bitmap: So, I'm starting with a basic track search dialog UI. Code on a normal git feature branch, right? In my fork.
      • 2016-05-22 14347, 2016

      • KodeStar
        are you vat registered? not sure why else you wouldn't have to pay VAT?
      • 2016-05-22 14319, 2016

      • kurros has quit
      • 2016-05-22 14312, 2016

      • ruaok
        We're a us company. As it stands hetzner does no charge us vat.
      • 2016-05-22 14314, 2016

      • ruaok
        Not
      • 2016-05-22 14330, 2016

      • kanha joined the channel
      • 2016-05-22 14344, 2016

      • KodeStar
        I'm just looking at the spreadsheet and yeah 500eruo a month is not to be sniffed at, but like you said the ddos thing is the only concerning thing, all someone would have to do is ddos your gateway servers and it would all be down due to them null routing the ips
      • 2016-05-22 14312, 2016

      • bitmap
        rahulr: correct
      • 2016-05-22 14349, 2016

      • ruaok
        KodeStar: understood. However, in 16 years, that has never happened. So I am not sure how to evaluate all this.
      • 2016-05-22 14353, 2016

      • KodeStar
        true, and you could always stick cloudflare in front of you if it did happen
      • 2016-05-22 14359, 2016

      • kurros joined the channel
      • 2016-05-22 14323, 2016

      • JesseW joined the channel
      • 2016-05-22 14304, 2016

      • The_Freso joined the channel
      • 2016-05-22 14359, 2016

      • Freso has quit
      • 2016-05-22 14359, 2016

      • The_Freso is now known as Freso
      • 2016-05-22 14322, 2016

      • KodeStar
        ruaok: I filled in the values for online.net, I don't know if those servers would actually be suitable, but if they were it would defintely be worth seeing if they would do it sans VAT as well (probably would as you are a US company) https://docs.google.com/spreadsheets/d/1L5W8pjvuu… and that would give you ddos protection, and 1GBPS RPN (similar to vrack)
      • 2016-05-22 14328, 2016

      • kurros has quit
      • 2016-05-22 14336, 2016

      • ruaok
        Thank you!
      • 2016-05-22 14324, 2016

      • KodeStar
        also while the hetzner network is supposed to be considered pretty good, as I understand it it goes Hetzner < online.net < OVH, but that could be just anecdotal, it would also depend where your biggest customer base is, it might be worth getting someone from a few different places pinging servers from each to see what kind of latentcy they get
      • 2016-05-22 14346, 2016

      • KodeStar
      • 2016-05-22 14347, 2016

      • bitmap
        looks like baron can accept queries now
      • 2016-05-22 14327, 2016

      • bitmap
        so...I think during the PG upgrade, we can put MBS in read-only mode and point it to baron
      • 2016-05-22 14338, 2016

      • kurros joined the channel
      • 2016-05-22 14326, 2016

      • bitmap
        when should we announce downtime for? within the next couple hours ideally
      • 2016-05-22 14353, 2016

      • bitmap
        s/downtime/readonly-mode/
      • 2016-05-22 14348, 2016

      • kurros has quit
      • 2016-05-22 14336, 2016

      • bitmap
        ruaok, zas, can we decide that ^?
      • 2016-05-22 14340, 2016

      • bitmap
        18:30 UTC? 19:00?
      • 2016-05-22 14323, 2016

      • ruaok
        Up to you and zas.
      • 2016-05-22 14353, 2016

      • ruaok
        I just arrived at the airport and am subject to sleazyjet's whims.
      • 2016-05-22 14310, 2016

      • bitmap
        k. I guess he's not around atm
      • 2016-05-22 14343, 2016

      • bitmap
        I'll just set a banner for 18:30
      • 2016-05-22 14359, 2016

      • ruaok
        I pinged him on telegram too.
      • 2016-05-22 14319, 2016

      • ruaok
        You'll likely need to reduce the global rate limit.
      • 2016-05-22 14335, 2016

      • ruaok
        Baron can't handle 500reqs/second.
      • 2016-05-22 14310, 2016

      • kurros joined the channel
      • 2016-05-22 14332, 2016

      • bitmap
        okay
      • 2016-05-22 14319, 2016

      • chrisskye
        question:
      • 2016-05-22 14348, 2016

      • chrisskye
        is the schema change going to affect the current output of the XML's?
      • 2016-05-22 14314, 2016

      • bitmap
        nope
      • 2016-05-22 14316, 2016

      • bitmap
        some small additions were made to it, but it shouldn't break anything that already existed
      • 2016-05-22 14344, 2016

      • kurros has quit
      • 2016-05-22 14316, 2016

      • kurros joined the channel
      • 2016-05-22 14328, 2016

      • kurros has quit
      • 2016-05-22 14359, 2016

      • kurros joined the channel
      • 2016-05-22 14306, 2016

      • hellska has left the channel
      • 2016-05-22 14315, 2016

      • kurros has quit
      • 2016-05-22 14325, 2016

      • kurros joined the channel
      • 2016-05-22 14327, 2016

      • Zastai has quit
      • 2016-05-22 14336, 2016

      • bitmap
        zas: around?
      • 2016-05-22 14344, 2016

      • zas
        I'm there, was dining
      • 2016-05-22 14310, 2016

      • bitmap
        cool, just making sure I was doing the upgrade alone
      • 2016-05-22 14315, 2016

      • bitmap
        +not
      • 2016-05-22 14330, 2016

      • zas
        i'll decrease the rate limit
      • 2016-05-22 14323, 2016

      • kurros has quit
      • 2016-05-22 14347, 2016

      • kurros joined the channel
      • 2016-05-22 14357, 2016

      • zas
        bitmap: how do you proceed to change the target db ?
      • 2016-05-22 14345, 2016

      • bitmap
        I'm just gonna edit the DBDefs files manually and svc -h the mbs services
      • 2016-05-22 14354, 2016

      • chrisskye
        One of our stealth start-up clients was chatting with me on hang-out and says, I’m "A lot more fun than most customer reps.” eh, ruaok
      • 2016-05-22 14354, 2016

      • zas
        k
      • 2016-05-22 14337, 2016

      • cetko
        alastairp: could you please press Felipe for access?
      • 2016-05-22 14349, 2016

      • bitmap
        I guess I'll say the steps in here as I'm doing them and we'll see if anything causes a fire
      • 2016-05-22 14315, 2016

      • zas
        i reduced a bit the rate limit for ws
      • 2016-05-22 14323, 2016

      • cetko
        I tried opening a trial access on bigquery but I have a prepaid card they won't accept
      • 2016-05-22 14335, 2016

      • ruaok
        chrisskye: nice. 😀
      • 2016-05-22 14348, 2016

      • zas
        330 req/s atm
      • 2016-05-22 14314, 2016

      • ruaok crosses his fingers for the upgrade
      • 2016-05-22 14334, 2016

      • ruaok
        bitmap: don't wait up for me. Going to be an hour later.
      • 2016-05-22 14300, 2016

      • bitmap
        aight. hopefully the upgrade goes smoothly...
      • 2016-05-22 14328, 2016

      • zas
        since it didnt restart since ages.... who knows...
      • 2016-05-22 14351, 2016

      • ruaok
        Will there be a Toyota reboot?
      • 2016-05-22 14302, 2016

      • ruaok
        Heh. Totoro
      • 2016-05-22 14310, 2016

      • zas
        yes at least one
      • 2016-05-22 14323, 2016

      • bitmap
        I have to copy some of the config changes I made into server-configs
      • 2016-05-22 14330, 2016

      • ruaok
        Zas: remember to check the ethN configs
      • 2016-05-22 14336, 2016

      • ruaok
        Important!!
      • 2016-05-22 14309, 2016

      • ruaok
        Remember that I believe that we have two connections to the private net.
      • 2016-05-22 14339, 2016

      • zas
        i see only one IP on totoro
      • 2016-05-22 14339, 2016

      • ruaok
        Review and ensure that both have ips assigned in case of fuckerage on restart.
      • 2016-05-22 14345, 2016

      • chrisskye
        isn’t it Sunday?
      • 2016-05-22 14312, 2016

      • ruaok
        Try to config the second eth as well.
      • 2016-05-22 14322, 2016

      • zas
      • 2016-05-22 14326, 2016

      • ruaok
        Chrisskye yep, is Sunday, why?
      • 2016-05-22 14336, 2016

      • zas
        this is the current config
      • 2016-05-22 14340, 2016

      • JesseW
        ah, "fuckerage on restart" -- always something to watch out for.
      • 2016-05-22 14345, 2016

      • chrisskye
        I was asked why I was working...but, hey, you guys are too
      • 2016-05-22 14302, 2016

      • ruaok
        Zas: ewww, wth?
      • 2016-05-22 14316, 2016

      • zas
        yes.. looks weird
      • 2016-05-22 14337, 2016

      • ruaok
        Don't trust that things will come back. Take precautions.