数据库用着用着就会挂掉,必须重新启动才能连接
【DM版本】: V8
【操作系统】:UnionTech OS Server 20 Enterprise
【CPU】: 8 virt-rhel7.6.0
【问题描述】*:
2023-03-02 11:53:21.921 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378838798), ckpt_fil(0), ckpt_off(24433152), cur_lsn(378838798), l_next_seq(4195328), g_next_seq(4195328), cur_free(24433152), total_space(536862720), free_space(536862720), n_ep(1)
2023-03-02 11:58:21.971 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378839070), ckpt_fil(0), ckpt_off(24558080), cur_lsn(378839070), l_next_seq(4195414), g_next_seq(4195414), cur_free(24558080), total_space(536862720), free_space(536862720), n_ep(1)
2023-03-02 12:00:24.993 [INFO] database P0000021495 T0000000000000021526 BACKUP DATABASE [DAMENG]
2023-03-02 12:00:24.993 [INFO] database P0000021495 T0000000000000021526 CMD START......
2023-03-02 12:03:01.357 [INFO] database P0000021495 T0000000000000021526 CMD END.CODE:[0]
2023-03-02 12:03:21.715 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378841015), ckpt_fil(0), ckpt_off(25021440), cur_lsn(378841015), l_next_seq(4195509), g_next_seq(4195509), cur_free(25021952), total_space(536862720), free_space(536862208), n_ep(1)
2023-03-02 12:08:21.745 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378841285), ckpt_fil(0), ckpt_off(25146880), cur_lsn(378841285), l_next_seq(4195601), g_next_seq(4195601), cur_free(25146880), total_space(536862720), free_space(536862720), n_ep(1)
2023-03-02 12:10:24.785 [INFO] database P0000021495 T0000000000000021526 BACKUP DATABASE [DAMENG]
2023-03-02 12:10:24.785 [INFO] database P0000021495 T0000000000000021526 CMD START......
2023-03-02 12:11:43.528 [ERROR] database P0000021495 T0000000000000021526 comm_msg_recv failed, errno = 104, desc = 连接被对方重设
2023-03-02 12:11:43.562 [ERROR] database P0000021495 T0000000000000021526 comm_msg_send failed, errno = 32, desc = 断开的管道
2023-03-02 12:11:43.562 [ERROR] database P0000021495 T0000000000000021526 comm_msg_send failed, errno = 32, desc = 断开的管道
2023-03-02 12:11:43.562 [ERROR] database P0000021495 T0000000000000021526 comm_msg_send failed, errno = 32, desc = 断开的管道
2023-03-02 12:11:43.597 [ERROR] database P0000021495 T0000000000000021526 CMD END.CODE:[-7169],DESC:[bakresӫDMAPϻϢͨЅʧ°ܝ
2023-03-02 12:13:21.574 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378841571), ckpt_fil(0), ckpt_off(25278464), cur_lsn(378841571), l_next_seq(4195703), g_next_seq(4195703), cur_free(25278464), total_space(536862720), free_space(536862720), n_ep(1)
2023-03-02 12:18:21.599 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378841841), ckpt_fil(0), ckpt_off(25404928), cur_lsn(378841841), l_next_seq(4195796), g_next_seq(4195796), cur_free(25404928), total_space(536862720), free_space(536862720), n_ep(1)
2023-03-02 12:20:24.645 [INFO] database P0000021495 T0000000000000021539 BACKUP DATABASE [DAMENG]
2023-03-02 12:20:24.645 [INFO] database P0000021495 T0000000000000021539 CMD START......
2023-03-02 12:21:32.619 [ERROR] database P0000021495 T0000000000000021539 comm_msg_recv failed, errno = 104, desc = 连接被对方重设
2023-03-02 12:21:32.724 [ERROR] database P0000021495 T0000000000000021539 comm_msg_send failed, errno = 32, desc = 断开的管道
2023-03-02 12:21:32.725 [ERROR] database P0000021495 T0000000000000021539 comm_msg_send failed, errno = 32, desc = 断开的管道
2023-03-02 12:21:32.725 [ERROR] database P0000021495 T0000000000000021539 comm_msg_send failed, errno = 32, desc = 断开的管道
2023-03-02 12:21:32.735 [ERROR] database P0000021495 T0000000000000021539 CMD END.CODE:[-7169],DESC:[bakresӫDMAPϻϢͨЅʧ°ܝ
2023-03-02 12:23:21.707 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378844955), ckpt_fil(0), ckpt_off(26165248), cur_lsn(378844955), l_next_seq(4195900), g_next_seq(4195900), cur_free(26165248), total_space(536862720), free_space(536862720), n_ep(1)
2023-03-02 12:28:21.723 [INFO] database P0000021495 T0000000000000021514 ckpt2_log_adjust: ckpt_lsn(378845226), ckpt_fil(0), ckpt_off(26291712), cur_lsn(378845226), l_next_seq(4195995), g_next_seq(4195995), cur_free(26291712), total_space(536862720), free_space(536862720), n_ep(1)
2023-03-02 12:30:24.767 [INFO] database P0000021495 T0000000000000021527 BACKUP DATABASE [DAMENG]
2023-03-02 12:30:24.767 [INFO] database P0000021495 T0000000000000021527 CMD START......
2023-03-02 12:32:41.902 [INFO] database P0000021495 T0000000000000021527 CMD END.CODE:[0]
什么数据库版本。
关闭定时备份作业,观察还会宕机吗
可以加群,及时解答
940124259
这个只是ERROR,挂库的话没有FATAL错误吗?
请确认是否在备份过程中出现的异常。
您说的挂掉是指数据库服务不可再连接吗