Join between Source an Object :
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'
Log files are available here :
Here’s an extract of qserv-master.log :
Adding orsibs: COMP_PREDICATE FACTOR COLUMN_REF o . objectId = FACTOR 390034570102582 AND COMP_PREDICATE FACTOR COLUMN_REF o . latestObsTime = FACTOR COLUMN_REF s . taiMidPoint
Parsed value expression for select list.
s.ra
s.decl
o.raRange
o.declRange
SELECT s.ra,s.decl,o.raRange,o.declRange FROM Object AS o WHERE o.objectId=390034570102582 AND o.latestObsTime=s.taiMidPoint
Testing
Testing
aggr origlist: s.ra, s.decl, o.raRange, o.declRange,
pass: s.ra,s.decl,o.raRange,o.declRange
fixup:
parallel: SELECT s.ra,s.decl,o.raRange,o.declRange FROM LSST.Object_%CC% AS o WHERE o.objectId=390034570102582 AND o.latestObsTime=s.taiMidPoint
merge: SELECT
Here’s an extract of xrootd.log :
130930 17:22:30 31390 XrootdXeq: qsmaster.31420:20@134.158.127.130 login
File write(0) at 0 for 201 by qsmaster
File write(0) Added.
File write(0) Flushing.
Flush ok, ready to return good.
File write(0) at 0 for 201 by qsmaster --FINISH--
0 WriteSpawn Mon Sep 30 17:22:30 2013 0.000767
File write(0) at 0 for 201 by qsmaster
Runner running Task: msg: session=1 chunk=7310 db=LSST frag: q=SELECT s.ra,s.decl,o.raRange,o.declRange FROM LSST.Object_7310 AS o WHERE o.objectId=390034570102582 AND o.latestObsTime=s.taiMidPoint, sc= rt=r_1e01fa2d9ea14d542987c2af43bb3645f_7310_0
File write(0) Added.
File write(0) Flushing.
Flush ok, ready to return good.
It seems that the parser forgot to add the Source table in the FROM clause while rewriting the query.
Join between Source and Filter :
mysql> SELECT taiMidPoint, psfFlux, psfFluxSigma, ra, decl FROM Source JOIN Filter USING (filterId) WHERE objectId = 402412665835716 AND filterName = 'r';
ERROR 4110 (Proxy): Qserv error: 'mysqld error during index lookup q=SELECT chunkId FROM qservMeta.LSST__Source WHERE objectId IN (402412665835716)'
Log files are available here :
Here the description of qservMeta.LSST__Source table :
mysql> desc LSST__Source;
+------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| sourceId | bigint(20) | NO | PRI | NULL | |
| chunkId | int(11) | YES | | NULL | |
| subChunkId | int(11) | YES | | NULL | |
+------------+------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
Could you please give me the exact structure of LSST_Source table ?