Hi all,
It doesn't seem to exist an emptychunk table on in2p3 cluster? If yes,
is it possible to create it with the data-loader?
FYI, tomorrow is a day-off in France, so I certainly won't be available.
fjammes@ccosvms0070:~/src/qserv (u/fjammes/DM-1962=)$ time mysql --host
ccqserv100 --port 4040 --user qsmaster -e "SELECT deepSourceId,
u_apFluxSigma FROM LSST.Object WHERE deepSourceId = 2381971683496090;"
ERROR 4120 (Proxy) at line 1: Error during execution:
-1 Ref=1 Resource(/chk/LSST/1234567890): 20150507-14:24:01, Error
accessing resource (delayed), 2, No servers are available to write the
file. (-1)
real 0m15.077s
user 0m0.006s
sys 0m0.014s
And the log on the master node:
[qserv@ccqserv100 fjammes]$ tail -n 40 /qserv/run/var/log/qserv-czar.log
0507 14:29:24.869 [0x7f4c469b0740] INFO root
(build/css/KvInterfaceImplMem.cc:144) - got: '12'
0507 14:29:24.875 [0x7f4c3498f700] DEBUG root (app.py:343) - reporting
-1 100 Dispatch Query.
0507 14:29:24.875 [0x7f4c3498f700] DEBUG root
(build/qdisp/MessageStore.cc:49) - Msg: -1 100 Dispatch Query.
0507 14:29:24.875 [0x7f4c3498f700] DEBUG root
(build/ccontrol/userQueryProxy.cc:105) - EXECUTING UserQuery_submit(5)
0507 14:29:24.875 [0x7f4c3498f700] INFO root
(build/qana/ScanTablePlugin.cc:130) - Squash scan tables: <2 chunks.
0507 14:29:24.875 [0x7f4c3498f700] INFO root
(build/ccontrol/UserQuery.cc:266) - UserQuery::_setupMerger()
0507 14:29:24.876 [0x7f4c3498f700] INFO root
(build/ccontrol/UserQuery.cc:172) - UserQuery beginning submission
0507 14:29:24.876 [0x7f4c3498f700] INFO root
(build/qproc/QuerySession.cc:399) - Non-subchunked
0507 14:29:24.876 [0x7f4c3498f700] DEBUG root
(build/qproc/QuerySession.cc:419) - returning queries:
0507 14:29:24.876 [0x7f4c3498f700] DEBUG root
(build/qproc/QuerySession.cc:421) - SELECT deepSourceId,u_apFluxSigma
FROM LSST.Object_1234567890 AS QST_1_ WHERE deepSourceId=2381971683496090
0507 14:29:24.876 [0x7f4c3498f700] DEBUG root
(build/qproc/TaskMsgFactory2.cc:152) - no nextFragment
0507 14:29:24.876 [0x7f4c3498f700] DEBUG root
(build/qproc/TaskMsgFactory2.cc:154) - SELECT deepSourceId,u_apFluxSigma
FROM LSST.Object_1234567890 AS QST_1_ WHERE deepSourceId=2381971683496090
0507 14:29:24.877 [0x7f4c3498f700] INFO root
(build/ccontrol/MergingRequester.cc:230) - setError
0507 14:29:24.877 [0x7f4c3498f700] INFO root
(build/ccontrol/MergingRequester.cc:231) - setError 0
0507 14:29:24.877 [0x7f4c3498f700] DEBUG root
(build/qdisp/Executive.cc:464) - Executive (0x25bb470) tracking id=1
0507 14:29:24.877 [0x7f4c3498f700] DEBUG root
(build/qdisp/Executive.cc:198) - Flag set to false 0
0507 14:29:24.877 [0x7f4c3498f700] INFO root
(build/qdisp/Executive.cc:202) - Exec add pth=/chk/LSST/1234567890
0507 14:29:24.877 [0x7f4c3498f700] DEBUG root
(build/qdisp/MessageStore.cc:49) - Msg: 1234567890 1200 Exec add
pth=/chk/LSST/1234567890
Opening xroot://10.158.37.100:1094//chk/LSST/1234567890
0507 14:29:24.877 [0x7f4c3498f700] DEBUG root
(build/qdisp/Executive.cc:394) - Provision was ok
0507 14:29:24.878 [0x7f4c25ffb700] INFO root
(build/qdisp/QueryResource.cc:56) - Provision done
0507 14:29:24.878 [0x7f4c25ffb700] ERROR root
(build/qdisp/QueryResource.cc:61) - Error provisioning, msg=No servers
are available to write the file. code=2
0507 14:29:24.878 [0x7f4c25ffb700] INFO root
(build/ccontrol/MergingRequester.cc:230) - setError
0507 14:29:24.878 [0x7f4c25ffb700] INFO root
(build/ccontrol/MergingRequester.cc:231) - setError 2 No servers are
available to write the file.
0507 14:29:24.878 [0x7f4c25ffb700] ERROR root
(build/ccontrol/MergingRequester.cc:168) - Error receiving result.
0507 14:29:24.879 [0x7f4c3498f700] INFO root (app.py:404) - Query
dispatch (5) took 0.005176 seconds
0507 14:29:24.879 [0x7f4c3498f700] INFO root
(build/qdisp/Executive.cc:499) - Executive (0x25bb470) REAPED id=1
0507 14:29:24.879 [0x7f4c3498f700] INFO root
(build/qdisp/Executive.cc:553) - Still 1 in flight.
0507 14:29:29.879 [0x7f4c3498f700] INFO root
(build/qdisp/Executive.cc:218) - entry state:0x7f4c200331e0
Resource(/chk/LSST/1234567890): 20150507-14:29:24, Error accessing
resource (delayed), 2, No servers are available to write the file.)
0507 14:29:29.880 [0x7f4c3498f700] INFO root
(build/qdisp/Executive.cc:229) - Query exec finish. 1 dispatched.
0507 14:29:29.880 [0x7f4c3498f700] DEBUG root
(build/qdisp/MessageStore.cc:49) - Msg: 1234567890 1203 Error accessing
resource (delayed) 2 (No servers are available to write the file.)
1431001764
0507 14:29:29.880 [0x7f4c3498f700] INFO root
(build/qdisp/Executive.cc:232) - Query exec:. 1 != 0
0507 14:29:29.880 [0x7f4c3498f700] DEBUG root
(build/qdisp/Executive.cc:236) - Flag set to _empty=0 sCount=0
requestCount=1
0507 14:29:29.880 [0x7f4c3498f700] INFO root
(build/rproc/InfileMerger.cc:328) - Merged
qservResult.result_11881262490 into qservResult.result_11881262490
0507 14:29:29.880 [0x7f4c3498f700] ERROR root
(build/ccontrol/UserQuery.cc:215) - Joined everything (failure!)
0507 14:29:29.881 [0x7f4c3498f700] INFO root (app.py:408) - Query exec
(5) took 5.000873 seconds
0507 14:29:29.882 [0x7f4c3498f700] ERROR root
(build/qdisp/Executive.cc:360) - Ref=1 Resource(/chk/LSST/1234567890):
20150507-14:29:24, Error accessing resource (delayed), 2, No servers are
available to write the file.
0507 14:29:29.883 [0x7f4c3498f700] DEBUG root (app.py:343) - reporting
-1 -1 Ref=1 Resource(/chk/LSST/1234567890): 20150507-14:29:24, Error
accessing resource (delayed), 2, No servers are available to write the file.
0507 14:29:29.883 [0x7f4c3498f700] ERROR root
(build/qdisp/MessageStore.cc:47) - Msg: -1 -1 Ref=1
Resource(/chk/LSST/1234567890): 20150507-14:29:24, Error accessing
resource (delayed), 2, No servers are available to write the file.
0507 14:29:29.885 [0x7f4c3498f700] INFO root (app.py:413) - Final state
of all queries error
Thanks
########################################################################
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
|