#musicbrainz-devel

Is there a way to reimport the data but keep the edits I've created?

there is a few ways.

one interesting way would be to not have InitDb.pl write to your RAWDATA database.

do this:

setup the import to import to musicbrainz_db_new and musicbrainz_db_raw_temp

when you're ready to run change DBDefs to point to musicbrainz_db_new and musicbrainz_db_raw_old

that *should* keep your edits

Was musicbrainz_db_raw_old supposed to be musicbrainz_db_raw_temp ?

If I want to change which databases the import goes to, I edit DBDefs.pm right?

yeds

Change the database => for READWRITE and RAWDATA.

yes

Then after the import finishes I'll change RAWDATA back from musicbrainz_db_raw_temp to what it was before (musicbrainz_db_raw) and I can drop my previous READWRITE database

ding

Okay makes sense, I'll give it a shot :)

argh AFAIK all I've done is edit DBDefs.pm and then revert that change, but now the server crashes when I switch to my master branch.

I have two MB repos and neither will work when I switch to master.

But they work fine for my other branches.

what errors you getting?

compare DBDefs.pm and DBDefs.pm.default and look for the PLUGIN_CACHE_OPTIONS section.

you may need to copy the section from the default into your config

Yeah it's not in my DBDefs

Odd, the server didn't notice the change.

use CPAN to install Catalyst/Plugin/Cache.pm

cpan

install Catalyst::Plugin::Cache

That worked, thanks

And just in time. The dump is just about to finish downloading.

:-)

I started 27 min ago

ruaok: do you have an md5 thingy for mbdump.tar.bz2?

f32cebe8de99ba57030f0965ff679901

yay it matches

its been transferred 4 times before the file reached you.

and only one of those was fast

for some reason wget stalled for ages and I restarted it so I just wanted to make sure it continued ok

I'm getting Cannot open /usr/share/postgresql/8.4/contrib/musicbrainz_collate.sql

short answer: RTFM

heh, yeah

when updating from git, you should see if INSTALL changes and follow the changes

cd postgresql-musicbrainz-collate

make

sudo make install

you need to install postgresql-contrib

Has the INSTALL been updated?

yes

oh, that's the collate one

yep

Ah whoops, I was looking at a different branch's INSTALL

if you need me, use my nick and I'll hear.

Hopefully I won't :) It's importing now so I think I'm going to go to bed and let it run.

OK, friday night. I think it's time to start musichackday

a bit ahead of yourself, no?

well, hackday proper starts sunday morning for me

which I really don't want to deal with

so I may as well start now

lol

bah. ran out of space

504s across the board; think the server fell asleep

djce: ping?

ah, it's back, I think

is there any test sql queries that exist for showing information

what sort of information?

like a search for an artist showing track, releases etc

like artist=MJ track list

sort of thing

not that I'm aware of

ok

when running /admin/InitDb.pl --createdb --import /tmp/dumps/mbdump*.tar.bz2 --echo is it suppoed to create indexes etc, coz mine failed and when i run quries i get a, no primary key warning

it should do

hmm ok, ill redownload the files and try again then

hi nikki

line 179 in INSTALL should have a . before the /admin

it certainly should

glad to help

hehe

is there a wen portal to experience ngs

wen portal?

web

like musicbrainz.com

the ngs code is running on test.musicbrainz.org if that's what you mean

yep

k im having too many issues with postgres 8.4 and this, so gonna try 8.3 and reinstalling everything again

8.4 is fine

I doubt dropping to 8.3 will fix anything

well it was a pain getting the ident etc working

just postgres issues i think

8.3 is no different

have you pasted into pg_hba like the INSTALL says and restarted the server?

yeah

then it should work :) what doesn't?

kept telling me it needs name value pairs etc

are you using any javascript libs like jquery or mootools etc ?

query

query*

...

jquery*

got there in the end.

I think this keyboard is dying. my caps lock as control hasn't been working properly today

what are you using it for

control? :)

oh

jquery lol. Erm, all our JS really

the release editor mostly, at the moment

have you done a lot of work on it with jquery ?

A fair amount, yea

ic

probably would have been better to go with mootools or dojo, because they have clases, so you can better modularize the code, but im sure there is a good reason why you went with jquery

apart from the simplicity of implementation

You can do classes in jQuery too

It's all javascript at the end of the day, it's not like MooTools does magic we couldn't do our selves

true

(We do use classes, just not the same format as mootools)

good good

is the ngs dump accurate or is it just test data ?

dump=dumps

sorry the singular sounds bad

it's a conversion of the current data

brianfreud and anyone else listening: the 504 errors are happening because the back ends (mb_server) are crashing intermittently while serving requests.

crashing as in receiving SIGKILL

that doesn't sound good :o

not much data to go on yet but I just saw one crashing after querying "SELECT * FROM link_attribute_type WHERE id = '0'"

which also doesn't look great.

but for now I'd better go back to $dayjob.

food for thought.