Comments (1)
Found some ideas in backup repo, but this helm chart already defines CLICKHOUSE_HOST
Suggested solution is to set for backup clickhouse_host=127.0.0.1
I might "override" with clickhouse.backup.env, but which will stick, one in my values.yaml or from template?
- name: CLICKHOUSE_HOST
value: {{ template "posthog.clickhouse.fullname" . }}
{{/*
Return clickhouse fullname
*/}}
{{- define "posthog.clickhouse.fullname" -}}
{{- if .Values.clickhouse.fullnameOverride -}}
{{- .Values.clickhouse.fullnameOverride | trunc 63 | trimSuffix "-" -}}
{{- else -}}
{{- printf "%s-%s" "clickhouse" .Release.Name | trunc 63 | trimSuffix "-" -}}
{{- end -}}
{{- end -}}
Full error:
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,"(query: SELECT status,error FROM system.backup_actions WHERE command='create chi-posthog-posthog-0-0-full-2022-12-06-00-00-07')",2022-12-06T00:00:08.010052183Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Code: 60. DB::Exception: Received from chi-posthog-posthog-0-0:9000. DB::Exception: Table system.backup_actions doesn't exist. (UNKNOWN_TABLE),2022-12-06T00:00:08.010049713Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Received exception from server (version 22.3.13):,2022-12-06T00:00:08.010044266Z
2022-12-06T00:00:13.397274353Z,k8s_container,INFO,"SELECT status,error FROM system.backup_actions WHERE command='create chi-posthog-posthog-0-0-full-2022-12-06-00-00-07'",
2022-12-06T00:00:13.397274353Z,k8s_container,INFO,error create full-2022-12-06-00-00-07 on chi-posthog-posthog-0-0,2022-12-06T00:00:07.987132452Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,(query: SELECT status FROM system.backup_actions WHERE command='create chi-posthog-posthog-0-0-full-2022-12-06-00-00-07'),2022-12-06T00:00:07.983222708Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Code: 60. DB::Exception: Received from chi-posthog-posthog-0-0:9000. DB::Exception: Table system.backup_actions doesn't exist. (UNKNOWN_TABLE),2022-12-06T00:00:07.983220114Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Received exception from server (version 22.3.13):,2022-12-06T00:00:07.983211982Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,(query: SELECT status FROM system.backup_actions WHERE command='create chi-posthog-posthog-0-0-full-2022-12-06-00-00-07'),2022-12-06T00:00:07.956158568Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Code: 60. DB::Exception: Received from chi-posthog-posthog-0-0:9000. DB::Exception: Table system.backup_actions doesn't exist. (UNKNOWN_TABLE),2022-12-06T00:00:07.956155400Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Received exception from server (version 22.3.13):,2022-12-06T00:00:07.956141033Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,(query: INSERT INTO system.backup_actions(command) VALUES('create chi-posthog-posthog-0-0-full-2022-12-06-00-00-07')),2022-12-06T00:00:07.928767960Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Code: 60. DB::Exception: Received from chi-posthog-posthog-0-0:9000. DB::Exception: Table system.backup_actions doesn't exist. (UNKNOWN_TABLE),2022-12-06T00:00:07.928764402Z
2022-12-06T00:00:13.393621223Z,k8s_container,ERROR,Received exception from server (version 22.3.13):,2022-12-06T00:00:07.928755742Z
2022-12-06T00:00:13.397274353Z,k8s_container,INFO,INSERT INTO system.backup_actions(command) VALUES('create chi-posthog-posthog-0-0-full-2022-12-06-00-00-07'),2022-12-06T00:00:07.927824877Z
2022-12-06T00:00:13.397274353Z,k8s_container,INFO,create full-2022-12-06-00-00-07 on chi-posthog-posthog-0-0,2022-12-06T00:00:07.904611353Z
from charts-clickhouse.
Related Issues (20)
- Cleanup old `posthog-grafana-annotation` jobs
- Add additional configuration to externalKafka
- Read-only tables in clickhouse
- CI - Ingress: validate traffic routing
- Alertmanager - switch `RedisTooManyConnections` to be % based
- Support nodeSelector, tolerations, affinity for "events" HOT 1
- Plugin server is not starting
- Unable to change clickhouse log level
- Trying to install second instance HOT 3
- Only 23.5.1 available for Helm Chart for k8 HOT 1
- Support for external Grafana HOT 3
- External Zookeeper seems ignored - references built-in
- Support GCP CloudSQL Proxy for connecting to Postgres database in GCP deployment HOT 1
- Migration failed to run HOT 1
- Service does not have load balancer ingress IP address: posthog/posthog-ingress-nginx-controller HOT 3
- Add slow lane consumer for ingestion
- Bump version of kafka
- Kafka error: 'posthog' is not in the form of topic-partition or topic-partition.uniqueId-delete (if marked for deletion). HOT 1
- Unable to reset password using SMTP.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from charts-clickhouse.