Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server merge replication issue mini dumpsql Expand / Collapse
Author
Message
Posted Monday, September 16, 2013 2:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 8, 2014 12:04 AM
Points: 110, Visits: 716
hello all,

I am getting an error while I am trying to replicate data. below is the output from the error dmp.i am unable to figure out what is happening. any help would be highly appreciated. this error is off and on. Merge job is scheduled to run every 5 min. sometimes it is successful sometimes it is not.



SQL server 2005 version with SP4.

windows server 2003 enterprise edition

___________________________

Below is the error from the sql server log

Source spid66

Message
Replication-agentclassname: agent eClaims-eClaimsDR_Merge-4 failed. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.

Error: 14151, Severity: 18, State: 1.

___________________________

below is the output of the file opened in windbg.



Microsoft (R) Windows Debugger Version 6.12.0002.633 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.


Loading Dump File [ReplAgent20130908161007_0.mdmp]
User Mini Dump File: Only registers, stack and portions of memory are available

WARNING: Inaccessible path: 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn'
Symbol search path is: srv*c:\debuggers\symbols*http://msdl.microsoft.com/download/symbols;C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Executable search path is:
Windows Server 2003 Version 3790 (Service Pack 2) MP (4 procs) Free x86 compatible
Product: Server, suite: Enterprise TerminalServer SingleUserTS
Machine Name:
Debug session time: Sun Sep 8 16:10:07.000 2013 (UTC + 4:00)
System Uptime: not available
Process Uptime: 0 days 0:00:07.000
................................................................
......
Loading unloaded module list
......
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr.
(bb4.980): Access violation - code c0000005 (first/second chance not available)
eax=00000000 ebx=00000001 ecx=0390d8c4 edx=7c82845c esi=000003a4 edi=00000000
eip=7c82845c esp=0390e2a0 ebp=0390e310 iopl=0 nv up ei ng nz ac pe cy
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000297
ntdll!KiFastSystemCallRet:
7c82845c c3 ret
0:017> !analyse -v
No export analyse found
0:017> !analyze -v
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************

*** WARNING: Unable to verify timestamp for replmerg.exe
Unable to load image C:\WINDOWS\system32\sqlncli.dll, Win32 error 0n2
*** WARNING: Unable to verify timestamp for sqlncli.dll
GetPageUrlData failed, server returned HTTP status 404
URL requested:

FAULTING_IP:
replrec!CDatabaseReconciler::AddRetry+eed
4e6a093d 8b420c mov eax,dword ptr [edx+0Ch]

EXCEPTION_RECORD: ffffffff -- (.exr 0xffffffffffffffff)
ExceptionAddress: 4e6a093d (replrec!CDatabaseReconciler::AddRetry+0x00000eed)
ExceptionCode: c0000005 (Access violation)
ExceptionFlags: 00000000
NumberParameters: 2
Parameter[0]: 00000000
Parameter[1]: 2030000c
Attempt to read from address 2030000c

DEFAULT_BUCKET_ID: INVALID_POINTER_READ

PROCESS_NAME: replmerg.exe

ERROR_CODE: (NTSTATUS) 0xc0000005 - The instruction at 0x%08lx referenced memory at 0x%08lx. The memory could not be %s.

EXCEPTION_CODE: (NTSTATUS) 0xc0000005 - The instruction at 0x%08lx referenced memory at 0x%08lx. The memory could not be %s.

EXCEPTION_PARAMETER1: 00000000

EXCEPTION_PARAMETER2: 2030000c

READ_ADDRESS: 2030000c

FOLLOWUP_IP:
replrec!CDatabaseReconciler::AddRetry+eed
4e6a093d 8b420c mov eax,dword ptr [edx+0Ch]

MOD_LIST: <ANALYSIS/>

NTGLOBALFLAG: 0

FAULTING_THREAD: 00000980

PRIMARY_PROBLEM_CLASS: INVALID_POINTER_READ

