EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange

Hi,
I'm getting errors from SQL Server 2000 SP3 running under Windows Server
2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
give any errors. I've looked in the Knowledge Base for articles dealing
with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
me.
Here is part of what is showing up in the log:
SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 06/25/04 14:49:33 spid 55
*
* Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
Line 0+00000000) * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
E89C400A * Input Buffer 2342 bytes -
* select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
where f.brand_cd=rb.br * and_cd and market_cd in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
* 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
* MODULE BASE END SIZE * sqlservr
00400000 00B2CFFF 0072d000 * ntdll
77F40000 77FF9FFF 000ba000 * kernel32
77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
GDI32 77C00000 77C43FFF 00044000 * OPENDS60
41060000 41065FFF 00006000 * MSVCRT
77BA0000 77BF3FFF 00054000 * UMS
41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
00010000 * sqlevn70 41080000 41086FFF 00007000 *
NETAPI32 02C60000 02CB2FFF 00053000 * ole32
030D0000 031F3FFF 00124000 * XOLEHLP
03200000 03205FFF 00006000 * MSDTCPRX
03210000 03280FFF 00071000 * OLEAUT32 03290000
0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
00061000 * MTXCLU 03380000 03397FFF 00018000 *
VERSION 033A0000 033A7FFF 00008000 * WSOCK32
033B0000 033B8FFF 00009000 * WS2_32
033C0000 033D7FFF 00018000 * WS2HELP
033E0000 033E7FFF 00008000 * CLUSAPI 03430000
03440FFF 00011000 * RESUTILS 03450000 03461FFF
00012000 * USERENV 03470000 03529FFF 000ba000 *
MFC42u 03530000 03623FFF 000f4000 * secur32
036B0000 036C2FFF 00013000 * mswsock
036E0000 03722FFF 00043000 * DNSAPI
03730000 03756FFF 00027000 * winrnr 037A0000
037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
0002f000 * rasadhlp 03800000 03804FFF 00005000 *
SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
00C80000 00C94FFF 00015000 * security
044B0000 044B3FFF 00004000 * wshtcpip
04500000 04507FFF 00008000 * SSmsLPCn 04510000
04516FFF 00007000 * ntdsapi 04530000 04545FFF
00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
04AE0000 04BA5FFF 000c6000 * sqloledb
04BB0000 04C35FFF 00086000 * MSDART
04480000 044A8FFF 00029000 * COMCTL32 04C40000
04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
045B0000 045C7FFF 00018000 * comctl32
05550000 05635FFF 000e6000 * oledb32
059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
xpstar 03050000 03096FFF 00047000 * SQLRESLD
030A0000 030A6FFF 00007000 * SQLSVC
030B0000 030C6FFF 00017000 * ODBC32
05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
05CD0000 05CD8FFF 00009000 * odbcint
05EB0000 05EC6FFF 00017000 * NDDEAPI
05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
05FF5FFF 00006000 * xpstar 06000000 06008FFF
00009000 * dbghelp 06840000 068F4FFF 000b5000 *
* Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
00000004 000004F4 00000004 00000000 * Ecx: 00000033:
* Edx: 00000002:
* Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
00000000 3AE52998 * SegCs: 0000001B:
* EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
00000000 00C567A0 * SegSs: 00000023:
*
************************************************** *****************************
*
* Short Stack Dump
* 007F8A40 Module(sqlservr+003F8A40)
(RangeGenerator::GetNextRange+000003D0) * 00801CB1
Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
Module(kernel32+0000A990) (FlsSetValue+00000779)
If you don't find anything on KB, are up on sp and CHECKDB comes out clean, it is time for a case
with MS Support...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Glen K" <blah@.blah.com> wrote in message news:pan.2004.06.25.19.18.22.966869@.blah.com...
> Hi,
> I'm getting errors from SQL Server 2000 SP3 running under Windows Server
> 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
> give any errors. I've looked in the Knowledge Base for articles dealing
> with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
> me.
> Here is part of what is showing up in the log:
>
> SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
> ************************************************** *****************************
> *
> * BEGIN STACK DUMP:
> * 06/25/04 14:49:33 spid 55
> *
> * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
> Line 0+00000000) * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
> E89C400A * Input Buffer 2342 bytes -
> * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
> REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
> and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
> market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
> ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
> where f.brand_cd=rb.br * and_cd and market_cd in
> (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
> ,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
> ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
> * 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
> by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
> * MODULE BASE END SIZE * sqlservr
> 00400000 00B2CFFF 0072d000 * ntdll
> 77F40000 77FF9FFF 000ba000 * kernel32
> 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
> 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
> 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
> GDI32 77C00000 77C43FFF 00044000 * OPENDS60
> 41060000 41065FFF 00006000 * MSVCRT
> 77BA0000 77BF3FFF 00054000 * UMS
> 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
> 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
> 00010000 * sqlevn70 41080000 41086FFF 00007000 *
> NETAPI32 02C60000 02CB2FFF 00053000 * ole32
> 030D0000 031F3FFF 00124000 * XOLEHLP
> 03200000 03205FFF 00006000 * MSDTCPRX
> 03210000 03280FFF 00071000 * OLEAUT32 03290000
> 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
> 00061000 * MTXCLU 03380000 03397FFF 00018000 *
> VERSION 033A0000 033A7FFF 00008000 * WSOCK32
> 033B0000 033B8FFF 00009000 * WS2_32
> 033C0000 033D7FFF 00018000 * WS2HELP
> 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
> 03440FFF 00011000 * RESUTILS 03450000 03461FFF
> 00012000 * USERENV 03470000 03529FFF 000ba000 *
> MFC42u 03530000 03623FFF 000f4000 * secur32
> 036B0000 036C2FFF 00013000 * mswsock
> 036E0000 03722FFF 00043000 * DNSAPI
> 03730000 03756FFF 00027000 * winrnr 037A0000
> 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
> 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
> SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
> 00C80000 00C94FFF 00015000 * security
> 044B0000 044B3FFF 00004000 * wshtcpip
> 04500000 04507FFF 00008000 * SSmsLPCn 04510000
> 04516FFF 00007000 * ntdsapi 04530000 04545FFF
> 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
> CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
> 04AE0000 04BA5FFF 000c6000 * sqloledb
> 04BB0000 04C35FFF 00086000 * MSDART
> 04480000 044A8FFF 00029000 * COMCTL32 04C40000
> 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
> 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
> SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
> 045B0000 045C7FFF 00018000 * comctl32
> 05550000 05635FFF 000e6000 * oledb32
> 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
> 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
> 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
> xpstar 03050000 03096FFF 00047000 * SQLRESLD
> 030A0000 030A6FFF 00007000 * SQLSVC
> 030B0000 030C6FFF 00017000 * ODBC32
> 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
> 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
> 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
> WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
> 05CD0000 05CD8FFF 00009000 * odbcint
> 05EB0000 05EC6FFF 00017000 * NDDEAPI
> 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
> 05FF5FFF 00006000 * xpstar 06000000 06008FFF
> 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
> * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
> 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
> 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
> 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
> 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
> * Edx: 00000002:
> * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
> C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
> 00000000 3AE52998 * SegCs: 0000001B:
> * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
> 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
> 00000000 00C567A0 * SegSs: 00000023:
> *
> ************************************************** *****************************
> *
> ----
> * Short Stack Dump
> * 007F8A40 Module(sqlservr+003F8A40)
> (RangeGenerator::GetNextRange+000003D0) * 00801CB1
> Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
> Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
> 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
> 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
> 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
> 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
> 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
> Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
> Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
> Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
> Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
> Module(kernel32+0000A990) (FlsSetValue+00000779)
|||Hi Glen,
Thanks for Tibor's suggestion. Looking at the nature of this issue, it
would require intensive troubleshooting which would be done quickly and
effectively with direct assistance from a Microsoft Support Professional
through Microsoft Product Support Services. You can contact Microsoft
Product Support directly by choosing one of the options listed at
http://support.microsoft.com/default...=sz;en-us;top.
If this is not an urgent issue and you would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address) mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Sincerely yours,
Bill Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
| From: Glen K <blah@.blah.com>
| Subject: EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange
| User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing
moment of clarity.)
| Message-ID: <pan.2004.06.25.19.18.22.966869@.blah.com>
| Newsgroups: microsoft.public.sqlserver.server
| MIME-Version: 1.0
| Content-Type: text/plain; charset=ISO-2022-jp
| Content-Transfer-Encoding: 8bit
| Lines: 124
| Date: Fri, 25 Jun 2004 19:18:22 GMT
| NNTP-Posting-Host: 67.86.129.2
| X-Complaints-To: abuse@.cv.net
| X-Trace: news4.srv.hcvlny.cv.net 1088191102 67.86.129.2 (Fri, 25 Jun 2004
15:18:22 EDT)
| NNTP-Posting-Date: Fri, 25 Jun 2004 15:18:22 EDT
| Organization: Optimum Online
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.gigan ews.com!f
eed5.newsreader.com!newsreader.com!news3.optonline .net!news4.srv.hcvlny.cv.n
et.POSTED!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:347783
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
| I'm getting errors from SQL Server 2000 SP3 running under Windows Server
| 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
| give any errors. I've looked in the Knowledge Base for articles dealing
| with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
| me.
|
| Here is part of what is showing up in the log:
|
|
|
| SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
| EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
|
************************************************** **************************
***
| *
| * BEGIN STACK DUMP:
| * 06/25/04 14:49:33 spid 55
| *
| * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
| Line 0+00000000) * Exception Code = c0000005
| EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
| E89C400A * Input Buffer 2342 bytes -
| * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
| REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
| and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
| market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
| ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
| where f.brand_cd=rb.br * and_cd and market_cd in
| (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
| ,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
| ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
| * 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
| by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
| * MODULE BASE END SIZE * sqlservr
| 00400000 00B2CFFF 0072d000 * ntdll
| 77F40000 77FF9FFF 000ba000 * kernel32
| 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
| 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
| 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
| GDI32 77C00000 77C43FFF 00044000 * OPENDS60
| 41060000 41065FFF 00006000 * MSVCRT
| 77BA0000 77BF3FFF 00054000 * UMS
| 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
| 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
| 00010000 * sqlevn70 41080000 41086FFF 00007000 *
| NETAPI32 02C60000 02CB2FFF 00053000 * ole32
| 030D0000 031F3FFF 00124000 * XOLEHLP
| 03200000 03205FFF 00006000 * MSDTCPRX
| 03210000 03280FFF 00071000 * OLEAUT32 03290000
| 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
| 00061000 * MTXCLU 03380000 03397FFF 00018000 *
| VERSION 033A0000 033A7FFF 00008000 * WSOCK32
| 033B0000 033B8FFF 00009000 * WS2_32
| 033C0000 033D7FFF 00018000 * WS2HELP
| 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
| 03440FFF 00011000 * RESUTILS 03450000 03461FFF
| 00012000 * USERENV 03470000 03529FFF 000ba000 *
| MFC42u 03530000 03623FFF 000f4000 * secur32
| 036B0000 036C2FFF 00013000 * mswsock
| 036E0000 03722FFF 00043000 * DNSAPI
| 03730000 03756FFF 00027000 * winrnr 037A0000
| 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
| 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
| SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
| 00C80000 00C94FFF 00015000 * security
| 044B0000 044B3FFF 00004000 * wshtcpip
| 04500000 04507FFF 00008000 * SSmsLPCn 04510000
| 04516FFF 00007000 * ntdsapi 04530000 04545FFF
| 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
| CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
| 04AE0000 04BA5FFF 000c6000 * sqloledb
| 04BB0000 04C35FFF 00086000 * MSDART
| 04480000 044A8FFF 00029000 * COMCTL32 04C40000
| 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
| 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
| SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
| 045B0000 045C7FFF 00018000 * comctl32
| 05550000 05635FFF 000e6000 * oledb32
| 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
| 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
| 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
| xpstar 03050000 03096FFF 00047000 * SQLRESLD
| 030A0000 030A6FFF 00007000 * SQLSVC
| 030B0000 030C6FFF 00017000 * ODBC32
| 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
| 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
| 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
| WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
| 05CD0000 05CD8FFF 00009000 * odbcint
| 05EB0000 05EC6FFF 00017000 * NDDEAPI
| 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
| 05FF5FFF 00006000 * xpstar 06000000 06008FFF
| 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
| * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
| 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
| 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
| 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
| 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
| * Edx: 00000002:
| * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
| C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
| 00000000 3AE52998 * SegCs: 0000001B:
| * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
| 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
| 00000000 00C567A0 * SegSs: 00000023:
| *
|
************************************************** **************************
***
| *
|
| * Short Stack Dump
| * 007F8A40 Module(sqlservr+003F8A40)
| (RangeGenerator::GetNextRange+000003D0) * 00801CB1
| Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
| Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
| 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
| 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
| 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
| 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
| 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
| Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
| Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
| Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
| Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
| Module(kernel32+0000A990) (FlsSetValue+00000779)
|
|||Hi Glen,
Thanks for Tibor's suggestion. Looking at the nature of this issue, it
would require intensive troubleshooting which would be done quickly and
effectively with direct assistance from a Microsoft Support Professional
through Microsoft Product Support Services. You can contact Microsoft
Product Support directly by choosing one of the options listed at
http://support.microsoft.com/default...=sz;en-us;top.
If this is not an urgent issue and you would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address) mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Sincerely yours,
Bill Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
| From: Glen K <blah@.blah.com>
| Subject: EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange
| User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing
moment of clarity.)
| Message-ID: <pan.2004.06.25.19.18.22.966869@.blah.com>
| Newsgroups: microsoft.public.sqlserver.server
| MIME-Version: 1.0
| Content-Type: text/plain; charset=ISO-2022-jp
| Content-Transfer-Encoding: 8bit
| Lines: 124
| Date: Fri, 25 Jun 2004 19:18:22 GMT
| NNTP-Posting-Host: 67.86.129.2
| X-Complaints-To: abuse@.cv.net
| X-Trace: news4.srv.hcvlny.cv.net 1088191102 67.86.129.2 (Fri, 25 Jun 2004
15:18:22 EDT)
| NNTP-Posting-Date: Fri, 25 Jun 2004 15:18:22 EDT
| Organization: Optimum Online
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.gigan ews.com!f
eed5.newsreader.com!newsreader.com!news3.optonline .net!news4.srv.hcvlny.cv.n
et.POSTED!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:347783
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
| I'm getting errors from SQL Server 2000 SP3 running under Windows Server
| 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
| give any errors. I've looked in the Knowledge Base for articles dealing
| with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
| me.
|
| Here is part of what is showing up in the log:
|
|
|
| SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
| EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
|
************************************************** **************************
***
| *
| * BEGIN STACK DUMP:
| * 06/25/04 14:49:33 spid 55
| *
| * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
| Line 0+00000000) * Exception Code = c0000005
| EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
| E89C400A * Input Buffer 2342 bytes -
| * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
| REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
| and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
| market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
| ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
| where f.brand_cd=rb.br * and_cd and market_cd in
| (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
| ,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
| ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
| * 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
| by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
| * MODULE BASE END SIZE * sqlservr
| 00400000 00B2CFFF 0072d000 * ntdll
| 77F40000 77FF9FFF 000ba000 * kernel32
| 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
| 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
| 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
| GDI32 77C00000 77C43FFF 00044000 * OPENDS60
| 41060000 41065FFF 00006000 * MSVCRT
| 77BA0000 77BF3FFF 00054000 * UMS
| 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
| 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
| 00010000 * sqlevn70 41080000 41086FFF 00007000 *
| NETAPI32 02C60000 02CB2FFF 00053000 * ole32
| 030D0000 031F3FFF 00124000 * XOLEHLP
| 03200000 03205FFF 00006000 * MSDTCPRX
| 03210000 03280FFF 00071000 * OLEAUT32 03290000
| 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
| 00061000 * MTXCLU 03380000 03397FFF 00018000 *
| VERSION 033A0000 033A7FFF 00008000 * WSOCK32
| 033B0000 033B8FFF 00009000 * WS2_32
| 033C0000 033D7FFF 00018000 * WS2HELP
| 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
| 03440FFF 00011000 * RESUTILS 03450000 03461FFF
| 00012000 * USERENV 03470000 03529FFF 000ba000 *
| MFC42u 03530000 03623FFF 000f4000 * secur32
| 036B0000 036C2FFF 00013000 * mswsock
| 036E0000 03722FFF 00043000 * DNSAPI
| 03730000 03756FFF 00027000 * winrnr 037A0000
| 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
| 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
| SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
| 00C80000 00C94FFF 00015000 * security
| 044B0000 044B3FFF 00004000 * wshtcpip
| 04500000 04507FFF 00008000 * SSmsLPCn 04510000
| 04516FFF 00007000 * ntdsapi 04530000 04545FFF
| 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
| CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
| 04AE0000 04BA5FFF 000c6000 * sqloledb
| 04BB0000 04C35FFF 00086000 * MSDART
| 04480000 044A8FFF 00029000 * COMCTL32 04C40000
| 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
| 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
| SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
| 045B0000 045C7FFF 00018000 * comctl32
| 05550000 05635FFF 000e6000 * oledb32
| 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
| 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
| 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
| xpstar 03050000 03096FFF 00047000 * SQLRESLD
| 030A0000 030A6FFF 00007000 * SQLSVC
| 030B0000 030C6FFF 00017000 * ODBC32
| 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
| 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
| 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
| WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
| 05CD0000 05CD8FFF 00009000 * odbcint
| 05EB0000 05EC6FFF 00017000 * NDDEAPI
| 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
| 05FF5FFF 00006000 * xpstar 06000000 06008FFF
| 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
| * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
| 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
| 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
| 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
| 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
| * Edx: 00000002:
| * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
| C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
| 00000000 3AE52998 * SegCs: 0000001B:
| * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
| 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
| 00000000 00C567A0 * SegSs: 00000023:
| *
|
************************************************** **************************
***
| *
|
| * Short Stack Dump
| * 007F8A40 Module(sqlservr+003F8A40)
| (RangeGenerator::GetNextRange+000003D0) * 00801CB1
| Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
| Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
| 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
| 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
| 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
| 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
| 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
| Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
| Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
| Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
| Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
| Module(kernel32+0000A990) (FlsSetValue+00000779)
|