Here’s my situation:
~/phoenix_apps/dog$ mix ecto.migrations
Repo: Dog.Repo
Status Migration ID Migration Name
--------------------------------------------------
up 20190715054239 create_users
up 20190716225030 create_members
up 20190716225304 create_memberships
But, when I try:
~/phoenix_apps/dog$ mix ecto.rollback
17:32:13.213 [info] == Running 20190716225304 Dog.Repo.Migrations.CreateMemberships.change/0 backward
17:32:13.216 [info] drop table memberships
** (Postgrex.Error) ERROR 42P01 (undefined_table) table "memberships" does not exist
(ecto_sql) lib/ecto/adapters/sql.ex:621: Ecto.Adapters.SQL.raise_sql_call_error/1
(elixir) lib/enum.ex:1327: Enum."-map/2-lists^map/1-0-"/2
(ecto_sql) lib/ecto/adapters/sql.ex:708: Ecto.Adapters.SQL.execute_ddl/4
(ecto_sql) lib/ecto/migration/runner.ex:340: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql) lib/ecto/migration/runner.ex:119: anonymous fn/6 in Ecto.Migration.Runner.flush/0
(elixir) lib/enum.ex:1940: Enum."-reduce/3-lists^foldl/2-0-"/3
(ecto_sql) lib/ecto/migration/runner.ex:118: Ecto.Migration.Runner.flush/0
(stdlib) timer.erl:166: :timer.tc/1
(ecto_sql) lib/ecto/migration/runner.ex:27: Ecto.Migration.Runner.run/7
(ecto_sql) lib/ecto/migrator.ex:276: Ecto.Migrator.attempt/7
(ecto_sql) lib/ecto/migrator.ex:211: anonymous fn/4 in Ecto.Migrator.do_down/4
(ecto_sql) lib/ecto/migrator.ex:258: anonymous fn/3 in Ecto.Migrator.run_maybe_in_transaction/6
(ecto_sql) lib/ecto/adapters/sql.ex:890: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4
(db_connection) lib/db_connection.ex:1415: DBConnection.run_transaction/4
(ecto_sql) lib/ecto/migrator.ex:257: Ecto.Migrator.run_maybe_in_transaction/6
(elixir) lib/task/supervised.ex:90: Task.Supervised.invoke_mfa/2
(elixir) lib/task/supervised.ex:35: Task.Supervised.reply/5
(stdlib) proc_lib.erl:247: :proc_lib.init_p_do_apply/3
And, if I try:
~/phoenix_apps/dog$ mix ecto.migrate
17:39:34.415 [info] Already up
~/phoenix_apps/dog$ mix ecto.migrations
Repo: Dog.Repo
Status Migration ID Migration Name
--------------------------------------------------
up 20190715054239 create_users
up 20190716225030 create_members
up 20190716225304 create_memberships
It appears I am stuck in an infinite circle of hell.
