注册

数据库日志疯狂打印dthrd_info_add nth:141, dthrd_info:0x7fea6d7f9da0, thrd_name:dm_sql_thd且查询会话有很多未知的CREATE会话

volare 2024/12/05 343 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
数据库日志疯狂打印,导致日志占用磁盘控件很大(几百G):
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282687 dthrd_info_add nth:143, dthrd_info:0x7fea69ff2da0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282688 dthrd_info_add nth:144, dthrd_info:0x7fea96ffcda0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282690 dthrd_info_add nth:146, dthrd_info:0x7fea697f1da0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282691 dthrd_info_add nth:147, dthrd_info:0x7fea957f9da0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282692 dthrd_info_add nth:148, dthrd_info:0x7feb11ffada0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282689 dthrd_info_add nth:145, dthrd_info:0x7fea6cff8da0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282693 dthrd_info_add nth:149, dthrd_info:0x7fea87ffeda0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282694 dthrd_info_add nth:150, dthrd_info:0x7fea94ff8da0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282695 dthrd_info_add nth:151, dthrd_info:0x7fea68ff0da0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282696 dthrd_info_add nth:152, dthrd_info:0x7fea6aff4da0, thrd_name:dm_sql_thd
2024-12-05 11:41:56.559 [INFO] database P0002303330 T0000000000003282697 dthrd_info_add nth:153, dthrd_info:0x7fea86ffcda0, thrd_name:dm_sql_thd

查询会话STATE字段有很多未知的CREATE会话,CLNT_IP值是:0:

SQL_TEXT STATE CURR_SCH USER_NAME TRX_ID CLNT_TYPE CLNT_HOST APPNAME CLNT_IP OSNAME RUN_STATUS LAST_RECV_TIME LAST_SEND_TIME CLNT_VER
[NULL] CREATE -1 UNKNOWN :0 RUNNING 1970-01-01 08:00:00.000 2024-12-05 11:36:00.153 [NULL]
[NULL] CREATE -1 UNKNOWN :0 RUNNING 1970-01-01 08:00:00.000 2024-12-05 11:36:00.154 [NULL]
[NULL] CREATE -1 UNKNOWN :0 RUNNING 1970-01-01 08:00:00.000 2024-12-05 11:36:00.154 [NULL]
[NULL] CREATE -1 UNKNOWN :0 RUNNING 1970-01-01 08:00:00.000 2024-12-05 11:36:00.154 [NULL]
[NULL] CREATE -1 UNKNOWN :0 RUNNING 1970-01-01 08:00:00.000 2024-12-05 11:36:00.154 [NULL]
[NULL] CREATE -1 UNKNOWN :0 RUNNING 1970-01-01 08:00:00.000 2024-12-05 11:36:00.154 [NULL]
[NULL] CREATE -1 UNKNOWN :0 RUNNING 1970-01-01 08:00:00.000 2024-12-05 11:36:00.154 [NULL]

导致数据库连接失败,请问是什么原因,怎么解决

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