Skip to content

snuba tries to connect to clickhouse with default user for some requests, ignoring the settings #7321

@stinker-max

Description

@stinker-max

Environment

Self-hosted sentry deployed via helm-chart in kubernetes v1.27.16
I tried two versions of sentry, the problem is on both:

sentry: 24.8.0, helm-chart: 25.20.0, external clickhouse: 23.8.11.28
sentry: 25.4.0, helm-chart: 26.17.1, external clickhouse: 23.9.6.20

Steps to Reproduce

  1. I had sentry version 23.11.0 deployed and everything was working correctly.
    The following chart parameters were filled in for the clickhouse:

externalClickhouse:
host: "load-balancer-host"
tcpPort: 9001
httpPort: 8123
username: snuba
password: "password"
database: default
singleNode: false
clusterName: snt

  1. Updated sentry to 24.8.0. All migrations were performed correctly and the service started working

The error occurs due to the prohibition of connection from external hosts under default user in clickhouse.

Expected Result

There should be no mistake. Snuba connects correctly to the clickhouse under the user from the settings.

Actual Result

Some web pages stopped opening with internal error 500 (issue example).
I found the request uri in the browser in dev tools:
https://sentry.example.ru/api/0/organizations/our-org/issues/
In the logs of the snuba api:
snuba.clickhouse.errors.ClickhouseError: DB::Exception: Received from node.clickhouse:9000. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name.

Metadata

Metadata

Assignees

No one assigned
    No fields configured for issues without a type.

    Projects

    Status

    Waiting for: Product Owner

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions