zhenkuan_zhang created KYLIN-5268:
-------------------------------------
Summary: kylin4.0.1服务每天都会内存溢出java.lang.OutOfMemoryError: Java heap
space
Key: KYLIN-5268
URL: https://issues.apache.org/jira/browse/KYLIN-5268
Project: Kylin
Issue Type: Bug
Reporter: zhenkuan_zhang
Attachments: kylin_query.log
Hi，最近发现我们的kylin服务非常不稳定，三个节点，每天都会有节点出现内存溢出的状况，通过分析Dump 出
java_pid34184.hprof文件，发现内存会被两个查询完全占满导致jvm内存溢出，sql是通过tableau发送来的。sql如下：
1.
SELECT "自訂 SQL 查詢"."FAIL" AS "FAIL" FROM (
SELECT DT TEST_DATE,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6)
TEST_FLOOR,TEST_LINE,CONFIG,REGION,LOCALLIZATION,
SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 )
VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3)
WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4)
DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL ,
INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA
) "自訂 SQL 查詢"
2.
SELECT "自訂 SQL 查詢"."RETEST" AS "RETEST" FROM (
SELECT DT TEST_DATE,TEST_STATION_CODE,SUBSTRING(TEST_LINE,1,6)
TEST_FLOOR,TEST_LINE,CONFIG,REGION,LOCALLIZATION,
SUBSTRING(ATL FROM 1 for POSITION('*-' IN ATL from 1)-1 )
VENDERATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 5)+1 FOR 3)
WEEKATL,SUBSTRING(ATL FROM POSITION('-' IN ATL FROM 6)+1 FOR 4)
DATEATL,SUBSTRING(ATL FROM POSITION('*-' IN ATL FROM 1)+7 FOR 4) EEEEATL ,
INPUT,FAIL,RETEST FROM BI_DW.KPY_FACT_SUM_DATA
) "自訂 SQL 查詢"
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
