Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Постгре не переживает пересоздание пода #270

Closed
ksa75 opened this issue Dec 23, 2024 · 2 comments
Closed

Comments

@ksa75
Copy link

ksa75 commented Dec 23, 2024

kubectl -n datalens delete po pg-6864b55cd9-78hfw $fc
Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely.
pod "pg-6864b55cd9-78hfw" force deleted

kc -n datalens logs pg-dccfdf47f-qg2h9 -f
..
2024-12-23 15:43:30.722 UTC [1] LOG: database system is ready to accept connections
2024-12-23 15:43:34.794 UTC [65] ERROR: relation "collections" does not exist at character 218
2024-12-23 15:43:34.794 UTC [65] STATEMENT: select 'collection' as "type", null as "workbook_id", "collection_id", "title", "sort_title", "description", "parent_id", "project_id", "tenant_id", "created_by", "created_at", "updated_by", "updated_at", "meta" from "collections" where "tenant_id" = $1 and "project_id" is null and "deleted_at" is null and "parent_id" is null union all select 'workbook' as "type", "workbook_id", "collection_id", "title", "sort_title", "description", null as "parent_id", "project_id", "tenant_id", "created_by", "created_at", "updated_by", "updated_at", "meta" from "workbooks" where "tenant_id" = $2 and "project_id" is null and "collection_id" is null and "deleted_at" is null order by "type" asc, "created_at" desc limit $3
2024-12-23 15:43:36.915 UTC [65] ERROR: relation "collections" does not exist at character 218

cat values.yaml
versions:
ui: 0.2312.0
control: 0.2176.0
data: 0.2176.0
us: 0.260.0

database:
enabled: true
demo: false
storageClass: yc-network-ssd
version: 13
image: postgres:13-alpine
resources:
requests:
cpu: 250m
memory: 128Mi
limits:
cpu: 1000m
memory: 512Mi

ingress:
enabled: true
domain: datalens.apps.mks2.company.global
yc: false

registry: datalens-tech

application:
ui:
replicas: 1
image: null
resources:
requests:
cpu: 250m
memory: 256Mi
limits:
cpu: 1000m
memory: 512Mi
us:
replicas: 1
image: null
resources:
requests:
cpu: 500m
memory: 512Mi
limits:
cpu: 4
memory: 16Gi
control:
replicas: 1
image: null
resources:
requests:
cpu: 500m
memory: 1024Mi
limits:
cpu: 4
memory: 16Gi
data:
replicas: 1
image: null
resources:
requests:
cpu: 1000m
memory: 1024Mi
limits:
cpu: 4
memory: 16Gi

@ksa75 ksa75 closed this as completed Dec 24, 2024
@ksa75
Copy link
Author

ksa75 commented Dec 24, 2024

Использовали образ ванильного постгре postgres:16-alpine, а должны были ghcr.io/datalens-tech/postgres:16

@goshander
Copy link
Contributor

goshander commented Dec 24, 2024

@ksa75 приветствую, можете подсказать пожалуйста какую реализацию k8s вы используете?
На k3s и minikube не наблюдаю проблем с удалением пода pg


UPD: проблема решена

Из-за особенностей работы с локалью в alpine подойдет и любой ванильный образ postgres:16, главное не alpine - в нем нет модуля работы с локалью

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants