• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 37
  • Last Modified:

select operation drop when SQL server AOG failing over.

hi all,

when I doing a select (*) operation against a MS SQL server 2016 AOG with 2 x read-only load balanced replica, I tried to failover to other node and see what will happen to the select (*)  operation,

I got this:

Msg 10054, Level 20, State 0, Line 14
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 。)

Open in new window



any reason why the select (*) is not keep going but return an error during AOG failover ?

I tried that using server local version of SSMS, it seems it is the SSMS version problem! What I found out is sth else, the AOG failover will WAIT until the existing select query is finished, not that good, right?
0
marrowyung
Asked:
marrowyung
  • 4
  • 3
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How are you connecting to the database Replica? Can you post the current connecting string that you're using?
Also, how many Replicas the database has?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"Also, how many Replicas the database has?"

1  x primary and 2 x secondary.

"How are you connecting to the database Replica?"

via connector.

"an you post the current connecting string that you're using?"

Server= tcp:SQLAOGlistener,1433; Trusted_Connection=true; Database=WideWorldImporters;  MultiSubnetFailover=True; ApplicationIntent=ReadOnly;

Open in new window

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
1  x primary and 2 x secondary.
From which Node to which did you failed over the AOG?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
marrowyungSenior Technical architecture (Data)Author Commented:
login to primary and failover to secondary.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I've already posted this article in your another question but I think they are related so check if it helps.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
i might come back.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now