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