为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8.2
【操作系统】:银河麒麟
【CPU】:arm
【问题描述】*: SM环境数据库一直报警告,有什么办法解决吗?
2023-07-19 11:13:23.508 [WARNING] database P0000003819 T0000000000002129061 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.509 [WARNING] database P0000003819 T0000000000002129058 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.520 [WARNING] database P0000003819 T0000000000002129062 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.574 [WARNING] database P0000003819 T0000000000002129064 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.575 [WARNING] database P0000003819 T0000000000002129063 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.582 [WARNING] database P0000003819 T0000000000002129066 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.582 [WARNING] database P0000003819 T0000000000002129065 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.649 [WARNING] database P0000003819 T0000000000002129068 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.650 [WARNING] database P0000003819 T0000000000002129067 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.773 [WARNING] database P0000003819 T0000000000002129070 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.807 [WARNING] database P0000003819 T0000000000002129071 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.815 [WARNING] database P0000003819 T0000000000002129073 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.816 [WARNING] database P0000003819 T0000000000002129072 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.905 [WARNING] database P0000003819 T0000000000002129075 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.906 [WARNING] database P0000003819 T0000000000002129074 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.976 [WARNING] database P0000003819 T0000000000002129078 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.977 [WARNING] database P0000003819 T0000000000002129076 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.989 [WARNING] database P0000003819 T0000000000002129080 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:23.990 [WARNING] database P0000003819 T0000000000002129079 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.038 [WARNING] database P0000003819 T0000000000002129082 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.038 [WARNING] database P0000003819 T0000000000002129081 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.062 [WARNING] database P0000003819 T0000000000002129084 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.063 [WARNING] database P0000003819 T0000000000002129083 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.092 [WARNING] database P0000003819 T0000000000002129086 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.092 [WARNING] database P0000003819 T0000000000002129085 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.112 [WARNING] database P0000003819 T0000000000002129088 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.113 [WARNING] database P0000003819 T0000000000002129087 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.153 [WARNING] database P0000003819 T0000000000002129091 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.153 [WARNING] database P0000003819 T0000000000002129089 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.154 [WARNING] database P0000003819 T0000000000002129092 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.154 [WARNING] database P0000003819 T0000000000002129090 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.202 [WARNING] database P0000003819 T0000000000002129096 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.203 [WARNING] database P0000003819 T0000000000002129094 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.205 [WARNING] database P0000003819 T0000000000002129097 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.206 [WARNING] database P0000003819 T0000000000002129095 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.236 [WARNING] database P0000003819 T0000000000002129099 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.237 [WARNING] database P0000003819 T0000000000002129098 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.256 [WARNING] database P0000003819 T0000000000002129100 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.430 [WARNING] database P0000003819 T0000000000002129102 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.468 [WARNING] database P0000003819 T0000000000002129104 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.471 [WARNING] database P0000003819 T0000000000002129103 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.616 [WARNING] database P0000003819 T0000000000002129108 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
2023-07-19 11:13:24.617 [WARNING] database P0000003819 T0000000000002129107 Failure occurs in data_recv_inet_once, code(107) len(32576, 0)
可以看下数据库参数COMM_TRACE是多少
select para_name,para_value from v$dm_ini where para_name='COMM_TRACE';
COMM_TRACE
服务器日志是否记录通信中产生的警告信息。0:不记录 1:记录
可以改成0不记录此类警告,修改方法:
sp_set_para_value(2,'COMM_TRACE',0);
重启数据库生效
这是通信中产生的告警信息,错误代码是操作系统返回的,107 Transport endpoint 传输终点没有连接,在系统繁忙的时候会刷这个,通常可以忽略