#metabrainz

/

      • Gentlecat
        uh.. https://www.metabrainz.org/

        • 2016-05-20 14138, 2016

      • Gentlecat
        zas: ^ can you check this please when you have a minute? :)

        • 2016-05-20 14148, 2016

      • D4RK-PH0ENiX has quit

        • 2016-05-20 14120, 2016

      • zas
        Huh?

        • 2016-05-20 14144, 2016

      • zas
        ah yes, the www.

        • 2016-05-20 14152, 2016

      • Gentlecat
        maybe www.metabrainz.org is missing from nginx config

        • 2016-05-20 14119, 2016

      • zas
        it is, and we don't have it for most websitez

        • 2016-05-20 14151, 2016

      • zas
        for https it will require to have in cert

        • 2016-05-20 14104, 2016

      • zas
        ^it in cert

        • 2016-05-20 14117, 2016

      • Gentlecat
        I was just doing a google search and saw https://www.metabrainz.org/relationships

        • 2016-05-20 14151, 2016

      • Gentlecat
        having a redirect will probably be enough

        • 2016-05-20 14109, 2016

      • Gentlecat
        as long as it doesn't show MB :D

        • 2016-05-20 14126, 2016

      • zas
        can you please add a MBH ticket for it, i'll need to check all certs and all confis

        • 2016-05-20 14129, 2016

      • zas
        configs*

        • 2016-05-20 14139, 2016

      • Gentlecat
        of course

        • 2016-05-20 14154, 2016

      • Gentlecat
        oh, right. looks like it's the same with https://www.critiquebrainz.org/

        • 2016-05-20 14118, 2016

      • zas
        ruaok: yes, apart the night incident (for which i'm 100% to blame), the overall behavior is much better, we are answering to > 400 req/s with 200 now, it was 250 before, and responsivness improved

        • 2016-05-20 14156, 2016

      • zas
        load on web servers is ok, totoro is ok, search servers didn't crash

        • 2016-05-20 14113, 2016

      • Gentlecat
        http://tickets.musicbrainz.org/browse/MBH-449

        • 2016-05-20 14120, 2016

      • zas
        ok ty Gentlecat

        • 2016-05-20 14126, 2016

      • Gentlecat
        👍

        • 2016-05-20 14152, 2016

      • ruaok
        zas: lets see if we can push to 500/s. Then I'll do a blog post stating that we've done some minor heroics.

        • 2016-05-20 14119, 2016

      • ruaok
        ansd by push, I mean adding baron and lolo to the mix

        • 2016-05-20 14132, 2016

      • ruaok
        but, working with bitmap to get 9.5 going and schema change is higher priority

        • 2016-05-20 14105, 2016

      • zas
        i think we are fine with current web servers, the main constraint is totoro and search servers

        • 2016-05-20 14121, 2016

      • ruaok
        I think they have more capacity.

        • 2016-05-20 14127, 2016

      • ruaok
        remember that totoro has 24 cores!

        • 2016-05-20 14157, 2016

      • ruaok
        and we have enough stats on the search servers now that we can see when we're hitting the new limits

        • 2016-05-20 14104, 2016

      • zas
        k

        • 2016-05-20 14159, 2016

      • bitmap
        wonder if the parallel query planner in 9.6 will help us significantly, given that most of the DB should fit in memory

        • 2016-05-20 14153, 2016

      • zas
        bitmap: the best is to benchmark ;) but i guess this recent feature is there for a reason :)

        • 2016-05-20 14155, 2016

      • bitmap
        yeah, just need to wait 5-10 years to upgrade PG again

        • 2016-05-20 14111, 2016

      • ZaphodBeeblebrox
        uuh I am getting a "This Connection is Untrusted" for https://www.metabrainz.org/ :/

        • 2016-05-20 14147, 2016

      • Gentlecat
        https://metabrainz.org/ is the place to go

        • 2016-05-20 14159, 2016

      • ZaphodBeeblebrox
        ah yes good that works

        • 2016-05-20 14126, 2016

      • ZaphodBeeblebrox
        huh never realised before that the 4 logos on the front page change

        • 2016-05-20 14156, 2016

      • reosarevok
        The Wolfram Alpha logo is pretty cool

        • 2016-05-20 14152, 2016

      • Leo_Verto
        it is, doesn't scale very well though

        • 2016-05-20 14102, 2016

      • Leo_Verto
        the favicon doesn't look too great

        • 2016-05-20 14127, 2016

      • ZaphodBeeblebrox
        hmn. where is the page with everyone's whos been a donator listed?

        • 2016-05-20 14151, 2016

      • ZaphodBeeblebrox
        ahh

        • 2016-05-20 14152, 2016

      • ZaphodBeeblebrox
        https://metabrainz.org/donors

        • 2016-05-20 14133, 2016

      • Leo_Verto
        wow, quite a few people donating during the last few dates

        • 2016-05-20 14138, 2016

      • Leo_Verto
        also stupid date format :P

        • 2016-05-20 14141, 2016

      • Lotheric
        When I try to "sign in" on AcousticBrainz website using my MusicBrainz account I get Error: invalid_request

        • 2016-05-20 14141, 2016

      • Lotheric
        Mismatched redirect URI

        • 2016-05-20 14142, 2016

      • ZaphodBeeblebrox
        hmm i think I'm still on two different names in there. my realname recently and my oldername as "Zaphod Beeblebrox"

        • 2016-05-20 14155, 2016

      • ZaphodBeeblebrox
        oh ick wtf date format

        • 2016-05-20 14158, 2016

      • Lotheric
        I'm assuming it has something to do with going all https I've heard people talking about ?

        • 2016-05-20 14123, 2016

      • Leo_Verto
        hmm, I can log in fine

        • 2016-05-20 14139, 2016

      • Leo_Verto
        ah

        • 2016-05-20 14140, 2016

      • Gentlecat
        Lotheric: yes, you might need to switch to https or http

        • 2016-05-20 14146, 2016

      • Leo_Verto
        works for me on the http version but not on https

        • 2016-05-20 14156, 2016

      • Gentlecat
        I don't remember which protocol is specified in redirect URL

        • 2016-05-20 14156, 2016

      • Leo_Verto
        which is odd

        • 2016-05-20 14122, 2016

      • ZaphodBeeblebrox
        I wonder if it's possible to consolidate my users

        • 2016-05-20 14126, 2016

      • ZaphodBeeblebrox
        (merge me :D)

        • 2016-05-20 14127, 2016

      • Leo_Verto
        probably specifying http which causes problems with mixed content settings?

        • 2016-05-20 14142, 2016

      • ZaphodBeeblebrox
        probably need database entry

        • 2016-05-20 14149, 2016

      • ZaphodBeeblebrox
        s/access

        • 2016-05-20 14148, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-05-20 14137, 2016

      • ZaphodBeeblebrox
        my brain just can't read 04/25/16 03:19:59

        • 2016-05-20 14159, 2016

      • ZaphodBeeblebrox
        2004 24d month 16th day

        • 2016-05-20 14101, 2016

      • ZaphodBeeblebrox
        seriously

        • 2016-05-20 14120, 2016

      • Leo_Verto
        ISO 8601 please

        • 2016-05-20 14122, 2016

      • ZaphodBeeblebrox
        or 4th of 25th year 2016

        • 2016-05-20 14154, 2016

      • ZaphodBeeblebrox
        especially egregious is that 24h timestamp next ot it

        • 2016-05-20 14158, 2016

      • ZaphodBeeblebrox
        megaconfus!

        • 2016-05-20 14107, 2016

      • ZaphodBeeblebrox
        anything as long as it cna make sence

        • 2016-05-20 14108, 2016

      • Gentlecat
        instead of complaining you could just submit a patch

        • 2016-05-20 14130, 2016

      • Leo_Verto
        Oh yeah

        • 2016-05-20 14137, 2016

      • ZaphodBeeblebrox
        yea great. thnaks

        • 2016-05-20 14127, 2016

      • ZaphodBeeblebrox
        I'm sorry I will learn not to complain (wasn't really complaining, being funny? idk) as long as I can not fix it myself

        • 2016-05-20 14148, 2016

      • ZaphodBeeblebrox bows in the dust for he is not someone who cna write code at all

        • 2016-05-20 14102, 2016

      • ZaphodBeeblebrox
        i san't even joke about things anymore

        • 2016-05-20 14103, 2016

      • ZaphodBeeblebrox
        sorry

        • 2016-05-20 14105, 2016

      • ZaphodBeeblebrox
        so so sorry

        • 2016-05-20 14100, 2016

      • Leo_Verto
        fixing it right now :D

        • 2016-05-20 14112, 2016

      • ZaphodBeeblebrox
        jesus crist don't take everything like a personal insult that "ur such bad codersdevblahblahgblah" or whatever just because this was mentioned. hell, I know very well you're super busy with the server falling a aprt :/

        • 2016-05-20 14129, 2016

      • ZaphodBeeblebrox
        I didn't mean it like that :(

        • 2016-05-20 14143, 2016

      • The_Freso joined the channel

        • 2016-05-20 14131, 2016

      • Gentlecat
        I'm not taking anything you are saying as an insult

        • 2016-05-20 14132, 2016

      • Leo_Verto
        of course you didn't but it took Gent​lecat for me to realize I could change that awful date format :P

        • 2016-05-20 14142, 2016

      • Gentlecat
        just suggesting a way to fix a problem

        • 2016-05-20 14150, 2016

      • Gentlecat
        alternatively you can create a ticket

        • 2016-05-20 14100, 2016

      • Freso has quit

        • 2016-05-20 14101, 2016

      • The_Freso is now known as Freso

        • 2016-05-20 14128, 2016

      • ZaphodBeeblebrox
        say "write a ticket" to me then :P saying "instead of complaining you could just submit a patch" is like saying "you can't complain, instead fix it".. oh wait you don't know how? , we assuem you know how, the not knowing how is unapliable" ergo : if you can't fix it we don't wanna hear your complaint"

        • 2016-05-20 14128, 2016

      • ZaphodBeeblebrox
        I'm sorry if I missunderstood. thank you for all you hard work (I know the server is sucha pita)

        • 2016-05-20 14153, 2016

      • ZaphodBeeblebrox
        (honnestly I would have thought writing a ticket would be.. unwelcomed too sine I don't *really* wanna pester you wit something so dumb and small in the middle of the huge servercrisis here :/)

        • 2016-05-20 14105, 2016

      • ZaphodBeeblebrox
        don't want to add anymore on the plate :/

        • 2016-05-20 14129, 2016

      • Gentlecat
        you are overthinking it

        • 2016-05-20 14140, 2016

      • Gentlecat
        if we are busy, we'll just get to it a bit later

        • 2016-05-20 14148, 2016

      • ZaphodBeeblebrox
        as usual I am being an idiot. maybe I should

        • 2016-05-20 14148, 2016

      • ZaphodBeeblebrox is now known as CatQuest

        • 2016-05-20 14155, 2016

      • CatQuest
        maybe i'll be better now

        • 2016-05-20 14114, 2016

      • CatQuest
        cat's are better, right Gentlecat ?

        • 2016-05-20 14156, 2016

      • kartikgupta0909 has quit

        • 2016-05-20 14113, 2016

      • madmouser1 joined the channel

        • 2016-05-20 14124, 2016

      • mihaitish has quit

        • 2016-05-20 14126, 2016

      • diana_olhovyk_ has quit

        • 2016-05-20 14142, 2016

      • JesseW joined the channel

        • 2016-05-20 14107, 2016

      • Mineo joined the channel

        • 2016-05-20 14145, 2016

      • JesseW has quit

        • 2016-05-20 14135, 2016

      • yeeeargh joined the channel

        • 2016-05-20 14119, 2016

      • alastairp
        Mineo: thanks :)

        • 2016-05-20 14122, 2016

      • alastairp
        (github)

        • 2016-05-20 14100, 2016

      • ruaok
        alastairp: no worries, nothing secret/NDA worthy in that thread

        • 2016-05-20 14120, 2016

      • alastairp
        great, thanks for clarifying

        • 2016-05-20 14129, 2016

      • JonnyJD joined the channel

        • 2016-05-20 14140, 2016

      • chirlu
        bitmap: Regarding https://github.com/metabrainz/musicbrainz-server/… (the part UmkaDK got at error for) …

        • 2016-05-20 14118, 2016

      • chirlu
        It indeed looks as if that would have no effect at all, being outside a transaction (or inside a one-statement transaction, if you prefer).

        • 2016-05-20 14111, 2016

      • UmkaDK
        Thanks chirlu! So, it's a problem with our database, right?

        • 2016-05-20 14124, 2016

      • chirlu
        Well, I’m not sure.

        • 2016-05-20 14151, 2016

      • chirlu
        The warning looks legitimate, in that the commands probably really have no effect.

        • 2016-05-20 14126, 2016

      • UmkaDK
        But that code hasn't changed in quote a while...

        • 2016-05-20 14124, 2016

      • chirlu
        Yes, I saw – it’s older than NGS.

        • 2016-05-20 14143, 2016

      • chirlu
        Wouldn’t be the first bug that old, though.

        • 2016-05-20 14127, 2016

      • UmkaDK
        So it seems unlikely that pg-9.5 would introduce a non-backwards-compatible change

        • 2016-05-20 14150, 2016

      • UmkaDK
        ... and then there is that! :)

        • 2016-05-20 14139, 2016

      • chirlu
        http://www.postgresql.org/message-id/201311260019…

        • 2016-05-20 14123, 2016

      • JonnyJD has quit

        • 2016-05-20 14137, 2016

      • LordSputnik
        Freso: nope, because pulling that in requires completely upgrading the server which'll take time I don't have for another few weeks (which is when the other botbot work will get done too)

        • 2016-05-20 14128, 2016

      • UmkaDK
        Yee, that seems to suggest that getting a warning is an expected behaviour as 9.3

        • 2016-05-20 14158, 2016

      • UmkaDK
        Now I just need to work out why we are getting a duplicate key for that replication packet.

        • 2016-05-20 14102, 2016

      • UmkaDK
        :)

        • 2016-05-20 14120, 2016

      • CJ_ has quit

        • 2016-05-20 14120, 2016

      • Freso
        LordSputnik: Alright then.

        • 2016-05-20 14115, 2016

      • reosarevok
        bitmap: http://tickets.musicbrainz.org/browse/MBS-8941 is one of those bugs

        • 2016-05-20 14131, 2016

      • reosarevok
        That's about as much data as I can give you about it now, but if I notice more patterns I'll let you know

        • 2016-05-20 14102, 2016

      • kanha has quit

        • 2016-05-20 14127, 2016

      • reosarevok
        Also, bitmap: you were the person to pester about this, right? https://tickets.musicbrainz.org/browse/STYLE-631 (last line has all the desired entries)

        • 2016-05-20 14150, 2016

      • mihaitish joined the channel

        • 2016-05-20 14110, 2016

      • QuoraUK has quit

        • 2016-05-20 14137, 2016

      • QuoraUK joined the channel

        • 2016-05-20 14151, 2016

      • Zialus has quit

        • 2016-05-20 14129, 2016

      • Zialus joined the channel

        • 2016-05-20 14142, 2016

      • chrisskye
        alastairp: Don’t worry. I know. We avoid getting tangled in anything confidential. When someone asks about the projects you’re involved with I’d like to copy you; because you seem the best able to answer questions.

        • 2016-05-20 14151, 2016

      • alastairp
        ok, thanks :)

        • 2016-05-20 14133, 2016

      • chrisskye
        If I copy you, please feel free to offer tech/practical comments. If you feel hesitant, pass your comments by me before sending, but I’m not worried. I believe you are the expert in what you are doing...so you should have a voice and share info

        • 2016-05-20 14140, 2016

      • Zastai joined the channel

        • 2016-05-20 14133, 2016

      • kanha joined the channel

        • 2016-05-20 14155, 2016

      • reosarevok
        zas: search died for a tiiiny moment there it seemed?

        • 2016-05-20 14159, 2016

      • reosarevok
        But back very quickly

        • 2016-05-20 14124, 2016

      • chirlu has quit

        • 2016-05-20 14110, 2016

      • chirlu joined the channel

        • 2016-05-20 14130, 2016

      • LordSputnik
        reosarevok: it just had a tea break :P

        • 2016-05-20 14143, 2016

      • LordSputnik
        the search server is clearly British

        • 2016-05-20 14117, 2016

      • CatQuest
        :D

        • 2016-05-20 14129, 2016

      • reosarevok
        bitmap: and another small issue: http://tickets.musicbrainz.org/browse/MBS-8942 (this one is easy to reproduce!)