BUG: ALTER DB Hangs When DUMP DB Performed Simultaneously

ID: Q224146


The information in this article applies to:

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 version 6.5.

Additional query words:


Keywords          : kbSQLServ650 kbSQLServ650bug 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 30, 1999