the raw tables got imported into the musicbrainz schema, not the musicbrainz_raw schema.
2011-07-10 19108, 2011
ruaok
:-(
2011-07-10 19111, 2011
reosarevok
warp: couldn't you live somewhere where trains don't cost 30 euros for 2 hours?
2011-07-10 19107, 2011
nikki blinks
2011-07-10 19149, 2011
ocharles
ruaok: that's correct
2011-07-10 19156, 2011
ocharles
ruaok: they aren't meant to be in musicbrainz_raw
2011-07-10 19157, 2011
ruaok
reosarevok: we could go to london where you can pay 30 EUR for a 15 minute ride!
2011-07-10 19116, 2011
ocharles
ruaok: also, indexes aren't the huge bottleneck in the import, FKs and constraints are more costly. but I figured what the hell, might as well make it zippy :)
2011-07-10 19126, 2011
reosarevok
:p
2011-07-10 19129, 2011
ruaok
ah, interesting. then my dbdefs settings were wrong and the search might work.
2011-07-10 19136, 2011
ocharles nods
2011-07-10 19141, 2011
reosarevok
(ok, true, not 6€, a bit more, but still)
2011-07-10 19148, 2011
ocharles
I originally planned to put it in mb_raw
2011-07-10 19154, 2011
ocharles
but luks said why bother, and I agree
2011-07-10 19109, 2011
ocharles
but the upgrade ran ok as master?
2011-07-10 19116, 2011
ruaok
ocharles: deleting bad FKs now.
2011-07-10 19121, 2011
ruaok
so, still waiting.
2011-07-10 19139, 2011
ocharles
ah, ok
2011-07-10 19142, 2011
ocharles
when did that start?
2011-07-10 19116, 2011
ruaok
Fks started 40 minutes ago
2011-07-10 19110, 2011
ocharles
hum
2011-07-10 19128, 2011
ocharles
seems worth running this deletion ahead of time then
2011-07-10 19138, 2011
ocharles
could you email me a prod to do that tomorrow?
2011-07-10 19140, 2011
ruaok
yes, plz.
2011-07-10 19107, 2011
ruaok
and DB_READ_ONLY mode is true to its name now?
2011-07-10 19123, 2011
ocharles
no, good point
2011-07-10 19136, 2011
ruaok pushes it onto ocharles' stack
2011-07-10 19142, 2011
ruaok
now doing PKs.
2011-07-10 19152, 2011
ruaok
yes, we need to do this cleanup before the put things in read-only