Updated to 2.1.1 from 2.0.0; getting errors about a missing table in the DB

[perfectly-preserved-pie]

2024-06-13T20:02:29.892160901Z ** (Ch.Error) Code: 16. DB::Exception: No such column revenue_source_amount in table plausible_events_db.events_v2 (1a342a0e-6b7d-43b4-b6d9-9d8876844653). (NO_SUCH_COLUMN_IN_TABLE) (version 24.3.3.102 (official build))

2024-06-13T20:02:29.892172219Z 

2024-06-13T20:02:29.892184878Z     (ecto_sql 3.11.1) lib/ecto/adapters/sql.ex:1054: Ecto.Adapters.SQL.raise_sql_call_error/1

2024-06-13T20:02:29.892193601Z     (stdlib 5.2) gen_server.erl:1143: :gen_server.try_terminate/3

2024-06-13T20:02:29.892217688Z     (stdlib 5.2) gen_server.erl:1339: :gen_server.terminate/10

2024-06-13T20:02:29.892225275Z     (stdlib 5.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

docker-compose.yml

version: "3.3"
services:
  mail:
    hostname: plausible_smtp
    image: bytemark/smtp
    restart: always

  plausible_db:
    hostname: plausible_postgres
    # supported versions are 12, 13, and 14
    image: postgres:12-alpine
    restart: always
    volumes:
       - /appdata/plausible/postgres/db-data:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=redacted

  plausible_events_db:
    hostname: plausible_clickhouse
    image: clickhouse/clickhouse-server:24.3.3.102-alpine
    restart: always
    volumes:
      - /appdata/plausible/clickhouse/event-data:/var/lib/clickhouse
      - /appdata/plausible/clickhouse/logs:/var/log/clickhouse-server
      - ./clickhouse/clickhouse-config.xml:/etc/clickhouse-server/config.d/logging.xml:ro
      - ./clickhouse/clickhouse-user-config.xml:/etc/clickhouse-server/users.d/logging.xml:ro
    ulimits:
      nofile:
        soft: 262144
        hard: 262144

  plausible:
    hostname: plausible
    image: ghcr.io/plausible/community-edition:v2.1.1
    restart: always
    command: sh -c "sleep 10 && /entrypoint.sh db createdb && /entrypoint.sh db migrate && /entrypoint.sh run"
    depends_on:
      - plausible_db
      - plausible_events_db
      - mail
    #ports:
     # - 8000:8000
    volumes:
      - /appdata/plausible/cities/geonames.csv:/etc/app/cities/geonames.csv:ro
    env_file:
      - plausible-conf.env

volumes:
  db-data:
    driver: local
  event-data:
    driver: local

networks:
  default:
    external:
      name: regularstack

Any ideas how to fix this?

Ubuntu 22.04 LTS, Docker version 26.1.4, build 5650f9b

[perfectly-preserved-pie]

Well I seem to have deleted all my of my data by following this migration guide #3132 so I'm just going to start fresh I guess.

[ruslandoga]

The migration in v2 doesn't delete any data unless you drop the tables.