Post reply

sqlserver restarting automatically but it's in cluster not switching to passive

  • August 7, 2023 at 6:07 am

    #4254613

     

    1. in logs found this error and then sqlserver is restarting

      Trace ID '1' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the problem.

    sql server is restarting automatically but it is in cluster and not switching its roles to passive node and giving this error

    2 . Cluster resource 'SQL Server (DB01)' of type 'SQL Server' in clustered role 'SQL Server (DB01)' failed.

    Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.

    Thanks
    Naga.Rohitkumar

  • August 7, 2023 at 11:20 am

    #4254840

    If I understand correctly, there is some trace in progress.  It could be default trace, try to stop the trace or disable it after bringing the cluster offline. Also check and ensure that it has enough free hard disk space to recover successfully once it is online.

    =======================================================================

  • August 7, 2023 at 1:25 pm

    #4254938

    Are the SQL services set to automatically  start in SQL Configuration Manager?  That needs to be set to manual.  The cluster controls starting the SQL Services.

    And, the error message is telling you the issue. You are out of disk space.

    Execute this so you can find out the traces and the drives the files reside on:

    SELECT * FROM sys.traces

    I suspect that there may be some large log files, or memory dumps that are filling that drive.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • August 7, 2023 at 3:35 pm

    #4255042

    C2 level audit level trace is enabled , due to which .trc files is generating huge on daily basis

    it is reaching more than 80 gb , so we concluded to disable it and after next restart of sqlserver services

    we need check the log file is still generating for time being we have added 200 gb on both nodes.

    Thanks
    Naga.Rohitkumar

  • August 7, 2023 at 3:36 pm

    #4255043

    sql server drives have enough space and also we are trying to resolve tempdb issues to make sure disk wont increase due to tempdb growth.

    Thanks
    Naga.Rohitkumar

  • November 28, 2023 at 2:58 pm

    #4336029

    Please read on temptdb database contention.

    https://www.sqlshack.com/sql-server-tempdb-database-and-latch-contention/

     

    DBASupport

Viewing 6 posts - 1 through 5 (of 5 total)

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