November 13, 2015 at 9:01 am
Hi,
I have opened the performance monitor and I saw several task state = Suspended on the distribution database for inserts and updates with waits with the application column displaying = Replication Merge History and wait type column with values like 18 Writelog
What show I check? The log of the database is not full
November 13, 2015 at 9:15 am
Also, In the waiting category logging is above all others with this values:
wait time 13000
average waiter count 14.7
Recent wait time = wait time
It sounds like a log issue or a disk issue
November 13, 2015 at 9:43 am
I also run the sp_who2 and I see same lines with
56 SUSPENDED username... .distributionINSERT 1052862911/13 16:38:04Replication Merge History 56 0
November 13, 2015 at 10:42 am
Some log information from SQL Server log:
2015-11-13 16:38:02.51 spid97 Replication-Replication Merge Subsystem: agent 0043007B-0045-0045-4500-320036003800 failed. The reconciler process was stopped because the Subscriber that initiated the synchronization is no longer connected. If this failure continues, restart the Merge Agent with higher value for -InternetTimeout.
2015-11-13 16:38:12.83 spid90 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:38:12.83 spid90 Replication-Replication Merge Subsystem: agent 0034007B-0035-0030-3900-300045004100 failed. Internal error: Either the computer running IIS is out of memory or an incorrect session ID was sent in a request. [Session id,,,,,]
2015-11-13 16:44:15.54 spid112 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:44:15.54 spid112 Replication-Replication Merge Subsystem: agent 0036007B-0045-0036-4600-440043003500 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 16:47:41.64 spid78 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:47:41.64 spid78 Replication-Replication Merge Subsystem: agent 0033007B-0041-0030-3100-340041003800 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 16:48:57.24 spid189 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:48:57.24 spid189 Replication-Replication Merge Subsystem: agent 0042007B-0041-0039-3600-370038003100 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 16:53:29.84 spid61 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:53:29.84 spid61 Replication-Replication Merge Subsystem: agent 0045007B-0043-0043-4500-380034004500 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 16:53:32.35 spid163 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:53:32.35 spid163 Replication-Replication Merge Subsystem: agent 0045007B-0043-0043-4500-380034004500 failed. The reconciler process was stopped because the Subscriber that initiated the synchronization is no longer connected. If this failure continues, restart the Merge Agent with higher value for -InternetTimeout.
2015-11-13 16:55:05.46 spid60 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:55:05.46 spid60 Replication-Replication Merge Subsystem: agent 0044007B-0038-0044-3400-440035004400 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Central'. Check to ensure that the server is running.
2015-11-13 16:56:35.78 spid56 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:56:35.78 spid56 Replication-Replication Merge Subsystem: agent 0042007B-0041-0039-3600-370038003100 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 16:59:40.51 spid162 Error: 14151, Severity: 18, State: 1.
2015-11-13 16:59:40.51 spid162 Replication-Replication Merge Subsystem: agent 0039007B-0030-0046-3600-460044004300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:00:08.16 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 29:139:1, last LSN: 29:139:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:14.93 spid125 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:00:14.93 spid125 Replication-Replication Merge Subsystem: agent 0039007B-0030-0046-3600-460044004300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:00:15.49 Backup Log was backed up. Database: DatabaseName_Archive, creation date(time): 2014/04/11(10:07:04), first LSN: 23927:2654:1, last LSN: 23927:2654:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:18.99 Backup Log was backed up. Database: DatabaseName_Central, creation date(time): 2014/04/12(07:23:44), first LSN: 18637:4063:1, last LSN: 18647:2210:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:20.84 Backup Log was backed up. Database: DatabaseName_Market, creation date(time): 2014/04/12(15:39:21), first LSN: 3611948:114585:1, last LSN: 3611949:13793:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:22.22 Backup Log was backed up. Database: DatabaseName_Stats, creation date(time): 2014/04/11(12:05:06), first LSN: 8140:3828:1, last LSN: 8140:5102:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:35.24 spid132 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:00:35.24 spid132 Replication-Replication Merge Subsystem: agent 0038007B-0039-0033-4300-410041004100 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:18:48.86 spid115 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:18:48.86 spid115 Replication-Replication Merge Subsystem: agent 0037007B-0038-0045-3300-360035003900 failed. The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload).
2015-11-13 17:19:01.60 spid115 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:19:01.60 spid115 Replication-Replication Merge Subsystem: agent 0045007B-0043-0043-4500-380034004500 failed. The reconciler process was stopped because the Subscriber that initiated the synchronization is no longer connected. If this failure continues, restart the Merge Agent with higher value for -InternetTimeout.
2015-11-13 17:21:45.57 spid141 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:21:45.57 spid141 Replication-Replication Merge Subsystem: agent 0037007B-0038-0045-3300-360035003900 failed. The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload).
2015-11-13 17:25:29.61 spid86 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:25:29.61 spid86 Replication-Replication Merge Subsystem: agent 0045007B-0044-0043-3700-420037003600 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:25:38.78 spid86 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:25:38.78 spid86 Replication-Replication Merge Subsystem: agent 0031007B-0046-0030-3100-420046003300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:26:11.57 spid120 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:26:11.57 spid120 Replication-Replication Merge Subsystem: agent 0031007B-0043-0045-3500-320043003300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:27:17.15 spid145 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:27:17.15 spid145 Replication-Replication Merge Subsystem: agent 0045007B-0043-0043-4500-380034004500 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:29:19.13 spid97 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:29:19.13 spid97 Replication-Replication Merge Subsystem: agent 0034007B-0035-0031-4500-390035004300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:30:38.45 spid141 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:30:38.45 spid141 Replication-Replication Merge Subsystem: agent 0030007B-0041-0032-3600-440042003900 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:31:36.84 spid110 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:31:36.84 spid110 Replication-Replication Merge Subsystem: agent 0042007B-0043-0033-4500-330035003100 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:35:17.22 spid193 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:35:17.22 spid193 Replication-Replication Merge Subsystem: agent 0034007B-0032-0038-4100-320039003400 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Central'. Check to ensure that the server is running.
November 13, 2015 at 10:48 am
I don't think the problem is the waits...
The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Central'.
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2015 at 10:51 am
Do you think that the problem is this:
"The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload)"
November 13, 2015 at 10:53 am
I think that it happens because if a subscriber stay more that 7 days without sincronizing, then the data is considereted unvalid
November 13, 2015 at 11:01 am
The resource wait on the activity monitor is very high for the logging:
With wait time and recent wait time above 16000
November 13, 2015 at 11:12 am
Another piece of the log:
2015-11-13 17:00:18.99 Backup Log was backed up. Database: DatabaseName_Central, creation date(time): 2014/04/12(07:23:44), first LSN: 18637:4063:1, last LSN: 18647:2210:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:20.84 Backup Log was backed up. Database: DatabaseName_Market, creation date(time): 2014/04/12(15:39:21), first LSN: 3611948:114585:1, last LSN: 3611949:13793:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:22.22 Backup Log was backed up. Database: DatabaseName_Stats, creation date(time): 2014/04/11(12:05:06), first LSN: 8140:3828:1, last LSN: 8140:5102:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001DC8-0000'}). This is an informational message only. No user action is required.
2015-11-13 17:00:35.24 spid132 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:00:35.24 spid132 Replication-Replication Merge Subsystem: agent 0038007B-0039-0033-4300-410041004100 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:18:48.86 spid115 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:18:48.86 spid115 Replication-Replication Merge Subsystem: agent 0037007B-0038-0045-3300-360035003900 failed. The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload).
2015-11-13 17:19:01.60 spid115 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:19:01.60 spid115 Replication-Replication Merge Subsystem: agent 0045007B-0043-0043-4500-380034004500 failed. The reconciler process was stopped because the Subscriber that initiated the synchronization is no longer connected. If this failure continues, restart the Merge Agent with higher value for -InternetTimeout.
2015-11-13 17:21:45.57 spid141 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:21:45.57 spid141 Replication-Replication Merge Subsystem: agent 0037007B-0038-0045-3300-360035003900 failed. The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload).
2015-11-13 17:25:29.61 spid86 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:25:29.61 spid86 Replication-Replication Merge Subsystem: agent 0045007B-0044-0043-3700-420037003600 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:25:38.78 spid86 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:25:38.78 spid86 Replication-Replication Merge Subsystem: agent 0031007B-0046-0030-3100-420046003300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:26:11.57 spid120 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:26:11.57 spid120 Replication-Replication Merge Subsystem: agent 0031007B-0043-0045-3500-320043003300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:27:17.15 spid145 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:27:17.15 spid145 Replication-Replication Merge Subsystem: agent 0045007B-0043-0043-4500-380034004500 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:29:19.13 spid97 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:29:19.13 spid97 Replication-Replication Merge Subsystem: agent 0034007B-0035-0031-4500-390035004300 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:30:38.45 spid141 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:30:38.45 spid141 Replication-Replication Merge Subsystem: agent 0030007B-0041-0032-3600-440042003900 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:31:36.84 spid110 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:31:36.84 spid110 Replication-Replication Merge Subsystem: agent 0042007B-0043-0033-4500-330035003100 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:35:17.22 spid193 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:35:17.22 spid193 Replication-Replication Merge Subsystem: agent 0034007B-0032-0038-4100-320039003400 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Central'. Check to ensure that the server is running.
2015-11-13 17:36:19.75 spid114 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:36:19.75 spid114 Replication-Replication Merge Subsystem: agent 0032007B-0030-0033-3500-440039004400 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 17:52:32.45 spid128 Error: 14151, Severity: 18, State: 1.
2015-11-13 17:52:32.45 spid128 Replication-Replication Merge Subsystem: agent 0041007B-0034-0032-3100-460039004400 failed. The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'. Check to ensure that the server is running.
2015-11-13 18:00:09.29 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 29:139:1, last LSN: 29:139:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001860-0000'}). This is an informational message only. No user action is required.
2015-11-13 18:00:10.25 Backup Log was backed up. Database: DatabaseName_Archive, creation date(time): 2014/04/11(10:07:04), first LSN: 23927:2654:1, last LSN: 23927:2654:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001860-0000'}). This is an informational message only. No user action is required.
2015-11-13 18:00:17.69 Backup Log was backed up. Database: DatabaseName_Central, creation date(time): 2014/04/12(07:23:44), first LSN: 18647:2210:1, last LSN: 18652:5630:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001860-0000'}). This is an informational message only. No user action is required.
2015-11-13 18:00:21.49 Backup Log was backed up. Database: DatabaseName_Market, creation date(time): 2014/04/12(15:39:21), first LSN: 3611949:13793:1, last LSN: 3611950:217425:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001860-0000'}). This is an informational message only. No user action is required.
2015-11-13 18:00:22.07 Backup Log was backed up. Database: DatabaseName_Stats, creation date(time): 2014/04/11(12:05:06), first LSN: 8140:5102:1, last LSN: 8140:5977:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'TDPSQL-00001860-0000'}). This is an informational message only. No user action is required.
2015-11-13 18:04:00.33 spid78 Error: 14151, Severity: 18, State: 1.
2015-11-13 18:04:00.33 spid78 Replication-Replication Merge Subsystem: agent 0034007B-0042-0044-3000-320041004500 failed. The reconciler process was stopped because the Subscriber that initiated the synchronization is no longer connected. If this failure continues, restart the Merge Agent with higher value for -InternetTimeout.
2015-11-13 18:04:12.87 spid153 Error: 14151, Severity: 18, State: 1.
2015-11-13 18:04:12.87 spid153 Replication-Replication Merge Subsystem: agent 0032007B-0037-0031-3700-300038003000 failed. The reconciler process was stopped because the Subscriber that initiated the synchronization is no longer connected. If this failure continues, restart the Merge Agent with higher value for -InternetTimeout.
2015-11-13 18:04:18.78 spid116 Error: 14151, Severity: 18, State: 1.
2015-11-13 18:04:18.78 spid116 Replication-Replication Merge Subsystem: agent 0033007B-0044-0044-3100-370036003400 failed. Internal error: Either the computer running IIS is out of memory or an incorrect session ID was sent in a request. [Session id,,,,,]
November 13, 2015 at 11:50 am
Canot be lack of disk perfortmance what is causing this ?
November 13, 2015 at 1:37 pm
No idea. You need to sit down and figure out why
The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply