Index rebuid failed | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Index rebuid failed

I observed following error in my Maintanance plan report – it actually does an optimization of all the databases .
Rebuilding indexes for table ‘perfil’ …… [Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 0: [Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.1 And hence the job fails. any one have any idea whts the issue . thanks
rajiv

I tried to run the following query(in QA) for re-indexing in same database/table , getting same error<br /><br />EXEC SeguridadSysgold..sp_MSforeachtable @command1=’DBCC DBREINDEX (”?”)'<br /><br />error <img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />qlDumpExceptionHandler: Process 63 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.<br /><br />rajiv
Ye olde warning – don’t use undocumented SPs, like sp_MSforeachtable. Could it be that your database has a table that has no indexes? Could your procedure be trying to reindex system tables (which I would assume is not recommended)?
AFAIK, there is no way to reindex the system tables. MS feels that they are optimized enough due to some different access approach, that they don’t need to be reindexed anyway. So, I don’t think this is the reason. Can it be there are any jobs running while you are trying to run this statement? Any entry in any log? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Also found same error in log and a dump file has been created. following is the content of that .
* *******************************************************************************<br />*<br />* BEGIN STACK DUMP:<br />* 08/28/05 03:12:43 spid 60<br />*<br />* Exception Address = 0040A735 (CVariableInfo::CVarBlock:<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />vbJoin + 00000035 Line 0+00000000)<br />* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION<br />* Access Violation occurred writing address 0061007D<br />* Input Buffer 122 bytes -<br />* dbcc dbreindex(N'[dbo].[perfil]’, N”, 90, sorted_data_reorg)<br />* <br />*<br />* MODULE BASE END SIZE<br />* sqlservr 00400000 00B2CFFF 0072d000<br />* ntdll 7C800000 7C8BFFFF 000c0000<br />* kernel32 77E40000 77F41FFF 00102000<br />* ADVAPI32 77F50000 77FEBFFF 0009c000<br />* RPCRT4 77C50000 77CEEFFF 0009f000<br />* USER32 77380000 77411FFF 00092000<br />* GDI32 77C00000 77C47FFF 00048000<br />* OPENDS60 41060000 41065FFF 00006000<br />* MSVCRT 77BA0000 77BF9FFF 0005a000<br />* UMS 41070000 4107CFFF 0000d000<br />* SQLSORT 42AE0000 42B6FFFF 00090000<br />* MSVCIRT 60020000 6002FFFF 00010000<br />* sqlevn70 41080000 41086FFF 00007000<br />* NETAPI32 02C50000 02CA7FFF 00058000<br />* ole32 030C0000 031F3FFF 00134000<br />* XOLEHLP 03200000 03205FFF 00006000<br />* MSDTCPRX 03210000 03287FFF 00078000<br />* msvcp60 03290000 032F0FFF 00061000<br />* MTXCLU 03300000 03318FFF 00019000<br />* VERSION 03320000 03327FFF 00008000<br />* WSOCK32 03330000 03338FFF 00009000<br />* WS2_32 03340000 03356FFF 00017000<br />* WS2HELP 03360000 03367FFF 00008000<br />* OLEAUT32 03370000 033FBFFF 0008c000<br />* CLUSAPI 03440000 03451FFF 00012000<br />* RESUTILS 03460000 03472FFF 00013000<br />* USERENV 03480000 03543FFF 000c4000<br />* secur32 03550000 03562FFF 00013000<br />* mswsock 03580000 035C0FFF 00041000<br />* DNSAPI 035D0000 035F8FFF 00029000<br />* winrnr 03640000 03646FFF 00007000<br />* WLDAP32 03650000 0367DFFF 0002e000<br />* rasadhlp 036A0000 036A4FFF 00005000<br />* SSNETLIB 00C60000 00C74FFF 00015000<br />* SSNMPN70 00C80000 00C85FFF 00006000<br />* security 04160000 04163FFF 00004000<br />* hnetcfg 04170000 041C8FFF 00059000<br />* wshtcpip 04210000 04217FFF 00008000<br />* SSmsLPCn 04370000 04376FFF 00007000<br />* ntdsapi 04390000 043A4FFF 00015000<br />* kerberos 045C0000 04617FFF 00058000<br />* cryptdll 04620000 0462BFFF 0000c000<br />* MSASN1 04730000 04741FFF 00012000<br />* SQLFTQRY 04570000 045A1FFF 00032000<br />* xpsp2res 10000000 102C4FFF 002c5000<br />* CLBCatQ 04BC0000 04C42FFF 00083000<br />* COMRes 04C50000 04D15FFF 000c6000<br />* sqloledb 04D20000 04DA0FFF 00081000<br />* MSDART 04DB0000 04DC9FFF 0001a000<br />* MSDATL3 04DD0000 04DE4FFF 00015000<br />* oledb32 05170000 051E8FFF 00079000<br />* OLEDB32R 051F0000 05200FFF 00011000<br />* msv1_0 052A0000 052C6FFF 00027000<br />* iphlpapi 052D0000 052E9FFF 0001a000<br />* PSAPI 052F0000 052FAFFF 0000b000<br />* xpsqlbot 05290000 05295FFF 00006000<br />* rsaenh 05390000 053BEFFF 0002f000<br />* xpstar 03070000 030B6FFF 00047000<br />* SQLRESLD 05640000 05646FFF 00007000<br />* SQLSVC 05650000 05666FFF 00017000<br />* ODBC32 05670000 056ACFFF 0003d000<br />* COMCTL32 056B0000 05746FFF 00097000<br />* comdlg32 05750000 05799FFF 0004a000<br />* SHELL32 057A0000 05FA2FFF 00803000<br />* SHLWAPI 05FB0000 06001FFF 00052000<br />* odbcbcp 06010000 06015FFF 00006000<br />* W95SCM 06020000 0602BFFF 0000c000<br />* SQLUNIRL 06030000 0605CFFF 0002d000<br />* WINSPOOL 06060000 06086FFF 00027000<br />* SHFOLDER 06090000 06098FFF 00009000<br />* comctl32 060B0000 061B2FFF 00103000<br />* odbcint 063A0000 063B6FFF 00017000<br />* NDDEAPI 064C0000 064C6FFF 00007000<br />* SQLSVC 064D0000 064D5FFF 00006000<br />* xpstar 064E0000 064E8FFF 00009000<br />* ACTIVEDS 07130000 07162FFF 00033000<br />* adsldpc 071E0000 07206FFF 00027000<br />* credui 07210000 0723DFFF 0002e000<br />* ATL 07240000 07257FFF 00018000<br />* adsldp 072E0000 0730DFFF 0002e000<br />* SXS 07B50000 07C0BFFF 000bc000<br />* dbghelp 07040000 070F4FFF 000b5000<br />*<br />* Edi: 00610075: 7D2CFE83 7EF68550 04FE831E FE83477E 8342740A 0F7E12FE <br />* Esi: 00000001: <br />* Eax: 6ADF3C88: 00000001 00200030 00730055 00610075 00690072 0047006F <br />* Ebx: 00730055: F0458BE2 D9EC5D89 E84589EE 9BA05DDD 1DA8E0DF E8500C74 <br />* Ecx: 6ADF3CB0: 00000041 00780020 00730055 00610075 00690072 0020006F <br />* Edx: 6ADF3C50: 00000001 003005B0 6A01E700 6ADF3C90 00000022 00000000 <br />* Eip: 0040A735: 8B085F89 598B0879 0C5F890C 06498B66 D00D0366 660098D7 <br />* Ebp: 0472A49C: 0472A4AC 0040A62F 6ADF3C90 6ADF3C90 0472A4B8 00401A65 <br />* SegCs: 0000001B: <br />* EFlags: 00010202: 00740074 005C0065 00640041 005C006D 00690042 0000006E <br />* Esp: 0472A480: 6ADF3C88 00000000 6ADF2000 0040A68E 00000000 33C34050 <br />* SegSs: 00000023: <br />* *******************************************************************************<br />* ——————————————————————————-<br />* Short Stack Dump<br />* 0040A735 Module(sqlservr+0000A735) (CVariableInfo::CVarBlock:<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />vbJoin+00000035)<br />* 0040A68E Module(sqlservr+0000A68E) (CVariableInfo:<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />viRelease+00000056)<br />* 0040A62F Module(sqlservr+0000A62F) (CVarPageMgr::Release+00000014)<br />* 00401A65 Module(sqlservr+00001A65) (CMemObj::Free+0000001E)<br />* 004F6DE7 Module(sqlservr+000F6DE7) (CXVariant::ClearDeep+0000003<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /><br />* 0040ACC8 Module(sqlservr+0000ACC<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> (CXVariant::Clear+0000000E)<br />* 00473A89 Module(sqlservr+00073A89) (StatMan::~StatMan+00000032)<br />* 004FE9F4 Module(sqlservr+000FE9F4) (FUpsBuildStats+0000053A)<br />* 004FE76D Module(sqlservr+000FE76D) (FCheckSetOptions+0000022D)<br />* 005AACA3 Module(sqlservr+001AACA3) (CIndexDDL::ExecSelForStats+00000063)<br />* 005AAE8D Module(sqlservr+001AAE8D) (CIndexDDL::Create+000001CE)<br />* 005AB273 Module(sqlservr+001AB273) (CIndexDDL::Rebuild+00000237)<br />* 005AB737 Module(sqlservr+001AB737) (RebuildIndexDriver+0000009D)<br />* 008CBEC4 Module(sqlservr+004CBEC4) (RebuildObjectIndexes+00000175)<br />* 008CC180 Module(sqlservr+004CC180) (dbreindex+0000024A)<br />* 0060066E Module(sqlservr+0020066E) (CStmtDbcc:<img src=’/community/emoticons/emotion-12.gif’ alt=’:X’ />retExecute+0000085C)<br />* 0041B442 Module(sqlservr+0001B442) (CMsqlExecContext::ExecuteStmts+000003B9)<br />* 0041AA88 Module(sqlservr+0001AA8<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> (CMsqlExecContext::Execute+000001B6)<br />* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)<br />* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)<br />* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)<br />* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)<br />* 41074698 Module(UMS+0000469<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> (ThreadStartRoutine+0000009<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /><br />* 77BCB3CA Module(MSVCRT+0002B3CA) (endthread+000000AB)<br />* 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)<br />* ————————————————
]]>