为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:--05134284094-20230927-203585-20067 Pack1
【操作系统】:kylinv10
【CPU】:
【问题描述】*:
使用驱动版本:
JDBC日志中conn-4为什么会隔了5s才有下一个日志记录?
[DEBUG - 2024-11-14 20:29:23] tid:39 - [initProcessApplications] { conn-4 } access(); CMD_COMMIT
[INFO - 2024-11-14 20:29:23] tid:39 - [initProcessApplications] { conn-4 } commit();
[INFO - 2024-11-14 20:29:23] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): false;
[INFO - 2024-11-14 20:29:23] tid:39 - [initProcessApplications] { conn-4 } setAutoCommit(Boolean); [PARAMS]: true;
[INFO - 2024-11-14 20:29:23] tid:39 - [initProcessApplications] { conn-4 } clearWarnings();
[INFO - 2024-11-14 20:29:23] tid:39 - [initProcessApplications] { conn-4 } isClosed(): false;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } isClosed(): false;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } getAutoCommit(): true;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } setAutoCommit(Boolean); [PARAMS]: false;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } getCatalog(): null;
[DEBUG - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } access(); CMD_PREPARE
[SQL - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } prepareStatement(String): pstmt-332, handle-0; [PARAMS]: "SELECT * FROM QRTZ_SCHEDULER_STATE WHERE SCHED_NAME = 'sharedportal'";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } getAutoCommit(): false;
[DEBUG - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } access(); CMD_EXECUTE2
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332 } executeQuery(): rs-303;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } next(): true;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } getString(String): "svc-sjzc-sharedportal-7578c469-st9cn1731585222908"; [PARAMS]: "INSTANCE_NAME";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } getLong(String): 1731587362522; [PARAMS]: "LAST_CHECKIN_TIME";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } getLong(String): 7500; [PARAMS]: "CHECKIN_INTERVAL";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } next(): true;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } getString(String): "svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652"; [PARAMS]: "INSTANCE_NAME";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } getLong(String): 1731587359779; [PARAMS]: "LAST_CHECKIN_TIME";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } getLong(String): 7500; [PARAMS]: "CHECKIN_INTERVAL";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } next(): false;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332, rs-303 } close();
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-332 } close();
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } getCatalog(): null;
[DEBUG - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } access(); CMD_PREPARE
[SQL - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } prepareStatement(String): pstmt-333, handle-2; [PARAMS]: "UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = ? WHERE SCHED_NAME = 'sharedportal' AND INSTANCE_NAME = ?";
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-333 } setLong(Integer, Long); [PARAMS]: 1, 1731587367281;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-333 } setString(Integer, String); [PARAMS]: 2, "svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652";
[DEBUG - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } access(); CMD_EXECUTE2
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-333 } executeUpdate(): 1;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3, pstmt-333 } close();
[DEBUG - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } access(); CMD_COMMIT
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } commit();
[DEBUG - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } access(); CMD_COMMIT
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } commit();
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } setAutoCommit(Boolean); [PARAMS]: true;
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } clearWarnings();
[INFO - 2024-11-14 20:29:27] tid:193 - [QuartzScheduler_sharedportal-svc-sjzc-sharedportal-c6d8cdbb7-gmdrc1731587344652_ClusterManager] { conn-3 } isClosed(): false;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } isClosed(): false;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): true;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): true;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): true;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): true;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): true;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } setAutoCommit(Boolean); [PARAMS]: false;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): false;
[INFO - 2024-11-14 20:29:28] tid:39 - [initProcessApplications] { conn-4 } getAutoCommit(): false;
数据库服务器cpu,内存,磁盘io使用比较正常;
而在应用前台多次刷新内容即会复现该问题,SQL较简单(不局限于某一条SQL);
数据库驱动已更换为对应数据库软件安装目录下获取的版本;
跟踪调用链条显示dm.jdbc返回时间长
这会是哪里导致的问题?
需要查看对应的dmserver堆栈信息,调整数据库的参数设置?还是要更换连接驱动?
麻烦各位大佬提供点解决问题的思路
可以找商务申请目前最新的版本再测试下这个问题
可以看一下偶发3-5s时,是否还存在别的数据在增删改查,导致数据库存在压力,或者从数据库日志来看,是否存在REDO日志切换等情况
这可能是因为日志记录是在不同的线程中完成的,或者是因为日志框架(如log4j、SLF4J等)有缓冲或延迟写入日志文件的配置。