August 13, 2001 at 2:26 am
I have been getting these EXCEPTIONN_ACCESS
_VIOLATION errors quite regulary. i have tried several things to resolve but with no avail. i.e changing locks etc. below is the stack dump. i would be grateful if anyone could help me debug this error.
2001/08/10 18:26:17.71 spid309 EXCEPTION_ACCESS_VIOLATION raised, attempting to create symptom dump
2001/08/10 18:26:17.73 spid309 Initializing symptom dump and stack dump facilities
2001/08/10 18:26:23.24 spid309 ***BEGIN STACK TRACE***
2001/08/10 18:26:23.28 spid309 0x004C85CD in SQLSERVR.EXE, bufrunlock_15626312Filter_420er () + 0x346D
2001/08/10 18:26:23.29 spid309 0x0048ADE6 in SQLSERVR.EXE, getcurrentcmd_33102Filter_420er () + 0x0016
2001/08/10 18:26:23.32 spid309 0x00406367 in SQLSERVR.EXE, getcurrentcmd_36062Filter_420er () + 0x02C7
2001/08/10 18:26:23.35 spid309 0x0040681F in SQLSERVR.EXE, tablelockwait () + 0x0C3F
2001/08/10 18:26:23.35 spid309 0x004EF683 in SQLSERVR.EXE, procwrite () + 0x0113
2001/08/10 18:26:23.37 spid309 0x00572D7E in SQLSERVR.EXE, proccreate () + 0x07AE
2001/08/10 18:26:23.39 spid309 0x005222E2 in SQLSERVR.EXE, s_normalize_134492_80ns_20820er () + 0x0012
2001/08/10 18:26:23.40 spid309 0x00469AD4 in SQLSERVR.EXE, sequencer_13442692_80ns_20820er () + 0x00E4
2001/08/10 18:26:23.42 spid309 0x0042BA5A in SQLSERVR.EXE, language_exec () + 0x011A
2001/08/10 18:26:23.42 spid309 0x0025134D in opends60.dll, srv_post_handle () + 0x0000
2001/08/10 18:26:23.42 spid309 0x002508BB in opends60.dll, srv_post_handle () + 0x0000
2001/08/10 18:26:23.42 spid309 0x00241569 in opends60.dll, Ordinal65 () + 0x0000
2001/08/10 18:26:23.42 spid309 0x00241384 in opends60.dll, Ordinal65 () + 0x0000
2001/08/10 18:26:23.42 spid309 0x10219D84 in MSVCRT40.dll
2001/08/10 18:26:23.42 spid309 0x77F04F3E in KERNEL32.dll, lstrcmpiW () + 0x0000
2001/08/10 18:26:23.42 spid309 ***END STACK TRACE***
August 13, 2001 at 2:28 am
This relates to last MSG. I am Using SQL 6.5 with the latest service pack.
August 13, 2001 at 10:50 am
You will likely have to call MS for support. Have any changes, anything at all, even not SQL related been made to this server? When was the SP applied?
Steve Jones
August 13, 2001 at 3:30 pm
The SP has been on the machine for over a year. i have been chaging some settings memory locks etc as well as creating indexes and defraging existing indexes. the changes to the config were made three weeks before getiing these errors. i have tried changibg the locks and thresholds but these donot seem to have worked. the last thing i did was create the indexes with 80% fill factor which leads me to think possibly a bad sector on disk.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply