SQL 2019 BDC installation on Redhat enterprise linux

sreeraj murali 1

Hi Experts,

Trying to deploy SQL 2019 BDC cluster on Kubernetes cluster running on Redhat enterprise linux. The SQL bdc installation fails with below error message, after putting the value of storage class. Need help in fixing the installation issues.

Starting cluster deployment.

{"kind":"Status","apiVersion":"v1","metadata":{},"status":"Failure","message":"secrets \"domain-service-account-secret\" already exists","reason":"AlreadyExists","details":{"name":"domain-service-account-secret","kind":"secrets"},"code":409}

(409)

Reason: Conflict

HTTP response headers: HTTPHeaderDict({'Audit-Id': '9928a384-9266-4730-ab2e-87cccd0602c8', 'Cache-Control': 'no-cache, private', 'Content-Type': 'application/json', 'X-Kubernetes-Pf-Flowschema-Uid': 'dd636fd7-0468-4723-83e9-b933b354582a', 'X-Kubernetes-Pf-Prioritylevel-Uid': 'e68836ae-01a7-43a4-bac7-cf67d404a413', 'Date': 'Sat, 04 Sep 2021 07:58:44 GMT', 'Content-Length': '242'})

HTTP response body: {"kind":"Status","apiVersion":"v1","metadata":{},"status":"Failure","message":"secrets \"domain-service-account-secret\" already exists","reason":"AlreadyExists","details":{"name":"domain-service-account-secret","kind":"secrets"},"code":409}

Kindly do assist.

1 answer

CarrinWu-MSFT 6,866 Reputation points

2021-09-06T03:30:13.04+00:00

Hi @sreeraj murali ,

Welcome to Microsoft Q&A!

From the error message which you posted, we can know that there has an domain service account already exists. Please follow this troubleshoot steps to get more detail information.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
sreeraj murali 1 Reputation point

2021-09-06T15:05:52.403+00:00

Hello Carin,
Thanks a lot for the response and advice.
We tried to setup the BDC cluster with aks-dev-test deloyment profile, and there is no reference of domain service account which had come across during the steps, Kubernetes cluster deployment and further.
Could you help in providing more light on troubleshooting the same.

Also, if you can guide on the storage provisioning options availabe, that will help. We are trying to setup the cluster with 1 master node + 3 worker nodes. Looking for more information on what storage option-like NFS we can use for the cluster.
Kindly guide.

Best Regards
Sreeraj Murali

CarrinWu-MSFT 6,866 Reputation points

2021-09-07T03:01:26.05+00:00

Hi @sreeraj murali ,

We tried to setup the BDC cluster with aks-dev-test deployment profile

As my researched, aks-dev-test deployment profile is that deploy SQL Server Big Data Cluster on Azure Kubernetes Service (AKS). Are you using AKS? If not, please refer to this link. Please noted that you could find steps in the left.

sreeraj murali 1 Reputation point

2021-09-08T06:43:14.503+00:00

Hello Carin,

We did try to re install the kubernetes cluster and re run the SQL 2019 BDC installation again. The installation is stuck with Waiting for "control plan to be ready" and it got stuck with same error msg, for 2-3 hrs. Kindly advice how to tshoot the same.

!

Thanks
Sreeraj

CarrinWu-MSFT 6,866 Reputation points

2021-09-09T01:43:32.927+00:00

The 409 error is that the request was received, but it was a request to update an older version of the object. Please refer to this similar thread.

sreeraj murali 1 Reputation point

2021-09-17T17:40:05.063+00:00

Hi Carrin,

Had been trying to complete the installation of SQL 2019 BDC on Kubernetes. This got diverted to an new direction. We have the 4 Redhat linux systems, 1-Master and 3-Worker nodes. and with Local persistent volume provisioned.
The installation is stuck with "3x metricsdc" pods getting crashed repeatedly.

Every 2.0s: kubectl get pods -n mssql-cluster Fri Sep 17 10:36:44 2021

NAME READY STATUS RESTARTS AGE
control-lkdz6 3/3 Running 0 6m10s
controldb-0 2/2 Running 0 6m2s
controlwd-7q2qd 1/1 Running 0 5m42s
logsdb-0 1/1 Running 0 5m40s
logsui-xlqdd 1/1 Running 0 5m41s
metricsdb-0 1/1 Running 0 5m41s
metricsdc-bh9pc 0/1 CrashLoopBackOff 2 (12s ago) 5m41s
metricsdc-j6s8p 0/1 Error 2 (113s ago) 5m41s
metricsdc-rdflb 0/1 Error 2 (112s ago) 5m41s
metricsui-bnwmm 1/1 Running 0 5m40s
mgmtproxy-gb2b4 2/2 Running 0 5m41s

Attaching the POD-error logs and the POD status. [133166-kubectl-describe-pod-metricsdc-j4c5n-n-mssql-clust.txt][1][133070-metricsdc-bwpvb-pod-logs.txt][2]

Kindly advice to fix the issue. Didnt find any troubleshooting notes on MS documentation
Sign in to comment

Share via

SQL 2019 BDC installation on Redhat enterprise linux

1 answer