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
|