timescale can't start up due to /var/lib/postgresql/data not created about helm-charts HOT 6 CLOSED

chown -R 1000:1000 /data/timescaledb/wal/

Hi mate, where you put this code line? I have the same error.

from helm-charts.

well,when I chang to use ceph as storageClass,it can run successfully.Befor I use hostPath(not local volume in k8s 1.14) as static pv like below.

apiVersion: storage.k8s.io/v1
kind: StorageClass
metadata:
  name: timescaledb-data-local-volume
provisioner: kubernetes.io/no-provisioner
volumeBindingMode: WaitForFirstConsumer
reclaimPolicy: Retain
---
apiVersion: storage.k8s.io/v1
kind: StorageClass
metadata:
  name: timescaledb-wal-local-volume
provisioner: kubernetes.io/no-provisioner
volumeBindingMode: WaitForFirstConsumer
reclaimPolicy: Retain

apiVersion: v1
kind: PersistentVolume
metadata:
  name: timescaledb-data-vol-0
spec:
  capacity:
    storage: 200Gi
  accessModes:
    - ReadWriteOnce
  persistentVolumeReclaimPolicy: Retain
  nodeAffinity:
    required:
      nodeSelectorTerms:
        - matchExpressions:
            - key: "kubernetes.io/hostname"
              operator: In
              values:
                - "rh2-inf-kafka1"
  storageClassName: timescaledb-data-local-volume
  volumeMode: Filesystem
  hostPath:
    type: DirectoryOrCreate
    path: /data/timescaledb/data

....other pv like this

so dose this mean hostPath is not support,,for I must use local nvme ssd on host

from helm-charts.

I'm not sure why this is happening, the error message:

install: cannot change owner and permissions of ‘/var/lib/postgresql/data’: No such file or directory

Occurs because the user postgres cannot create that directory; However the StatefulSet explicitly mounts /var/lib/postgresql/data with the postgres user.

For the failing deploy, could you share the following output?

kubectl describe pod/<yourpod>

from helm-charts.

While thinking about the above, I think the problem is with the permissions on the directory of the HostPath. The Docker Image is run as a non-root user, which means the container cannot change ownership of directories.

For the dynamically provisioned Volumes (like your ceph volume), the following piece of code ensures correct ownership:

      securityContext:
        # The postgres user inside the TimescaleDB image has uid=1000.
        # This configuration ensures the permissions of the mounts are suitable
        fsGroup: 1000

https://github.com/timescale/timescaledb-kubernetes/blob/master/charts/timescaledb-single/templates/statefulset-timescaledb.yaml#L36-L39

For troubleshooting could you set the permissions of your HostPath to very liberally (even 0777) and see if that works?

If that solves the problem, the only thing you may need to change is the owner uid of the directory of the HostPath Volume.

from helm-charts.

Thanks for your replay.

Change peermissions to 0777 did not help,but after use command likechown -R 1000:1000 /data/timescaledb/wal/ did slove the problem.

from helm-charts.

chown -R 1000:1000 /data/timescaledb/wal/

Hi mate, where you put this code line? I have the same error.

Same here.. .where can you run that cmd. I tried to exec into the container, but it's not running

from helm-charts.