Msg 8624 with Server Running Low on Memory
I attach the SQL Server error log for a development server. As you will see there is a serious stack dump.
Please pass this on to your product team.
The scenario in which it occurred was that there was a large (60GB) database on the server, which wasn't being used.
Queries started displaying the following error:
Msg 8624, Level 16, State 1, Line 1
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.
As soon as I took the large database Offline, the above error didn't occur but the query didn't complete.
This is the query:
insert changedprofile (userprofileid)
select userprofileid from userprofile
where userprofileid not in (select userprofileid from changedprofile)
Both of the tables concerned had less than 5 rows and all datatypes were conventional (non-clr).
Upvotes: 1<=-=Mar 3 2006 9:00AM=-=>
Thank you for reporting this issue. Is this issue reproducible at will by taking the database back online? If yes, will you please let us how the best way to get in contact with you, so that we can collect all the necessary information to understand and resolve the problem? Also, it would be helpful if you could attach one of the dumps that were generated to the bug.<=-=Mar 13 2006 3:08PM=-=>
Unfortunately we were unable to reproduce the issue based on the information provided. Please see the previous response to this bug.<=-=Jul 6 2012 1:19AM=-=>
I no longer have access to this system, so I cannot provide you with any further info.