Solved

SQL Server AG doesn't recognize the active node


Userlevel 1
Badge +6

Hi, I’m getting this error

Error Code: [30:385]
Description: Failed to choose agent for backup for backup type [Transaction Log], reason [Failed to update AG information of MSSQLAGInstance. ].
Source: hsapsqldb9, Process: SQLBackupMaster
 

tried to restart the services on the cluster members - didn’t help

icon

Best answer by Neelam Jain 23 September 2021, 12:47

View original

19 replies

Userlevel 5
Badge +12

Hi Eldan,

 

Are the AG Nodes the same SP/MR level as the CommServe?

 

Best Regards,

Michael

Userlevel 1
Badge +6

Hi Michael, sorry but i’m not familiar with the SP/ MR abbreviations  ;)

Userlevel 5
Badge +12

My apologies! - SP = Service Pack, which has been replaced by FR (Feature Release) and MR = Maintenance Release which replaced HotFix Pack (HPK).

 

I would suggest to ensure the AG Nodes are the same Commvault Software Level as the CommServe.

Userlevel 1
Badge +6

yes, the nodes and the software are at the same level

Userlevel 5
Badge +12

Hi Eldan,

Can you check the SQLBackupMaster.log for any errors on server hsapsqldb9 for this Job?
The log Files are usually located at: <Install Drive>:\Program Files\Commvault\ContentStore\Log Files\

Best Regards,

Michael

Userlevel 1
Badge +6

@MichaelCapon I don’t see any meaningful information

40556 1f98  08/02 15:53:02 3390473 SQLBackupController::FetchAGFromRemoteAgentAndUpdateCS(531): -Debug-: Got AG infromation from replica [HSAPSQLDB9\IPD].

40556 1f98  08/02 15:53:03 3390473 NetMessage::verifyResponseHeader() - Error Code [-1] returned - [].

40556 1f98  08/02 15:53:03 3390473 InstInterfaceNet::setMSSQLAGProperties() - 

40556 1f98  08/02 15:53:03 3390473 SQLBackupController::FetchAGFromRemoteAgentAndUpdateCS(579): -Error-: Failed to update AG information of MSSQLAGInstance with error [-1].

40556 1f98  08/02 15:53:03 3390473 SQLBackupController::MarkJobStatusFailed(187): -Debug-: JOB STATUS FAIL.

40556 1f98  08/02 15:53:03 3390473 BKP CALLED COMPLETE (PHASE Status::FAIL), 3390473. Token [3390473:2:5:0:55415]

 

Userlevel 4
Badge +7

Hi @Eldan 


May be best to raise a support case to check this out as there may be a number of things that cause this. 

Out of curiosity, are you able to confirm if this was a working AG and it’s now problematic or is this a new setup? 

If you view the properties of the AG, do the either of the replicas have an _1 appended to their name? 

E.G. 
 

 

Userlevel 1
Badge +6

It was working and now problematic

I don’t have the underscore+number added

Userlevel 7
Badge +21

@Eldan , can you raise a support case and share the number here?

Userlevel 7
Badge +21

Hey @Eldan , following up to see if you managed to raise a case for this issue.  If you did, please share the number so I can track it accordingly :nerd:

Thanks!

Userlevel 7
Badge +21

Gentle follow up, @Eldan.  I don’t see any support case in your name, so please advise if you have a case number, or were able to get this resolved.

Thanks!

Userlevel 1
Badge +6

Hi, it’s not relevant right now. the instance was moved back to the original node and the backup is running

Userlevel 7
Badge +21

I’m sorry we couldn’t help…..is this something you expect to retry soon as o we can try and get to the bottom of it for you?

Badge

Hi @Eldan 


May be best to raise a support case to check this out as there may be a number of things that cause this. 

Out of curiosity, are you able to confirm if this was a working AG and it’s now problematic or is this a new setup? 

If you view the properties of the AG, do the either of the replicas have an _1 appended to their name? 

E.G. 
 

 

Hi, I am also facing similar issue and _1 is visible for both the replicas.

Please let me know what should be done here.

Badge

Hi, I am also facing similar issue and _1 is visible for both the replicas.

Please let me know what should be done here.

Userlevel 3
Badge +5

Hello Neelam - Are you able to provide log cuts from the SQLBackupMaster.log from your environment?

 

Can you check the SQLBackupMaster.log for any errors on server [ your SQL Server ] for this Job?
The log Files are usually located at: <Install Drive>:\Program Files\Commvault\ContentStore\Log Files\

 

@Neelam Jain Ideally we would need to check those logs also to see if and what is returned before we are able to determine the issue. Knowing that you are seeing the _1 clients also is helpful but we would still like to confirm in more detail the issue before making assumptions on the resolution.

It also may be best to open a support incident so a member of the support staff can view full logging to narrow this down further.

Userlevel 4
Badge +7

@Neelam Jain 

Further to Ronalds update, the _1 usually comes as a result of the following: https://documentation.commvault.com/commvault/v11_sp20/article?p=31667.htm - this will impact our AG unless fixed.

The knowledge base article for this issue is here: https://kb.commvault.com/article/63652

Probably best to raise a case so we can validate as there is a small chance it’s something else entirely.

Please let us know how you go.

Chris 

Badge

@Chris Hollis @Ron Potts 

Thanks guys for your valuable comment.

I had opened a case with support and issue resolved by merging the duplicate clients as per the link provided byr Ron also.

https://documentation.commvault.com/commvault/v11_sp20/article?p=31667.htm

 

Regards

Neelam Jain

 

Userlevel 7
Badge +21

Great!  I marked your reply as the Best Answer then!

Reply