Windows本地文件夹挂载Docker Desktop环境Kubernetes pod异常问题咨询

你当前的配置存在三类核心错误，以下是具体说明和修复方案： #

1 路径配置错误 #

Docker Desktop for Windows 运行的Kubernetes集群，识别Windows本地路径的格式不是/C/data/sql，WSL2后端下的正确映射路径为/run/desktop/mnt/host/c/data/sql，路径中的盘符为小写。你之前的PV路径填写错误，导致挂载的是集群节点内不存在的目录，K8s会默认新建空目录，所以进入容器看到的是空文件夹。

2 PV与PVC绑定匹配错误 #

你的PVC未配置storageClassName和标签选择器，Kubernetes默认会优先匹配动态存储卷，而非你手动创建的本地PV，导致PVC实际绑定的是集群自动生成的空PV，自然看不到本地文件。

3 权限与挂载路径错误 #

• 你之前直接挂载时mountPath写的是相对路径data，会挂载到容器工作目录下的子目录，而非预期的根目录/data
• MSSQL容器默认使用UID为10001的mssql用户运行，Windows本地目录挂载到容器后默认属主为root，mssql用户无读写权限，所以会报访问拒绝错误，volumePermissions.enabled=true是部分Helm Chart的内置参数，你自定义的配置不生效是正常的。

1 持久卷（PV） #

apiVersion: v1
kind: PersistentVolume
metadata:
  name: dev-customer-db-pv
  labels:
    type: local
    app: customer-db
    chart: customer-db-0.1.0
    release: dev
    heritage: Helm
spec:
  storageClassName: manual # 指定手动存储类，避免动态绑定
  capacity:
    storage: 1Gi
  accessModes:
    - ReadWriteOnce
  hostPath:
    path: /run/desktop/mnt/host/c/data/sql # 修正为Docker Desktop识别的Windows C盘路径
    type: Directory # 提前确保本地C:\data\sql目录存在

2 持久卷声明（PVC） #

apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: dev-customer-db-pvc
  labels:
    app: customer-db
    chart: customer-db-0.1.0
    release: dev
    heritage: Helm
spec:
  storageClassName: manual # 和PV存储类保持一致
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 100Mi
  selector: # 匹配PV标签，确保绑定到手动创建的PV
    matchLabels:
      app: customer-db
      release: dev

3 Deployment配置（新增权限修复逻辑） #

apiVersion: apps/v1
kind: Deployment
metadata:
  name: dev-customer-db
  labels:
    ufo: dev-customer-db-config
    app: customer-db
    chart: customer-db-0.1.0
    release: dev
    heritage: Helm
spec:
  selector:
    matchLabels:
      app: customer-db
      release: dev
  replicas: 1
  template:
    metadata:
      labels:
        app: customer-db
        release: dev
    spec:
      volumes:
        - name: dev-customer-db-pv
          persistentVolumeClaim:
            claimName: dev-customer-db-pvc
      # 新增初始化容器，修改挂载目录权限给mssql用户
      initContainers:
      - name: fix-permissions
        image: busybox:latest
        command: ["sh", "-c", "chown -R 10001:10001 /data"]
        volumeMounts:
        - name: dev-customer-db-pv
          mountPath: /data
        securityContext:
          runAsUser: 0
      containers:
      - name: customer-db
        image: "mcr.microsoft.com/mssql/server:2019-latest"
        imagePullPolicy: IfNotPresent
        volumeMounts:
          - name: dev-customer-db-pv
            mountPath: /data
        envFrom:
          - configMapRef:
              name: dev-customer-db-config
          - secretRef:
              name: dev-customer-db-secrets

部署完成后执行kubectl get pvc dev-customer-db-pvc，确认STATUS为Bound，VOLUME字段显示为你手动创建的dev-customer-db-pv，再进入容器查看/data目录即可看到本地文件，且MSSQL可以正常读写。

内容的提问来源于stack exchange，提问作者ngruson