为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM7
【操作系统】:centos7
【CPU】:x86_64
【问题描述】*:使用dmrman恢复数据,数据量5G多,恢复过程一直没有结束,运行了10多个小时,查看dm安装目录下的日志显示错误
dmrman CTLSTMT="RESTORE DATABASE '/dmdata/data/DAMENG5236/dm.ini' FROM BACKUPSET '/dmdata/data/backup/13430';"
[root@localhost log]# tail dm_DMAP_202504.log
2025-04-09 02:40:48 [INFO] dmap P0000000939 T0000140272715355968 dmap shutdown successfully
2025-04-09 02:41:21 [INFO] dmap P0000001099 T0000140659231741760 dmap V7.6.1.92-Build(2021.03.05-136011)ENT
2025-04-09 02:41:21 [INFO] dmap P0000001099 T0000140659231741760 dmap is ready
2025-04-09 05:05:12 [ERROR] dmap P0000001099 T0000140659034621696 os_file_flush error! handle: 7, ret: -1, code: 5, desc: Input/output error
2025-04-09 05:10:59 [ERROR] dmap P0000001099 T0000140659034621696 os_file_flush error! handle: 7, ret: -1, code: 5, desc: Input/output error
2025-04-09 05:16:09 [ERROR] dmap P0000001099 T0000140659034621696 os_file_flush error! handle: 7, ret: -1, code: 5, desc: Input/output error
2025-04-09 05:27:23 [ERROR] dmap P0000001099 T0000140659034621696 os_file_flush error! handle: 7, ret: -1, code: 5, desc: Input/output error
2025-04-09 05:34:50 [ERROR] dmap P0000001099 T0000140659034621696 os_file_flush error! handle: 7, ret: -1, code: 5, desc: Input/output error
2025-04-09 05:40:23 [ERROR] dmap P0000001099 T0000140659034621696 os_file_flush error! handle: 7, ret: -1, code: 5, desc: Input/output error
2025-04-09 05:48:15 [ERROR] dmap P0000001099 T0000140659034621696 os_file_flush error! handle: 7, ret: -1, code: 5, desc: Input/output error
[root@localhost log]#
数据库进程(dmap)在尝试将数据刷写到磁盘时失败,检查磁盘健康状态:
smartctl -a /dev/sda # 替换为实际磁盘设备路径
dmesg | grep -i error # 查看内核日志中的磁盘错误
测试写入速度:dd if=/dev/zero of=/DATA/test bs=32k count=20K oflag=dsync
此错误表明达梦数据库在尝试刷新文件(如数据文件、日志文件)到磁盘时发生I/O异常,需立即排查存储系统及文件状态。