#metabrainz

/

      • adhawkins
        I'll make a start on the ones I can do. Thanks for the pointer to those ones.
      • 2017-08-14 22647, 2017

      • adhawkins
        Freso: Do you have any collections that contain the things I'm after? If they're public I could use them to test with.
      • 2017-08-14 22626, 2017

      • Freso
        adhawkins: I don't know what things you're after. :) I made a comment on your gist with a link to all of my (public) collections.
      • 2017-08-14 22628, 2017

      • adhawkins
        Freso: Thanks, I'll take a look at that and see if it helps.
      • 2017-08-14 22611, 2017

      • CatQuest has a list of instruments.. but uh not public
      • 2017-08-14 22648, 2017

      • adhawkins
        Any WS experts here? Is there a way of querying a collection and having it expand (e.g.) the instrument list?
      • 2017-08-14 22652, 2017

      • adhawkins
      • 2017-08-14 22613, 2017

      • adhawkins
        As an example, that has an instrument list that says there are three of them, but doesn't actually list them. Is it possible, or is that all you can get by querying a collection?
      • 2017-08-14 22648, 2017

      • adhawkins
        Also, so far, none of the responses for 'collection' have had a 'type-id' attribute. The schema suggests that they should have.
      • 2017-08-14 22602, 2017

      • adhawkins
        Although I guess the scheme does mark it as optional...
      • 2017-08-14 22618, 2017

      • adhawkins
      • 2017-08-14 22632, 2017

      • adhawkins
        Who is the font of all knowledge as far as the WS goes these days?
      • 2017-08-14 22623, 2017

      • Freso
        bitmap is maybe the best guess for that.
      • 2017-08-14 22607, 2017

      • adhawkins
        Freso: Ok, thanks. What timezone is he in?
      • 2017-08-14 22613, 2017

      • Freso
        adhawkins: UTC-0600, I think.
      • 2017-08-14 22657, 2017

      • adhawkins
        Oh ok. He might be around at some point then. If not, I'll pop back tomorrow.
      • 2017-08-14 22606, 2017

      • adhawkins
        Thanks for the help so far guys, appreciate it as always.
      • 2017-08-14 22626, 2017

      • pingupingu
        Hello giys
      • 2017-08-14 22622, 2017

      • Freso
        aug 14 21:14:56 koume chronyd[11159]: System clock wrong by 126.818305 seconds, adjustment started
      • 2017-08-14 22622, 2017

      • Freso
        aug 14 21:17:03 koume chronyd[11159]: System clock was stepped by 126.818305 seconds
      • 2017-08-14 22631, 2017

      • pingupingu
        I have just downloaded the mbdump*.tar.bz2 and imported it with ./admin/InitDb.pl as shown in https://github.com/metabrainz/musicbrainz-server/…
      • 2017-08-14 22640, 2017

      • Freso
        My clock should be fixed now. Sorry about time confusion for meeting earlier. :)
      • 2017-08-14 22649, 2017

      • pingupingu
        now I have installed it and all is well. now I am installing the search server with the freedb indexdata.. but its been running really really slow. its taken about 15 hours or so and completed about 57%
      • 2017-08-14 22658, 2017

      • pingupingu
        I don't remember this running this slow
      • 2017-08-14 22615, 2017

      • Freso
        (systemd was starting a chrony.service on boot, but the actual service file is chronyd.service. I don't know if that service file changed name at some point, or if my NTP setup has been broken for ages here. :/)
      • 2017-08-14 22632, 2017

      • Freso
        pingupingu: Search server indexing is really, really, really slow.
      • 2017-08-14 22630, 2017

      • pingupingu
        oh ok.. I am checking for indices on the musicbrainz tables.. but I am not finding any.. do the dump include the indices as well?
      • 2017-08-14 22647, 2017

      • pingupingu
        the mbdump*.tar.bz2 files I mean
      • 2017-08-14 22656, 2017

      • Freso
        bitmap, yvanzo: ^
      • 2017-08-14 22627, 2017

      • pingupingu
        Freso, ?
      • 2017-08-14 22611, 2017

      • khan_ joined the channel
      • 2017-08-14 22630, 2017

      • khan has quit
      • 2017-08-14 22602, 2017

      • Freso
        pingupingu: bitmap and yvanzo are our MusicBrainz developers and some of the ones more likely to know the answers.
      • 2017-08-14 22626, 2017

      • pingupingu
        right
      • 2017-08-14 22641, 2017

      • yvanzo
        pingupingu: I can only confirm Freso's answer: indexing can be damn slow.
      • 2017-08-14 22629, 2017

      • pingupingu
        yvanzo, I tried to list indices but all I got was this: https://paste.fedoraproject.org/paste/rBkzw2DIgRA…
      • 2017-08-14 22629, 2017

      • pingupingu
        I would have expected a lot more indices for the mb tables
      • 2017-08-14 22626, 2017

      • yvanzo
        Did you grab search indices from mbdump-derived?
      • 2017-08-14 22650, 2017

      • pingupingu
        these are the ones I ingested: mbdump-derived.tar.bz2 mbdump-editor.tar.bz2 mbdump-stats.tar.bz2 mbdump.tar.bz2
      • 2017-08-14 22648, 2017

      • yvanzo
        Ok, sure they are not included anymore.
      • 2017-08-14 22611, 2017

      • pingupingu
        yvanzo, eh?
      • 2017-08-14 22619, 2017

      • kepstin
        the db indexes should be created by the InitDb tool, I thought...
      • 2017-08-14 22629, 2017

      • kepstin
        so I wonder if something went wrong there
      • 2017-08-14 22609, 2017

      • pingupingu
        when I ran this: it definitely says "Seq Scan" implying no index
      • 2017-08-14 22618, 2017

      • pingupingu
        hmm kepstin
      • 2017-08-14 22633, 2017

      • pingupingu
      • 2017-08-14 22629, 2017

      • kepstin
        if you look at https://github.com/metabrainz/musicbrainz-server/… - what it does is create the tables, load the data, then create indexes
      • 2017-08-14 22659, 2017

      • kepstin
        so what probably happened for you is something went wrong during import, so it never got to the stop where it created indexes
      • 2017-08-14 22623, 2017

      • pingupingu
        hmm I didn't see any error messages on import
      • 2017-08-14 22617, 2017

      • pingupingu
        I think this is the reason why the search indices are taking this long. I will cancel the indices.. drop the db and run the file ingest again.. will paste the output here
      • 2017-08-14 22658, 2017

      • pingupingu
        kepstin, I am running the ingests again now
      • 2017-08-14 22603, 2017

      • pingupingu
      • 2017-08-14 22600, 2017

      • kepstin
        hmm, gonna need some help from a dev for that
      • 2017-08-14 22607, 2017

      • pingupingu
      • 2017-08-14 22626, 2017

      • kepstin
        make sure you're running a mbs codebase for the same database schema version as the dump was generated with
      • 2017-08-14 22631, 2017

      • UmkaDK_ joined the channel
      • 2017-08-14 22638, 2017

      • kepstin
        but other than that I don't know how to help you :/
      • 2017-08-14 22655, 2017

      • pingupingu
        I am still running an older version of MB
      • 2017-08-14 22627, 2017

      • pingupingu
        I had to change the DBprefs. db_schema something to {23} instead of {1}
      • 2017-08-14 22619, 2017

      • kepstin
        importing data that doesn't match the schema of your server version will not work.
      • 2017-08-14 22650, 2017

      • Freso
        pingupingu: How much older are we talking?
      • 2017-08-14 22633, 2017

      • pingupingu
        last commit: d8ebdbbbdd1b40ad8bafef16703b377df43900d1 20 Feb 2017
      • 2017-08-14 22605, 2017

      • UmkaDK has quit
      • 2017-08-14 22641, 2017

      • Freso
        You will want to move to a newer codebase.
      • 2017-08-14 22648, 2017

      • Freso
        We had a schema change release in...
      • 2017-08-14 22656, 2017

      • Freso
        April(?).
      • 2017-08-14 22622, 2017

      • pingupingu
        arr ok.. let me pull in the latest
      • 2017-08-14 22610, 2017

      • yvanzo
        in May
      • 2017-08-14 22605, 2017

      • Freso
        Well, after February either way. :)
      • 2017-08-14 22652, 2017

      • arbenina_ joined the channel
      • 2017-08-14 22623, 2017

      • arbenina_ has quit
      • 2017-08-14 22631, 2017

      • drsaunde
        ruaok: I've replied
      • 2017-08-14 22658, 2017

      • adhawkins
        Anyone know of an event with some relations set?
      • 2017-08-14 22646, 2017

      • drsaunde
      • 2017-08-14 22645, 2017

      • yvanzo
      • 2017-08-14 22609, 2017

      • drsaunde
        yvanzo: that one needs a little fixing (see how the date is there twice in the title... it doesn't need to be in the title as its there automatically)
      • 2017-08-14 22600, 2017

      • yvanzo
        Fixed, thanks.
      • 2017-08-14 22620, 2017

      • pingupingu
        Freso, yvanzo updated to the latest master.. build and configured.. now ingesting the dumps
      • 2017-08-14 22614, 2017

      • CallerNo6 has quit
      • 2017-08-14 22654, 2017

      • pingupingu
        built the search server now waiting for the mbdump ingest to finish
      • 2017-08-14 22605, 2017

      • Mineo has quit
      • 2017-08-14 22646, 2017

      • chhavi__ has quit
      • 2017-08-14 22610, 2017

      • adhawkins
        yvanzo: Thanks, appreciate it.
      • 2017-08-14 22618, 2017

      • adhawkins
        drsaunde: Ditto
      • 2017-08-14 22648, 2017

      • jwf|matrix has quit
      • 2017-08-14 22648, 2017

      • suhas2go[m] has quit
      • 2017-08-14 22653, 2017

      • Leo_Verto has quit
      • 2017-08-14 22605, 2017

      • sagar-kohli[m] has quit
      • 2017-08-14 22610, 2017

      • psolanki has quit
      • 2017-08-14 22650, 2017

      • pingupingu
        Freso, yvanzo kepstin yes that was the problem it seems a newer DB schema the indices are being generated
      • 2017-08-14 22633, 2017

      • reosarevok
        ruaok, Quesito: I did what I could, but I haven't done this sort of legal text often, so you might want to have someone who has take a quick look and fix some issues
      • 2017-08-14 22619, 2017

      • sagar-kohli[m] joined the channel
      • 2017-08-14 22646, 2017

      • Leo_Verto joined the channel
      • 2017-08-14 22646, 2017

      • suhas2go[m] joined the channel
      • 2017-08-14 22646, 2017

      • jwf|matrix joined the channel
      • 2017-08-14 22653, 2017

      • psolanki joined the channel
      • 2017-08-14 22617, 2017

      • psolanki is now known as Guest38886
      • 2017-08-14 22650, 2017

      • pingupingu has quit
      • 2017-08-14 22651, 2017

      • Gentlecat
        reosarevok, Quesito: can add a separate link
      • 2017-08-14 22604, 2017

      • Gentlecat
      • 2017-08-14 22626, 2017

      • jwf|matrix has quit
      • 2017-08-14 22626, 2017

      • jwf|matrix joined the channel
      • 2017-08-14 22613, 2017

      • Quesito
        Gentlecat: I think that might be helpful-and also perhaps when I email folks that sign up-a little blip about how to get started maybe too...
      • 2017-08-14 22649, 2017

      • Gentlecat
        sure
      • 2017-08-14 22646, 2017

      • github joined the channel
      • 2017-08-14 22646, 2017

      • github
        [metabrainz.org] gentlecat opened pull request #284: Add a separate link for logging in into the navbar (master...sign-in) https://git.io/v75iC
      • 2017-08-14 22646, 2017

      • github has left the channel
      • 2017-08-14 22642, 2017

      • Gentlecat
        Quesito: text is a bit more complicated, so it's probably best to create a ticket
      • 2017-08-14 22653, 2017

      • legoatm is now known as legoktm
      • 2017-08-14 22626, 2017

      • D4RK-PH0ENiX has quit
      • 2017-08-14 22647, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-08-14 22651, 2017

      • D4RK-PH0ENiX has quit
      • 2017-08-14 22600, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-08-14 22600, 2017

      • D4RK-PH0ENiX has quit
      • 2017-08-14 22606, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-08-14 22607, 2017

      • D4RK-PH0ENiX has quit
      • 2017-08-14 22637, 2017

      • D4RK-PH0ENiX joined the channel
      • 2017-08-14 22605, 2017

      • github joined the channel
      • 2017-08-14 22605, 2017

      • github
        [metabrainz.org] gentlecat opened pull request #285: Update Python dependencies (master...dependencies) https://git.io/v75DJ
      • 2017-08-14 22605, 2017

      • github has left the channel
      • 2017-08-14 22620, 2017

      • Sophist-UK has quit
      • 2017-08-14 22621, 2017

      • spuniun_ has quit
      • 2017-08-14 22621, 2017

      • jwf has quit
      • 2017-08-14 22621, 2017

      • CatQuest has quit
      • 2017-08-14 22621, 2017

      • mrc0mmand has quit
      • 2017-08-14 22622, 2017

      • moufl has quit
      • 2017-08-14 22622, 2017

      • samj1912 has quit
      • 2017-08-14 22622, 2017

      • _flow_ has quit
      • 2017-08-14 22622, 2017

      • yurrriq has quit
      • 2017-08-14 22622, 2017

      • hernantz has quit
      • 2017-08-14 22623, 2017

      • ruaok has quit
      • 2017-08-14 22625, 2017

      • iliekcomputers has quit
      • 2017-08-14 22625, 2017

      • anshuman73 has quit
      • 2017-08-14 22625, 2017

      • rvedotrc has quit
      • 2017-08-14 22626, 2017

      • Ether_Man has quit
      • 2017-08-14 22626, 2017

      • armalcolite has quit
      • 2017-08-14 22626, 2017

      • cjnolet_ has quit
      • 2017-08-14 22627, 2017

      • minus has quit
      • 2017-08-14 22627, 2017

      • Clint has quit
      • 2017-08-14 22627, 2017

      • Tykling has quit
      • 2017-08-14 22627, 2017

      • sagar-kohli[m] has quit
      • 2017-08-14 22629, 2017

      • legoktm has quit
      • 2017-08-14 22630, 2017

      • jwheare has quit
      • 2017-08-14 22630, 2017

      • kasb4h has quit
      • 2017-08-14 22630, 2017

      • Gentlecat has quit
      • 2017-08-14 22630, 2017

      • Quesito has quit
      • 2017-08-14 22630, 2017

      • RJ2 has quit
      • 2017-08-14 22631, 2017

      • MightyJay has quit
      • 2017-08-14 22631, 2017

      • nawcom has quit
      • 2017-08-14 22631, 2017

      • MarcusPie has quit