[
https://issues.apache.org/jira/browse/KYLIN-1523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shaofeng SHI closed KYLIN-1523.
-------------------------------
Resolution: Won't Fix
> Kylin server hang when many bad query running
> ---------------------------------------------
>
> Key: KYLIN-1523
> URL: https://issues.apache.org/jira/browse/KYLIN-1523
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v1.4.0
> Reporter: qianqiaoneng
> Assignee: liyang
> Priority: Critical
> Attachments: kylin-425.jstack
>
>
> When there are some bad query running, kylin server will be exhausted then
> crashed. Better to have some control on the resource that bad query consumer,
> or kill the bad query with some timeout. Should not let them bring the server
> down.
> The root reason is there are too many slow queries like below exhaust kylin:
> 2016-03-21 14:28:33,487 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3557 seconds (thread id 0x1841) –
> 2016-03-21 14:28:33,489 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3557 seconds (thread id 0x1840) –
> 2016-03-21 14:28:33,490 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3556 seconds (thread id 0x1842) –
> 2016-03-21 14:28:33,491 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3556 seconds (thread id 0x1843) –
> 2016-03-21 14:28:33,493 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3556 seconds (thread id 0x1844) –
> 2016-03-21 14:28:33,494 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3553 seconds (thread id 0x1845) –
> 2016-03-21 14:28:33,495 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3553 seconds (thread id 0x1847) –
> 2016-03-21 14:28:33,509 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3552 seconds (thread id 0x1848) –
> 2016-03-21 14:28:33,512 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3551 seconds (thread id 0x184a) –
> 2016-03-21 14:28:33,525 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3510 seconds (thread id 0x184c) –
> 2016-03-21 14:28:33,554 INFO [BadQueryDetector] service.BadQueryDetector:57 :
> Slow query has been running 3510 seconds (thread id 0x184d) –
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
