Failed Assertion Error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Failed Assertion Error

One of my database was marked "suspect". The error log gave me this error : 2003-10-22 03:09:30.20 spid61 SQL Server Assertion: File: <S:sql
tdbmsstorengdrsinclude
ecord.inl>, line=1447
Failed Assertion = ‘m_SizeRec > 0 && m_SizeRec <= MAXDATAROW’. 2003-10-22 03:09:30.27 spid61 Error: 3624, Severity: 20, State: 1.
2003-10-22 03:09:30.34 spid61 Using ‘dbghelp.dll’ version ‘4.0.5’
*Dump thread – spid = 61, PSS = 0x1b1216a0, EC = 0x1b1219b0
*Stack Dump being sent to e:MSSQLlogSQL00009.dmp Did anybody experienced this type of error ?
Thanks
Cristian
What is the version of SQL & Service pack.
And what time this particular error has been raised, check the dmp file for more information. Refer to this posthttp://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=4702 for information.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Hi Satya,
I check the link mentioned but they didn’t find what caused the error. I have SP2 on SQL Server 2000. Do you think the SP3 will fix this one ? This was the command at the time of the error : * Input Buffer 239 bytes –
* update TICKET33_AUDIT set Delivery_datetime = "10/22/03 03:09:11:045",
* Delivery_count = 1, Produce_report = 0, Full_delivery_datetime = "10/22/
* 03 03:09:11:045", Update_date = "10/22/03 03:09:11:045" where Ticket_key
* = "200310225009880027" And this is some other information : PSS @0x1B1216A0
—————
pspid = 61 m_dwLoginFlags = 0x00b0 plsid = 426467432
pbackground = 0 pbSid
—–
13ffff73 ffffff11 ffff0002 ffffffff a
sSecFlags = 0x2
pdeadlockpri = 0 poffsets = 0x0 pss_stats = 0x0
ptickcount = 825671109 pcputickcount = 579257086933602
ploginstamp = 5893 ptimestamp = 2003-10-22 03:06:19.950
prowcount = 0 plangid = 0 pdateformat = 1
pdatefirst = 7 Language = us_english UserName = aplanash
poptions = 0x400000 poptions2 = 0x20000 pline = 1
pcurstepno = 2 prowcount = 0 pstatlist = 0
pcurcmd = 197 pseqstat = 0 ptextsize = 4096
pretstat = 0 pslastbatchstarttime = 2003-10-22 03:09:11.060
pmemusage = 156 hLicense = 0 tpFlags = 0x1
isolation_level = 0 fips_flag = 0x0 sSaveSecFlags = 0x0
psavedb = 0 pfetchstat = 0 pcrsrows = 0
pslastbatchtime = 2003-10-22 03:09:11.060 pubexecdb = 0
fInReplicatedProcExec = 0 pMsqlXact = 0x1B121E78 presSemCount = [0]454171056
presSemCount = [0]454171056 pcputot = 622
pcputotstart = 622 pcpucmdstart = 622 pbufread = 459
pbufreadstart = 452 plogbufread = 15184 plogbufreadstart = 15048
pbufwrite = 84 pbufwritestart = 79 pLockTimeout = 4294967295
pUtilResultSet = 0x00000000 Do you see anything relevant to the problem ? Thanks for your help
Cristian
For such failed assertion errors its always recommended to apply latest service packs.
Check README.HTMl for SP3a and see whether its addressed or not, in general I would recommend to apply latest service pack. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

I am having the same type of error.. I have SQL SP3 on Windows Server 2003. I cannot find out what is going wrong.. Can anyone offer any more help? JS
MCP, MCAD.Net, MCSD.Net
The main reason for assertion errors could be hardware and due to bad data on the disk resulting the AV, run DBCC CHECKDB during low traffic hours in order to assess the data consistency. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
We installed SP3. Are SP3 and SP3a same thing or different? One more thing i noticed, Acttually this problem is in my client database and i wonder that the space available for the database is zero. Could it be the reason for the same. Lalit
Lalit Do not open similar (duplicate) discussion in various threads and for your issue continue underhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1916 thread. Note the points listed in this thread for assessment. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>