Exception: capacity was less than the current size

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Exception: capacity was less than the current size

Postby PDinCA » Thu Aug 19, 2010 11:45 pm

Build: 1.3.0.58
Client: Windows 7 Ultimate
Server: 2003 32-bit
DB: 2008 SP1

What: Viewed a deadlock. Clicked the next exception, which is a "Long running query" and the exception below occurs.

When: Every time I click on it.

SQL Response 1.3 has encountered a problem and needs to close.
If you were in the middle of something, the information you were working on may be lost.

Technical details:

capacity was less than the current size.
Parameter name: capacity

ArgumentOutOfRangeException

at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.Collections.Generic.List`1..ctor(Int32 capacity)
at k.a.<>c__DisplayClass1.<RequestData>b__0(Object )
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

AlertRepositoryLogFile:
For the time I tried to view the Alert:
15:31:48.557|Info |AlertRepository |36 |Begining old data cleanup.
15:31:48.557|Info |AlertRepository |36 |Cleaning old data
15:32:12.837|Info |AlertRepository |36 |Old data clean complete
15:32:12.837|Info |AlertRepository |36 |Checking for deleted servers
15:32:12.837|Info |AlertRepository |36 |Deleted servers checked
15:32:12.837|Info |AlertRepository |36 |Checking for old files
15:32:12.915|Info |AlertRepository |36 |Old files checked
PDinCA
 
Posts: 517
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby Anu Deshpande » Mon Aug 23, 2010 10:59 am

Many thanks for your post and apologies for the inconvenience caused.

Let us know if this happens for all the alerts on that server? Does the behaviour changes for the other SQL Server added (if any)?

Have you tried restarting the Alert Repository service? Kindly let me know if this makes any difference.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby PDinCA » Mon Aug 23, 2010 6:14 pm

Of the 3 alert categories, this is the only one that causes the problem.

Alert Service restarted. UI bombs.
PDinCA
 
Posts: 517
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests