Print

Print


Hi,

I've installed latest Qserv release on the cluster (current parallel 
install procedure is not robust and I tried to fix/improve it in 
DM-3194, using shmux, thanks to Yvan).
And now this query, which was breaking Qserv services on previous 
release, returns results:

fjammes@ccosvms0070:~/src/qserv/admin/tools/cluster/cc-in2p3/shmux$ time 
mysql --host ccqserv100 --port 4040 --user qsmaster -e "SELECT 
deepSourceId, u_apFluxSigma FROM LSST.Object WHERE u_apFluxSigma between 
0 and 2"
...
| 2918657910899974 | 3.26332850650429e-30 |
| 2918657910901981 | 3.20529788051422e-30 |
| 2918657910899973 |  3.2619586763274e-30 |
| 2918657910899984 | 3.26314656089494e-30 |
| 2918657910899920 | 4.77743136377084e-30 |
| 2918657910899919 | 3.28568524128156e-30 |
| 2918657910899918 | 1.47820417116329e-28 |
| 2918657910899917 | 3.25375144940033e-30 |
| 2918657910899916 | 3.24042027266006e-30 |
| 2918657910901992 | 2.89821413081739e-30 |
| 2918657910899914 | 3.23978341659658e-30 |
| 2918657910899913 | 4.35431238285225e-30 |
| 2918657910899912 | 3.25930611013314e-30 |
| 2918657910899911 | 3.24119694301384e-30 |
| 2918657910899910 | 3.24499443022022e-30 |
| 2918657910899909 | 9.21167574549085e-30 |
| 2918657910899946 |  3.2414810442706e-30 |
| 2918657910899907 | 3.25408825624256e-30 |^C| 2918657910899907 | 
3.25408825624256e-30 |
Ctrl-C -- sending "KILL QUERY 9" to server ...
Ctrl-C -- query aborted.

+------------------+----------------------+
^CCtrl-C -- sending "KILL 9" to server ...
Ctrl-C -- query aborted.

real    14m24.823s
user    1m4.975s
sys     1m20.412s

Nice!

########################################################################
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