前言

环境：k8s 1.22.6、nfs-server后端存储

部署mysql

kind: StatefulSet
apiVersion: apps/v1
metadata:name: mysql-hisnamespace: hislabels:app: mysql-hisannotations:kubesphere.io/alias-name: mysql-hiskubesphere.io/creator: dev-liukubesphere.io/description: his项目的数据库
spec:replicas: 1selector:matchLabels:app: mysql-histemplate:metadata:creationTimestamp: nulllabels:app: mysql-hisannotations:kubesphere.io/creator: dev-liukubesphere.io/imagepullsecrets: '{}'logging.kubesphere.io/logsidecar-config: '{}'spec:volumes:- name: host-timehostPath:path: /etc/localtimetype: ''containers:- name: container-91dh9aimage: 'mysql:5.7.35'ports:- name: tcp-3306containerPort: 3306protocol: TCP- name: tcp-33060containerPort: 33060protocol: TCPenv:- name: MYSQL_ROOT_PASSWORDvalue: Aa123456resources: {}volumeMounts:- name: host-timemountPath: /etc/localtime- name: mysql-hismountPath: /var/lib/mysqlterminationMessagePath: /dev/termination-logterminationMessagePolicy: FileimagePullPolicy: IfNotPresentsecurityContext:privileged: truerestartPolicy: AlwaysterminationGracePeriodSeconds: 30dnsPolicy: ClusterFirstserviceAccountName: defaultserviceAccount: defaultsecurityContext:runAsNonRoot: falseschedulerName: default-schedulervolumeClaimTemplates:- kind: PersistentVolumeClaimapiVersion: v1metadata:name: mysql-hisnamespace: hiscreationTimestamp: nullspec:accessModes:- ReadWriteOnceresources:requests:storage: 1GistorageClassName: nfs-storageclassvolumeMode: Filesystemstatus:phase: PendingserviceName: mysql-his-6kpepodManagementPolicy: OrderedReadyupdateStrategy:type: RollingUpdaterollingUpdate:partition: 0revisionHistoryLimit: 10

报错

#创建sts之后，pod启动报错，日志如下
[root@master01 ~]# kubectl  -n his  logs   mysql-his-0 
2023-10-05 15:41:02+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.35-1debian10 started.
chown: changing ownership of '/var/lib/mysql/': Operation not permitted
[root@master01 ~]#

解决办法

#测试使用docker启动mysql，可以正常启动
mysql -p  /my/own/datadir
docker run --name mysql -v /my/own/datadir:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=Aa123456 -d mysql:5.7.35#最后问题定位为后端存储nfs配置存在错误。
#查看nfs配置：
[root@master01 k8s]# cat /etc/exports
/data/k8s *(rw,sync)
#添加一个参数：
[root@master01 k8s]# cat /etc/exports
/data/k8s *(rw,sync,no_root_squash)
[root@master01 k8s]# exportfs -rv	#使配置立即生效，也可以systemctl reload nfs-server.service
#最后重新创建mysql pod，pod正常，问题解决