RML Utilities: ReadTrace may encounter assertion building the partial aggregates

  • Article

Summary

In rare circumstances ReadTrace may encounter the following SQL Server 2008 assertion error when attempting to execute a parallel query.

11/03/08 00:05:35.139 [0X00003B94] Dumping error record 1 of 2:
11/03/08 00:05:35.139 [0X00003B94] --------------------------------------------------------------------------
11/03/08 00:05:35.144 [0X00003B94]    Description       = A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
11/03/08 00:05:35.206 [0X00003B94]    Source            = Microsoft SQL Server Native Client 10.0
11/03/08 00:05:35.210 [0X00003B94]    ERRORINFO.hrError = 0x80004005
11/03/08 00:05:35.215 [0X00003B94]    ERRORINFO.dwMinor = 3624
11/03/08 00:05:35.219 [0X00003B94]    ERRORINFO.clsid   = {8F4A6B68-4F36-4E3C-BE81-BC7CA4E9C45C}
11/03/08 00:05:35.224 [0X00003B94]    SQL State         = HY000
11/03/08 00:05:35.228 [0X00003B94]    Native Error      = 3624
11/03/08 00:05:35.233 [0X00003B94]
11/03/08 00:05:35.237 [0X00003B94] Dumping error record 2 of 2:
11/03/08 00:05:35.242 [0X00003B94] --------------------------------------------------------------------------
11/03/08 00:05:35.247 [0X00003B94]    Description       = Location:      xbmp.cpp:2038
Expression:      0 != pxteBitmap

Check the SQL Server error log for additional details.

Workaround

Alter the SQL Server's sp_configure 'max degree or parallism' value and set to the value of 1 to disable parallel plan generation.

Additional References

This issue has been reproduced and filed with the SQL Server development team and is currently under review.

SQL Server Defect #254853

Bob Dorr
SQL Server Principal Escalation Engineer