SQL Server 2019 on Kubernetes of Docker Desktop for Windows

5/29/2020

I'm trying to install SQL Server 2019 on Kubernetes - "Docker Desktop for Windows"

Here is the error:

D:\Docker\buckwoody>kubectl logs -l app=mssql --tail=100000
failed to try resolving symlinks in path "/var/log/pods/default_mssql-deployment-8dd99d5b4-9z2gd_5a917b86-7728-4c5d-af38-b52d1f78e580/mssql/3.log": lstat /var/log/pods/default_mssql-deployment-8dd99d5b4-9z2gd_5a917b86-7728-4c5d-af38-b52d1f78e580/mssql/3.log: no such file or directory
D:\Docker\buckwoody>

It looks like the error is related to volumes but I cant seem to figure out what. Has anyone encountered the error before?

Here is a SQL Server 2019 deployment manifest file:

apiVersion: apps/v1
kind: Deployment
metadata:
  name: mssql-deployment
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mssql
  strategy:
    type: Recreate
  template:
    metadata:
      labels:
        app: mssql
    spec:
      terminationGracePeriodSeconds: 10
      securityContext:
        fsGroup: 1000
      containers:
      - name: mssql
        image: mcr.microsoft.com/mssql/rhel/server:2019-latest
        env:
        - name: MSSQL_PID
          value: "Developer"
        - name: ACCEPT_EULA
          value: "Y"
        - name: MSSQL_SA_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mssql-secret
              key: SA_PASSWORD 
        volumeMounts:
        - name: mssqldb
          mountPath: "/backup"
          # mountPath: /var/opt/mssql
      volumes:
      - name: mssqldb
        persistentVolumeClaim:
          claimName: pv-claim-data-sql

Here is the PersistentVolume manifest file:

kind: PersistentVolume
apiVersion: v1
metadata:
  name: pv-data-sql
  labels:
    type: local
spec:
  storageClassName: hostpath
  capacity:
    storage: 10Gi
  accessModes:
    - ReadWriteOnce
  hostPath:
    path: /T/Docker/DMK/BACKUP
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: pv-claim-data-sql
spec:
  storageClassName: hostpath
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 10Gi

Here is the Service manifest file:

apiVersion: v1 
kind: Service 
metadata:
  name: sql2019nodeport
spec:
  type: NodePort
  selector:
    app: mssql

  ports:
    # Three types of ports for a service
    # nodePort - a static port assigned on each the node
    # port - port exposed internally in the cluster
    # targetPort - the container port to send requests to
    - nodePort: 31433
      name: tds
      port: 1433 
      targetPort: 80
-- Gopinath Rajee
docker-desktop
kubernetes
sql-server-2019
windows-10-desktop

0 Answers