You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by bubugao0809 <bu...@163.com> on 2019/03/19 08:55:37 UTC
can not query after update from 2.0.0 to 2.2.0
Hi all,
Follow the instruction here :http://kylin.apache.org/docs/howto/howto_upgrade.html
I update the kylin from 2.0.0 to 2.2.0 , but I keep getting these errors while quering:
2019-03-19 16:15:12,107 DEBUG [BadQueryDetector] badquery.BadQueryHistoryManager:85 : Loaded 50 Bad Query(s)
2019-03-19 16:15:12,157 INFO [BadQueryDetector] service.BadQueryDetector:178 : Problematic thread 0x3b
at sun.misc.Unsafe.park(Native Method)
at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
at java.util.concurrent.ArrayBlockingQueue.poll(ArrayBlockingQueue.java:418)
at org.apache.kylin.storage.hbase.cube.v2.ExpectedSizeIterator.next(ExpectedSizeIterator.java:63)
at org.apache.kylin.storage.hbase.cube.v2.ExpectedSizeIterator.next(ExpectedSizeIterator.java:31)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at com.google.common.collect.Lists.newArrayList(Lists.java:145)
at org.apache.kylin.storage.gtrecord.StorageResponseGTScatter.iterator(StorageResponseGTScatter.java:84)
at org.apache.kylin.storage.gtrecord.ScannerWorker.iterator(ScannerWorker.java:64)
2019-03-19 16:15:35,194 DEBUG [http-bio-7070-exec-5] security.KylinAuthenticationProvider:113 : User ADMIN authorities : [ROLE_ADMIN, ROLE_ANALYST, ROLE_MODELER]
2019-03-19 16:15:35,253 DEBUG [http-bio-7070-exec-5] security.KylinAuthenticationProvider:126 : Authenticated user org.springframework.security.authentication.UsernamePasswordAuthenticationToken@37047726: Principal: org.springframework.security.core.userdetails.User@3b40b2f: Username: ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@ffff4c9c: RemoteIpAddress: 10.24.1.53; SessionId: null; Granted Authorities: ROLE_ADMIN, ROLE_ANALYST, ROLE_MODELER
2019-03-19 16:16:18,985 INFO [kylin-coproc--pool3-t4] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=108431 ms ago, cancelled=false, msg=row '' on table 'KYLIN_JWG8DCN3PO' at region=KYLIN_JWG8DCN3PO,,1552951168290.4d2247a5d70d764709b238ee31279611., hostname=insight-hadoop-datanode-3.xx.com,16020,1550648351816, seqNum=2
2019-03-19 16:16:19,070 INFO [kylin-coproc--pool3-t3] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=108519 ms ago, cancelled=false, msg=row '' on table 'KYLIN_LPEKROSIHD' at region=KYLIN_LPEKROSIHD,,1552864581993.7d7782b797056ed87838747bbc06567e., hostname=insight-hadoop-datanode-10.xx.com,16020,1552087271188, seqNum=2
2019-03-19 16:16:19,102 INFO [kylin-coproc--pool3-t2] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=108551 ms ago, cancelled=false, msg=row '' on table 'KYLIN_PJ7DRSO3FG' at region=KYLIN_PJ7DRSO3FG,,1552778181238.4ed951c81f4d2b237f8258006bee22e5., hostname=insight-hadoop-datanode-16.xx.com,16020,1545651143259, seqNum=2
2019-03-19 16:16:20,436 INFO [kylin-coproc--pool3-t1] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=109885 ms ago, cancelled=false, msg=row '' on table 'KYLIN_O7D5YT0QWR' at region=KYLIN_O7D5YT0QWR,,1552691769767.edaccbe34521045d02bc4c1f00c849a0., hostname=insight-hadoop-datanode-2.xx.com,16020,1546424087792, seqNum=2
My conf is in attached file. I queried hbase directly , and those tables are right there with values.
答复: can not query after update from 2.0.0 to 2.2.0
Posted by Na Zhai <na...@kyligence.io>.
Hi, bubugao0809.
Can you provide the sql that you query?
发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用
发件人: bubugao0809<ma...@163.com>
发送时间: 2019年3月19日 16:56
收件人: user@kylin.apache.org<ma...@kylin.apache.org>
主题: can not query after update from 2.0.0 to 2.2.0
Hi all,
Follow the instruction here :http://kylin.apache.org/docs/howto/howto_upgrade.html
I update the kylin from 2.0.0 to 2.2.0 , but I keep getting these errors while quering:
2019-03-19 16:15:12,107 DEBUG [BadQueryDetector] badquery.BadQueryHistoryManager:85 : Loaded 50 Bad Query(s)
2019-03-19 16:15:12,157 INFO [BadQueryDetector] service.BadQueryDetector:178 : Problematic thread 0x3b
at sun.misc.Unsafe.park(Native Method)
at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
at java.util.concurrent.ArrayBlockingQueue.poll(ArrayBlockingQueue.java:418)
at org.apache.kylin.storage.hbase.cube.v2.ExpectedSizeIterator.next(ExpectedSizeIterator.java:63)
at org.apache.kylin.storage.hbase.cube.v2.ExpectedSizeIterator.next(ExpectedSizeIterator.java:31)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at com.google.common.collect.Lists.newArrayList(Lists.java:145)
at org.apache.kylin.storage.gtrecord.StorageResponseGTScatter.iterator(StorageResponseGTScatter.java:84)
at org.apache.kylin.storage.gtrecord.ScannerWorker.iterator(ScannerWorker.java:64)
2019-03-19 16:15:35,194 DEBUG [http-bio-7070-exec-5] security.KylinAuthenticationProvider:113 : User ADMIN authorities : [ROLE_ADMIN, ROLE_ANALYST, ROLE_MODELER]
2019-03-19 16:15:35,253 DEBUG [http-bio-7070-exec-5] security.KylinAuthenticationProvider:126 : Authenticated user org.springframework.security.authentication.UsernamePasswordAuthenticationToken@37047726: Principal: org.springframework.security.core.userdetails.User@3b40b2f: Username: ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@ffff4c9c: RemoteIpAddress: 10.24.1.53; SessionId: null; Granted Authorities: ROLE_ADMIN, ROLE_ANALYST, ROLE_MODELER
2019-03-19 16:16:18,985 INFO [kylin-coproc--pool3-t4] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=108431 ms ago, cancelled=false, msg=row '' on table 'KYLIN_JWG8DCN3PO' at region=KYLIN_JWG8DCN3PO,,1552951168290.4d2247a5d70d764709b238ee31279611., hostname=insight-hadoop-datanode-3.xx.com,16020,1550648351816, seqNum=2
2019-03-19 16:16:19,070 INFO [kylin-coproc--pool3-t3] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=108519 ms ago, cancelled=false, msg=row '' on table 'KYLIN_LPEKROSIHD' at region=KYLIN_LPEKROSIHD,,1552864581993.7d7782b797056ed87838747bbc06567e., hostname=insight-hadoop-datanode-10.xx.com,16020,1552087271188, seqNum=2
2019-03-19 16:16:19,102 INFO [kylin-coproc--pool3-t2] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=108551 ms ago, cancelled=false, msg=row '' on table 'KYLIN_PJ7DRSO3FG' at region=KYLIN_PJ7DRSO3FG,,1552778181238.4ed951c81f4d2b237f8258006bee22e5., hostname=insight-hadoop-datanode-16.xx.com,16020,1545651143259, seqNum=2
2019-03-19 16:16:20,436 INFO [kylin-coproc--pool3-t1] client.RpcRetryingCaller:132 : Call exception, tries=12, retries=35, started=109885 ms ago, cancelled=false, msg=row '' on table 'KYLIN_O7D5YT0QWR' at region=KYLIN_O7D5YT0QWR,,1552691769767.edaccbe34521045d02bc4c1f00c849a0., hostname=insight-hadoop-datanode-2.xx.com,16020,1546424087792, seqNum=2
My conf is in attached file. I queried hbase directly , and those tables are right there with values.