-
ruaok
where would it be? under your desk?
2005-10-01 27453, 2005
-
ruaok gets punchy
2005-10-01 27454, 2005
-
srotta
ruaok: Ok, not a problem, I have more time to check the background info 8)
2005-10-01 27415, 2005
-
djce
well I ran the export by hand yesterday, so maybe it's in some unusual directory.
2005-10-01 27405, 2005
-
ruaok
oh.
2005-10-01 27417, 2005
-
ruaok
well, if you find it, that'd be grand.
2005-10-01 27426, 2005
-
warp
ruaok: .nl?
2005-10-01 27429, 2005
-
warp
ruaok: when? where? how?
2005-10-01 27429, 2005
-
djce
I'll try.
2005-10-01 27449, 2005
-
ruaok
warp: I'll be logging into the
nl.mb.org server. :-)
2005-10-01 27456, 2005
-
ruaok
(if dave doesn't find the missing packet)
2005-10-01 27406, 2005
-
warp
aw
2005-10-01 27424, 2005
-
Knio-sleep has quit
2005-10-01 27434, 2005
-
warp
oh, i think i still owe you some chocolate btw.
2005-10-01 27442, 2005
-
ruaok
oh yeah. soon.
2005-10-01 27448, 2005
-
ruaok
we had 36C weather today
2005-10-01 27454, 2005
-
warp
yikes.
2005-10-01 27403, 2005
-
warp
i'll mention it again in two months then.
2005-10-01 27407, 2005
-
warp
:D
2005-10-01 27409, 2005
-
ruaok
:-)
2005-10-01 27424, 2005
-
djce
Ah, I see. I chose "no compression", which means the replication data is in individual files, not a tar packet.
2005-10-01 27426, 2005
-
dholmes has quit
2005-10-01 27429, 2005
-
djce
I'll go make the packet...
2005-10-01 27414, 2005
-
srotta
Hmm, when changing the artist, do I have to create a new album under the correct artist name, and then merge the old album into that one?
2005-10-01 27436, 2005
-
chocomo
no just select 'move'
2005-10-01 27445, 2005
-
chocomo
and link the mods here
2005-10-01 27450, 2005
-
srotta
Damn, I'm blind. 8)
2005-10-01 27453, 2005
-
chocomo
:)
2005-10-01 27403, 2005
-
chocomo
yo're a newbie. its alowed
2005-10-01 27413, 2005
-
djce
ruaok: the file timestamp is a bit screwy, but the packet is now in place on the FTP site.
2005-10-01 27457, 2005
-
ruaok
thanks!
2005-10-01 27405, 2005
-
ruaok
oh, I wonder if we made the deadline.
2005-10-01 27412, 2005
-
djce
?
2005-10-01 27424, 2005
-
ruaok
Sat Oct 1 10:15:06 2005 : Replication packet #4331 not available
2005-10-01 27429, 2005
-
djce
cron?
2005-10-01 27436, 2005
-
djce
ah.
2005-10-01 27436, 2005
-
ruaok
in .nl and .de
2005-10-01 27453, 2005
-
ruaok goes to boot the two to catch up in the meantime
2005-10-01 27457, 2005
-
djce
ah well. time to bite the bullet I suppose.
2005-10-01 27407, 2005
-
djce fires up lots of shells
2005-10-01 27414, 2005
-
ruaok
oh - with the new segment count in PG, the application of replication packets flies!
2005-10-01 27421, 2005
-
ruaok
much better than a stock install.
2005-10-01 27425, 2005
-
ruaok
ok. here goes.
2005-10-01 27435, 2005
-
djce
cool.
2005-10-01 27443, 2005
-
ruaok
packet 4331 is applying now
2005-10-01 27454, 2005
-
ruaok
can you link to the mirror servers in your offline message?
2005-10-01 27412, 2005
-
djce
sure
2005-10-01 27437, 2005
-
ruaok
ok next packet is applying. looks good.
2005-10-01 27438, 2005
-
ruaok
thanks!!
2005-10-01 27435, 2005
-
srotta
2005-10-01 27419, 2005
-
ruaok
looks good to me.
2005-10-01 27431, 2005
-
djce writes a script to set the servers offline / online ...
2005-10-01 27438, 2005
-
ruaok
.nl is up to date and .de will be in about an hour.
2005-10-01 27409, 2005
-
chocomo
ja
2005-10-01 27418, 2005
-
chocomo
ok I'm of for food and mom
2005-10-01 27444, 2005
-
ruaok
have fun.
2005-10-01 27453, 2005
-
ruaok
gute besserung for your mom!
2005-10-01 27459, 2005
-
chocomo
uuuh
2005-10-01 27406, 2005
-
chocomo
I'll have to write that down
2005-10-01 27407, 2005
-
djce
ok time to get busy, at last.
2005-10-01 27414, 2005
-
djce
say bye to the web site! for now...
2005-10-01 27423, 2005
-
chocomo
eek wait
2005-10-01 27451, 2005
-
chocomo
nw
2005-10-01 27455, 2005
-
chocomo
my mom I wist
2005-10-01 27400, 2005
-
chocomo
bai
2005-10-01 27415, 2005
-
djce
export started...
2005-10-01 27406, 2005
-
djce
dump complete.
2005-10-01 27432, 2005
-
ruaok
mb & meb?
2005-10-01 27450, 2005
-
ruaok
I guess meb would go so fast you couldn't blink
2005-10-01 27438, 2005
-
djce
ypu.
2005-10-01 27439, 2005
-
djce
yup.
2005-10-01 27451, 2005
-
djce
new db instance created...
2005-10-01 27411, 2005
-
djce tries to remember how to use "InitDb.pl"
2005-10-01 27436, 2005
-
djce
import started...
2005-10-01 27437, 2005
-
ruaok
--createdb --import mbdump...
2005-10-01 27439, 2005
-
ruaok
:-)
2005-10-01 27447, 2005
-
djce
--with-pending=/path/to/pending.so
2005-10-01 27456, 2005
-
djce
It told me off when I missed it out :-)
2005-10-01 27435, 2005
-
djce
mmmmm tables. /me pats the database
2005-10-01 27445, 2005
-
djce
hmm.. now that's a bit of an oversight.
2005-10-01 27456, 2005
-
djce
metabrainz has an "Export" script, but no "Import".
2005-10-01 27401, 2005
-
djce
I'll have to do that one by hand.
2005-10-01 27414, 2005
-
ruaok looks shifty
2005-10-01 27418, 2005
-
djce
:-)
2005-10-01 27422, 2005
-
djce
only 2 or three tables, IIRC.
2005-10-01 27452, 2005
-
ruaok
there was more than one? :-)
2005-10-01 27416, 2005
-
ruaok
loading data still??
2005-10-01 27420, 2005
-
djce
ya.
2005-10-01 27432, 2005
-
djce
metab has two real tables, plus three replication ones .
2005-10-01 27453, 2005
-
djce
mmmm moderation_closed. Henceforth I shall call him, "fatboy".
2005-10-01 27426, 2005
-
ruaok
lol
2005-10-01 27438, 2005
-
ruaok
I seriously think we need to put some of that out to pasture.
2005-10-01 27405, 2005
-
djce
I think you're probably right.
2005-10-01 27440, 2005
-
djce
I suspect it doesn't help that one of the rows in the table is over 300,000 bytes wide.
2005-10-01 27418, 2005
-
ruaok
what??
2005-10-01 27434, 2005
-
ruaok
have you ever looked at it?
2005-10-01 27414, 2005
-
djce
it's a fscking huge "add trms" mod.
2005-10-01 27418, 2005
-
djce
with many many many trms.
2005-10-01 27422, 2005
-
djce
all in one moderation.
2005-10-01 27443, 2005
-
djce
It's all documented in MBImport. Take a look at the comments.
2005-10-01 27417, 2005
-
djce
That's why there's now a limit on the number of TRMs you can submit at once.
2005-10-01 27440, 2005
-
djce
(Or rather, IIRC, if you submit 100s of TRMs, they get added in a series of smaller moderations, instead of all in one big one).
2005-10-01 27438, 2005
-
ruaok
I remember now
2005-10-01 27428, 2005
-
ruaok
why don't we stick that list of trm someplace and then nuke that one filed with a see here: note?
2005-10-01 27453, 2005
-
djce
could do. there are quite a few really massive mod rows; that one is just the largest of all.
2005-10-01 27413, 2005
-
ruaok
where is it at now?
2005-10-01 27421, 2005
-
djce
the import? "trackwords".
2005-10-01 27437, 2005
-
ruaok should go to bed
2005-10-01 27401, 2005
-
djce
Don't let me stop you. I'll try and have good news for you when you're back.
2005-10-01 27423, 2005
-
ruaok
dunno if I can sleep at this point.
2005-10-01 27458, 2005
-
djce
trmjoin...
2005-10-01 27405, 2005
-
djce
vote_closed....
2005-10-01 27432, 2005
-
djce
primary keys...
2005-10-01 27459, 2005
-
ruaok goes to brush his teeth
2005-10-01 27405, 2005
-
djce
almost done with the keys...
2005-10-01 27432, 2005
-
djce
on to the indexes...
2005-10-01 27411, 2005
-
ruaok returns ready for bed
2005-10-01 27426, 2005
-
djce
still on the indexes I'm afraid.
2005-10-01 27450, 2005
-
djce
my guess is it'll be at least 30 minutes, probably more like an hour until completion.
2005-10-01 27453, 2005
-
djce
foreign keys ...
2005-10-01 27427, 2005
-
ruaok dawdles along
2005-10-01 27416, 2005
-
djce
Some time after this is done, I need to fix the import scripts.
2005-10-01 27442, 2005
-
djce
Something is holding open a connection on template1,which means that I can't create the metabrainz db until musicbrainz is all complete.
2005-10-01 27421, 2005
-
djce
fatboy's constraints now...
2005-10-01 27416, 2005
-
ruaok
lol
2005-10-01 27457, 2005
-
djce
trackwords...
2005-10-01 27407, 2005
-
ValHallA|SW joined the channel
2005-10-01 27450, 2005
-
srotta
I read a while ago about this database built by ANTs.
2005-10-01 27452, 2005
-
Kilu joined the channel
2005-10-01 27405, 2005
-
srotta
Seems like a real miracle worker, so it makes my wonder, what's wrong with it. 8)
2005-10-01 27448, 2005
-
djce
vacuuming....
2005-10-01 27426, 2005
-
ruaok
ooh!
2005-10-01 27433, 2005
-
ruaok
i mean. oooooh!
2005-10-01 27440, 2005
-
ruaok
(on the nikki scale)
2005-10-01 27437, 2005
-
djce
2005-10-01 27440, 2005
-
djce
mmmm rebuild
2005-10-01 27408, 2005
-
djce
musicb. done...
2005-10-01 27413, 2005
-
djce
ok I think we're all done.
2005-10-01 27414, 2005
-
djce
woo hoo!
2005-10-01 27443, 2005
-
ruaok
yay!
2005-10-01 27448, 2005
-
ruaok
bring 'er up!
2005-10-01 27442, 2005
-
dholmes joined the channel
2005-10-01 27442, 2005
-
djce
here goes...
2005-10-01 27401, 2005
-
djce
so far so good.
2005-10-01 27408, 2005
-
djce
please dive in and test!
2005-10-01 27429, 2005
-
djce
now I need to go fix the new, missing, replication packet.
2005-10-01 27442, 2005
-
djce
/Hopefully/ replication didn't break during all of that.
2005-10-01 27429, 2005
-
ruaok
looks good.
2005-10-01 27441, 2005
-
ruaok
I'll keep an eye on replication.
2005-10-01 27445, 2005
-
ruaok
.de just caught up.
