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 <[email protected]> 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 赵天烁 <[email protected]>: > >> 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 >> >> *[email protected] <[email protected]>* >> >> >> >> 珠海市魅族科技有限公司 >> >> MEIZU Technology Co., Ltd. >> >> 广东省珠海市科技创新海岸魅族科技楼 >> >> MEIZU Tech Bldg., Technology & Innovation Coast >> >> Zhuhai, 519085, Guangdong, China >> >> >> >> >> >> meizu.com >> >> >> >> >> >> >> >> >> > > > > -- > Best regards, > > Shaofeng Shi > >
