TeslaMate Version 2.2.0 Fails to Start After Postgres Restore #5035

hugocosta99 · 2025-11-14T10:45:19Z

hugocosta99
Nov 14, 2025

Hi all,

I'm new here and first of all I would like to say thank you for this project and for the community's support. Keep up the excellent work! 😉

I have some issues when I try to update my TeslaMate container to version 2.2.0 after restoring a Postgres 18-trixie backup. The same happens if I use other Postgres version 17-trixe for example but only after restore...

Version 2.2.0 works fine on an empty database (DB), but it crashes after the restore. See the logs below/here:

(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3

(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 20:00:02.444 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 20:00:02.443 [info] schema "private" already exists, skipping
2025-11-11 20:00:02.442 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 20:00:02.433 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:59:41.931 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:59:41.931 [info] schema "private" already exists, skipping
2025-11-11 19:59:41.929 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:59:41.915 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:59:25.493 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:59:25.493 [info] schema "private" already exists, skipping
2025-11-11 19:59:25.491 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:59:25.483 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:59:03.203 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:59:03.203 [info] schema "private" already exists, skipping
2025-11-11 19:59:03.202 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:59:03.192 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:58:42.892 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:58:42.892 [info] schema "private" already exists, skipping
2025-11-11 19:58:42.891 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:58:42.883 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:58:27.321 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:58:27.321 [info] schema "private" already exists, skipping
2025-11-11 19:58:27.320 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:58:27.313 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:58:15.477 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:58:15.477 [info] schema "private" already exists, skipping
2025-11-11 19:58:15.475 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:58:15.468 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:58:03.258 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:58:03.258 [info] schema "private" already exists, skipping
2025-11-11 19:58:03.257 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:58:03.247 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
(elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
2025-11-11 19:57:50.489 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
2025-11-11 19:57:50.489 [info] schema "private" already exists, skipping
2025-11-11 19:57:50.073 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
2025-11-11 19:57:50.064 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
waiting for postgres at database:5432

The same restore works fine on the previous Container version 2.1.1.

I followed the steps in the documentation step by step: https://docs.teslamate.org/docs/maintenance/backup_restore.

I'm not an expert and I'm wondering why it didn't work with version 2.2.0.

Any suggestions? Thanks a lot in advance.

Answered by hugocosta99

Nov 15, 2025

I think I figured it out. I deleted the 'private' table with the command "DROP SCHEMA private CASCADE;" after the restore. It's working fine with the Teslamate container version 2.2.0."

Excellent. Thanks, guys, for your help! ;)

View full answer

mtuan293 · 2025-11-14T20:56:34Z

mtuan293
Nov 14, 2025

I might also encounter the same issue, upgrading from 1.31.1 straight to 2.2.0.
Here's my log:

teslamate logs

ubuntu@my-server:~/TeslaMate$ sudo docker ps -a
CONTAINER ID   IMAGE                        COMMAND                  CREATED          STATUS                         PORTS                                                                                                                   NAMES
3ba9397ee858   teslamate/teslamate:latest   "tini -- /bin/dash /…"   20 minutes ago   Restarting (1) 9 seconds ago                                                                                                                           teslamate-teslamate-1
010bc4184999   postgres:18-trixie           "docker-entrypoint.s…"   20 minutes ago   Up 20 minutes                  5432/tcp                                                                                                                teslamate-database-1
2f3666beae35   teslamate/grafana:latest     "/run.sh"                20 minutes ago   Up 20 minutes                  3000/tcp                                                                                                                teslamate-grafana-1
0375e87297d3   eclipse-mosquitto:2          "/docker-entrypoint.…"   20 minutes ago   Up 20 minutes                  127.0.0.1:1883->1883/tcp                                                                                                teslamate-mosquitto-1
b96cd0023e34   traefik:v3.6.1               "/entrypoint.sh --gl…"   20 minutes ago   Up 20 minutes                  0.0.0.0:80->80/tcp, [::]:80->80/tcp, 0.0.0.0:443->443/tcp, [::]:443->443/tcp, 0.0.0.0:443->443/udp, [::]:443->443/udp   teslamate-proxy-1
ubuntu@my-server:~/TeslaMate$
ubuntu@my-server:~/TeslaMate$ sudo docker compose logs teslamate
teslamate-1  | 2025-11-14 01:34:52.217 [info] == Running 20250407155134 TeslaMate.Repo.Migrations.UpgradeEarthdistance.change/0 forward
teslamate-1  | 2025-11-14 01:34:52.220 [info] execute "ALTER EXTENSION earthdistance UPDATE"
teslamate-1  | 2025-11-14 01:34:52.220 [info] version "1.2" of extension "earthdistance" is already installed
teslamate-1  | 2025-11-14 01:34:52.221 [info] == Migrated 20250407155134 in 0.0s
teslamate-1  | 2025-11-14 01:34:52.253 [info] == Running 20250613133700 TeslaMate.Repo.Migrations.AddAndCalculateElevationChanges.up/0 forward
teslamate-1  | 2025-11-14 01:34:52.253 [info] alter table drives
teslamate-1  | 2025-11-14 01:34:52.254 [info] execute "WITH elevation_changes AS (\n  SELECT\n    drive_id,\n    COALESCE(NULLIF(LEAST(SUM(CASE WHEN elevation_diff > 0 THEN elevation_diff ELSE 0 END), 32768), 32768), 0) as ascent,\n    COALESCE(NULLIF(LEAST(SUM(CASE WHEN elevation_diff < 0 THEN ABS(elevation_diff) ELSE 0 END), 32768), 32768), 0) as descent\n  FROM (\n    SELECT\n      drive_id,\n      elevation - LAG(elevation) OVER (PARTITION BY drive_id ORDER BY date) as elevation_diff\n    FROM positions\n    WHERE elevation IS NOT NULL\n  ) as changes\n  GROUP BY drive_id\n)\nUPDATE drives d\nSET\n  ascent = ec.ascent,\n  descent = ec.descent\nFROM elevation_changes ec\nWHERE d.id = ec.drive_id;\n"
teslamate-1  | 2025-11-14 01:34:56.963 [info] == Migrated 20250613133700 in 4.7s
teslamate-1  | 2025-11-14 01:34:56.966 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:34:56.966 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:34:56.966 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:34:56.966 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:34:57.973 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:34:57.976 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:34:57.976 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:34:57.976 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:34:59.052 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:34:59.054 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:34:59.054 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:34:59.054 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:35:00.349 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:35:00.351 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:35:00.352 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:35:00.352 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:35:02.048 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:35:02.050 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:35:02.051 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:35:02.051 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:35:04.547 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:35:04.549 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:35:04.550 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:35:04.550 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:35:08.658 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:35:08.661 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:35:08.661 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:35:08.661 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:35:16.002 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:35:16.005 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:35:16.005 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:35:16.005 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:35:29.710 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:35:29.712 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:35:29.713 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:35:29.713 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:35:56.220 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:35:56.223 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:35:56.223 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:35:56.223 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:36:48.362 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:36:48.364 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:36:48.365 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:36:48.365 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:37:49.353 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:37:49.356 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:37:49.357 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:37:49.357 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:38:50.279 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:38:50.282 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:38:50.282 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:38:50.282 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:39:51.168 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:39:51.171 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:39:51.171 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:39:51.171 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:40:52.112 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:40:52.114 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:40:52.115 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:40:52.115 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:41:53.050 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:41:53.052 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:41:53.052 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:41:53.052 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:42:53.950 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:42:53.953 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:42:53.953 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:42:53.953 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:43:54.942 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:43:54.945 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:43:54.946 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:43:54.946 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:44:55.928 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:44:55.931 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:44:55.931 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:44:55.931 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:45:56.899 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:45:56.902 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:45:56.902 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:45:56.902 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:46:57.830 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:46:57.832 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:46:57.833 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:46:57.833 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:47:58.730 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:47:58.733 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:47:58.733 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:47:58.733 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:48:59.652 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:48:59.654 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:48:59.655 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:48:59.655 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:35.100 [info] == Running 20250407155134 TeslaMate.Repo.Migrations.UpgradeEarthdistance.change/0 forward
teslamate-1  | 2025-11-14 01:52:35.108 [info] execute "ALTER EXTENSION earthdistance UPDATE"
teslamate-1  | 2025-11-14 01:52:35.109 [info] version "1.2" of extension "earthdistance" is already installed
teslamate-1  | 2025-11-14 01:52:35.110 [info] == Migrated 20250407155134 in 0.0s
teslamate-1  | 2025-11-14 01:52:35.146 [info] == Running 20250613133700 TeslaMate.Repo.Migrations.AddAndCalculateElevationChanges.up/0 forward
teslamate-1  | 2025-11-14 01:52:35.146 [info] alter table drives
teslamate-1  | 2025-11-14 01:52:35.147 [info] execute "WITH elevation_changes AS (\n  SELECT\n    drive_id,\n    COALESCE(NULLIF(LEAST(SUM(CASE WHEN elevation_diff > 0 THEN elevation_diff ELSE 0 END), 32768), 32768), 0) as ascent,\n    COALESCE(NULLIF(LEAST(SUM(CASE WHEN elevation_diff < 0 THEN ABS(elevation_diff) ELSE 0 END), 32768), 32768), 0) as descent\n  FROM (\n    SELECT\n      drive_id,\n      elevation - LAG(elevation) OVER (PARTITION BY drive_id ORDER BY date) as elevation_diff\n    FROM positions\n    WHERE elevation IS NOT NULL\n  ) as changes\n  GROUP BY drive_id\n)\nUPDATE drives d\nSET\n  ascent = ec.ascent,\n  descent = ec.descent\nFROM elevation_changes ec\nWHERE d.id = ec.drive_id;\n"
teslamate-1  | 2025-11-14 01:52:40.083 [info] == Migrated 20250613133700 in 4.9s
teslamate-1  | 2025-11-14 01:52:40.087 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:40.087 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:40.087 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:40.087 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:41.678 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:41.680 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:41.681 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:41.681 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:42.848 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:42.850 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:42.851 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:42.851 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:44.178 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:44.181 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:44.181 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:44.181 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:45.934 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:45.936 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:45.937 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:45.937 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:48.483 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:48.485 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:48.486 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:48.486 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:52.630 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:52.633 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:52.633 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:52.633 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:52:59.965 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:52:59.968 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:52:59.968 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:52:59.968 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:53:13.675 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:53:13.678 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:53:13.678 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:53:13.678 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:53:40.177 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:53:40.180 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:53:40.180 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:53:40.180 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:54:32.273 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:54:32.275 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:54:32.276 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:54:32.276 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
teslamate-1  | 2025-11-14 01:55:33.207 [info] == Running 20250924215353 TeslaMate.Repo.Migrations.CreatePrivateSchema.up/0 forward
teslamate-1  | 2025-11-14 01:55:33.210 [info] execute "CREATE SCHEMA IF NOT EXISTS private;"
teslamate-1  | 2025-11-14 01:55:33.210 [info] schema "private" already exists, skipping
teslamate-1  | 2025-11-14 01:55:33.210 [info] execute "ALTER TABLE public.tokens SET SCHEMA private;"
teslamate-1  | ** (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1098: Ecto.Adapters.SQL.raise_sql_call_error/1
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/adapters/sql.ex:1219: Ecto.Adapters.SQL.execute_ddl/4
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:348: Ecto.Migration.Runner.log_and_execute_ddl/3
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (elixir 1.18.4) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
teslamate-1  |     (ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3
ubuntu@my-server:~/TeslaMate$

0 replies

brianmay · 2025-11-14T20:57:15Z

brianmay
Nov 14, 2025
Collaborator

Somehow you have both a public.tokens table and a private.tokens table. Which is a bit weird, because moving it over is an atomic operation.

Oh, I wonder if you haven't emptied the database successfully between runs. Yep. That would explain it.

The instructions only talk about dropping/recreating the public schema, not the private schema. As such when you run the migration the table will already exist in the private schema, hence the error.

I think the instructions need to be amended to tell you to delete the private schema as well as the public schema.

DROP SCHEMA private CASCADE;
CREATE SCHEMA private;

The extensions are not required for the private schema.

4 replies

mtuan293 Nov 14, 2025

Somehow you have both a public.tokens table and a private.tokens table. Which is a bit weird, because moving it over is an atomic operation.

Oh, I wonder if you haven't emptied the database successfully between runs. Yep. That would explain it.

The instructions only talk about dropping/recreating the public schema, not the private schema. As such when you run the migration the table will already exist in the private schema, hence the error.

I think the instructions need to be amended to tell you to delete the private schema as well as the public schema.
DROP SCHEMA private CASCADE;
CREATE SCHEMA private;
The extensions are not required for the private schema.

Looks like my log also said something about private and public schema. Can you explain a bit more on what does this do? Storing the Tesla API token?

brianmay Nov 14, 2025
Collaborator

In Postgresql; the terminology is a bit weird. Not sure why they call it "schema", to me I think of something like a json values schema which is a very different thing.

Each database can have one/more schemas. Generally you would only use one schema "public". Each schema can have one or more tables.

Previously Teslamate would store all tables in the "public" schema. But this makes it hard to setup Grafana to not have access to the tokens table. Grafana does not need access to the Token and should not have access to the Token.

We tried to address this by encrypting the token. Encrypting the token is a good idea, and still is. Encrypting the token protects database backups. But obviously it is restricted by how good the secret is. And keeping the secret secret.

This change to Teslamate moves the token secret to the "private" schema. By itself, this gains absolutely nothing. But now it is possible to create a new Grafana role that has read-only access to only the public schema. Meaning Grafana is no longer able to access the token, and adds an additional layer of security. It also means you can ensure Grafana cannot make changes to the teslamate data.

What still needs to be done is to document how to setup this new read only Grafana role. This needs to be done with care, otherwise you might break the existing teslamate user (shouldn't be an issue, normally it is admin) and/or allow the grafana role access to stuff (like the tokens) is does not need to be able to access.

And it seems the instructions also need to be updated to reflect that you now have to delete the private schema before restoring from the database.

hugocosta99 Nov 14, 2025
Author

Somehow you have both a public.tokens table and a private.tokens table. Which is a bit weird, because moving it over is an atomic operation.

Oh, I wonder if you haven't emptied the database successfully between runs. Yep. That would explain it.

The instructions only talk about dropping/recreating the public schema, not the private schema. As such when you run the migration the table will already exist in the private schema, hence the error.

I think the instructions need to be amended to tell you to delete the private schema as well as the public schema.
DROP SCHEMA private CASCADE;
CREATE SCHEMA private;
The extensions are not required for the private schema.

Hello Brian,

Thanks a lot for your reply and explanation. I did as you said and it still didn't work.

I ran these commands before I proceeded to the restore:

DROP SCHEMA public CASCADE;
DROP SCHEMA private CASCADE;
CREATE SCHEMA public;
CREATE SCHEMA private;
CREATE EXTENSION cube WITH SCHEMA public;
CREATE EXTENSION earthdistance WITH SCHEMA public;

The restore works without errors, but I still can't get it to work. Logs are still showing: " (Postgrex.Error) ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"

It's a little bit weird because it works fine with version 2.1.1.

Do you have any other ideas? :)

mtuan293 Nov 15, 2025

Do you have any other ideas? :)

Well I have been experimenting in the past few days. I'm just upgrading one version after another. From 1.31.1 to 1.32 to 1.33... and so on. The database seems to be working so far on 2.2.0.
Just docker compose down, update the docker-compose.yml file, then docker compose pull and bring it back up with docker compose up -d. Rinse and repeat.

hugocosta99 · 2025-11-15T12:21:51Z

hugocosta99
Nov 15, 2025
Author

I think I figured it out. I deleted the 'private' table with the command "DROP SCHEMA private CASCADE;" after the restore. It's working fine with the Teslamate container version 2.2.0."

Excellent. Thanks, guys, for your help! ;)

7 replies

mtuan293 Nov 15, 2025

so this got me curious, did this change happen recently, or just how TeslaMate's database always has been? Like I said I tried going one by one each version and that seemed to migrate data just...fine? Compared to going straight from 1.31.1 to 2.2.0 that would give me errors about private schema thing.

hugocosta99 Nov 15, 2025
Author

so this got me curious, did this change happen recently, or just how TeslaMate's database always has been? Like I said I tried going one by one each version and that seemed to migrate data just...fine? Compared to going straight from 1.31.1 to 2.2.0 that would give me errors about private schema thing.

Until Version 2.1.1, it worked fine without issues.
I'm not sure if Teslamate Version 2.2.0 works differently, but it failed because I had both tables after the restore.
That's why I had to delete the private one, and after I started the container, it created a private one itself.
I don't know if that answered your question.

mtuan293 Nov 15, 2025

so this got me curious, did this change happen recently, or just how TeslaMate's database always has been? Like I said I tried going one by one each version and that seemed to migrate data just...fine? Compared to going straight from 1.31.1 to 2.2.0 that would give me errors about private schema thing.

Until Version 2.1.1, it worked fine without issues. I'm not sure if Teslamate Version 2.2.0 works differently, but it failed because I had both tables after the restore. That's why I had to delete the private one, and after I started the container, it created a private one itself. I don't know if that answered your question.

May I ask what version were you upgrading from? My database backup is from v1.31.1 that also gives me the same issue 🤔

JakobLichterfeld Nov 15, 2025
Maintainer

so this got me curious, did this change happen recently, or just how TeslaMate's database always has been?

Introduced in #4968 -> 2.2.0

hugocosta99 Nov 15, 2025
Author

so this got me curious, did this change happen recently, or just how TeslaMate's database always has been? Like I said I tried going one by one each version and that seemed to migrate data just...fine? Compared to going straight from 1.31.1 to 2.2.0 that would give me errors about private schema thing.

Until Version 2.1.1, it worked fine without issues. I'm not sure if Teslamate Version 2.2.0 works differently, but it failed because I had both tables after the restore. That's why I had to delete the private one, and after I started the container, it created a private one itself. I don't know if that answered your question.

May I ask what version were you upgrading from? My database backup is from v1.31.1 that also gives me the same issue 🤔

I upgraded from Version 2.1.1 and the database from 17-trixie to 18-trixie.

mtuan293 · 2025-11-22T20:31:38Z

mtuan293
Nov 22, 2025

Came back here to say I just updated from v2.1.1 to v2.2.0 without issues. My process was:

Had a database backup file from v1.31.1.
Cleaned everything Docker, pruned all volumes and images, effectively first time clean install of TeslaMate.
Deployed TeslaMate v2.1.1, by changing the docker-compose.yml at these two teslamate/teslamate:2.1 and teslamate/grafana:2.1. Note: I'm using postgres:18-trixie, so basically everything is identical to the current Advanced Guide (except for the v2.1.1).
Restored the database as in Docs. Everything worked fine at this point.
Updated to v2.2.0 by changing back teslamate/teslamate:latest and teslamate/grafana:latest and did a docker compose pull (I also did compose down then compose up -d).

I'm using the latest Docker Engine v29 from https://docs.docker.com/engine/install/ubuntu/

0 replies

miRUAcleInjoker · 2025-11-24T01:37:27Z

miRUAcleInjoker
Nov 24, 2025

I ran into the same issue and finally figured out the root cause.
In my case the problem was caused by starting all containers too early during the PostgreSQL major version upgrade.

According to the official docs, after recreating the Postgres container you should only start the database container first:

docker compose up -d database

However, I mistakenly ran:

docker compose up -d

This started Teslamate before restoring the backup, and the first launch of Teslamate 2.2.0 automatically created the new private schema and the private.tokens table.
Later, when I restored my old backup (which still contained public.tokens), the database ended up with both tables, and the migration failed with:

ERROR 42P07 (duplicate_table) relation "tokens" already exists in schema "private"

To fix it, I redid the upgrade process following the docs exactly:

Stop all containers

Remove the Postgres volume:

docker volume rm "$(basename "$PWD")_teslamate-db"

Start only the Postgres container:
```
docker compose up -d database
```
Restore the backup
Start the rest of the stack normally

After doing this, Teslamate started correctly and all migrations completed without errors.

Hope this helps anyone who hits the same problem!

2 replies

mtuan293 Nov 24, 2025

I kinda did similar to yours. Started fresh at 2.1.1 with docker compose up -d then docker compose down. At this point I did docker compose up -d database and proceeded to restore the database file from 1.31.1. Wait a minute, then docker compose down. Now docker compose up -d to start the whole stack.
After all of this I just updated 2.1.1 to 2.2.0 and no issues ¯\_(ツ)_/¯

JakobLichterfeld Nov 24, 2025
Maintainer

According to the official docs,

You mean TeslaMate official dos, right https://docs.teslamate.org/docs/maintenance/upgrading_postgres as it clearly states in

Change the postgres version and ensure your volume mount is configured correctly in docker-compose.yml and start the container ... docker compose up -d database

suuuch · 2025-12-04T12:14:56Z

suuuch
Dec 4, 2025

try add a depends_on in the docker-compose.yml

the teslamate service look like this.

  teslamate:
    image: teslamate/teslamate:latest
    restart: always
    environment:
      - ENCRYPTION_KEY=<you_key>
      - DATABASE_USER=teslamate
      - DATABASE_PASS=<password>
      - DATABASE_NAME=teslamate
      - DATABASE_HOST=database
      - MQTT_HOST=mosquitto
    ports:
      - 4000:4000
    volumes:
      - ./import:/opt/app/import
    cap_drop:
      - all
    depends_on:
      database:
        condition: service_started
      mosquitto:
        condition: service_started

1 reply

hugocosta99 Dec 4, 2025
Author

Thank's a lot ;) it makes sense.
I'll try it

thkrmr · 2025-12-27T11:13:58Z

thkrmr
Dec 27, 2025

Since I have the stack deployed via Portainer, I went ahead, created a psql dump, stopped the containers, removed the db volume, updated the stack definition in the UI, started the stack, all services came up.

I then (prematurely) proceeded with the restore and I ran into the same error, token table already exists.

Docs then say before restore

# Stop the teslamate container to avoid write conflicts
docker compose stop teslamate

I missed the detail where it said docker compose up -d database on the upgrading postgres page, since I already was reading the backup restore page and then to proceed with restore.

I think the docs contradict themselves a bit, it says to compose down everything on the upgrading postgres page, but in the backup restore page (which is separate to the upgrading postgres page), it says to stop the teslamate service, implying it was running before - but it shouldn't have been. Should've made sure teslamate doesn't start unless the restore is done.

And since there's no easy way to bring a single service (database in this instance) via the Portainer UI, adding

DROP SCHEMA private CASCADE;
CREATE SCHEMA private;

Before restoring the dump (in addition to the public schema creation) seems to do the trick.

In my case correct order of events would've been
Dump db → stop containers → rm db volume → edit compose file → update stack in Portainer and wait for all services to come up healthy → stop teslamate service → add drop/create private table to restore procedure → restore db dump → start teslamate service

0 replies

TeslaMate Version 2.2.0 Fails to Start After Postgres Restore #5035

Uh oh!

(ecto_sql 3.13.2) lib/ecto/migration/runner.ex:311: Ecto.Migration.Runner.perform_operation/3

Replies: 7 comments · 14 replies

Uh oh!

Uh oh!

brianmay Nov 14, 2025 Collaborator

Uh oh!

Uh oh!

brianmay Nov 14, 2025 Collaborator

Uh oh!

hugocosta99 Nov 14, 2025 Author

Uh oh!

Uh oh!

Uh oh!

hugocosta99 Nov 15, 2025 Author

Uh oh!

Uh oh!

hugocosta99 Nov 15, 2025 Author

Uh oh!

Uh oh!

JakobLichterfeld Nov 15, 2025 Maintainer

Uh oh!

hugocosta99 Nov 15, 2025 Author

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

JakobLichterfeld Nov 24, 2025 Maintainer

Uh oh!

Uh oh!

hugocosta99 Dec 4, 2025 Author

Uh oh!

Replies: 7 comments 14 replies

brianmay
Nov 14, 2025
Collaborator

brianmay Nov 14, 2025
Collaborator

hugocosta99 Nov 14, 2025
Author

hugocosta99
Nov 15, 2025
Author

hugocosta99 Nov 15, 2025
Author

JakobLichterfeld Nov 15, 2025
Maintainer

hugocosta99 Nov 15, 2025
Author

JakobLichterfeld Nov 24, 2025
Maintainer

hugocosta99 Dec 4, 2025
Author