nikki suddenly remembers she was going to reimport the data
2010-05-14 13403, 2010
navap
Is there a way to reimport the data but keep the edits I've created?
2010-05-14 13437, 2010
ruaok
there is a few ways.
2010-05-14 13418, 2010
ruaok
one interesting way would be to not have InitDb.pl write to your RAWDATA database.
2010-05-14 13433, 2010
ruaok
do this:
2010-05-14 13458, 2010
ruaok
setup the import to import to musicbrainz_db_new and musicbrainz_db_raw_temp
2010-05-14 13426, 2010
ruaok
when you're ready to run change DBDefs to point to musicbrainz_db_new and musicbrainz_db_raw_old
2010-05-14 13443, 2010
ruaok
that *should* keep your edits
2010-05-14 13431, 2010
navap
Was musicbrainz_db_raw_old supposed to be musicbrainz_db_raw_temp ?
2010-05-14 13404, 2010
navap
If I want to change which databases the import goes to, I edit DBDefs.pm right?
2010-05-14 13412, 2010
ruaok
yeds
2010-05-14 13413, 2010
navap
Change the database => for READWRITE and RAWDATA.
2010-05-14 13417, 2010
ruaok
yes
2010-05-14 13423, 2010
navap
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
2010-05-14 13458, 2010
ruaok
ding
2010-05-14 13411, 2010
navap
Okay makes sense, I'll give it a shot :)
2010-05-14 13449, 2010
ijabz_ joined the channel
2010-05-14 13453, 2010
navap
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.
2010-05-14 13418, 2010
navap
I have two MB repos and neither will work when I switch to master.
compare DBDefs.pm and DBDefs.pm.default and look for the PLUGIN_CACHE_OPTIONS section.
2010-05-14 13402, 2010
ruaok
you may need to copy the section from the default into your config
2010-05-14 13416, 2010
navap
Yeah it's not in my DBDefs
2010-05-14 13406, 2010
navap
Odd, the server didn't notice the change.
2010-05-14 13450, 2010
navap is reminded about a conversation we had a long time back where you suggested I setup and use cache and I said no to keep virtualbox running as lightly as possible.
And just in time. The dump is just about to finish downloading.
2010-05-14 13443, 2010
ruaok
:-)
2010-05-14 13425, 2010
nikki wonders if navap started downloading after her
2010-05-14 13414, 2010
navap
I started 27 min ago
2010-05-14 13449, 2010
nikki
ruaok: do you have an md5 thingy for mbdump.tar.bz2?
2010-05-14 13437, 2010
ruaok nods
2010-05-14 13425, 2010
ruaok
f32cebe8de99ba57030f0965ff679901
2010-05-14 13410, 2010
nikki
yay it matches
2010-05-14 13403, 2010
ruaok
its been transferred 4 times before the file reached you.
2010-05-14 13407, 2010
ijabz joined the channel
2010-05-14 13408, 2010
ruaok just thought about that
2010-05-14 13432, 2010
ruaok
and only one of those was fast
2010-05-14 13448, 2010
nikki
for some reason wget stalled for ages and I restarted it so I just wanted to make sure it continued ok
2010-05-14 13424, 2010
nikki starts the import and waits
2010-05-14 13421, 2010
navap
I'm getting Cannot open /usr/share/postgresql/8.4/contrib/musicbrainz_collate.sql
2010-05-14 13441, 2010
ruaok
short answer: RTFM
2010-05-14 13447, 2010
nikki
heh, yeah
2010-05-14 13459, 2010
ruaok
when updating from git, you should see if INSTALL changes and follow the changes
2010-05-14 13411, 2010
ruaok
the useful answer....
2010-05-14 13428, 2010
ruaok
cd postgresql-musicbrainz-collate
2010-05-14 13431, 2010
ruaok
make
2010-05-14 13433, 2010
ruaok
sudo make install
2010-05-14 13440, 2010
nikki
you need to install postgresql-contrib
2010-05-14 13443, 2010
navap
Has the INSTALL been updated?
2010-05-14 13410, 2010
ruaok
yes
2010-05-14 13410, 2010
nikki
oh, that's the collate one
2010-05-14 13421, 2010
ruaok
yep
2010-05-14 13444, 2010
navap
Ah whoops, I was looking at a different branch's INSTALL
2010-05-14 13413, 2010
ruaok goes to do some yoga before bed.
2010-05-14 13424, 2010
ruaok
if you need me, use my nick and I'll hear.
2010-05-14 13423, 2010
navap
Hopefully I won't :) It's importing now so I think I'm going to go to bed and let it run.
2010-05-14 13426, 2010
alastairp
OK, friday night. I think it's time to start musichackday
2010-05-14 13438, 2010
ruaok
a bit ahead of yourself, no?
2010-05-14 13424, 2010
alastairp
well, hackday proper starts sunday morning for me
2010-05-14 13436, 2010
alastairp
which I really don't want to deal with
2010-05-14 13440, 2010
alastairp
so I may as well start now
2010-05-14 13444, 2010
ruaok
lol
2010-05-14 13413, 2010
djce joined the channel
2010-05-14 13443, 2010
nikki
bah. ran out of space
2010-05-14 13451, 2010
outsidecontext joined the channel
2010-05-14 13414, 2010
djce joined the channel
2010-05-14 13428, 2010
brianfreud
504s across the board; think the server fell asleep
2010-05-14 13435, 2010
brianfreud
djce: ping?
2010-05-14 13445, 2010
brianfreud
ah, it's back, I think
2010-05-14 13401, 2010
aCiD2 joined the channel
2010-05-14 13415, 2010
brianfreud joined the channel
2010-05-14 13459, 2010
aCiD2 joined the channel
2010-05-14 13444, 2010
VectorX joined the channel
2010-05-14 13444, 2010
VectorX
is there any test sql queries that exist for showing information
2010-05-14 13458, 2010
nikki
what sort of information?
2010-05-14 13459, 2010
VectorX
like a search for an artist showing track, releases etc
2010-05-14 13428, 2010
VectorX
like artist=MJ track list
2010-05-14 13432, 2010
VectorX
sort of thing
2010-05-14 13443, 2010
nikki
not that I'm aware of
2010-05-14 13431, 2010
VectorX
ok
2010-05-14 13452, 2010
VectorX
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
2010-05-14 13442, 2010
nikki
it should do
2010-05-14 13419, 2010
VectorX
hmm ok, ill redownload the files and try again then
2010-05-14 13434, 2010
nikki prods aCiD2
2010-05-14 13444, 2010
aCiD2
hi nikki
2010-05-14 13421, 2010
nikki
line 179 in INSTALL should have a . before the /admin
k im having too many issues with postgres 8.4 and this, so gonna try 8.3 and reinstalling everything again
2010-05-14 13450, 2010
nikki is using 8.4 ok :/
2010-05-14 13457, 2010
aCiD2
8.4 is fine
2010-05-14 13407, 2010
aCiD2
I doubt dropping to 8.3 will fix anything
2010-05-14 13423, 2010
VectorX
well it was a pain getting the ident etc working
2010-05-14 13429, 2010
VectorX
just postgres issues i think
2010-05-14 13429, 2010
aCiD2
8.3 is no different
2010-05-14 13442, 2010
aCiD2
have you pasted into pg_hba like the INSTALL says and restarted the server?
2010-05-14 13451, 2010
VectorX
yeah
2010-05-14 13400, 2010
aCiD2
then it should work :) what doesn't?
2010-05-14 13417, 2010
VectorX
kept telling me it needs name value pairs etc
2010-05-14 13428, 2010
VectorX
are you using any javascript libs like jquery or mootools etc ?
2010-05-14 13433, 2010
aCiD2
query
2010-05-14 13435, 2010
aCiD2
query*
2010-05-14 13437, 2010
aCiD2
...
2010-05-14 13439, 2010
aCiD2
jquery*
2010-05-14 13441, 2010
aCiD2
got there in the end.
2010-05-14 13451, 2010
nikki giggles
2010-05-14 13411, 2010
aCiD2
I think this keyboard is dying. my caps lock as control hasn't been working properly today
2010-05-14 13419, 2010
VectorX
what are you using it for
2010-05-14 13424, 2010
aCiD2
control? :)
2010-05-14 13428, 2010
aCiD2
oh
2010-05-14 13435, 2010
aCiD2
jquery lol. Erm, all our JS really
2010-05-14 13445, 2010
aCiD2
the release editor mostly, at the moment
2010-05-14 13452, 2010
VectorX
have you done a lot of work on it with jquery ?
2010-05-14 13459, 2010
aCiD2
A fair amount, yea
2010-05-14 13408, 2010
VectorX
ic
2010-05-14 13405, 2010
VectorX
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
2010-05-14 13418, 2010
VectorX
apart from the simplicity of implementation
2010-05-14 13446, 2010
aCiD2
You can do classes in jQuery too
2010-05-14 13411, 2010
aCiD2
It's all javascript at the end of the day, it's not like MooTools does magic we couldn't do our selves
2010-05-14 13420, 2010
VectorX
true
2010-05-14 13420, 2010
aCiD2
(We do use classes, just not the same format as mootools)
2010-05-14 13452, 2010
VectorX
good good
2010-05-14 13429, 2010
VectorX
is the ngs dump accurate or is it just test data ?
2010-05-14 13441, 2010
VectorX
dump=dumps
2010-05-14 13453, 2010
VectorX
sorry the singular sounds bad
2010-05-14 13423, 2010
nikki
it's a conversion of the current data
2010-05-14 13430, 2010
djce
brianfreud and anyone else listening: the 504 errors are happening because the back ends (mb_server) are crashing intermittently while serving requests.
2010-05-14 13440, 2010
djce
crashing as in receiving SIGKILL
2010-05-14 13437, 2010
nikki
that doesn't sound good :o
2010-05-14 13453, 2010
djce
not much data to go on yet but I just saw one crashing after querying "SELECT * FROM link_attribute_type WHERE id = '0'"
