#metabrainz

zas, ruaok, etc., Any idea what's up with the webservice? http://stats.metabrainz.org/dashboard/db/musicb... It looks like the gateways are returning 503 for *all* webservice requests, none are hitting the backend

only website is working atm

That was the jinx.

bitmap too ^

apparently musicbrainz uses ~22mbit of bandwidth only serving up the website and error pages :/

there's actually an increase in incoming bw, possibly due to clients retrying?

I assume ruaok is still in London and therefore didn’t get the message.

So we’ll have to wait until he, zas or bitmap awake spontaneously.

Freso, Gentlecat, alastairp: If any of you is around, you could try and ping ruaok via Telegram, I guess.

wtf

i'm there

Oh, hi zas.

Seems like the rate limit is 0 for everyone. :-)

chirlu: during the incident, was the main website still available ? (the web service was over rate limited)

Yes, the website was there.

Beta was also there the whole time (website and web service).

Yes; the issue was only concerning the main ws

Morning all, I think I found out whats killing your web service

zag: you mean apart me ? ;)

I love it when someone messages ModBot with questions

I mean I do get the email anyway, but :D

zas: I forget, do you get support mail?

russss: if you're around can you ping me?

alastairp: hi

hey. question about emf

how long does it take to get from the camp to heathrow?

I have to be in New York on Monday, and I'm trying to see if it's worth doing emf if I have to spend all sunday travelling to the airport

reosarevok: nope

alastairp: you can get a train from Guildford to Woking and then there's a coach link from there to Heathrow. Allegedly the whole journey takes 70mins but I'd probably allow a bit more than that.

zas: zas@?

yup

hmm, right. plus international checkin time. last flight of the day is at 8pm

Ok :)

I'll work on it. Thanks. Hopefully I can push arrival back to Monday

alternative is going into london and then taking the tube out to heathrow but I can't see that being quicker.

hi, I try to get a json response via https://musicbrainz.org/ws/2/release?query= and Accept header set to json, but I always get the xml. Is this working properly?

you need to use &fmt=json

docu said accept header works too

ahh, I didn't know that!

buit it doesn´t work actually :D

you can ask bitmap when he is up - he will be able to confirm

thx

Guys, have a small postgresql question ...

When the database is setup, where should the musicbrainz schema go: under the system postgres database or under the musicbrainz_db database?

Does anyone know?

I'm not sure what you're asking - are you doing things manually which the init_db script normally does?

I'm not super familiar with pg schemas, but I believe they apply to a database, therefore it should be on musicbrainz_db

Yes, we are doing things manually... and I'm not super familiar with pg schemas either

Gore: the issue you described should be fixed ... can you give the exact query and headers ?

Hmmm, or is it a 200 response ?

zas http://i.imgur.com/Oy2cQGL.png enough?

UmkaDK: https://gist.github.com/alastair/370dfc96d6f0eb...

looks like it's a schema inside the musicbrainz_db database

our DBA's have been "improving" things and said that, and I quote:

In the postgres database on the same cluster: https://gist.github.com/alastair/dda8308e7f0f07...

Gore: ok, not the issue i was thinking of (which was only on rate limiter errors), this one is a MBS issue, can you report it on the bug tracker (search before, perhaps known)

"musicbrainz schema was under the system postgres database. It has been corrected, muzicbrainz schema is now only under the musicbrainz_db database."

zas i´ll ask bitmap when he is here

oh, interesting

Since then I've started getting: ERROR: relation "cover_art_archive.cover_art" does not exist

from my first gist, I believe here cover_art_archive is the schema name, and cover_art is the table name

perhaps your DBAs moved the musicbrainz schema and not the cover_art_archive one?

Gore: i just did the test, and i can confirm it returns xml instead of json...

And yes, Accept: application/json should be enough

interesting

zas thx for confirming t5his

ahh

Gore: i know because i discussed recently about xml vs json with bitmap, in order to fix the lua-based rate limiter error messages. Basically, &fmt= has priority over Accept header, and when no fmt nor header is specified the response defaults to xml.

Gore: can you try this request with the header: http://musicbrainz.org/ws/2/work/8e134b32-99b8-...

alastairp: is cover_art_archive a separate schema??

UmkaDK: yes, I believe so (from looking at the output of those commands on my database, not from other knowledge)

zas http://i.imgur.com/74UHfMB.png

Gore: zas: looks like searchserver doesn't honour Accept headers

Ohh bummer!! In that case I'm almost 100% sure that they've missed that

yup

the software that responds to ?query= is different

UmkaDK: link them to that first gist I posted. They may need to copy all of the schemas listed there (though some of them may not be required for mirrors)

kk, thank you so much alastairp!!

👍

Hmmm ... I suspect "public" (owned by postres user) is not required

yes, I think so

let me see. there should be a way of listing tables in a schema

I see no tables in the public schema on my database

Cool! :)

Again, thank you so much alastairp!!

I should tell ruaok to start paying me

:)