ActiveData icon indicating copy to clipboard operation
ActiveData copied to clipboard

Problem with nested query

Open klahnakoski opened this issue 6 years ago • 2 comments

The docs mention a query into unittest.run.files https://github.com/mozilla/ActiveData/blob/dev/docs/jx_tutorial.md#select-clause

{
    "from": "unittest.run.files",
    "select": ["run.stats.bytes","run.files.url"],
    "where": {"and": [
        {"eq": {"build.platform": "linux64"}},
        {"gt": {"run.stats.bytes": 600000000}}
    ]}
}

which appears to fail

Call to ActiveData failed
	File ESQueryRunner.js, line 33, in ActiveDataQuery
	File thread.js, line 247, in Thread_prototype_resume
	File thread.js, line 226, in retval
	File Rest.js, line 46, in Rest.send/ajaxParam.error
	File Rest.js, line 100, in Rest.send/request.onreadystatechange
caused by Error while calling /query
caused by Bad response (400)
caused by Should not happen
	File __init__.py, line 156, in _index
	File __init__.py, line 123, in __init__
	File jx_usingES.py, line 85, in __init__
	File __init__.py, line 64, in wrapper
	File __init__.py, line 92, in wrap_from
	File jx.py, line 60, in jx_query
	File __init__.py, line 55, in output
	File app.py, line 1625, in dispatch_request
	File app.py, line 1639, in full_dispatch_request
	File app.py, line 1988, in wsgi_app
	File app.py, line 2000, in __call__
	File serving.py, line 181, in execute
	File serving.py, line 193, in run_wsgi
	File serving.py, line 251, in handle_one_request
	File BaseHTTPServer.py, line 340, in handle
	File serving.py, line 216, in handle
	File SocketServer.py, line 655, in __init__
	File SocketServer.py, line 334, in finish_request
	File SocketServer.py, line 599, in process_request_thread
	File threading.py, line 766, in run
	File threading.py, line 813, in __bootstrap_inner
	File threading.py, line 786, in __bootstrap
caused by run.files
	File __init__.py, line 152, in _index
	File __init__.py, line 123, in __init__
	File jx_usingES.py, line 85, in __init__
	File __init__.py, line 64, in wrapper
	File __init__.py, line 92, in wrap_from
	File jx.py, line 60, in jx_query
	File __init__.py, line 55, in output
	File app.py, line 1625, in dispatch_request
	File app.py, line 1639, in full_dispatch_request
	File app.py, line 1988, in wsgi_app
	File app.py, line 2000, in __call__
	File serving.py, line 181, in execute
	File serving.py, line 193, in run_wsgi
	File serving.py, line 251, in handle_one_request
	File BaseHTTPServer.py, line 340, in handle
	File serving.py, line 216, in handle
	File SocketServer.py, line 655, in __init__
	File SocketServer.py, line 334, in finish_request
	File SocketServer.py, line 599, in process_request_thread
	File threading.py, line 766, in run
	File threading.py, line 813, in __bootstrap_inner
	File threading.py, line 786, in __bootstrap

Please check if this is a problem with the new cluster, and if so, ensure a test is made

klahnakoski avatar Jul 31 '18 15:07 klahnakoski

It appears unittest.run.files has been removed. Use the task.artifacts table (which also has a problem.

klahnakoski avatar Jul 31 '18 15:07 klahnakoski

A better error message is in order for cases when the table does not exist

klahnakoski avatar Jul 31 '18 15:07 klahnakoski