unkin-agent 5a23146513 logging: set clickhouse readonly profile to readonly=2 (#409) ...

## 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"`

Reviewed-on: #409
Co-authored-by: unkin-agent <unkin-agent@unkin.net>
Co-committed-by: unkin-agent <unkin-agent@unkin.net>

2026-08-23 22:36:52 +10:00

..

base

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

2026-08-23 22:36:52 +10:00

overlays/au-syd1

Scrape traefik gateway metrics into VictoriaMetrics (#397)

2026-08-23 12:41:58 +10:00