Emmanuel

I am puzzled how you got yourself into that state.
Clearly your database name is wrong. But I tried
to reproduce that: I put in the qms log file
a wrong db name:

[qmsdb]
db = testX.slac.stanford.edu

and the system acted as designed: I wasn't able to
start qserv, it complained about:

No metadata found.

and it the qms log I saw:

2013-04-26 22:57:57,076 DEBUG connected to mysql (socket)
2013-04-26 22:59:05,413 DEBUG Failed to select db 
'qms_testX.slac.stanford.edu'
2013-04-26 22:59:05,413 ERROR Exception in listDbs: No metadata found.

Can you send me your qms config file?

Jacek



On 04/25/2013 11:34 PM, Emmanuel Medernach wrote:
> Hello Jacek,
>
> We are working on QMS integration and we have a problem when we try to start it:
>
> 2013-04-25 16:53:18,436 DEBUG connected to mysql (port)
> 2013-04-25 16:53:20,419 DEBUG Connected to db qms_<...>.in2p3.fr
> 2013-04-25 16:53:20,419 DEBUG Executing SELECT dbName FROM DbMeta
> 2013-04-25 16:53:20,422 ERROR MySQL Error [1146]: Table
> 'qms_<...>.in2p3.fr.DbMeta' doesn't exist
> 2013-04-25 16:53:20,424 ERROR Exception in listDbs: Internal MySQL error. (MySQL
> Error [1146]: Table 'qms_<...>.in2p3.fr.DbMeta' doesn't exist)
>
>
> It seems some QMS tables are missing, could you please provide us a description
> of these tables in order to create them ?
>
> Thanks in advance,
> --
> Emmanuel
>
>
> Jacek Becla a écrit :
>> Fabrice
>>
>> Re 2837 which I just opened: please let me know if you have
>> any questions whatsoever. We should get some experience
>> with the  metadata server before we run the large scale
>> tests, so we should play with it soon.
>>
>> Note that things such as
>>
>> ./meta/examples/runMetaClientTool.sh createTable LSST
>>    tableName=RunDeepSource partitioning=on
>>    schemaFile=../testdata/case03/data/RunDeepSource.sql
>>    overlap=0.025 phiColName=coord_ra thetaColName=coord_decl
>>    logicalPart=1 physChunking=0x0021
>>
>> can also be loaded using a config file instead many
>> command line arguments, as showed in
>> ./meta/tests/completeTest.sh:
>>
>> createDb Summer2012 @./meta/examples/dbPartitioned.params
>>
>> createTable Summer2012 @./meta/examples/tb_Source.params
>>
>> A thought: you might create such config files and keep them
>> together with the data for each of the test cases.
>>
>> I wasn't sure if I should assign it to you or Emmanuel,
>> feel free to reassign...
>>
>> thanks,
>> 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