kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 沈鲁威 <>
Subject 紧急求救,kylin Query机 查询运行20多分钟后死机
Date Mon, 23 Apr 2018 14:51:49 GMT
我们这边搭建了 cdh5.13.1+kylin.2.3.0
一台任务机,三台查询机slb 负载均衡(4核8G)

 只能 stop 停掉这台查询机,其他机器才能正常工作

查看机器负载 并不高
查看日志 出现过的错误日志
1、ncategorized SQLException for SQL []; SQL state [null]; error code [0]; exception while
executing query: POST failed, error code 500 and response: {"code":"999","data":null,"msg":"Timeout
visiting cube! Check why coprocessor exception is not sent back? In coprocessor Self-termination
is checked every 100 scanned rows, the configured timeout(54000) cannot support this many
scans?\nwhile executing SQL: \"select COALESCE(SUM(a.total_sale_money_kpi),0) as total_sale_money_kpi
, COALESCE(SUM(a.total_sale_count_kpi),0) as 
2、by total_sale_money_kpi desc ### Cause: java.sql.SQLException: exception while executing
query: POST failed, error code 500 and response: {"code":"999","data":null,"msg":"org.apache.hadoop.hbase.DoNotRetryIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: Coprocessor passed deadline! Maybe server is
overloaded at
at org.apache.hadoop.hbase.regionserver.HRegion.execService( at org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(
at org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(
at at
at org.apache.hadoop.hbase.ipc.RpcExecutor$ at org.apache.hadoop.hbase.ipc.RpcExecutor$\nwhile
executing SQL: 

View raw message