2.3.0.334 Error: Blocked Process stays Active if "Unknown"

PDinCAPDinCA Posts: 642 Silver 1
edited November 2, 2011 12:26PM in SQL Monitor Previous Versions
Blocked process: SQBCoreService.exe 
Process ID: 152 
Database: xcp_trans 
Host: 307997-DB1 
User: IAD\935960-sqlsvc 
Start time: 12:08 AM 
SQL fragment: BACKUP LOG [xcp_trans] TO VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC3', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC301', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC302', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC303', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC304', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC305', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC306' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (xcp_trans), 10/22/2011 12:08:02 AM', DESCRIPTION = N'Backup on 10/22/2011 12:08:02 AM Server: 308187-SQLCLUS Database: xcp_trans', FORMAT 

Blocking process: Unknown 
Process ID: 13 
Database:  
Host:  
User: Unknown 
Start time: 3:07 AM 
SQL fragment: Unknown
This is 12:08 on 10/22/2011 and it is STILL ACTIVE! The Backup definitely ended successfully or I'd be in deep trouble.

Seems that when SQL Monitor has an "Unknown" blocker, it can't determine when the Alert should be "Ended".

The problem is that every Blocked Process alert I have is still "Active". I had one that started this issue over four days ago.

How do I get back to normal - i.e. show "Ended", please?
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...

Comments

  • Hi,

    Thanks for reporting this issue.

    We are tracking this as SRP-5034. Restarting the SQL Server service should end these alerts. But if this is not possible, then you can clear them. There is no manual way to force an alert to end.

    Regards,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
  • PDinCAPDinCA Posts: 642 Silver 1
    As this is on the Production cluster, running a 24x7 app, we'll wait until the regular monthly maintenance failover.

    Thanks for opening the case.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
Sign In or Register to comment.