Skip to content

Migration to 2.0.0 fails to connect to Clickhouse when using IPv6 #3173

Description

@BeryJu

Past Issues Searched

  • I have searched open and closed issues to make sure that the bug has not yet been reported

Issue is a Bug Report

  • This is a bug report and not a feature request, nor asking for self-hosted support

Using official Plausible Cloud hosting or self-hosting?

Self-hosting

Describe the bug

When running bin/plausible rpc Plausible.DataMigration.NumericIDs.run when using IPv6 (having set ECTO_IPV6 and ECTO_CH_IPV6 to true), the migration fails:

~ $ bin/plausible rpc Plausible.DataMigration.NumericIDs.run
** (MatchError) no match of right hand side value: {:error, %DBConnection.ConnectionError{message: "connection not available and request was dropped from queue after 4000ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:\n\n  1. Ensuring your database is available and that you can connect to it\n  2. Tracking down slow queries and making sure they are running fast enough\n  3. Increasing the pool_size (although this increases resource consumption)\n  4. Allowing requests to wait longer by increasing :queue_target and :queue_interval\n\nSee DBConnection.start_link/2 for more information\n", severity: :error, reason: :queue_timeout}}
    lib/plausible/data_migration/numeric_ids.ex:6: Plausible.DataMigration.NumericIDs.do_run/2
    lib/plausible/data_migration/numeric_ids.ex:48: Plausible.DataMigration.NumericIDs.run/1
    nofile:1: (file)
    (stdlib 4.2) erl_eval.erl:748: :erl_eval.do_apply/7
    (elixir 1.14.3) lib/code.ex:425: Code.validated_eval_string/3
~ $

Expected behavior

The migration should work


Having a dig around https://github.com/plausible/analytics/blob/16846b16c8e513f72d7c23459ee879d9249f556d/lib/plausible/data_migration/repo.ex, when adding

transport_opts: [
  inet6: true,
]

on line 20, it does work (requires rebuilding the container)

Screenshots

No response

Environment

- OS: n/a
- Browser: n/a
- Browser Version: n/a

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions