Hello Team -
In an effort to better understand qserv, I decided run the queries included in the JHUScalingTest2012:
https://dev.lsstcorp.org/trac/wiki/db/Qserv/JHUScalingTest2012
I was surprised when most of them failed. Of course, this could very well be due to a configuration issue within my instance of qserv (e.g. discrepancy between metadata and actual partitioned data). These queries were run against my single-node qserv instance that uses Daniel's data. Simple queries complete successfully, as can be seen by the first two query results below. Queries involving procedure calls (e.g. qserv_areaspec_box, scisql_fluxToAbMag) seem to generally fail. Should I be surprised? Does this clearly indicate a problem with my qserv configuration?
Any insight will be appreciated.
Thanks,
Bill
mysql> select count(*) from Object;
+----------------+
| SUM(QS1_COUNT) |
+----------------+
| 3738244 |
+----------------+
1 row in set (5 min 10.16 sec)
mysql> select ra_PS, decl_PS from Object limit 1;
+----------------------+--------------------+
| ra_PS | decl_PS |
+----------------------+--------------------+
| 0.000300110409250248 | -0.630876672474271 |
+----------------------+--------------------+
1 row in set (1.49 sec)
mysql> select count(*) from Object where qserv_areaspec_box(1, 2, 3, 4) and scisql_fluxToAbMag(zFlux_PS) between 21 and 21.5;
ERROR 4120 (Proxy): Error during execution: 'read failed for chunk(s): 3720 3600'
mysql> SELECT objectId,
-> ra_PS, decl_PS,
-> uFlux_PS, gFlux_PS, rFlux_PS, iFlux_PS, zFlux_PS, yFlux_PS
-> FROM Object
-> WHERE scisql_fluxToAbMag(iFlux_PS)-scisql_fluxToAbMag(zFlux_PS) > 4;
ERROR 4120 (Proxy): Error during execution: 'read failed for chunk(s): 3478 3361 3481 3360 3480 3240 3241'
mysql> select ra_PS, decl_PS from Object limit 1;
+------------------+-------------------+
| ra_PS | decl_PS |
+------------------+-------------------+
| 0.63772900810462 | -5.99997626759221 |
+------------------+-------------------+
1 row in set (1.50 sec)
mysql> SELECT objectId,
-> ra_PS, decl_PS,
-> uFlux_PS, gFlux_PS, rFlux_PS, iFlux_PS, zFlux_PS, yFlux_PS
-> FROM Object
-> WHERE scisql_fluxToAbMag(iFlux_PS)-scisql_fluxToAbMag(zFlux_PS) > 5;
ERROR 4120 (Proxy): Error during execution: 'read failed for chunk(s): 3241 3361 3240 3360'
mysql> SELECT count(*)
-> FROM Object
-> WHERE ra_PS between 1 and 2
-> AND decl_PS between 3 and 4
-> AND scisql_fluxToAbMag(zFlux_PS) BETWEEN 21 AND 21.5
-> AND scisql_fluxToAbMag(gFlux_PS)-scisql_fluxToAbMag(rFlux_PS) BETWEEN 0.3 AND 0.4
-> AND scisql_fluxToAbMag(iFlux_PS)-scisql_fluxToAbMag(zFlux_PS) BETWEEN 0.1 AND 0.12;
ERROR 4120 (Proxy): Error during execution: 'read failed for chunk(s): 3360 3241 3240 3361'
mysql> SELECT count(*) AS n, AVG(ra_PS), AVG(decl_PS), chunkId
-> FROM Object
-> GROUP BY chunkId;
+----------------+-------------------------------+-------------------------------+
| SUM(QS1_COUNT) | (SUM(QS3_SUM)/SUM(QS2_COUNT)) | (SUM(QS5_SUM)/SUM(QS4_COUNT)) |
+----------------+-------------------------------+-------------------------------+
| 3738244 | 80.5458153658024 | 0.27024249373145 |
+----------------+-------------------------------+-------------------------------+
1 row in set (27.30 sec)
########################################################################
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
