没有可用的工作节点。对于postgres,我们间歇性地得到这个错误。我已经确保.properties文件在所有节点中都可用,并且是正确的,因此一些查询正在运行。
当硬件资源不足以执行大量查询时,是否会出现此错误?
确切的错误消息是:响应-->{"id":"20170816_111721_01180_c5tn3","infoUri":"http://ec2-52-91-204-246.compute-1.amazonaws.com:8080/query.html?20170816_111721_01180_c5tn3","stats":{"state":"FAILED","queued","errorType":"INTERNAL_error","failureInfo":{"type":"com.facebook.presto.spi.PrestoException","message":"无工作节点可用","已抑制":[],"stack":["com.facebook.presto.util.Failures.checkCondition(Failures.java:85)","com.facefacebook.prosto.sql.plancer.SystemPartitionHandle.getNodePartitionMap(SystemPartitionHandle.java:149)","com.facebook.presto.execution.scheduler.SqlQueryScheduler.lambda$null$0(SqlQueryScheduler.java:140)","java.util.HashMap.computeIfAbsent(HashMap.java:1126)","com.facebook.presto.execution.SqlQueryScheduler.lambda$new$1(SqlQuery scheduler.java:140)","com.facebook.preston.execution.scheduler.SqlQueryScheduler.createStages(SqlQueryScheller.java:241)"com.facebook.presto.execution.scheduler.SqlQueryScheduler.\u003Cinit\u003E(SqlQueryScheduler.java:131)","com.facebook.presto.execution.SqlQueryExecution.planDistribution(SqlQueryExecution.java:388)","com.facebook_presto.execection.SqlQueryExecution.start(SqlQueryExecution.java:252)","com.facebook.preston.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:62)"java.util.concurrent.ThreadPoolExecutor.runWorker
您的员工崩溃的原因可能有很多:
您的查询可能会阻塞某些资源并导致工作进程崩溃,或者资源不足,无法执行查询。您需要在config.properties
文件中重新配置presto服务器,以满足您的查询需求。