Tim Chan
09/29/2020, 5:11 PMYash Agarwal
09/29/2020, 5:13 PMTim Chan
09/29/2020, 5:15 PMNeha Pawar
Tim Chan
09/29/2020, 7:07 PM2020/09/29 19:06:16.333 ERROR [PinotQueryResource] [grizzly-http-server-1] Caught exception while sending query request
java.io.IOException: Failed : HTTP error code : 500
at org.apache.pinot.controller.api.resources.PinotQueryResource.sendPostRaw(PinotQueryResource.java:284) ~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.apache.pinot.controller.api.resources.PinotQueryResource.sendRequestRaw(PinotQueryResource.java:322) ~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.apache.pinot.controller.api.resources.PinotQueryResource.getQueryResponse(PinotQueryResource.java:204) ~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.apache.pinot.controller.api.resources.PinotQueryResource.handlePostSql(PinotQueryResource.java:131) ~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_265]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_265]
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.internal.Errors.process(Errors.java:292) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.internal.Errors.process(Errors.java:274) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.internal.Errors.process(Errors.java:244) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:679) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.service(GrizzlyHttpContainer.java:353) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:200) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:569) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:549) [pinot-all-0.5.0-SNAPSHOT-jar-with-dependencies.jar:0.5.0-SNAPSHOT-8511410b9b93616642c94ae11fc072444555962b]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_265]
2020/09/29 18:59:54.006 WARN [BaseInstanceSelector] [ClusterChangeHandlingThread] Failed to find servers hosting segment: sesame_person_features__3__202__20200918T0626Z for table: sesame_person_features_REALTIME (all ONLINE/CONSUMING instances: [] and OFFLINE instances: [] are disabled, counting segment as unavailable)
Neha Pawar
Tim Chan
09/30/2020, 5:53 AMYash Agarwal
09/30/2020, 4:01 PMTim Chan
09/30/2020, 4:43 PMNeha Pawar
Tim Chan
09/30/2020, 4:47 PMJAVA_OPTS: -Xms512M -Xmx1G -Dlog4j2.configurationFile=/opt/pinot/conf/pinot-server-log4j2.xml -Dplugins.dir=/opt/pinot/plugins
Provisioner: <http://kubernetes.io/gce-pd|kubernetes.io/gce-pd>
Parameters: type=pd-standard
Neha Pawar
Tim Chan
09/30/2020, 4:54 PM2020/09/30 06:33:05.663 ERROR [PinotQueryResource] [grizzly-http-server-1] Caught exception in sendQueryRaw
java.io.IOException: Failed : HTTP error code : 500
Neha Pawar
Tim Chan
09/30/2020, 5:09 PMYash Agarwal
09/30/2020, 5:20 PMTim Chan
09/30/2020, 5:22 PMFile "/Users/tchan/Workspace/gbo-pinot/.venv/lib/python3.7/site-packages/pinotdb/db.py", line 279, in execute
) from e
pinotdb.exceptions.DatabaseError: Error when querying
select sensor_id,
time_stamp,
annotations_json_str
from sesame_person_features
where time_stamp between 1601055847025 and 1601056747025
order by time_stamp, sensor_id asc
limit 56754 from <http://34.69.77.31:8099/query/sql>, raw response is:
<html><head><title>Grizzly 2.4.4</title><style><!--div.header {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#003300;font-size:22px;-moz-border-radius-topleft: 10px;border-top-left-radius: 10px;-moz-border-radius-topright: 10px;border-top-right-radius: 10px;padding-left: 5px}div.body {font-family:Tahoma,Arial,sans-serif;color:black;background-color:#FFFFCC;font-size:16px;padding-top:10px;padding-bottom:10px;padding-left:10px}div.footer {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#666633;font-size:14px;-moz-border-radius-bottomleft: 10px;border-bottom-left-radius: 10px;-moz-border-radius-bottomright: 10px;border-bottom-right-radius: 10px;padding-left: 5px}BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;}B {font-family:Tahoma,Arial,sans-serif;color:black;}A {color : black;}HR {color : #999966;}--></style> </head><body><div class="header">Request failed.</div><div class="body">Request failed.</div><div class="footer">Grizzly 2.4.4</div></body></html>
Jackie
09/30/2020, 5:23 PMselect * from mytable order by AirTime limit 1000000
annotations_json_str
? Could that be large?Tim Chan
09/30/2020, 5:24 PMJackie
09/30/2020, 5:33 PMTim Chan
09/30/2020, 5:34 PMJackie
09/30/2020, 5:36 PMannotations_json_str
)
select sensor_id,
time_stamp
from sesame_person_features
where time_stamp between 1601055847025 and 1601056747025
order by time_stamp, sensor_id asc
limit 10000
Tim Chan
09/30/2020, 6:56 PMselect sensor_id,
time_stamp
from sesame_person_features
where time_stamp between 1601055847025 and 1601056747025
order by time_stamp, sensor_id asc
limit 56754
Jackie
09/30/2020, 8:08 PMTim Chan
09/30/2020, 8:42 PM