注册

应用通过JDBC请求数据库,正常为20ms,但偶发有3-5s

JHSONN 2024/11/15 316 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:--05134284094-20230927-203585-20067 Pack1
【操作系统】:kylinv10
【CPU】:
【问题描述】*:
使用驱动版本:
image.png
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;

回答 0
暂无回答
扫一扫
联系客服