Print

Print


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