You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2017/11/29 07:05:00 UTC
[jira] [Closed] (KYLIN-1523) Kylin server hang when many bad query
running
[ 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)