TommyZC

Results 5 issues of TommyZC

* **dble version:2.19.03/lts** * 当前使用的fastjson版本为1.2.78,可能存在不兼容的情况 * **preconditions :** no * **configs:** **schema.xml** ``` ``` **rule.xml** ``` ``` **server.xml** ``` ``` * **steps:** step1. * **expect result:** 1. * **real result:**...

* **dble version:2.19.03/lts** * **preconditions :** no * **configs:** **schema.xml** ``` ``` **rule.xml** ``` ``` **server.xml** ``` ``` * **steps:** 应用程序日志中显示存在一条select xxx where xxx in();的sql语句报了dble后端超时错误 * **expect result:** dble日志中能看到这个报错 *...

community

* **dble version:2.19.03/lts** * **preconditions :** * **configs:** **schema.xml** ``` select user() ``` **rule.xml** ``` id hashmod 2 1 ``` **server.xml** ``` ``` * **steps:** step1. 创建表testjson CREATE TABLE `testjson`...

* **dble version:2.19.03/lts** * **preconditions :useSqlStat=1** dump信息如下: ![topConsumer](https://user-images.githubusercontent.com/48617791/219297866-9f4c3f1f-1e77-4e91-bee6-e1193cba4ee0.jpg) ![topLoader](https://user-images.githubusercontent.com/48617791/219298267-2dd5dc9f-912d-4b94-bfc0-976b2c7dd06e.jpg) ![suspect](https://user-images.githubusercontent.com/48617791/219298300-4e9b2630-97e6-4a9f-b977-bd8349428eb2.jpg) ![dominator_tree2](https://user-images.githubusercontent.com/48617791/219298359-eb3a4cb4-c6cb-4a51-93f3-e3ccb30e538d.jpg) ![Histogram](https://user-images.githubusercontent.com/48617791/219298537-f8e8caf0-f7f8-4adf-981a-4df0970666a0.jpg) ![Histogram2](https://user-images.githubusercontent.com/48617791/219298594-23702dcb-e55b-4be2-959a-1a2a826ff012.jpg) 从dump中看到是ConcurrentSkipListMap占用了大部分JVM内存,里边是UserSqlLastStat$sqlLast,开启useSqlStat功能后会使用到,不太理解的是DBLE为什么会有这么多的ConcurrentSkipListMap占用空间,而且map里边看到还有map,帮忙看一下是哪里的逻辑导致生成了这么多的ConcurrentSkipListMap。 源码中是在这里初始化了map和sqlLast ![image](https://user-images.githubusercontent.com/48617791/219300575-3505f823-ddbf-423a-855b-3ba96bfbaa8b.png) ![image](https://user-images.githubusercontent.com/48617791/219301249-d5b276a9-2253-4992-9b81-34fb142c6e29.png) ![image](https://user-images.githubusercontent.com/48617791/219301862-569015eb-483b-48d2-9cd5-82d07b6839c3.png)

memory
community

* **dble version:2.19.03/lts** * **preconditions :create table test2(id int(11), name char(10));** * **configs:** **schema.xml** ``` select user() ``` **rule.xml** ``` ``` **server.xml** ``` 2 2048 0 60000 0 86400000 300000...

community