AG group nodes - Error: 17836, Severity: 20, State: 14. Length specified in network packet payload did not match number of bytes read... etc
Question
Friday, August 3, 2018 2:44 PM
We have a pair of availability groups set up between two new servers, with each AG running as primary on the opposite node to the other.
SQL Server version is 12.0.5589.7
The AG groups are configured with a listener, along with read only routing for the secondaries.
On both servers, we are receiving repeated errors in the log evey few seconds:-
Error: 17836, Severity: 20, State: 14
Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: 10.x.x.x]
Where the IP is the other node in the Availability Group.
Both AGs appear to be in a healthy state when viewing the dashboard, all databases are synchronised with relatively low redo log queuse. Both AGs are set to replicate in synchronous mode.
I'm wondering where I should be looking next to see where the issue might be coming from?
Cheers
Matthew
All replies (2)
Friday, August 3, 2018 3:29 PM
Use NSlookup to identify the client [10.x.y.z] and which application is tapping you.
Sync traces with the occurrence of event 17836 & catch.
yup
Friday, August 3, 2018 11:07 PM
Do you have anything else like a scanner etc. running on your other node whose IP is showing up in the error? Check out the similar threads below and see if they're of any help.
https://stackoverflow.com/questions/36640719/how-to-resolve-error-17836-severity-20-state-14
Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.