You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "qianqiaoneng (JIRA)" <ji...@apache.org> on 2016/03/22 10:08:25 UTC
[jira] [Created] (KYLIN-1523) Kylin server crash when many bad query running

qianqiaoneng created KYLIN-1523:
-----------------------------------

             Summary: Kylin server crash 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


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.3.4#6332)