unkin/argocd-apps
3
0
Fork 0
Code Issues 7 Pull Requests 2 Actions Packages Projects Releases Wiki Activity

logging: set clickhouse readonly profile to readonly=2 #409

Merged
benvin merged 1 commits from benvin/ch-readonly2 into main 2026-08-23 22:36:53 +10:00
Conversation 0 Commits 1 Files Changed 1
+1 -1
unkin-agent commented 2026-08-23 22:05:54 +10:00
Member
Copy Link
Copy Source

Why

The readonly profile used by logreader sets readonly=1, which rejects any per-query settings change. HTTP clients (logviewer, chlog) send settings params like max_execution_time with their queries, so every query fails with Code: 164 DB::Exception: Cannot modify 'max_execution_time' setting in readonly mode — logviewer healthz returns 503 and CrashLoops, chlog queries fail. readonly=2 keeps data access read-only while permitting settings changes, which is what HTTP clients need.

Changes

  • Changes the readonly profile in apps/base/logging/clickhouseinstallation.yaml from readonly: "1" to readonly: "2"
## Why The `readonly` profile used by `logreader` sets `readonly=1`, which rejects any per-query settings change. HTTP clients (logviewer, chlog) send settings params like `max_execution_time` with their queries, so every query fails with `Code: 164 DB::Exception: Cannot modify 'max_execution_time' setting in readonly mode` — logviewer healthz returns 503 and CrashLoops, chlog queries fail. `readonly=2` keeps data access read-only while permitting settings changes, which is what HTTP clients need. ## Changes - Changes the `readonly` profile in `apps/base/logging/clickhouseinstallation.yaml` from `readonly: "1"` to `readonly: "2"`
unkin-agent added 1 commit 2026-08-23 22:05:54 +10:00
logging: set clickhouse readonly profile to readonly=2
ci/woodpecker/pr/vector-test Pipeline was successful
Details
ci/woodpecker/pr/pre-commit Pipeline was successful
Details
ci/woodpecker/pr/kubeconform Pipeline was successful
Details
9b20877518 
readonly=1 rejects any per-query settings change, so HTTP clients that
send settings params (logviewer, chlog) fail with Code 164. readonly=2
keeps data access read-only while permitting settings changes.
benvin merged commit 5a23146513 into main 2026-08-23 22:36:53 +10:00
benvin deleted branch benvin/ch-readonly2 2026-08-23 22:36:53 +10:00
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
benvin (BenVincent) unkin-agent (Unkin Agent) unkinben (Ben Vincent)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: unkin/argocd-apps#409
Delete Branch "benvin/ch-readonly2"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?