#musicbrainz-devel

and it says "By default, these 'inc=' arguments will only load relationship for the requested entity.”, which I don’t understand. I think that’s related to the recording-level-rels etc item

"inc= arguments which affect subqueries” doesn’t say specifically for which entities they’re valid. You can only work it out from the description afterwards (I think)

yeah, we don't restrict the inc params based on whether link types actually exist between two entity types or anything, so all are valid

(If you answer these, I can make the wiki changes)

by 'will only load relationship for the requested entity' I think it means for the requested resource, so if it's a direct lookup it'll only load them for that entity, if it's a browse request it'll load them for all the returned entities of whatever type you requested, but not any entities linked to those

ruaok: yes, same length

why does release browse not support tag and rating includes, but get does?

I have no idea, tbh

:)

OK. I always wanted to rewrite that docs page. Maybe I’ll do that

thanks again for your help. Now I can go and implement stuff!

(sigh)

oh and for the subqueries, the first 3 are for release (though isrcs should only work if inc=media is included), artist-credits is valid on /ws/2/{artist,label,recording,release,release-group} if they have any of inc={recordings,releases,release-groups} from the above section

and various-artists says the only place it's used in the description

actually, isrcs should also work on /ws/2/artist with inc=recordings

yeah. we have most of these documented anyway - https://github.com/alastair/python-musicbrainzn...

alastairp, if you help me get my head around the subject, I'm happy to do the drudgery of editing the wiki

CallerNo6: thanks for the offer

I’m not sure what the best way to reshuffle is

I think maybe the clearer way is to duplicate information - e.g. have a subsection per entity, which lists all its options

(and maybe another set of subsections that list what the options mean)

because to me the most common usecase is “I want to get a recording entity, what other things can I include with it"

which is really difficult at the moment

the opposite, which may be useful, is “what are all of the things which have areas"

but I think that’s less useful

duplicating the info would be clearer I think, yeah, so people don't have to cross-reference as much

there's too many "oh and btw this inc param is valid in this scenario" paragraphs that are easy to miss

iiuc, I agree. A set of reference tables is most important. But also maybe a few examples based on common questions, like "I have an artist name, how do I get a list of albums?"

yeah, a few common examples at the end of each section would be nice

Project musicbrainz-server_master build #139: STILL FAILING in 22 min: http://ci.musicbrainz.org/job/musicbrainz-serve...

* Michael Wiencek: Use MAINTENANCE database in InitDb.pl, since pgbouncer doesn't work with PGOPTIONS

oops, forgot to drop the existing test db first so it still has a broken timezone

anyone here know how to use tc?

kepstin, who hacked together our script isn't around to guide me. :(

I know one way of fixing the problem, but I'd rather try something intelligent first. :)

how does one go about removing all traffic control rules?

rvedotrc: you around?

Project musicbrainz-server_master build #140: STILL FAILING in 4 min 59 sec: http://ci.musicbrainz.org/job/musicbrainz-serve...

Hi guys. Will mbserver run Ok on postgres 9.4?

Updating my machine from wheezy to jessie and it's recommending replacing 9.1

adhawkins: I've been running it on 9.4 without any problems

Cool, thanks.

Someone remind me how to install perl modules locally?

Authen::Passphrase is missing...

cpanm Authen::Passphrase probably

That's doing something, cheers.

you could also cd into the musicbrainz-server checkout and re-run 'cpanm --notest --installdeps .' to get everything it needs

I did that, but it's still missing stuff.

I blew away the old local dir because of the upgrade.

I'll make a list of all the stuff I need to install manually if it's of any interest

odd, I know chirlu verified that all the steps work recently on ubuntu

a list would be very interesting though

Anything else I need to consider before upgrading postres?

Are there some modules that mbserver uses?

musicbrainz_collate.

after upgrading I think you'll need to recompile the postgresql-musicbrainz-collate and postgresql-musicbrainz-unaccent extensions in the mbserver checkout

Need to get that installed.

:)

hehe

collate and unaccent directories are empty...

git submodule init; git submodule update --recursive

Will that have screwed the upgrade of the database?

It threw some errors while upgrading.

hm, should't

what errors did it give?

pg_restore: [archiver (db)] COPY failed for table "area": ERROR: function musicbrainz.musicbrainz_unaccent(character varying) does not exist

the update is still running though.

ruaok: pong. Keeping a weather eye on stuff at work this evening :-)

I guess I can drop the 9.4 one again and update 9.1

hm, if it didn't abort it'll probably be fine, just should run ./admin/psql READWRITE < ./admin/sql/Extensions.sql

I've interrupted it, dropped the 9.4 one and am upgrading again.

ok

What do I have to do to add those modules to postgres?

I've compiled and installed them.

running the command I put a few lines above should create them

./admin/psql READWRITE < ./admin/sql/Extensions.sql

Got it, thanks

Ok, I appear to have hosed my database, so starting from scratch.

InitDB throwing an error with extensions

Thu May 7 22:30:41 2015 : psql:/home/mbserver/musicbrainz-server/admin/sql/Extensions.sql:4: ERROR: could not open extension control file "/usr/share/postgresql/9.4/extension/cube.control": No such file or directory

That file doesn't exist, should it?

if you are on debian/ubuntu, you need the package with contrib modules

postgresql-contrib

Ok, got that, thanks. How can I drop the database?

rvedotrc:oh yes.

sudo -s postgres dropdb musicbrainz

sudo -u postgres

sorry

I'm not really involved tonight (at work) - just being available /just in case/ something goes wonky,

Thu May 7 22:37:21 2015 : psql:/home/mbserver/musicbrainz-server/admin/sql/Extensions.sql:5: ERROR: could not open extension control file "/usr/share/postgresql/9.4/extension/musicbrainz_unaccent.control": No such file or directory

oh ffs.

all i need to do is read the bbc headline.

close tab.

close tab

get more booze.

(bbc headline?)

Extrapolation from zero results so far.

> Election 2015: Exit poll puts Tories close to majority

http://m.bbc.co.uk/news/election/2015/results (/me plugs fellow team's stuff)

rvedotrc: lets hope the exit polls are wrong

derwin: sadly there is no acceptable outcome of this election.

and mind you I don't even live there!

adhawkins: have you installed the musicbrainz extensions?

I dud.

did.

Ah, but then I purged postgres.

One sec.

That's better.

btw, if anyone has a few minutes spare, please try out http://bookbrainz.mbsandbox.org/ - we're beta testing the next release ;)

Any suggestions on this error importing?

cover_art_archive.art_type 0 0% 0Error loading /tmp/MBImport-KTIwo4M5/mbdump/cover_art_archive.art_type: DBD::Pg::db pg_putcopydata failed: no COPY in progress at /home/mbserver/musicbrainz-server/admin/MBImport.pl line 289, <LOAD> line 183.

Running ./admin/InitDb.pl --createdb --import /tmp/dumps/mbdump*.tar.bz2 --echo

I downloaded cdstubs, derived, mbdump, cover-art-archive and editor

that is weird. I have no idea what that could be

Will start again and try to get the first error

Ok, the first error is as it goes from the mbdump/work_type table to cdtoc_raw

Same thing, no copy in progress

what's 'git rev-parse HEAD' say?

e66f2d9d144f8d192917612775c9576016a6907e

I might be one or two versions behind.

hm, okay, was just checking if you were on latest master in case stuff I pushed broke it

Moving cdtoc file out of the way to see if that makes any difference

ah http://tickets.musicbrainz.org/browse/MBS-8126 maybe?

I'd try updating to the latest tagged release

Cool, I'll give that a go. Thanks

ok, time for a slightly earlier bed time.