 |
 |
Hello Daniel, As told on Thursday, i've met several error on SQL queries wich works on previous version (without qms and new parser). I'm not sure if error come from the test procedure or from qserv new version. I propose to send it to you one by one with detailed log, instead of sending the whole list (bugs may be fixed once and solve many queries). Here's one example for test case 01 : While connected to qserv : mysql> SELECT s.ra, s.decl, o.raRange, o.declRange FROM Object o JOIN Source s USING (objectId) WHERE o.objectId = 390034570102582 AND o.latestObsTime = s.taiMidPoint; ERROR 4120 (Proxy): Error during execution: 'open failed for chunk(s): 6801 6630 6800 7138 7308 6970 6971 6968 6631 7140read failed for chunk(s): 7478 7648 7310' xrootd and qserv-master logs are attached and it seems the errors are reported in xrootd.log with SQL sentence like this one : >>Unknown column 's.ra' in 'field list' Unable to execute query: CREATE TABLE r_1e01fa2d9ea14d542987c2af43bb3645f_7478_0 SELECT s.ra,s.decl,o.raRange,o.declRange FROM LSST.Object_7478 AS o WHERE o.objectId=390034570102582 AND o.latestObsTime=s.taiMidPoint; <<---Error with piece 0 complete (size=1). Indeed it seems table Source should be in FROM clause, aliased with 's' ? I can of course give you more information if needed. Thanks, Fabrice ######################################################################## 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