I/O error 170(The requested resource is in use.)

  • Laerte Poltronieri Junior-367636

    Hall of Fame

    Points: 3311

    Hi all

    I have some problems with one environment..

    It was a virtual cluster active/passive with 2 virtual nodes and virtual disk in procution and onde node is offline(i know te very inadvisable but ....)

    Yesterday i see this error in SQLERRORLOG

    DESCRIPTION: Error: 823, Severity: 24, State: 2

    I/O error 170(The requested resource is in use.) detected during read at offset 0x00000017420000 in file 'S:\Microsoft SQL Server\MSSQL\Data\XXXXXX_Data.MDF'.

    I think in a first moment is anti virus .i think it was try to read de mdf so I suggest disabling it.

    But searching in web i think some articles about error cluster.

    is this happening one failover ? and because th other node is offline this message shows up ? or can be another problem....i really think it was related to resources in cluster but i dont know where i begin to search

    Thanks all

    $hell your Experience !!![/url]

  • Vee

    Hall of Fame

    Points: 3028

    This link may be helpful for you.

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

  • Laerte Poltronieri Junior-367636

    Hall of Fame

    Points: 3311

    Thanks Vee i´ll see, but i still think is related to antivirus....

    $hell your Experience !!![/url]

  • hemanth.damecharla

    SSCommitted

    Points: 1740

    Laerte POltronieri Junior (12/24/2008)


    Hi all

    I have some problems with one environment..

    It was a virtual cluster active/passive with 2 virtual nodes and virtual disk in procution and onde node is offline(i know te very inadvisable but ....)

    Yesterday i see this error in SQLERRORLOG

    DESCRIPTION: Error: 823, Severity: 24, State: 2

    I/O error 170(The requested resource is in use.) detected during read at offset 0x00000017420000 in file 'S:\Microsoft SQL Server\MSSQL\Data\XXXXXX_Data.MDF'.

    I think in a first moment is anti virus .i think it was try to read de mdf so I suggest disabling it.

    But searching in web i think some articles about error cluster.

    is this happening one failover ? and because th other node is offline this message shows up ? or can be another problem....i really think it was related to resources in cluster but i dont know where i begin to search

    Thanks all

    [font="Verdana"]We have had a similar problem with one of our clusters.

    Let's just take the error message and start from there:

    If you receive 823 error message, it might indicate that Microsoft SQL Server 2000 has detected hardware or system problems when it was reading from or writing to database files and could lead database to inconsistent state. Data Corruption could occur if Write Caching is enabled without Battery Backups on server. For more information on 823 error messages, please refer >> http://support.microsoft.com/kb/828339.

    Now, I/O error 170 (requested resource is in use): For this, if you feel that the mdf file is in use; download handle >>http://technet.microsoft.com/en-us/sysinternals/bb896655.aspx and search for handles on the mdf. You, can do this in one of two ways:

    1. Handle -U [partial filename or search pattern] -> Shows the owning user name when searching for handles. ex: Handle -U dbname.mdf

    2. Handle -P [partial Process name or search pattern]-> Instead of examining all the handles in the system, this parameter narrows Handle's scan to those processes that begin with the name process. Thus: handle -p explorer

    If you find that it is the aniti-virus; that is one holding the resources then:

    1. Make sure that all the folders that SQl Server uses are in the Antivirus's exclusion list.

    2. Make sure that antivirus, does not scan any of the cluster resources.

    For more information, refer to the following KB articles:

    Article1:

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

    Here is a quote from the above KB article:

    Antivirus software may cause problems with Cluster services, including issues with failing over resources such as physical disks.

    Article2:

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

    Hope This Helps 🙂

    Regards,

    [/font]

    -Hope is a heuristic search :smooooth: ~Hemanth
  • Laerte Poltronieri Junior-367636

    Hall of Fame

    Points: 3311

    Thanks a lot. that is what i ´m looking for

    $hell your Experience !!![/url]

  • Tim-153783

    Default port

    Points: 1407

    I too have gotten this error 

    I/O error 170(The requested resource is in use.
    For what it is worth, in our environment, we take native backups to a fileshare on a cluster
    using Ola Hallengren's maintenance solution.  Sometimes the cluster seems
    to stop accepting connections causing backups to fail spewing out this message. 
    If we fail the share over to the other node, the backups succeed.  

  • as0917041

    SSC Enthusiast

    Points: 127

    Hi, 

    This usually happens due to some of the reasons: if there is a problem in hardware or if there is filter driver intervention in the IO process. In order to fix it read more: https://blogs.msdn.microsoft.com/sqlblog/2006/09/17/sql-io-error-message-and-its-resolution/
                                       http://www.databasefilerecovery.com/ms-sql-database-recovery.html

    Thanks

  • Johnson Welch

    SSCoach

    Points: 18748

    The error occurs due to many reasons like defects in hardware, virus attack, or re-installation in SQL Server. You can run DBCC CHECKDB to determine the cause of the error. This will help you out:
    https://www.sqlrecoverytool.com/fix-sql-server-fatal-error-823.html

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply