为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: V8
【操作系统】:centos 7
【CPU】: 8 virt-rhel7.6.0
【问题描述】*:
数据库连接超时,需要重启数据库才能正常连接
下面是dmap_br日子:
2023-02-24 10:09:52.356 [INFO] dmap_br P0000014760 T0000000000000014760 dmap_br V8
2023-02-24 10:09:52.379 [INFO] dmap_br P0000014760 T0000000000000014760 baker_dll_exec_fun success
2023-02-24 10:09:52.379 [INFO] dmap_br P0000014760 T0000000000000014760 bakres start with process ......
2023-02-24 10:09:52.379 [INFO] dmap_br P0000014760 T0000000000000014760 bakres receive from pipe success, CMD [BMML_INIT].
2023-02-24 10:09:53.262 [INFO] dmap_br P0000014760 T0000000000000014760 bakres receive from pipe success, CMD [BACKUP_START].
2023-02-24 10:10:56.911 [ERROR] dmap_br P0000014760 T0000000000000014760 comm_msg_send failed, errno = 104, desc = Connection reset by peer
2023-02-24 10:10:56.915 [INFO] dmap_br P0000014760 T0000000000000014760 baker_cmd_process failed, code:-7169 tsk_complete enqueue.
2023-02-24 10:10:56.915 [INFO] dmap_br P0000014760 T0000000000000014760 code = -7169, bakres CMD [END] begin...
2023-02-24 10:11:03.121 [INFO] dmap_br P0000014760 T0000000000000014760 bakres CMD [END] tsk node get...
2023-02-24 10:11:03.157 [INFO] dmap_br P0000014760 T0000000000000014760 bakres CMD [END] end.
2023-02-24 10:11:03.157 [INFO] dmap_br P0000014760 T0000000000000014760 bakres end cmd process with process.
2023-02-24 10:11:03.162 [ERROR] dmap_br P0000014760 T0000000000000014760 DMAP_BR fail to baker_dll_exec_fun, code[-7169].
这个是系统message日志
重启后可以的话,那您应该考虑重启后有什么变化,这里先简单提供几种可能哈,一种是数据库连接超过最大连接数了,另外在数据库运行时连不上情况,对数据库状态、数据库服务器内存使用情况等信息也可以进行排查