Red Gate forums :: View topic - 2.3.0.334 Error: Blocked Process stays Active if "Unknown"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

2.3.0.334 Error: Blocked Process stays Active if "Unknown"

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 509
Location: Costa Mesa, CA, USA

PostPosted: Mon Oct 24, 2011 6:42 pm    Post subject: 2.3.0.334 Error: Blocked Process stays Active if "Unknown" Reply with quote

Code:
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?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Wed Nov 02, 2011 5:14 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 509
Location: Costa Mesa, CA, USA

PostPosted: Wed Nov 02, 2011 5:26 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group