WaitForChildren: Children persisting. Retry: 12765
-
Hi all.
I have a 20 db server for online forums. Twice a month i restart the server
because forums become not accessible only on saturday morning.
The db's were created by a 3rd party software to manage all the forums.
I have full text jobs and db maintenance jobs scheduled on sundays and
nothing on saturdays.
Can this be a 3rd party software?
The following error log entries started on saturday morning at 4:45AM same
thing happened on may 27th.
Can you tell me what these entries mean?
THANKS FOR ALL YOUR HELP
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 194, PSS = 0x6891d220, EC = 0x6891d548
*Stack Dump being sent to e:\Data\MSSQL\log\SQLDump0207.txt
*
*******************************************************************************
*
* BEGIN STACK DUMP:
* 06/03/06 04:46:12 spid 194
*
*
*
* Input Buffer 152 bytes -
* exec GetRecentPostsByMemberID '419','{36852FD8-8864-4374-B1B1-8E81B3A369
* AC}'
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 02A40000 02A8EFFF 0004f000
* Secur32 02A90000 02A9EFFF 0000f000
* NTDSAPI 02AA0000 02AB0FFF 00011000
* DNSAPI 02AC0000 02AE3FFF 00024000
* WSOCK32 02AF0000 02AF7FFF 00008000
* WS2_32 02B00000 02B13FFF 00014000
* WS2HELP 02B20000 02B27FFF 00008000
* WLDAP32 02B30000 02B59FFF 0002a000
* NETRAP 02B60000 02B65FFF 00006000
* SAMLIB 02B70000 02B7EFFF 0000f000
* ole32 031E0000 032CEFFF 000ef000
* XOLEHLP 032D0000 032D7FFF 00008000
* MSDTCPRX 032E0000 03396FFF 000b7000
* MTXCLU 033A0000 033AFFFF 00010000
* VERSION 033B0000 033B6FFF 00007000
* LZ32 033C0000 033C5FFF 00006000
* CLUSAPI 033D0000 033DFFFF 00010000
* RESUTILS 033E0000 033ECFFF 0000d000
* USERENV 033F0000 03450FFF 00061000
* rnr20 03460000 0346BFFF 0000c000
* iphlpapi 034B0000 034C2FFF 00013000
* ICMP 034D0000 034D4FFF 00005000
* MPRAPI 034E0000 034F6FFF 00017000
* OLEAUT32 03500000 0359AFFF 0009b000
* ACTIVEDS 035A0000 035CEFFF 0002f000
* ADSLDPC 035D0000 035F2FFF 00023000
* RTUTILS 03600000 0360DFFF 0000e000
* SETUPAPI 03610000 0369DFFF 0008e000
* RASAPI32 036A0000 036D2FFF 00033000
* RASMAN 036E0000 036F0FFF 00011000
* TAPI32 03700000 03721FFF 00022000
* COMCTL32 03730000 037B3FFF 00084000
* SHLWAPI 037C0000 03828FFF 00069000
* DHCPCSVC 03830000 03848FFF 00019000
* winrnr 03CF0000 03CF7FFF 00008000
* rasadhlp 03D00000 03D04FFF 00005000
* SSNETLIB 044D0000 044E4FFF 00015000
* SSNMPN70 044F0000 044F5FFF 00006000
* security 04830000 04833FFF 00004000
* msafd 05B40000 05B5DFFF 0001e000
* wshtcpip 05BA0000 05BA6FFF 00007000
* SSmsLPCn 05C30000 05C36FFF 00007000
* rsabase 06310000 06332FFF 00023000
* CRYPT32 06340000 063C6FFF 00087000
* MSASN1 063D0000 063DFFFF 00010000
* msv1_0 06A10000 06A30FFF 00021000
* CLBCATQ 075A0000 0762FFFF 00090000
* sqloledb 07640000 076B2FFF 00073000
* MSDART 076C0000 076DEFFF 0001f000
* comdlg32 076E0000 0771DFFF 0003e000
* SHELL32 07720000 07964FFF 00245000
* MSDATL3 07970000 07984FFF 00015000
* oledb32 08010000 08075FFF 00066000
* OLEDB32R 08080000 0808FFFF 00010000
* xpstar 08090000 080D6FFF 00047000
* SQLRESLD 080E0000 080E6FFF 00007000
* SQLSVC 080F0000 08106FFF 00017000
* ODBC32 08110000 08141FFF 00032000
* odbcbcp 08150000 08155FFF 00006000
* W95SCM 08160000 0816BFFF 0000c000
* SQLUNIRL 10000000 1002CFFF 0002d000
* WINSPOOL 08170000 0818DFFF 0001e000
* MPR 08190000 0819FFFF 00010000
* SHFOLDER 081A0000 081A7FFF 00008000
* odbcint 08470000 08485FFF 00016000
* NDDEAPI 08490000 08496FFF 00007000
* SQLSVC 084A0000 084A5FFF 00006000
* xpstar 084B0000 084B8FFF 00009000
* SQLFTQRY 084C0000 084F1FFF 00032000
* LEServer 08B70000 08BC5FFF 00056000
* dbghelp 08CE0000 08DA0FFF 000c1000
* xpsqlbot 08EC0000 08EC5FFF 00006000
* xpsmtp80 091E0000 091FAFFF 0001b000
* mlang 09290000 0931EFFF 0008f000
* tquery 0DE10000 0DF88FFF 00179000
* mssws 0DF90000 0DF97FFF 00008000
* mswsock 0E040000 0E051FFF 00012000
* xplog70 0E0F0000 0E101FFF 00012000
* xplog70 0E110000 0E113FFF 00004000
* odsole70 04ED0000 04EDFFFF 00010000
* cdosys 04FE0000 0524DFFF 0026e000
* MSVCP50 05250000 052DCFFF 0008d000
* WININET 052E0000 05375FFF 00096000
* urlmon 05380000 053FAFFF 0007b000
* INETCOMM 05400000 05494FFF 00095000
* MSOERT2 054A0000 054BEFFF 0001f000
* inetres 054F0000 054FDFFF 0000e000
* msoeacct 055D0000 0560CFFF 0003d000
* acctres 05620000 05631FFF 00012000
* msident 05640000 0564CFFF 0000d000
* msidntld 05650000 05655FFF 00006000
* PSTOREC 05660000 0566BFFF 0000c000
* ATL 05670000 05684FFF 00015000
* odsole70 00C60000 00C64FFF 00005000
* srchadm 047B0000 047E5FFF 00036000
* athprxy 093A0000 093A7FFF 00008000
* msadce 059D0000 05A1AFFF 0004b000
* mswstr10 073E0000 07474FFF 00095000
* msadcer 0CD60000 0CD64FFF 00005000
* msjetoledb40 0CD70000 0CDC4FFF 00055000
* msjet40 0CDD0000 0CF3FFFF 00170000
* msjter40 0CF40000 0CF4CFFF 0000d000
* MSJINT40 0CF50000 0CF75FFF 00026000
* DBNETLIB 0DB30000 0DB3EFFF 0000f000
* DBnmpNTw 0DB40000 0DB46FFF 00007000
* SQLOLEDB 0DB50000 0DB5EFFF 0000f000
* sqlmap70 04AF0000 04B19FFF 0002a000
* MAPI32 04C00000 04C20FFF 00021000
* dbghelp 07080000 07134FFF 000b5000
*
* Edi: 6891D548: 6891D220 6891F3E0 5EBDB4B0 6891D554 6891D554
68920030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: 6891D220: 000400C2 00000000 004E7791 000097D5 00000000
00000000
* Ecx: 059CC6FC: 00000000 0001003F 00000000 00000000 00000000
00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
64F04D8B
* Ebp: 059CC6E0: 059CCF00 0087C41F 6891D220 059CD064 059CD2DA
780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F005C 00650070 004D006E 006E0061 00670061
005C0065
* Esp: 059CC6B4: 6891D548 00000000 6891D220 059CC6FC 6891D000
059CC6B4
* SegSs: 00000023:
*
*******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 008793DF Module(sqlservr+004793DF) (ExecutionContext::Cleanup+00000118)
* 00512EBC Module(sqlservr+00112EBC) (ExecutionContext:
urge+00000046)* 006FD84C Module(sqlservr+002FD84C) (CXid:
eactivate+000000A3)* 006D7DA1 Module(sqlservr+002D7DA1) (CQueryScan::ShutdownParallel+000000B6)
* 006D7ECF Module(sqlservr+002D7ECF)
(CQueryScan::ShutdownOnException+00000035)
* 00604E7A Module(sqlservr+00204E7A) (CStmtQuery::ErsqExecuteQuery+00000B38)
* 00429DFF Module(sqlservr+00029DFF) (CStmtSelect::XretExecute+00000229)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 00423193 Module(sqlservr+00023193) (CGList:
repend+0000001D)* 00650068 Module(sqlservr+00250068) (CIdentity::FCreate+00000149)
* 6A068BFF Module(UNKNOWN+00000000)
* -------------------------------------------------------------------------------
Stack Signature for the dump is 0xC3C628CD
SQL Server Assertion: File: <proc.c>, line=1576
Failed Assertion = 'm_activeSdesList.Head () == NULL'.
Error: 3624, Severity: 20, State: 1.
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 194, PSS = 0x6891d220, EC = 0x6891d548
*Stack Dump being sent to e:\Data\MSSQL\log\SQLDump0208.txt
*
*******************************************************************************
*
* BEGIN STACK DUMP:
* 06/03/06 04:46:19 spid 194
*
* Trying to use the transaction while there are 49 parallel nested xacts
outstanding
*
* exec GetRecentPostsByMemberID '419','{36852FD8-8864-4374-B1B1-8E81B3A369
* AC}'
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 02A40000 02A8EFFF 0004f000
* Secur32 02A90000 02A9EFFF 0000f000
* NTDSAPI 02AA0000 02AB0FFF 00011000
* DNSAPI 02AC0000 02AE3FFF 00024000
* WSOCK32 02AF0000 02AF7FFF 00008000
* WS2_32 02B00000 02B13FFF 00014000
* WS2HELP 02B20000 02B27FFF 00008000
* WLDAP32 02B30000 02B59FFF 0002a000
* NETRAP 02B60000 02B65FFF 00006000
* SAMLIB 02B70000 02B7EFFF 0000f000
* ole32 031E0000 032CEFFF 000ef000
* XOLEHLP 032D0000 032D7FFF 00008000
* MSDTCPRX 032E0000 03396FFF 000b7000
* MTXCLU 033A0000 033AFFFF 00010000
* VERSION 033B0000 033B6FFF 00007000
* LZ32 033C0000 033C5FFF 00006000
* CLUSAPI 033D0000 033DFFFF 00010000
* RESUTILS 033E0000 033ECFFF 0000d000
* USERENV 033F0000 03450FFF 00061000
* rnr20 03460000 0346BFFF 0000c000
* iphlpapi 034B0000 034C2FFF 00013000
* ICMP 034D0000 034D4FFF 00005000
* MPRAPI 034E0000 034F6FFF 00017000
* OLEAUT32 03500000 0359AFFF 0009b000
* ACTIVEDS 035A0000 035CEFFF 0002f000
* ADSLDPC 035D0000 035F2FFF 00023000
* RTUTILS 03600000 0360DFFF 0000e000
* SETUPAPI 03610000 0369DFFF 0008e000
* RASAPI32 036A0000 036D2FFF 00033000
* RASMAN 036E0000 036F0FFF 00011000
* TAPI32 03700000 03721FFF 00022000
* COMCTL32 03730000 037B3FFF 00084000
* SHLWAPI 037C0000 03828FFF 00069000
* DHCPCSVC 03830000 03848FFF 00019000
* winrnr 03CF0000 03CF7FFF 00008000
* rasadhlp 03D00000 03D04FFF 00005000
* SSNETLIB 044D0000 044E4FFF 00015000
* SSNMPN70 044F0000 044F5FFF 00006000
* security 04830000 04833FFF 00004000
* msafd 05B40000 05B5DFFF 0001e000
* wshtcpip 05BA0000 05BA6FFF 00007000
* SSmsLPCn 05C30000 05C36FFF 00007000
* rsabase 06310000 06332FFF 00023000
* CRYPT32 06340000 063C6FFF 00087000
* MSASN1 063D0000 063DFFFF 00010000
* msv1_0 06A10000 06A30FFF 00021000
* CLBCATQ 075A0000 0762FFFF 00090000
* sqloledb 07640000 076B2FFF 00073000
* MSDART 076C0000 076DEFFF 0001f000
* comdlg32 076E0000 0771DFFF 0003e000
* SHELL32 07720000 07964FFF 00245000
* MSDATL3 07970000 07984FFF 00015000
* oledb32 08010000 08075FFF 00066000
* OLEDB32R 08080000 0808FFFF 00010000
* xpstar 08090000 080D6FFF 00047000
* SQLRESLD 080E0000 080E6FFF 00007000
* SQLSVC 080F0000 08106FFF 00017000
* ODBC32 08110000 08141FFF 00032000
* odbcbcp 08150000 08155FFF 00006000
* W95SCM 08160000 0816BFFF 0000c000
* SQLUNIRL 10000000 1002CFFF 0002d000
* WINSPOOL 08170000 0818DFFF 0001e000
* MPR 08190000 0819FFFF 00010000
* SHFOLDER 081A0000 081A7FFF 00008000
* odbcint 08470000 08485FFF 00016000
* NDDEAPI 08490000 08496FFF 00007000
* SQLSVC 084A0000 084A5FFF 00006000
* xpstar 084B0000 084B8FFF 00009000
* SQLFTQRY 084C0000 084F1FFF 00032000
* LEServer 08B70000 08BC5FFF 00056000
* dbghelp 08CE0000 08DA0FFF 000c1000
* xpsqlbot 08EC0000 08EC5FFF 00006000
* xpsmtp80 091E0000 091FAFFF 0001b000
* mlang 09290000 0931EFFF 0008f000
* tquery 0DE10000 0DF88FFF 00179000
* mssws 0DF90000 0DF97FFF 00008000
* mswsock 0E040000 0E051FFF 00012000
* xplog70 0E0F0000 0E101FFF 00012000
* xplog70 0E110000 0E113FFF 00004000
* odsole70 04ED0000 04EDFFFF 00010000
* cdosys 04FE0000 0524DFFF 0026e000
* MSVCP50 05250000 052DCFFF 0008d000
* WININET 052E0000 05375FFF 00096000
* urlmon 05380000 053FAFFF 0007b000
* INETCOMM 05400000 05494FFF 00095000
* MSOERT2 054A0000 054BEFFF 0001f000
* inetres 054F0000 054FDFFF 0000e000
* msoeacct 055D0000 0560CFFF 0003d000
* acctres 05620000 05631FFF 00012000
* msident 05640000 0564CFFF 0000d000
* msidntld 05650000 05655FFF 00006000
* PSTOREC 05660000 0566BFFF 0000c000
* ATL 05670000 05684FFF 00015000
* odsole70 00C60000 00C64FFF 00005000
* srchadm 047B0000 047E5FFF 00036000
* athprxy 093A0000 093A7FFF 00008000
* msadce 059D0000 05A1AFFF 0004b000
* mswstr10 073E0000 07474FFF 00095000
* msadcer 0CD60000 0CD64FFF 00005000
* msjetoledb40 0CD70000 0CDC4FFF 00055000
* msjet40 0CDD0000 0CF3FFFF 00170000
* msjter40 0CF40000 0CF4CFFF 0000d000
* MSJINT40 0CF50000 0CF75FFF 00026000
* DBNETLIB 0DB30000 0DB3EFFF 0000f000
* DBnmpNTw 0DB40000 0DB46FFF 00007000
* SQLOLEDB 0DB50000 0DB5EFFF 0000f000
* sqlmap70 04AF0000 04B19FFF 0002a000
* MAPI32 04C00000 04C20FFF 00021000
* dbghelp 11BB0000 11C64FFF 000b5000
*
* Edi: 6891D548: 6891D220 6891F3E0 5EBDB4B0 5EBDB670 5EBDB670
68920030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: 6891D220: 000600C2 00000000 004E7791 000097D5 00000000
00000000
* Ecx: 059CAE88: 00000000 0001003F 00000000 00000000 00000000
00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D
64F04D8B
* Ebp: 059CAE6C: 059CB68C 0087C41F 6891D220 059CB7F0 059CBAB9
780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F005C 00650070 004D006E 006E0061 00670061
005C0065
* Esp: 059CAE40: 6891D548 00000000 6891D220 059CAE88 6891D000
059CAE40
* SegSs: 00000023:
*
*******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00865EF9 Module(sqlservr+00465EF9) (ReadOnlyXactImp::Rollback+00000028)
* 004A60D3 Module(sqlservr+000A60D3) (CMsqlReadOnlyXact::Rollback+0000000F)
* 00441AA0 Module(sqlservr+00041AA0) (CMsqlXact::Rollback+00000055)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 00423193 Module(sqlservr+00023193) (CGList:
repend+0000001D)* 00650068 Module(sqlservr+00250068) (CIdentity::FCreate+00000149)
* 6A068BFF Module(UNKNOWN+00000000)
* -------------------------------------------------------------------------------
Stack Signature for the dump is 0x22718303
SQL Server Assertion: File: <"xact">, line = 838
Failed Assertion = '!m_parNestedXactCnt' Trying to use the transaction while
there are 49 parallel nested xacts outstanding.
clean_tables_xact: active sdes for tabid 2935760842006-06-03 04:46:23.24
spid194 clean_tables_xact: active sdes for tabid 3095761412006-06-03
04:46:23.24 spid194 clean_tables_xact: active sdes for tabid
2935760842006-06-03 04:46:23.24 spid194 clean_tables_xact: active sdes for
tabid 3095761412006-06-03 04:46:23.24 spid194 clean_tables_xact: active
sdes for tabid 2935760842006-06-03 04:46:23.24 spid194 clean_tables_xact:
active sdes for tabid 2935760842006-06-03 04:47:03.25 spid194
WaitForChildren: Children persisting. Retry: 2
WaitForChildren: Children persisting. Retry: 3
WaitForChildren: Children persisting. Retry: 4
WaitForChildren: Children persisting. Retry: 5
Alex S -
I do not have an answer but more questions.
- What OS version and SP are you running ?
- What version of SQL Server are you running and SP ?
- Are you running any SQL Server hot fixes ?
- Have you googled the 'WaitForChildren' ?
- Have you contacted MS PSS ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
* What OS version and SP are you running ?
Windows 2000 SP4 Xeon 4 CPU, 2GHz, 3 gigs of memory.
* What version of SQL Server are you running and SP ?
SQL SERVER STANDARD EDITION SP3
Dynamic Configuration of Memory
* Are you running any SQL Server hot fixes ?
NO
* Have you googled the 'WaitForChildren' ?
Yes and every post says to contact MS PSS
* Have you contacted MS PSS ?
First thing monday morning i will contact them.
This morning i had to restart the server again.
because of the same errors in error log.
I got the same above errors and one of my db's was not accessible from the website.
Could this be because of maintenance plans for all db's.
I have a maint plan for all db's on sundays.
It includes optimization at 12:15 AM and full backup at 1:00AM
Optimization plan reorginizes data and index pages
Changes free space per page to 10%.
Removes unused space from db files.
Shrinks a db when it grows beyond 50 megs
Amount of free space to remain after shrink 10% of the data space.
I think this optimization job causes the problem.
If the tables are being written to will this process lock the data pages till it reorganizes them and then let the write process access the pages?
All the db's on this server are constantly being updated.
I have another maint plan that optimizes a 60 gig db at 2AM.
So far no errors from jobs they all completed.
In the past month we restarted the server 3 times.
Thank you.
Alex S -
look for corruption in msdb.
-
Hello,
The errors that you are getting are SQL server assertions. This means there are some internal checks in the SQL server software for which the result should always be true , but in this case is returning False. e.g. row size is returned as greater than 8K, which is not possible.
Action plan : do a DBCC CHECKDB on the database for which you are getting these errors. this is most probably the datbase where you have the "GetRecentPostsByMemberID" stored procedure.
Also if that does not resolve , i would suggest repopulation of the FTs catalouges.
If both dosent help, contact PSS
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply