BUG: Query Against Sysprocesses May Fail with Message 1105

ID: Q198030

The information in this article applies to:
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          : kbbug7.00 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 21, 1999