Microsoft KB Archive/198030

= BUG: Query Against Sysprocesses May Fail with Message 1105 =

Article ID: 198030

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q198030



BUG #: 52768 (SQLBUG_70)



SYMPTOMS
A stress of multiple clients that are all querying sysprocesses with random aborts results in the following error in the error log:

Error: 1105, Severity: 17, State: 3

Could not allocate space for object '(SYSTEM table id: -631257169)' in

database 'tempdb' because the 'DEFAULT' filegroup is full.

The error 1105 occurs even though tempdb is set for autogrow and plenty of disk space exists. The error 1105 is "transient" because it is not a true indication of the actual amount of space available in tempdb.

You may also see the following message in the error log as well:

Ec Iterator cleaned up a reference

This message is benign and can be ignored.



WORKAROUND
To work around this problem, reduce the amount and frequency of concurrent queries against the sysprocesses table.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: errorlog

Keywords: kbbug kbpending KB198030

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.