kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 赵天烁 <zhaotians...@meizu.com>
Subject query to slow ...................
Date Fri, 17 Jun 2016 11:01:28 GMT
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<mailto:zhaotianshuo@meizu.com>

珠海市魅族科技有限公司
MEIZU Technology Co., Ltd.
广东省珠海市科技创新海岸魅族科技楼
MEIZU Tech Bldg., Technology & Innovation Coast
Zhuhai, 519085, Guangdong, China


meizu.com




Mime
View raw message