(Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE)

[jonaski]

I'm having the following error when running /entrypoint.sh db createdb:

Loading plausible..
Starting dependencies..
Starting repos..
08:03:03.741 [error] Ch.Connection (#PID<0.156.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.11.1.2557 (official build))

08:03:03.741 [error] Ch.Connection (#PID<0.157.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.11.1.2557 (official build))

08:03:05.141 [error] Ch.Connection (#PID<0.156.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.11.1.2557 (official build))

08:03:05.905 [error] Ch.Connection (#PID<0.157.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.11.1.2557 (official build))

** (MatchError) no match of right hand side value: {:error, {:error, %DBConnection.ConnectionError{message: "connection not available and request was dropped from queue after 2996ms. 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}}}
    (plausible 0.0.1) lib/plausible_release.ex:148: anonymous fn/2 in Plausible.Release.createdb/1
    (elixir 1.17.1) lib/enum.ex:2531: Enum."-reduce/3-lists^foldl/2-0-"/3
    (plausible 0.0.1) lib/plausible_release.ex:147: Plausible.Release.createdb/1
    nofile:1: (file)
    (stdlib 6.0) erl_eval.erl:904: :erl_eval.do_apply/7

I've tried to create the database and table manually with.:

clickhouse-server-85558895dc-ggksq :) create database plausible_events_db;

CREATE DATABASE plausible_events_db

Query id: 6e3ba74d-794c-47c5-8bda-d07025216c83

Ok.

0 rows in set. Elapsed: 0.015 sec. 

CREATE TABLE plausible_events_db.schema_migrations
(
    `version` Int64,
    `inserted_at` DateTime
)
ENGINE = TinyLog

But I'm still seeing errors:

Loading plausible..
Starting dependencies..
Starting repos..
** (MatchError) no match of right hand side value: {:error, {:error, %DBConnection.ConnectionError{message: "connection not available and request was dropped from queue after 2996ms. 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}}}
    (plausible 0.0.1) lib/plausible_release.ex:148: anonymous fn/2 in Plausible.Release.createdb/1
    (elixir 1.17.1) lib/enum.ex:2531: Enum."-reduce/3-lists^foldl/2-0-"/3
    (plausible 0.0.1) lib/plausible_release.ex:147: Plausible.Release.createdb/1
    nofile:1: (file)
    (stdlib 6.0) erl_eval.erl:904: :erl_eval.do_apply/7

On entrypoint.sh db migrate:

Loading plausible..
Starting dependencies..
Starting repos..
08:14:05.244 [error] Could not create schema migrations table. This error usually happens due to the following:

  * The database does not exist
  * The "schema_migrations" table, which Ecto uses for managing
    migrations, was defined by another library
  * There is a deadlock while migrating (such as using concurrent
    indexes with a migration_lock)

To fix the first issue, run "mix ecto.create" for the desired MIX_ENV.

To address the second, you can run "mix ecto.drop" followed by
"mix ecto.create", both for the desired MIX_ENV. Alternatively you may
configure Ecto to use another table and/or repository for managing
migrations:

    config :plausible, Plausible.Repo,
      migration_source: "some_other_table_for_schema_migrations",
      migration_repo: AnotherRepoForSchemaMigrations

The full error report is shown below.

** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 2950ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:

  1. Ensuring your database is available and that you can connect to it
  2. Tracking down slow queries and making sure they are running fast enough
  3. Increasing the pool_size (although this increases resource consumption)
  4. Allowing requests to wait longer by increasing :queue_target and :queue_interval

See DBConnection.start_link/2 for more information

    (ecto_sql 3.12.0) lib/ecto/adapters/sql.ex:1078: Ecto.Adapters.SQL.raise_sql_call_error/1
    (elixir 1.17.1) lib/enum.ex:1703: Enum."-map/2-lists^map/1-1-"/2
    (ecto_sql 3.12.0) lib/ecto/adapters/sql.ex:1185: Ecto.Adapters.SQL.execute_ddl/4
    (ecto_sql 3.12.0) lib/ecto/migrator.ex:779: Ecto.Migrator.verbose_schema_migration/3
    (ecto_sql 3.12.0) lib/ecto/migrator.ex:563: Ecto.Migrator.lock_for_migrations/4
    (ecto_sql 3.12.0) lib/ecto/migrator.ex:485: Ecto.Migrator.migrations/3
    (plausible 0.0.1) lib/plausible_release.ex:97: anonymous fn/1 in Plausible.Release.all_pending_migrations/1
    nofile:1: (file)

On /entrypoint.sh run:

{exit,terminating,[{application_controller,call,2,[{file,"application_controller.erl"},{line,511}]},{application,enqueue_or_start,6,[{file,"application.erl"},{line,380}]},{application,ensure_all_started,3,[{file,"application.erl"},{line,359}]},{elixir,start_cli,0,[{file,"src/elixir.erl"},{line,195}]},{init,start_it,1,[]},{init,start_em,1,[]},{init,do_boot,3,[]}]}
Runtime terminating during boot (terminating)
2024-12-18T08:14:17.528474091Z

I got one instance running in another cluster with pretty much the same configuration, but I'm still not getting this one to work.

[jonaski]

This was postgresql related too.