BUGCHECK_STR: APPLICATION_FAULT_INVALID_POINTER_READ

LAST_CONTROL_TRANSFER: from 4ca208c7 to 4e6a093d

STACK_TEXT:
0390f6d0 4ca208c7 0114b6b8 02111eec 029c6e74 replrec!CDatabaseReconciler::AddRetry+0xeed
0390fcf0 4ca21c93 00000000 00000000 0390fd84 replprov!CMergeDatasource::CommitBatchInternal+0x3837
0390fd00 4ca0ca01 02c41538 00000000 00000000 replprov!CMergeDatasource::CommitBatch+0x13
0390fd84 4e6afcbb 02c41538 01b596b0 029c6e74 replprov!CMergeDatasource::InsertRow+0xe1
0390fdc8 4e6ac183 02c41538 62cbab5b 02cf2db0 replrec!CReplRowChange::CopyRowFromSource+0x68b
0390fdf4 4e6b3cc7 00000000 02c52a88 00000000 replrec!CCustomResolver::Reconcile+0xc3
0390fea4 4e6784c8 02c52a88 0390fef8 0390ff28 replrec!CReplRowChange::Reconcile+0xde7
0390fed4 4e69b131 0210ddf4 029c55b4 029ff6ec replrec!CDatabaseReconciler::DoArticleLoopDest+0x108
0390ff44 4e69e3cd 00000000 02cbb668 00000000 replrec!CDatabaseReconciler::DestThreadProcessQueue+0x431
0390ff78 781329bb 00000000 7dfd64d6 00000000 replrec!DestThreadProc+0xdd
0390ffb0 78132a47 00000000 77e6481f 01b891b8 msvcr80!_endthreadex+0x3b
0390ffb8 77e6481f 01b891b8 00000000 00000000 msvcr80!_endthreadex+0xc7
0390ffec 00000000 781329e1 01b891b8 00000000 kernel32!BaseThreadStart+0x34


SYMBOL_STACK_INDEX: 0

SYMBOL_NAME: replrec!CDatabaseReconciler::AddRetry+eed

FOLLOWUP_NAME: MachineOwner

MODULE_NAME: replrec

IMAGE_NAME: replrec.dll

DEBUG_FLR_IMAGE_TIMESTAMP: 4d027f6a

STACK_COMMAND: dt ntdll!LdrpLastDllInitializer BaseDllName ; dt ntdll!LdrpFailureData ; ~17s; .ecxr ; kb

FAILURE_BUCKET_ID: INVALID_POINTER_READ_c0000005_replrec.dll!CDatabaseReconciler::AddRetry

BUCKET_ID: APPLICATION_FAULT_INVALID_POINTER_READ_replrec!CDatabaseReconciler::AddRetry+eed

WATSON_STAGEONE_URL:

Followup: MachineOwner
---------



0:017> lmvm replrec
start end module name
4e650000 4e712000 replrec T (pdb symbols) c:\debuggers\symbols\replrec.pdb\FA32405ED24C4F6F966C1F15563420641\replrec.pdb
Loaded symbol image file: replrec.dll
Image path: C:\Program Files\Microsoft SQL Server\90\COM\replrec.dll
Image name: replrec.dll
Timestamp: Fri Dec 10 23:28:42 2010 (4D027F6A)
CheckSum: 000CF255
ImageSize: 000C2000
File version: 2005.90.5000.0
Product version: 9.0.5000.0
File flags: 0 (Mask 3F)
File OS: 40000 NT Base
File type: 2.0 Dll
File date: 00000000.00000000
Translations: 0000.04b0 0000.04e4 0409.04b0 0409.04e4




thanks.
Post #1494958
Posted Monday, September 16, 2013 9:19 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 34, Visits: 757
You could have a corrupted installation or something else.

It is best to contact Microsoft Support and have them analyze the dump file.
Post #1495359
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse