开始新对话

未解决

L

1 消息

15

2024年1月18日 04:15

rea'd0,热40服务器,sql server 2016用一个小时左右就挂起了

,A read of the file 'I:\sql\20240115_log.ldf' at offset 0000000000000000 succeeded after failing 3 time(s) with error: 1117(由于 I/O 设备错误,无法运行此项请求。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.
01/18/2024 09:20:52,spid44s,未知,The operating system returned error 1117(由于 I/O 设备错误,无法运行此项请求。) to SQL Server during a read at offset 0000000000000000 in file 'I:\sql\20240115_Data.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

Community Manager

 • 

6.6K 消息

2024年1月18日 10:21

您好!

从您这日志信息看不出什么服务器方面的问题。服务器方面,按照下面的文章检查一下服务器的硬件。另外,可以再仔细检查一下磁盘的状况。如果都没有问题,要么就是SQL那边的问题,或者和SQL的兼容性方面的问题了。

如何在PowerEdge服务器上运行硬件诊断程序

https://www.dell.com/support/kbdoc/en-us/000132726/%E5%A6%82-%E4%BD%95-%E5%9C%A8-poweredge-%E6%9C%8D%E5%8A%A1%E5%99%A8-%E4%B8%8A-%E8%BF%90%E8%A1%8C-%E7%A1%AC%E4%BB%B6-%E8%AF%8A%E6%96%AD%E7%A8%8B%E5%BA%8F?lang=zh#2

找不到事件!

Top