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

  • 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

     

     

    Wednesday, May 23, 2007 9:55 PM

All replies

  • 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?
    Wednesday, May 23, 2007 10:49 PM
  • 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

    Thursday, May 24, 2007 1:43 PM
  • Based on this and what you describe in your other post, you really ought to give Microsoft PSS a call.
    Thursday, May 24, 2007 7:19 PM
  • Do read this kb before contacting PSS. You might be running on an unsupported device.

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

     

    Friday, May 25, 2007 8:00 AM
  • 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.

     

    Saturday, September 6, 2008 4:12 PM