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