Error: fcb::close-flush: Operating system error 21(The device is not ready.) encountered

Question

We are using sql server 2005 Enterprise Edition with service pack1

 

I got the following error messages in the SQL log

 

1. The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....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, see SQL Server Books Online.
2. fcb::close-flush: Operating system error 21(The device is not ready.) encountered.

I got these errors for about 2 hrs and after that I see these messages in the sql log

 

• Starting up database ' '
• 1 transactions rolled forward in database ''  (). This is an informational message only. No user action is required.
• 0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required.
• Recovery is writing a checkpoint in database  ' ' ( ). This is an informational message only. No user action is required.
• CHECKDB for database  '' finished without errors on   (local time). This is an informational message only; no user action is required.
  
  

Can anyone please help me in troubleshooting this issue. Why this migh have happened.

 

any help would be appreciated.

 

Thanks

 

 

Answer 1

This sounds like an IO subsystem issue, i.e. SQL Server is having difficulty talking to one of your drives. Are you using direct attached storage or a SAN?

Answer 2

Thanks for the reply. We have Netapp SCSI disk storage. Could you please tell me how do I troubleshoot this so that I wont get such errors in future.

 

 

Thanks

Answer 3

Based on this and what you describe in your other post, you really ought to give Microsoft PSS a call.

Answer 4

Do read this kb before contacting PSS. You might be running on an unsupported device.

http://support.microsoft.com/kb/304261

 

Answer 5

I am having the same error, but am using SAN(DELL) with Mount Points (Win Server 64+Cluster+SQL 2005 Ent)? Any idea or suggestion to work around this problem?

 

thanks.