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
|