li-ang-666 opened a new issue #4654:
URL: https://github.com/apache/incubator-doris/issues/4654
**Describe the bug**
一个简单查询：
select id from 表 limit 1
在代码中：
while（true）{
JDBC 执行 SQL
}
会不定期出现:
Exception in thread "main"
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown error
在fe.warn.log中看到的日志是：
2020-09-22 17:21:13,368 WARN 24043 [StmtExecutor.execute():306] execute
Exception
java.util.ConcurrentModificationException: null
at java.util.TreeMap$PrivateEntryIterator.nextEntry(TreeMap.java:1211)
~[?:1.8.0_252]
at java.util.TreeMap$KeyIterator.next(TreeMap.java:1265) ~[?:1.8.0_252]
at
org.apache.doris.common.util.RuntimeProfile.printChildCounters(RuntimeProfile.java:235)
~[palo-fe.jar:?]
at
org.apache.doris.common.util.RuntimeProfile.prettyPrint(RuntimeProfile.java:212)
~[palo-fe.jar:?]
at
org.apache.doris.common.util.RuntimeProfile.prettyPrint(RuntimeProfile.java:219)
~[palo-fe.jar:?]
at
org.apache.doris.common.util.RuntimeProfile.prettyPrint(RuntimeProfile.java:219)
~[palo-fe.jar:?]
at
org.apache.doris.common.util.RuntimeProfile.prettyPrint(RuntimeProfile.java:219)
~[palo-fe.jar:?]
at
org.apache.doris.common.util.RuntimeProfile.prettyPrint(RuntimeProfile.java:219)
~[palo-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.writeProfile(StmtExecutor.java:342)
~[palo-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:244)
~[palo-fe.jar:?]
at
org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:184)
~[palo-fe.jar:?]
at
org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:316)
~[palo-fe.jar:?]
at
org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:501)
~[palo-fe.jar:?]
at
org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50)
~[palo-fe.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_252]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_252]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252]
2020-09-22 17:21:13,385 WARN 24043 [ConnectProcessor.processOnce():491] Null
packet received from network. remote: XXX.XXX.XXX.74:38188
2020-09-22 17:21:13,385 WARN 24043 [ReadListener.lambda$handleEvent$0():58]
Exception happened in one
session(org.apache.doris.mysql.nio.NConnectContext@4f53ffef).
java.io.IOException: Error happened when receiving packet.
at
org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:492)
~[palo-fe.jar:?]
at
org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50)
~[palo-fe.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_252]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_252]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252]
补充：
fe配置：
max_routine_load_job_num = 270
max_layout_length_per_row = 100000000
max_routine_load_task_num_per_be = 27
label_keep_max_second = 3600
history_job_keep_max_second = 3600
label_clean_interval_second = 3600
max_running_txn_num_per_db = 300
audit_log_delete_age = 7d
sys_log_delete_age = 7d
query_colocate_join_memory_limit_penalty_factor = 1
thrift_server_max_worker_threads = 6144
be配置：
routine_load_thread_pool_size = 27
sys_log_roll_num = 1
base_compaction_num_threads_per_disk = 3
base_compaction_check_interval_seconds = 10
cumulative_compaction_check_interval_seconds = 1
cumulative_compaction_skip_window_seconds = 10
min_compaction_failure_interval_sec = 10
cumulative_compaction_num_threads_per_disk = 3
10个be节点，20分桶，无分区
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
