| Author |
Topic |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
 Posted - 2007-06-25 : 09:18:18
|
Anyone else seen this specific error message before:quote:
SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
google gets several hits for a different line number, and different type of lock.Environment: SQL 2005 Sp2a (3402), 64bit, clustered.We've had 3 of these today, in a 1h20 minnute period. Apparently, this first raised it's head last friday (3 on friday, 2 on Saturday).All the same line number. DBCC CheckDB to be run asap (getting approval as we type).*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-25 : 12:57:20
|
| Update: Still an issue.We failed over, ran DBCC Checkdb no_infomsgs - reported no problems.restarted SQL on passive node (previously active node that had erported the assertion failures)Then we had assertion failure on new active node.ran DBCC CHECKDB , and it also report 0 errors, 0 consistency errorsWe probably will raise support call if we can find anything on this...*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-25 : 22:23:54
|
| Checked with Microsoft? Maybe bug. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-26 : 10:05:07
|
| Opened a call with them. Fortunately, we don't have 'site/system down' ... but that also means that we are likely to have to wait a while for some resources. Today it has been LOTS worse - we've failed over again, had probably 30+ instances across both nodes...wondering whether we should dbcc checkdb master, etc. Those are going to be common on both servers*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-26 : 10:09:14
|
"wondering whether we should dbcc checkdb master"Can't do any harm can it? And shouldn't take long either ...  |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-26 : 10:15:54
|
| Got one of the others doing that as I type.... will update asap*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-26 : 10:48:51
|
| update:DBCC CheckDB on all other DBs on the server (1 user, and sytem dbs), report 0 errors.We've tried trapping the spids, as they assert, to see if we can find comment code, but with lag and re-use, this is problematic. Strange thing is the assertions do not appear to cause execution failures, so we are uncertain what impact this is having.*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-26 : 11:46:03
|
| We are being asked to apply hotfix Build 09.00.3159. This is not a cumulative hotfix - does that mean we should first got to 3156 (cumulative hot that this patch is based on)? As far as I understand it, a hotfix on addresses the specific issue, unless it explicitly states that it is a cumulative? Comments?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-26 : 13:44:06
|
| That's correct, but double check with Microsoft. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-27 : 08:10:41
|
| hmm - got the fix - a 'not for public consumption' cumulative ... hell of a lot of KB's rolled up in it. I'll let ytou know what happens after it goes in ... anyone in or around Hertfordshire, look for a small mushroom cloud :P*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-27 : 09:10:35
|
"anyone in or around Hertfordshire, look for a small mushroom cloud"You had one of those only a year or so back ... was that you then too? The news said it was an oil refinery that blew up, had they slapped a D-notice on your T-SQL?  |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-28 : 04:12:21
|
| hmm - that was just before I went up to the client site, so I am not taking responsibility for that one :P*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
SQL 2005 sp2a Assertion Failure