Please check what kinds of queries you were using? Some full table scan(such as select * from fact_table) queries will exhaust all system resource.
2017-12-28 14:02 GMT+08:00 hehe <[email protected]>: > Kylin hangs up after several query. Env: kylin 1.6.0 > > 2017-12-27 15:29:41,149 INFO [BadQueryDetector] > service.BadQueryDetector:151 : System free memory less than 100 MB. 13 > queries running. > 2017-12-27 15:31:15,942 DEBUG [BadQueryDetector] > badquery.BadQueryHistoryManager:84 : Loaded 10 Bad Query(s) > 2017-12-27 15:31:15,956 INFO [BadQueryDetector] > service.BadQueryDetector:169 : Problematic thread 0x72 > at sun.nio.cs.UTF_8.newDecoder(UTF_8.java:68) > at java.lang.StringCoding.decode(StringCoding.java:213) > at java.lang.String.<init>(String.java:453) > at org.apache.kylin.common.util.Bytes.toString(Bytes.java:232) > at > org.apache.kylin.dict.StringBytesConverter.convertFromBytes( > StringBytesConverter.java:32) > at > org.apache.kylin.dict.StringBytesConverter.convertFromBytes( > StringBytesConverter.java:23) > at > org.apache.kylin.dict.TrieDictionary.getValueFromIdImpl( > TrieDictionary.java:290) > at > org.apache.kylin.common.util.Dictionary.getValueFromId( > Dictionary.java:130) > at > org.apache.kylin.dict.lookup.SnapshotTable$1.getRow( > SnapshotTable.java:151) > at org.apache.kylin.dict.lookup.LookupTable.init(LookupTable. > java:68) > 2017-12-27 15:36:01,844 DEBUG [BadQueryDetector] > badquery.BadQueryHistoryManager:84 : Loaded 10 Bad Query(s) > 2017-12-27 15:37:42,595 INFO [Job > af175c3d-5750-4366-afb7-63e4bc661a8d-1356-SendThread( > HQxPSL-ACRM-D07:2181)] > zookeeper.ClientCnxn:1103 : Client session timed out, have not heard from > server in 152907ms for sessionid 0x26067f6e7e9247b, closing socket > connection and attempting reconnect > 2017-12-27 15:37:42,594 INFO [Thread-12-SendThread(HQxPSL-ACRM-D06:2181)] > zookeeper.ClientCnxn:1103 : Client session timed out, have not heard from > server in 152907ms for sessionid 0x36067f6e88e249c, closing socket > connection and attempting reconnect > 2017-12-27 15:39:19,460 WARN [Thread-12-EventThread] > zookeeper.ClientCnxn:532 : ---watch process time---:45489 ms! > 2017-12-27 15:39:19,460 INFO [Job > af175c3d-5750-4366-afb7-63e4bc661a8d-1356-SendThread( > HQxPSL-ACRM-D07:2181)] > zookeeper.ClientCnxn:1103 : Client session timed out, have not heard from > server in 142419ms for sessionid 0x26067f6e7e9247a, closing socket > connection and attempting reconnect > 2017-12-27 15:39:19,460 WARN [Job > af175c3d-5750-4366-afb7-63e4bc661a8d-1356-EventThread] > zookeeper.ClientCnxn:532 : ---watch process time---:45489 ms! > 2017-12-27 15:39:19,461 INFO [Job > af175c3d-5750-4366-afb7-63e4bc661a8d-1356-SendThread( > HQxPSL-ACRM-D05:2181)] > zookeeper.ClientCnxn:982 : Opening socket connection to server > HQxPSL-ACRM-D05/10.229.150.223:2181. Will not attempt to authenticate > using > SASL (unknown error) > > > How can I solve the problem,thank you! > > -- > Sent from: http://apache-kylin.74782.x6.nabble.com/ >
