Print

Print


Hi Jacek,

It's a bug, sigh. You can get around it by using the following directive:

cms.space mwfiles linger 0

Notice the addition of another option. The code wants at least one option 
and while it accepts and uses mwfiles it doesn't recognize that it valid as 
the only option. The error message in the log file sort of tells you that.

Andy

-----Original Message----- 
From: Jacek Becla
Sent: Tuesday, July 28, 2015 12:44 PM
To: qserv-l ; Thukral, Vaikunth ; Andrew Hanushevsky
Subject: Re: [QSERV-L] Fwd: Re: [QSERV-L] Error provisioning, msg=Unable to 
write file; multiple files exist

Andy,

I tried adding that line but the cmsd won't start.

The log file attached.

Are you at slac? Maybe you wanna stop by?

Jacek






On 07/27/2015 04:44 PM, Jacek Becla wrote:
> Thanks Andy, it is simpler than I expected :)
>
> I am forwarding to the list.
>
> Vaikunth, can you try?
>
> Jacek
>
>
>
> -------- Forwarded Message --------
> Subject: Re: [QSERV-L] Error provisioning, msg=Unable to write file;
> multiple files exist
> Date: Mon, 27 Jul 2015 16:03:42 -0700
> From: Andrew Hanushevsky <[log in to unmask]>
> To: Jacek Becla <[log in to unmask]>
>
> Yes, I recall this. Daniel had a patch for this and it got rolled into the
> mainline controlled by an option. You must specify the option in the
> config file to get around this issue. The directive and option is:
>
> cms.space mwfiles
>
> you might have additional options in effect. Simply add he mwfiles if so.
> Only the redirector uses this option but it's OK to have it everywhere.
>
> Andy
>
> On Mon, 27 Jul 2015, Jacek Becla wrote:
>
>> We run into a problem... when we running a query that has no results
>>
>> select * from Object where id <non existent id>
>>
>> qserv can't map it to any chunk (makes sense), and it ends up executing
>>
>>  SELECT *
>>  FROM qservTest_case01_qserv.Object_1234567890 AS QST_1_
>>  WHERE objectId=430213989000
>>
>> the chunk 1234567890 is a special chunk and it exists on all nodes.
>>
>> And that upsets our code
>>
>> (build/qdisp/QueryResource.cc:61) - Error provisioning, msg=Unable to
>> write
>> file; multiple files exist. code=2
>>
>> So I suspect if we started replicating our chunks we'd be in trouble
>> too....
>>
>> Anyway, we should open a ticket and fix that, but I wanted to collect
>> more info before doing it, especially since I seem to recall we talked
>> about something similar with AndyH.
>>
>> Any recollections anyone?
>>
>> 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 

########################################################################
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