#musicbrainz

(debian testing, postgresql 9.1.1)

ocharles, ^

adhawkins: I get the same error, but I thought this is normal since my ./upgrade.sh script failed

adhawkins: has yours passed without error?

No, I think I had problems in upgrade.sh too

Didn't save them though

That error is now generated by slave.sh every time it tried to replicate

The error you've posted does ring a bell from when I did the upgrade.sh though

well, it seems not surprising that replication isn't possible if the upgrade.sh failed ;-)

Yeah, I guess!

But luks thought they looked more like perl errors, so were unrelated to the database.

hmm, the extract_path_value() thing looks like a database thing...

Yeah, but the ones in the slave log were the ones luks thought were perl related

I did things in the wrong order, which probably didn't help

what do you mean?

I did upgrade.sh first before running the perl Makefile.pl to update the perl dependencies

w 29

hrglgrmpf: when does that happen?

the extract_path_value error

when I call upgrade.sh

upgrading RT_STANDALONE server is going to be a little harder

Mine is a slave

I have both...

ohh

I think I saw the same error though

actually, plperl is required by all types of servers

that seems a little pointless on RT_SLAVE

hrglgrmpf: I think that admin/sql/updates/20110804-json-extract.sql failed for you because you don't have PL/perl

and the following script which needs the functions failed as well

could be!

I can't upgrade at the moment, but will do later

What is plperl?

this stuff really shouldn't be installed in RT_SLAVE...

however, why hasn't perl Makefile.PL warned me / installed it?

hrglgrmpf: it's a postgresql module, nothing to do with perl

ok, than the blog post should have mentioned it :-)

well, perl as in something that has access to the modules in Makefile.PL

I thought you won't need it at all

it makes no sense for me to require it on RT_SLAVE servers

Ok, so if upgrade.sh didn't fully upgrade the databases correctly, what can I do to fix it?

given that edit data is not replicated

someone please look at the instructions in the blog and add a comment or something with the missing steps :)

adhawkins: your problem is unrelated

I think my upgrade.sh failed in the same way though

you didn't mention that it failed

hrglgrmpf is seeing the same errors as me in his slave.log I think

luks, http://forums.musicbrainz.org/viewtopic.php?pid... in case it's an acoustid issue

I know, I forgot until I saw hrglgrmpf's message :)

I did this at midnight :)

echo 'select * from replication_control;' | ./admin/psql

what does it say?

(1 row)

so it finished correctly

I seem to remember seeing some errors along the way similar to what hrglgrmpf has posted

you can ignore them, you won't need those indexes

Ok

So we're still left with the replication errors, which I think hrglgrmpf is seeing too.

ianmcorvidae: ping

What's the alternative for someone who wants to run a local server to do batch queries against?

there is no alternative for running the web service

Any way of keeping the database updated without using the slave stuff to do it?

ocharles is on his was :)

what's broke?

yep, on it

I don't get how rob's slaves were working fine...

We both had some errors reported by upgrade.sh, but luks doesn't think they're relevant

the other error was related to plperl

which wouldn't make the replication not work

ocharles, I can give you access to my VM if it would help

adhawkins: it's fine

pull now and try with master HEAD

kovacsur: anything that *should* remain capitalized on http://musicbrainz.org/release/60417765-6282-45... ? (aside from first letters, etc, of course :)

checking

Um, ocharles, for a git newbie can you tell me what commands I need? :)

git checkout master; git pull origin master

Ah, that release

The thing with that one is it has quite a few missing diacritics, etc as well

but that is how it is printed on the cover

ocharles, shall we take this to #mb-dev?

adhawkins: sounds good!

I can fix it to proper Hungarian, but I wasn't sure I should

v6lur, are you editing that release right now? If not, I'll fix capitalization and diacritics

then typos in a second edit

i'm not anymore :P

oh, I see you've corrected caps

i entered stuff as on back cover http://media.cdr.nl/COVER/LARGE/BACK/JK149150.jpg

okay, I'll fix diacritics (autoedit) then typos

but do go ahead and fix the typos, as i don't really speak the language :)

why "typos in a second edit"?

because those aren't autoedits

that's how I usually do it

so?

they take 2 weeks to pass

i can approve them for you

:p

i just want this release out of my "Recordings need capitalization fixes" collection :P

well, in that case I'll do it as one edit. :p

Artist credits are rather suspicious as well (Soml� was a member of Omega when that single was released, etc), but I'll just leave them as they are

A bit better now http://musicbrainz.org/release/56390511-9b17-42...

also, track 1 is an outtake from a musical theatre production, the artist credits given on the packaging are the authors

Hmm, I see nikki's wikipedia script now loads photos too :D

v6lur, http://musicbrainz.org/edit/16241042

thanks :)

i'll fix recordings now, too

thanks for the approval

uh, I didn't update recording titles because I assumed they would need to be merged into the original ones anyway

or are these special mixes/remasters?

no idea. i didn't plan on merging them, but i'll fix the caps

there.

kovacsur / v6lur: I imagine you've both seen the option to change recordings and tracks at the same time, right? :)

(just checking)

reosarevok, I did

yes. how else would i have managed it in under a minute? :P

Hmm

v6lur: does that mean that it applies *all* differences?

(that's also the reason i started working through that collection of mine...)

(not just the changes you make in that session)

almost

well

i mean, it detects any differences in tracklist and recordings

Oh, ok

I thought it would only give you the checkbox for the changes *you* just did

but the checkboxes are only there if you change *anything* in given session

Oooh

That sounds like a kind-of-bug :p

anything in tracklist, that is

i like it

I like that the option is there

so to me, it's a feature. not a bug, to paraphrase HP people

But not having to change something in the tracklist (if it's already fine) to fix recordings :P

(the computer company, not that japanese group :P )

Sure, I see the point, I just don't think it should depend on you changing something then

ah, yea... i usually just enter "aaa" to last track of every disc to get the checkboxes, go to recordings page, go back, delete "aaa", and then go to recordings page again :P

So, that's a bug/problem :)

(also, lol)

hrglgrmpf, see on #mb-dev for details of a fix to the problem replicating.

oh, v6lur, any reason you changed "Zalatnay Sarolta" to western name order, but left Nem�nyi B�la in Hungarian order?

oh, nevermind, that's how they're printed

i wondered about them myself, too. then i figured, hey, that's how they are in cover, maybe they had good reasons

if you have reason to believe they had not, fix them and ping me :)