Build the index. It's in Douglas's scripts. It might not be in the recipe. Does the recipe treat how to load data? If so, it should be in the recipe. I really want to get rid of doing it manually--hence the desire for non-manual loading code. -Daniel On 05/20/2014 11:42 PM, Becla, Jacek wrote: > And when/how do we initialize it? Maybe we will have > the answer from Fabrice when we wake up :) > > Jacek > > > > On 05/20/2014 11:28 PM, Daniel L. Wang wrote: >> I think qservMeta is the db where we keep the secondary indexes. >> >> On 05/20/2014 11:12 PM, Jacek Becla wrote: >>> Quick question, I am trying to setup new environment from scratch, >>> and I stumbled across a problem with missing qservMeta database. >>> >>> I basically did the more or less typical: >>> >>> wget http://sw.lsstcorp.org/eupspkg/newinstall.sh >>> bash newinstall.sh >>> source loadLSST.sh >>> eups distrib install qserv -r >>> http://lsst-web.ncsa.illinois.edu/~fjammes/qserv >>> >>> cloned qserv, setup -r ., scons, scons install, >>> mkdir build/dist/ups, >>> eups expandtable ups/qserv.table > build/dist/ups/qserv.table >>> cd build/dist, setup -r ., cd admin/, scons, scons install >>> >>> cd build/dist/var/lib/mysql/ >>> ln -s /u1/pt1myisam/LSST >>> cd /u1/pt1myisam/paramFiles_v2/ >>> ~/qserv/2/qserv/admin/bin/qserv-admin.py < mydb.loadIt >>> and copied over emptyChunks.txt to build/dist/etc/ >>> >>> and tried running: >>> >>> SELECT * FROM Object WHERE objectId = 430213989000 >>> >>> which fails with >>> >>> 20140521 01:07:47.331687 0x27e0200 ERR <py> Unexpected error: (<class >>> '_mysql_exceptions.ProgrammingError'>, ProgrammingError(1146, "T >>> able 'qservMeta.LSST__Object' doesn't exist"), <traceback object at >>> 0x2712b90>) Traceback (most recent call last): >>> >>> >>> Indeed, I can verify the database qservMeta database not exist. >>> >>> Note, I did not try to run qserv-testdata. >>> >>> Before I dig any further... can anyone remind me what the deal >>> is with qservMeta? Do we really still need it and if so, who >>> should create it? >>> >>> We never talked about creating it at the Dev week, and it is >>> not mentioned in: >>> >>> https://dev.lsstcorp.org/trac/wiki/db/Qserv/RedesignFY2014/Hackathon2/howToRunQserv >>> >>> What am I missing? >>> >>> Jacek >>> >>> ######################################################################## >>> Use REPLY-ALL to reply to list >>> >>> To unsubscribe from the QSERV-L list, click the following link: >>> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1