Skip to Content
0
Mar 15 at 05:48 PM

Kyma Lost Databases

179 Views Last edit Mar 15 at 06:04 PM 4 rev

With each update of kyma the databases cease to exist, causing a great inconvenience. 

Has anyone been through this? is the default storageclass the best alternative?

Are there other possible configurations?
    
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:52.813 UTC [4690] FATAL: database \"sales_force_db_teste\" does not exist","stream":"stderr","time":"2023-03-14T14:23:52.813242278Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:46.078 UTC [4689] FATAL: database \"sales_force_db_teste\" does not exist","stream":"stderr","time":"2023-03-14T14:23:46.079042305Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:40.594 UTC [4688] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:40.594712373Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:37.586 UTC [4687] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:37.58789053Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:34.575 UTC [4686] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:34.575120791Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:31.567 UTC [4685] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:31.567486737Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:28.558 UTC [4684] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:28.558880422Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:25.549 UTC [4683] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:25.549097789Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:22.540 UTC [4682] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:22.541105437Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:19.531 UTC [4681] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:19.531693001Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:23:16.521 UTC [4680] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:23:16.521311094Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:18:41.915 UTC [4674] FATAL: database \"sales_force_db_teste\" does not exist","stream":"stderr","time":"2023-03-14T14:18:41.915709622Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:18:34.923 UTC [4673] FATAL: database \"sales_force_db_teste\" does not exist","stream":"stderr","time":"2023-03-14T14:18:34.923583994Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:18:05.634 UTC [4672] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:18:05.634250332Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:18:02.626 UTC [4671] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:18:02.626367159Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:17:59.618 UTC [4670] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:17:59.618177769Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:17:56.610 UTC [4668] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:17:56.610892022Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:17:53.603 UTC [4667] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:17:53.603236246Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:17:50.596 UTC [4666] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:17:50.596286447Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:17:47.589 UTC [4665] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:17:47.590095299Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:17:44.584 UTC [4664] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:17:44.584283313Z"}
{"_p":"F","cluster_identifier":"api.c-71b475b.kyma.internal.live.k8s.ondemand.com","log":"2023-03-14 14:17:41.573 UTC [4663] FATAL: database \"schedules\" does not exist","stream":"stderr","time":"2023-03-14T14:17:41.57361979Z"}
kind: PersistentVolume
apiVersion: v1
metadata:
name: postgres-pvc-storage-default
labels:
type: local
spec:
storageClassName: default
capacity:
storage: 15Gi
accessModes:
- ReadWriteMany
hostPath:
path: "/mnt/data"
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
labels:
app: postgres
name: postgres-pvc-storage-default
namespace: default
spec:
accessModes:
- ReadWriteMany
storageClassName: default
resources:
requests:
storage: 15Gi

postgres service

apiVersion: apps/v1
kind: Deployment
metadata:
name: postgres
spec:
selector:
matchLabels:
app: postgres
replicas: 1
revisionHistoryLimit: 2 ### default is 10
template:
metadata:
labels:
app: postgres
spec:
containers:
- name: postgres
image: postgres:12.10
imagePullPolicy: "IfNotPresent"
ports:
- containerPort: 5432
env:
- name: POSTGRES_USER
valueFrom:
secretKeyRef:
name: postgres-secret
key: postgres-user
- name: POSTGRES_PASSWORD
valueFrom:
secretKeyRef:
name: postgres-secret
key: postgres-password
volumeMounts:
- mountPath: /var/lib/postgresql/data
name: postgresdb
volumes:
- name: postgresdb
persistentVolumeClaim:
claimName: postgres-pvc-storage-default
---
kind: Service
apiVersion: v1
metadata:
name: postgres-service
spec:
selector:
app: postgres
type: LoadBalancer
ports:
- protocol: TCP
port: 5432
targetPort: 5432


image.png

image.png

image.png

image.png

image.png

Are there other possible configurations?

Attachments

image.png (107.0 kB)
image.png (282.2 kB)
image.png (186.7 kB)
image.png (164.5 kB)
image.png (174.0 kB)