3

For the lasts days I'm getting a high undistributed commands value in the replication monitor. Restarting the Server Agent solve the problem (momentarily) but after few hours starts again. Even when there are a lot of undistributed commands, I inject a token and get low latency (00:00:09 the most high). sp_replmonitorsubscriptionpendingcmds return the same values from the Replication Monitor.

The 'Distributor To Subscriber History' shows the message "TCP Provider: An existing connection was forcibly closed by the remote host". I'm looking for network issues and I didn't find nothing, just in the Application logs are the events 14152.

There are 6 replication jobs and they fail in similar time, but not in the same moment (all are replicating to the same subscriber), I means, in a period of few minutes between them. If was a network issue, they must broke at same moment, right?

After restart the agent or the server, it's working for several hours. I didn't find any pattern in the time, sometimes broke in the morning, others in the afternoon, etc.

How can I continue debugging the problem?

note: SQL server 2008 R2

  • does netstat -e show errors/discards? – Max Vernon Feb 15 '17 at 14:51
  • Thank you (for the edit and the comment)! Yes, I see a high discards packets (the same number for received and sent columns) – HEDMON Feb 16 '17 at 6:56
  • Are both servers on the same network? Is there a physical network involved or is this purely via a virtual network? – Max Vernon Feb 16 '17 at 14:44
  • No, servers are in different countries. – HEDMON Feb 16 '17 at 20:45
  • 1
    Maybe the comment before wasn't complete clear. The servers are in complete different companies (so, are different networks and locations) – HEDMON Feb 18 '17 at 8:03
2

It's almost certainly a network/connectivity issue, even if the jobs don't fail at the same time.

Error 14152 is logged when "Agent shuts down after unsuccessfully retrying an operation (agent encounters an error such as server not available, deadlock, connection failure, or time-out failure).", and if the last error was "existing connection was forcibly closed" that suggests there were also earlier tries with the same result even if not logged.

There are many reasons this could be happening intermittently. One specific reason can be multiple NICs in the distributor having the same IP assigned. It could also be the network connection is simply overloaded at times.

  • 1
    Thank you! It's a virtual server and there only one NIC. With the comment of @Max Vernon I found a lot of discard packets so, I believe there is network problem. – HEDMON Feb 16 '17 at 6:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.