September 5, 2003 at 4:40 am
Hi!
I have a server with about 15 databases on it, 5 of them a replicated to another server.
The database, that has the greatest number of publications (~300, with ~1000 articles, all subscriptions a push) often experiences log reader agent failer. So publications on other servers are replicated to this database as well.
I really need some hints for tracking the problem.
Thanks.
September 5, 2003 at 4:56 am
Single biggest reason in my experience is a connection fault, followed by a timeout. Enable logging on the logreader (-outputverboselevel 3 -output c:\logreader.txt I think) so you can get some info to work with. It should tell you something when you look at the logreader history?
Andy
September 18, 2003 at 10:12 am
Yes you add Andy's parameters on the second step of the log reader agent job... or you can also run the log reader from the command line with the logread.exe file. Pass the same parameters specified in the logreader job and the ones listed above.
September 23, 2003 at 4:49 am
quote:
Yes you add Andy's parameters on the second step of the log reader agent job...
The log reader agent job has 3 steps
http://roustam.hotbox.ru/log_reader_props.jpg
So I should add as a second step this command:
outputverboselevel 3 -output c:\logreader.txt
?
quote:
It should tell you something when you look at the logreader history?
This is what in the agent history:
http://roustam.hotbox.ru/log_reader.jpg
This is what I have in Error log:
2003-08-26 15:39:29.76 spid73 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 73, PSS = 0x46fc5838, EC = 0x46fc5b68
*Stack Dump being sent to d:\mssql\MSSQL\log\SQLDump0077.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/26/03 15:39:29 spid 73
*
*
*
* s p _ r e p l c 0b 00 73 00 70 00 5f 00 72 00 65 00 70 00 6c 00 63 00
* m d s & 6d 00 64 00 73 00 00 00 00 00 26 04 04 20 03 00 00 00
* & & 00 26 04 04 00 00 00 00 00 00 26 04 04 ff ff ff ff
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF 00733000
* ntdll 77F80000 77FFAFFF 0007b000
* KERNEL32 7C4E0000 7C598FFF 000b9000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77D9DFFF 0006e000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7BFFF 0003c000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107BFFF 0000c000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 10000000 10006FFF 00007000
* NETAPI32 11090000 110DEFFF 0004f000
* SECUR32 110E0000 110EEFFF 0000f000
* NETRAP 110F0000 110F5FFF 00006000
* SAMLIB 11100000 1110EFFF 0000f000
* WS2_32 11110000 11123FFF 00014000
* WS2HELP 11130000 11137FFF 00008000
* WLDAP32 11140000 11169FFF 0002a000
* DNSAPI 11170000 11193FFF 00024000
* WSOCK32 111A0000 111A7FFF 00008000
* ole32 11710000 117FBFFF 000ec000
* XOLEHLP 11800000 11807FFF 00008000
* MSDTCPRX 11810000 118C3FFF 000b4000
* MTXCLU 118D0000 118DFFFF 00010000
* VERSION 118E0000 118E6FFF 00007000
* LZ32 118F0000 118F5FFF 00006000
* CLUSAPI 11900000 1190FFFF 00010000
* RESUTILS 11910000 1191CFFF 0000d000
* USERENV 11920000 11981FFF 00062000
* rnr20 11990000 1199BFFF 0000c000
* iphlpapi 119E0000 119F2FFF 00013000
* ICMP 11A00000 11A04FFF 00005000
* MPRAPI 11A10000 11A26FFF 00017000
* OLEAUT32 11A30000 11ACAFFF 0009b000
* ACTIVEDS 11AD0000 11AFEFFF 0002f000
* ADSLDPC 11B00000 11B22FFF 00023000
* RTUTILS 11B30000 11B3DFFF 0000e000
* SETUPAPI 11B40000 11BCDFFF 0008e000
* RASAPI32 11BD0000 11C02FFF 00033000
* RASMAN 11C10000 11C20FFF 00011000
* TAPI32 11C30000 11C51FFF 00022000
* COMCTL32 11C60000 11CE3FFF 00084000
* SHLWAPI 11CF0000 11D54FFF 00065000
* DHCPCSVC 11D60000 11D78FFF 00019000
* winrnr 12220000 12227FFF 00008000
* rasadhlp 12230000 12234FFF 00005000
* SSNETLIB 12A00000 12A14FFF 00015000
* NTMARTA 12A20000 12A3CFFF 0001d000
* WINSPOOL 12A40000 12A5DFFF 0001e000
* MPR 12A60000 12A70FFF 00011000
* NTDSAPI 12A80000 12A90FFF 00011000
* security 13870000 13873FFF 00004000
* msafd 13BB0000 13BCDFFF 0001e000
* wshtcpip 13C10000 13C16FFF 00007000
* SSmsLPCn 13CC0000 13CC7FFF 00008000
* SSnmPN70 13D30000 13D35FFF 00006000
* mswsock 13E80000 13E91FFF 00012000
* kerberos 13F80000 13FB5FFF 00036000
* CRYPTDLL 14020000 1402DFFF 0000e000
* MSASN1 14060000 1406FFFF 00010000
* rsabase 145E0000 14602FFF 00023000
* CRYPT32 14610000 14687FFF 00078000
* CLBCATQ 14CC0000 14D45FFF 00086000
* sqloledb 14D60000 14DD2FFF 00073000
* MSDART 1F660000 1F67EFFF 0001f000
* comdlg32 14DE0000 14E1DFFF 0003e000
* SHELL32 14E20000 15067FFF 00248000
* MSDATL3 15070000 15084FFF 00015000
* oledb32 1F8A0000 1F905FFF 00066000
* OLEDB32R 1F910000 1F91FFFF 00010000
* xplog70 15610000 15621FFF 00012000
* xplog70 15630000 15633FFF 00004000
* msv1_0 15660000 1567EFFF 0001f000
* xpsqlbot 15680000 15685FFF 00006000
* xpstar 156C0000 15706FFF 00047000
* SQLRESLD 15710000 15716FFF 00007000
* SQLSVC 15720000 15736FFF 00017000
* ODBC32 15740000 15771FFF 00032000
* odbcbcp 15780000 15785FFF 00006000
* W95SCM 15790000 1579BFFF 0000c000
* SQLUNIRL 157A0000 157CCFFF 0002d000
* SHFOLDER 157D0000 157D7FFF 00008000
* odbcint 1F850000 1F865FFF 00016000
* NDDEAPI 15A20000 15A26FFF 00007000
* SQLSVC 15A30000 15A35FFF 00006000
* xpstar 15A40000 15A48FFF 00009000
* xpsql70 15CE0000 15CE8FFF 00009000
* DBNETLIB 15EA0000 15EAEFFF 0000f000
* DBnmpNTw 16950000 16956FFF 00007000
* SQLOLEDB 16C20000 16C2EFFF 0000f000
* adsldp 13770000 13791FFF 00022000
* adsmsext 136F0000 13701FFF 00012000
* msxml2 17C20000 17CCDFFF 000ae000
* odsole70 19000000 1900FFFF 00010000
* dbghelp 15BB0000 15C64FFF 000b5000
*
* Edi: 46FC5B68: 46FC5838 46FC5B6C 46FC5B6C 470421F0 47042030 46DFE030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: 46FC5838: 00000049 00000000 00F89C48 000093DE 00000000 00000000
* Ecx: 1A5FDE80: 00000000 0001003F 00000000 00000010 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 1A5FDE64: 1A5FE684 0088199F 46FC5838 1A5FE7E8 1A5FEA56 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 00740073 006D0065 00320033 0057005C 00650062 003B006D
* Esp: 1A5FDE38: 46FC5B68 00000000 46FC5838 1A5FDE80 46FC5000 1A5FDE38
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E) (CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29) (utassert_fail+000002E3)
* 00860F52 Module(sqlservr+00460F52) (LogIterForward::ProcessLog+0000003E)
* 00860EB6 Module(sqlservr+00460EB6) (LogIterForward::TryLogReadAhead+000000EC)
* 004F4A85 Module(sqlservr+000F4A85) (LogIterForward::GetNextBlock+0000015B)
* 004F494A Module(sqlservr+000F494A) (LogIterForward::GetNext+0000007A)
* 007EC81F Module(sqlservr+003EC81F) (get_trans_cmds+000001B3)
* 007EC5EB Module(sqlservr+003EC5EB) (repl_cmds+000001C6)
* 007EB4F4 Module(sqlservr+003EB4F4) (xp_replcmds+0000018A)
* 005F40E0 Module(sqlservr+001F40E0) (CSpecProc::ExecuteSpecial+00000119)
* 005F3D37 Module(sqlservr+001F3D37) (CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29) (CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A) (process_commands+00000232)
* 41072838 Module(UMS+00002838) (ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C4E987C Module(KERNEL32+0000987C) (SetThreadExecutionState+00000227)
* -------------------------------------------------------------------------------
2003-08-26 15:39:35.45 spid73 Stack Signature for the dump is 0xA943EE98
2003-08-26 15:39:35.51 spid73 SQL Server Assertion: File: <logscan.cpp>, line=1903
Failed Assertion = 'startLSN >= m_curLSN'.
2003-08-26 15:39:35.53 spid73 Error: 3624, Severity: 20, State: 1.
2003-08-26 15:39:35.54 spid73 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 73, PSS = 0x46fc5838, EC = 0x46fc5b68
*Stack Dump being sent to d:\mssql\MSSQL\log\SQLDump0078.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/26/03 15:39:35 spid 73
*
*
*
* s p _ r e p l c 0b 00 73 00 70 00 5f 00 72 00 65 00 70 00 6c 00 63 00
* m d s & 6d 00 64 00 73 00 00 00 00 00 26 04 04 20 03 00 00 00
* & & 00 26 04 04 00 00 00 00 00 00 26 04 04 ff ff ff ff
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF 00733000
* ntdll 77F80000 77FFAFFF 0007b000
* KERNEL32 7C4E0000 7C598FFF 000b9000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77D9DFFF 0006e000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7BFFF 0003c000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107BFFF 0000c000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 10000000 10006FFF 00007000
* NETAPI32 11090000 110DEFFF 0004f000
* SECUR32 110E0000 110EEFFF 0000f000
* NETRAP 110F0000 110F5FFF 00006000
* SAMLIB 11100000 1110EFFF 0000f000
* WS2_32 11110000 11123FFF 00014000
* WS2HELP 11130000 11137FFF 00008000
* WLDAP32 11140000 11169FFF 0002a000
* DNSAPI 11170000 11193FFF 00024000
* WSOCK32 111A0000 111A7FFF 00008000
* ole32 11710000 117FBFFF 000ec000
* XOLEHLP 11800000 11807FFF 00008000
* MSDTCPRX 11810000 118C3FFF 000b4000
* MTXCLU 118D0000 118DFFFF 00010000
* VERSION 118E0000 118E6FFF 00007000
* LZ32 118F0000 118F5FFF 00006000
* CLUSAPI 11900000 1190FFFF 00010000
* RESUTILS 11910000 1191CFFF 0000d000
* USERENV 11920000 11981FFF 00062000
* rnr20 11990000 1199BFFF 0000c000
* iphlpapi 119E0000 119F2FFF 00013000
* ICMP 11A00000 11A04FFF 00005000
* MPRAPI 11A10000 11A26FFF 00017000
* OLEAUT32 11A30000 11ACAFFF 0009b000
* ACTIVEDS 11AD0000 11AFEFFF 0002f000
* ADSLDPC 11B00000 11B22FFF 00023000
* RTUTILS 11B30000 11B3DFFF 0000e000
* SETUPAPI 11B40000 11BCDFFF 0008e000
* RASAPI32 11BD0000 11C02FFF 00033000
* RASMAN 11C10000 11C20FFF 00011000
* TAPI32 11C30000 11C51FFF 00022000
* COMCTL32 11C60000 11CE3FFF 00084000
* SHLWAPI 11CF0000 11D54FFF 00065000
* DHCPCSVC 11D60000 11D78FFF 00019000
* winrnr 12220000 12227FFF 00008000
* rasadhlp 12230000 12234FFF 00005000
* SSNETLIB 12A00000 12A14FFF 00015000
* NTMARTA 12A20000 12A3CFFF 0001d000
* WINSPOOL 12A40000 12A5DFFF 0001e000
* MPR 12A60000 12A70FFF 00011000
* NTDSAPI 12A80000 12A90FFF 00011000
* security 13870000 13873FFF 00004000
* msafd 13BB0000 13BCDFFF 0001e000
* wshtcpip 13C10000 13C16FFF 00007000
* SSmsLPCn 13CC0000 13CC7FFF 00008000
* SSnmPN70 13D30000 13D35FFF 00006000
* mswsock 13E80000 13E91FFF 00012000
* kerberos 13F80000 13FB5FFF 00036000
* CRYPTDLL 14020000 1402DFFF 0000e000
* MSASN1 14060000 1406FFFF 00010000
* rsabase 145E0000 14602FFF 00023000
* CRYPT32 14610000 14687FFF 00078000
* CLBCATQ 14CC0000 14D45FFF 00086000
* sqloledb 14D60000 14DD2FFF 00073000
* MSDART 1F660000 1F67EFFF 0001f000
* comdlg32 14DE0000 14E1DFFF 0003e000
* SHELL32 14E20000 15067FFF 00248000
* MSDATL3 15070000 15084FFF 00015000
* oledb32 1F8A0000 1F905FFF 00066000
* OLEDB32R 1F910000 1F91FFFF 00010000
* xplog70 15610000 15621FFF 00012000
* xplog70 15630000 15633FFF 00004000
* msv1_0 15660000 1567EFFF 0001f000
* xpsqlbot 15680000 15685FFF 00006000
* xpstar 156C0000 15706FFF 00047000
* SQLRESLD 15710000 15716FFF 00007000
* SQLSVC 15720000 15736FFF 00017000
* ODBC32 15740000 15771FFF 00032000
* odbcbcp 15780000 15785FFF 00006000
* W95SCM 15790000 1579BFFF 0000c000
* SQLUNIRL 157A0000 157CCFFF 0002d000
* SHFOLDER 157D0000 157D7FFF 00008000
* odbcint 1F850000 1F865FFF 00016000
* NDDEAPI 15A20000 15A26FFF 00007000
* SQLSVC 15A30000 15A35FFF 00006000
* xpstar 15A40000 15A48FFF 00009000
* xpsql70 15CE0000 15CE8FFF 00009000
* DBNETLIB 15EA0000 15EAEFFF 0000f000
* DBnmpNTw 16950000 16956FFF 00007000
* SQLOLEDB 16C20000 16C2EFFF 0000f000
* adsldp 13770000 13791FFF 00022000
* adsmsext 136F0000 13701FFF 00012000
* msxml2 17C20000 17CCDFFF 000ae000
* odsole70 19000000 1900FFFF 00010000
* dbghelp 1D440000 1D4F4FFF 000b5000
*
* Edi: 46FC5B68: 46FC5838 46FC5B6C 46FC5B6C 470421F0 47042030 46DFE030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: 46FC5838: 00060049 00000000 00F89C48 000093DE 00000000 00000000
* Ecx: 1A5FCA6C: 00000000 0001003F 00000000 00000010 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 1A5FCA50: 1A5FD270 0088199F 46FC5838 1A5FD3D4 1A5FD640 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 00740073 006D0065 00320033 0057005C 00650062 003B006D
* Esp: 1A5FCA24: 46FC5B68 00000000 46FC5838 1A5FCA6C 46FC5000 1A5FCA24
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E) (CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29) (utassert_fail+000002E3)
* 00861165 Module(sqlservr+00461165) (LogIterForward::Close+0000008A)
* 00441C58 Module(sqlservr+00041C58) (LogIterForward::~LogIterForward+00000020)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 007EB4F4 Module(sqlservr+003EB4F4) (xp_replcmds+0000018A)
* 005F40E0 Module(sqlservr+001F40E0) (CSpecProc::ExecuteSpecial+00000119)
* 005F3D37 Module(sqlservr+001F3D37) (CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29) (CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A) (process_commands+00000232)
* 41072838 Module(UMS+00002838) (ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C4E987C Module(KERNEL32+0000987C) (SetThreadExecutionState+00000227)
* -------------------------------------------------------------------------------
2003-08-26 15:39:36.43 spid73 Stack Signature for the dump is 0x0A424A49
2003-08-26 15:39:36.45 spid73 SQL Server Assertion: File: <logscan.cpp>, line=2137
Failed Assertion = 'm_noOfScAlloc == 0'.
2003-08-26 15:39:36.59 spid69 Error: 14151, Severity: 18, State: 1
2003-08-26 15:39:36.59 spid69 Replication-Replication Transaction-Log Reader Subsystem: agent JUPITER-mbsII-1 failed. The process could not execute 'sp_replcmds' on 'JUPITER'..
September 23, 2003 at 4:51 am
I could not find something about this in KB.
Thanks.
September 23, 2003 at 5:15 am
Missing a hyphen in from of outputverbose - maybe just a paste error on post? If not, does the dump go away if you remove the switches? Would the log reader have write access to c:\? Depending on your time frame, might be worth a call to PSS - shouldn't be much you can do that will get it to blow up like that.
Andy
September 23, 2003 at 6:03 am
quote:
Missing a hyphen in from of outputverbose - maybe just a paste error on post?
- I have not placed command -outputverboselevel 3 -output c:\logreader.txt
into a second step for log reader job, yet. Just wanted to make shure I am able to do this correct. /* the server is critical */
quote:
If not, does the dump go away if you remove the switches?
- Did not quite understood, what "switches"
/* may be I am having a translation problem */
quote:
Would the log reader have write access to c:\? Depending on your time frame, might be worth a call to PSS - shouldn't be much you can do that will get it to blow up like that.
- The account, MSSQLServer and SQLAgent services use to start is a domain account with local administrators group membership. PSS is a Product Support?
just noticed I did not tell: it is MS SQL Server 2000 (Ent) sp3 + MS Windows 2000 Adv Server sp4
September 23, 2003 at 9:08 am
Switches = the extra command line args for the logreader.
Andy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply