BUG: ALTER DB Hangs When DUMP DB Performed Simultaneously (224146)



The information in this article applies to:

  • Microsoft SQL Server 6.5

This article was previously published under Q224146
BUG #: 18672 (SQLBUG_65)

SYMPTOMS

When a database is altered and dumped at the same time, the ALTER database statement hangs and the errorlog contains the following message:
DPDB_FINDMAP : unable to find the OOS_MAP for page <page #>
The dump database completes without errors.

In addition, after canceling the ALTER database statement, the following error is written to the errorlog:
bufdiscard: WARNING, page 0x1100 (dbid 7, bp 0x1269560, obj 0x63, indid 0, plevel 0) has stat0x400/0, bkeep=0 (), skipping

WORKAROUND

Make sure that the alter database has completed before attempting to dump the database.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB224146