#musicbrainz-devel

/

      • ruaok
        no, thanks for the reminder.
      • 2011-07-10 19139, 2011

      • ocharles
        ok, outta here, back in an hour
      • 2011-07-10 19153, 2011

      • ruaok
        one sec.
      • 2011-07-10 19107, 2011

      • ruaok
        slaves do have indexes
      • 2011-07-10 19151, 2011

      • ruaok
        I think I know why the edit search is broken. :(
      • 2011-07-10 19106, 2011

      • ruaok
        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