none
SQLServerLogMgr::LogWriter: Operating system error 170(The requested resource is in use.) RRS feed

  • Question

  • Hello Experts,

            We have SQL Server 2012 on Windows server 2012 Failover cluster(VM).  Few days back we have installed Anti virus on Cluster nodes and got the error SQLServerLogMgr::LogWriter: Operating system error 170(The requested resource is in use.) Later we removed antivirus on both nodes. After couple of days again we started getting the same error and sql services are goes to stopped state. And if i perform failover then sql services are starting . Then after couple of hours later again it went to stopped state with the same error. This happened quite frequently in Node2 but on Node 1 it is happening very rarely.  Both nodes has different service packs and Windows CU.

    Initially we thought it could be AV and now we completely removed still we are facing the same issue. 

    Please help me to solve this nightmare issue.  



    system error log

    1:20:30 am

    BackupIoRequest::ReportIoError: write failure on backup device 'G:\Backup\Dif_bkp\SCMDB_backup_2019_08_14_010128_7899718.bak'. Operating system error 170(The requested resource is in use.).

    1:20:30 am

    SQLServerLogMgr::LogWriter: Operating system error 170(The requested resource is in use.) encountered.

    1:20:30 am 

    The log for database 'msdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

    1:20:30 am 

    The system failed to flush data to the transaction log. Corruption may occur in VolumeId: G:, DeviceName: \Device\HarddiskVolume5.
    ({Device Busy}
    The device is currently busy.)

    1:20:31 am 

    The system failed to flush data to the transaction log. Corruption may occur in VolumeId: H:, DeviceName: \Device\HarddiskVolume3.
    ({Device Busy}
    The device is currently busy.)

    SQL Server Errorlog- 

    Date,Source,Severity,Message
    08/14/2019 07:21:10,spid6s,Unknown,SQL Server shutdown has been initiated
    08/14/2019 07:21:10,spid6s,Unknown,Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup<c/> repair it<c/> or rebuild it. For more information about how to rebuild the master database<c/> see SQL Server Books Online.
    08/14/2019 07:21:10,spid6s,Unknown,Operating system error 170(The requested resource is in use.) on file "H:\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf" during FixupLogTail.
    08/14/2019 07:21:10,spid6s,Unknown,Error: 5159<c/> Severity: 24<c/> State: 13.
    08/14/2019 07:21:10,spid6s,Unknown,SQLServerLogMgr::FixupLogTail: Operating system error 170(The requested resource is in use.) encountered.
    08/14/2019 07:21:10,spid6s,Unknown,Error: 17053<c/> Severity: 16<c/> State: 1.
    08/14/2019 07:21:10,spid6s,Unknown,fcb status 0x42<c/> handle 0x00000000000007A8<c/> size 224 pages
    08/14/2019 07:21:10,spid6s,Unknown,blankSize 0x3c0000<c/> blkOffset 0x11a<c/> fileSeqNo 884<c/> totBytesWritten 0x0
    08/14/2019 07:21:10,spid6s,Unknown,SQLServerLogMgr::FixupLogTail (failure): alignBuf 0x000000001163E000<c/> writeSize 0xc00<c/> filePos 0x63400
    08/14/2019 07:21:10,spid6s,Unknown,374 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
    08/14/2019 07:21:10,spid6s,Unknown,Starting up database 'master'.
    08/14/2019 07:21:10,Server,Unknown,Software Usage Metrics is disabled.
    08/14/2019 07:21:10,Server,Unknown,CLR version v4.0.30319 loaded.
    08/14/2019 07:21:10,Server,Unknown,Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
    08/14/2019 07:21:10,Server,Unknown,Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    08/14/2019 07:21:10,Server,Unknown,Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    08/14/2019 07:21:10,Server,Unknown,This instance of SQL Server last reported using a process ID of 11160 at 8/14/2019 7:21:08 AM (local) 8/14/2019 3:21:08 AM (UTC). This is an informational message only; no user action is required.
    08/14/2019 07:21:09,Server,Unknown,Using conventional memory in the memory manager.
    08/14/2019 07:21:09,Server,Unknown,Detected 49151 MB of RAM. This is an informational message; no user action is required.
    08/14/2019 07:21:09,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    08/14/2019 07:21:09,Server,Unknown,SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket<c/> 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    08/14/2019 07:21:09,Server,Unknown,Command Line Startup Parameters:<nl/> -s "MSSQLSERVER"
    08/14/2019 07:21:09,Server,Unknown,Registry startup parameters: <nl/> -d H:\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e H:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l H:\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    08/14/2019 07:21:09,Server,Unknown,The service account is 'account\sqlservice'. This is an informational message; no user action is required.
    08/14/2019 07:21:09,Server,Unknown,Logging SQL Server messages in file 'H:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    08/14/2019 07:21:09,Server,Unknown,Authentication mode is MIXED.
    08/14/2019 07:21:09,Server,Unknown,System Manufacturer: 'VMware<c/> Inc.'<c/> System Model: 'VMware Virtual Platform'.
    08/14/2019 07:21:09,Server,Unknown,Server process ID is 5280.
    08/14/2019 07:21:09,Server,Unknown,All rights reserved.
    08/14/2019 07:21:09,Server,Unknown,(c) Microsoft Corporation.
    08/14/2019 07:21:09,Server,Unknown,Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64) <nl/> Aug 15 2017 10:23:29 <nl/> Copyright (c) Microsoft Corporation<nl/> Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)



    Thank you

    Sai Nadh
    Wednesday, August 14, 2019 10:12 AM

All replies