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