Hi Fabrice -
Thanks for sending this. Yes, my problem is that I'm working with an older (~1 year) qserv installation. I am now working Douglas to create a new qserv setup using the new install procedure.
Regards,
BIll
On Sep 5, 2013, at 5:55 AM, "Fabrice Jammes" <[log in to unmask]> wrote:
> Hello Bill,
>
> Indeed, Scisql should have been automatically installed by Qserv install
> procedure (documented here :
> https://dev.lsstcorp.org/trac/wiki/db/Qserv/InstallAuto)
>
> This install procedure has been intensively tested and is fully working
> with Qserv version marked with tag : u/fjammes/installCC_FDR
> (This is the version installed on in2p3 300 nodes cluster, it use QMS but
> not the new parser code)
>
> This procedure doesn't work at the moment with the head of the master
> branch. I'll work on this next week.
>
> Hope these informations will help you.
>
> Have a nice day,
>
> Fabrice
>
> On Thu, September 5, 2013 9:36 am, Bill Chickering wrote:
>> You're correct, scisql is not installed. At the same time, the
>> chunkQueries are not reaching the workers (no chunk query execution
>> error--doesn't get that far), so there is also an xrootd related issue.
>>
>> I see that scisql has dependencies MySQLdb and Mako. Perhaps I should
>> install all three of these within my qserv sandbox. Is there an obvious
>> reason why these aren't included as part of the standard qserv build?
>>
>> Thanks,
>> Bill
>>
>>
>> On Sep 4, 2013, at 9:34 PM, Serge Monkewitz <[log in to unmask]> wrote:
>>
>>
>>> Hi Bill,
>>>
>>>
>>> In general, if you get an error like "read/write failed for chunks foo,
>>> bar, baz", you should check the worker xrootd log to see the underlying
>>> chunk query execution error.
>>>
>>> Totally guessing here, but it looks to me like all the failed queries
>>> contain scisql_ UDF calls, and all the (semi-) successful ones don't.
>>> Is it possible you didn't install scisql for the worker mysql
>>> instances?
>>>
>>> Cheers,
>>> Serge
>>>
>>
>> ########################################################################
>> 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
########################################################################
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
|