为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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]
导致数据库连接失败,请问是什么原因,怎么解决
又没有设置ip白名单之类的,可以查一下数据库session,是不是又很多连接在连数据库但是因为权限设置连不上。
有达梦技术专家帮解答下吗