Print

Print


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