MS-SQL Operator not deployed on K8S version 1.18 and 1.20? also issue with leader election in HA mode?

[bharat15-ml]

Hi , Please provide yours's comments on following questions:-

1. I was able to deploy MSSQL K8S Operator on K8S version 1.13 but unable to deploy on K8S version 1.18 and 1.20. I was using sample manifest file for deployments given here - "https://github.com/microsoft/sql-server-samples/tree/master/samples/features/high%20availability/Kubernetes/sample-manifest-files".
   Error : getting similar error, sql pods are not coming up, discussed in this threads - "https://stackoverflow.com/questions/63405840/k8s-sql2019-ha-containers-dude-where-are-my-pods".

for deployment, I used following images-

1. agentsContainerImage: mcr.microsoft.com/mssql/ha:2019-CTP2.1-ubuntu

2. sqlServerContainer: mcr.microsoft.com/mssql/server:2019-latest

3. My second question was, once I add any database to AG, after than in any case further redeployment causing issue for failover and ag1-primary is not able to find primary pods among mssql1-0, mssql2-0, mssql3-0 . I guess there is some issue with leader election method which I was able to observe with pod ha-supervisor container logs. due to this issue client connection affected with ag-primary service.

Please let me know on these two issues?

[psavva]

@bharat15-ml did you ever get any answers to this, or workarounds, or figure something out?