kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: query to slow ...................
Date Sun, 26 Jun 2016 11:55:13 GMT
Troubleshooting slow query is not easy. Need to understand the data model,
the cube definition, and the exact query. Start from 1.5.2.1, Kylin has a
diagnosis tool that let you export necessary info in one zip. May help the
communication.

On Sat, Jun 18, 2016 at 9:41 AM, ShaoFeng Shi <shaofengshi@apache.org>
wrote:

> Hi Tianshuo,
>
> We welcome user to raise questions in the mailing list and we'd like to
> help as much as we can; but there are still some practices regarding how to
> ask a question; Here is a good article, I strongly recommend that you read
> it:
>
> http://catb.org/~esr/faqs/smart-questions.html#beprecise
>
>
> 2016-06-17 19:01 GMT+08:00 赵天烁 <zhaotianshuo@meizu.com>:
>
>> after successfully build a cube and send a query, it just stuck in
>> executing…  phase ,then after a while ,I got error log as follow:
>>
>> 2016-06-17 18:57:45,671 DEBUG [BadQueryDetector]
>> hbase.HBaseResourceStore:262 : Update row /bad_query/learn_kylin.json from
>> oldTs: 1466161005652, to newTs: 1466161065665, operation result: true
>>
>> 2016-06-17 18:57:45,672 INFO  [BadQueryDetector]
>> service.BadQueryDetector:230 : Problematic thread 0x63
>>
>>         at sun.misc.Unsafe.park(Native Method)
>>
>>         at
>> java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)
>>
>>         at
>> java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2082)
>>
>>         at
>> java.util.concurrent.ArrayBlockingQueue.poll(ArrayBlockingQueue.java:389)
>>
>>         at
>> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:125)
>>
>>         at
>> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:81)
>>
>>         at
>> com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
>>
>>         at
>> com.google.common.collect.Iterators$6.hasNext(Iterators.java:583)
>>
>>         at
>> org.apache.kylin.storage.hbase.cube.v2.SequentialCubeTupleIterator.hasNext(SequentialCubeTupleIterator.java:96)
>>
>>         at
>> org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:74)
>>
>>
>>
>> 2016-06-17 18:57:45,673 INFO  [BadQueryDetector]
>> service.BadQueryDetector:104 : Slow query has been running 3079.402 seconds
>> (project:learn_kylin, thread: 0x61) -- select * from KYLIN_SALES
>>
>> 2016-06-17 18:57:45,676 DEBUG [BadQueryDetector]
>> badquery.BadQueryHistoryManager:84 : Loaded 5 Bad Query(s)
>>
>> 2016-06-17 18:57:45,681 DEBUG [BadQueryDetector]
>> hbase.HBaseResourceStore:262 : Update row /bad_query/learn_kylin.json from
>> oldTs: 1466161065665, to newTs: 1466161065676, operation result: true
>>
>> 2016-06-17 18:57:45,682 INFO  [BadQueryDetector]
>> service.BadQueryDetector:230 : Problematic thread 0x61
>>
>>         at sun.misc.Unsafe.park(Native Method)
>>
>>         at
>> java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)
>>
>>         at
>> java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2082)
>>
>>         at
>> java.util.concurrent.ArrayBlockingQueue.poll(ArrayBlockingQueue.java:389)
>>
>>         at
>> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:125)
>>
>>         at
>> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:81)
>>
>>         at
>> com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
>>
>>         at
>> com.google.common.collect.Iterators$6.hasNext(Iterators.java:583)
>>
>>         at
>> org.apache.kylin.storage.hbase.cube.v2.SequentialCubeTupleIterator.hasNext(SequentialCubeTupleIterator.java:96)
>>
>>         at
>> org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:74)
>>
>>
>>
>> 2016-06-17 18:57:45,682 INFO  [BadQueryDetector]
>> service.BadQueryDetector:104 : Slow query has been running 2989.567 seconds
>> (project:learn_kylin, thread: 0x8bd) -- select * from KYLIN_SALES limit 1;
>>
>> 2016-06-17 18:57:45,685 DEBUG [BadQueryDetector]
>> badquery.BadQueryHistoryManager:84 : Loaded 5 Bad Query(s)
>>
>> 2016-06-17 18:57:45,690 DEBUG [BadQueryDetector]
>> hbase.HBaseResourceStore:262 : Update row /bad_query/learn_kylin.json from
>> oldTs: 1466161065676, to newTs: 1466161065686, operation result: true
>>
>> 2016-06-17 18:57:45,692 INFO  [BadQueryDetector]
>> service.BadQueryDetector:230 : Problematic thread 0x8bd
>>
>>
>>
>>
>> Any idea?
>>
>> -----------------------------------------------------
>>
>>
>>
>> 赵天烁
>>
>> Kevin Zhao
>>
>> *zhaotianshuo@meizu.com <zhaotianshuo@meizu.com>*
>>
>>
>>
>> 珠海市魅族科技有限公司
>>
>> MEIZU Technology Co., Ltd.
>>
>> 广东省珠海市科技创新海岸魅族科技楼
>>
>> MEIZU Tech Bldg., Technology & Innovation Coast
>>
>> Zhuhai, 519085, Guangdong, China
>>
>>
>>
>>
>>
>> meizu.com
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
>

Mime
View raw message