January 30, 2003 at 6:23 am
Since we put on the latest Security Patch (about 5 months ago)we started getting corruption in the msdb database on an instance of our production server. Seems to consistanly happen on an index on the log_shipping_history table. Also, we are seeing Failed Assertion = 'm_len !=0'. We went to Microsoft with the problem and they said it was hardware. It is now in the hands of HP and they are recreating our environment. We backed off the Security Patch and sent them all our databases so they could load our stuff on their servers then apply an I/O stress tool to see what happens. We have been troubleshooting this issue for about 5 months and have not made a lot of progress. Just wondered if anyone else out there has seen this error or had similar issues after applying the latest Security Patch. We have nothing else but NetIQ running on the SQL server.
February 3, 2003 at 12:00 pm
This was removed by the editor as SPAM
February 3, 2003 at 12:51 pm
Considered formatting and reinstalling everything?
Andy
February 3, 2003 at 2:41 pm
Not sure if it helps or if it's related, but have you seen this article
http://support.microsoft.com/default.aspx?scid=KB;en-us;q281346
When a dynamic cursor fetch is run under a profiler this problem usually yields the following assertion:
0x77f97ac6 Module(ntdll+17ac6) (NtGetContextThread+b)
0x00784f83 Module(sqlservr+384f83) (utassert_fail+19f)
0x0059792a Module(sqlservr+19792a) (Scan_rid::GetLogicalRid+22)
0x00597bf2 Module(sqlservr+197bf2) (MatchUserSargsToIndex+85)
0x00405cc8 Module(sqlservr+5cc8) (startscan+276)
0x006c0456 Module(sqlservr+2c0456) (RowsetSS::GotoMarker+a8)
0x006c0a79 Module(sqlservr+2c0a79) (RowsetMarker::GotoMarker+11)
0x0065e24f Module(sqlservr+25e24f) (CQScanRange::GotoMarker+b4)
0x006572e0 Module(sqlservr+2572e0) (CQScanFilter::GotoMarker+19)
0x0065cbbd Module(sqlservr+25cbbd) (CQScanNLJoin::GotoMarker+2b9)
0x006572e0 Module(sqlservr+2572e0) (CQScanFilter::GotoMarker+19)
0x00652da0 Module(sqlservr+252da0) (CQueryScan::GotoMarker+23)
0x005d8c41 Module(sqlservr+1d8c41) (CCursorDynaQueryScan::GotoMarker+67)
0x005d7c0f Module(sqlservr+1d7c0f) (CFetchDynamic::Fetch+2e8)
0x005c5ac0 Module(sqlservr+1c5ac0) (CCursor::Fetch+23d)
0x005c39ba Module(sqlservr+1c39ba) (CCursorFetchStmt::XretExecute+10b)
0x004145f1 Module(sqlservr+145f1) (CMsqlExecContext::ExecuteStmts+11a)
0x0041409f Module(sqlservr+1409f) (CMsqlExecContext::Execute+16a)
2000-11-13 17:51:16.48 kernel SQL Server Assertion: File: (scanrid.cpp), line=315
Failed Assertion = 'm_len != 0'.
2000-11-13 17:51:16.54 spid19 Error: 3624, Severity: 20, State: 1.
John Zacharkan
Edited by - zach_john on 02/03/2003 2:42:51 PM
John Zacharkan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply