为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8
【操作系统】:麒麟V10
【CPU】:Intel(R) Xeon(R) CPU E7- 4820 @ 2.00GHz
【问题描述】*:日志很多累死的报错如下, 用户连接不上了。
2023-08-28 09:30:48.172 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 99901
2023-08-28 09:31:00.405 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 99998
2023-08-28 09:31:12.602 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 97404
2023-08-28 09:31:24.798 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 99154
2023-08-28 09:31:37.011 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 98680
2023-08-28 09:31:49.222 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 95845
2023-08-28 09:32:01.422 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 98413
2023-08-28 09:32:13.627 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 97701
2023-08-28 09:32:25.812 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 94100
2023-08-28 09:32:37.994 [WARNING] database P0000018749 T0000000000000018820 curr process used file handle is overflow! max handle count is 65535, curr rocess handle count is 96645
从报错信息看应该是实际使用句柄数超过了限制的句柄数65535,可以先将数据库进程重启释放一下恢复使用,再查看下日志中在这个警告信息之前是否有其他ERROR信息