# Herbouwen mislukt op db:migrate "relatie "form\_templates" bestaat al"

**URL:** https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421
**Category:** Self-hosting
**Created:** [25 oktober 2023 om 15:09 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421 "2023-10-25T15:09:56Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![Aditya\_Patadia](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/aditya_patadia/32/335619_2.png) [@Aditya\_Patadia](https://meta.discourse.org/u/Aditya_Patadia)
#### Post date: [25 oktober 2023 om 15:09 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/1 "2023-10-25T15:09:56Z")

</div>

Discourse rebuild is failing. Here is log.

What is best way to resolve it? We have Postgres hosted on RDS and run discourse with official docker container method.

```plaintext
I, [2023-10-25T14:47:59.607563 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate'
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::DuplicateTable: ERROR: relation "form_templates" already exists
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rack-mini-profiler-3.1.1/lib/patches/db/pg.rb:110:in `exec'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rack-mini-profiler-3.1.1/lib/patches/db/pg.rb:110:in `async_exec'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:48:in `block (2 levels) in execute'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:47:in `block in execute'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract_adapter.rb:752:in `block in log'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract_adapter.rb:743:in `log'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:46:in `execute'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/schema_statements.rb:326:in `create_table'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:932:in `block in method_missing'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:900:in `block in say_with_time'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:900:in `say_with_time'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:921:in `method_missing'
/var/www/discourse/db/migrate/20230202173641_create_form_templates.rb:5:in `change'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:870:in `exec_migration'
/var/www/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `block in exec_migration'
/var/www/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:854:in `block (2 levels) in migrate'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:853:in `block in migrate'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:852:in `migrate'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1046:in `migrate'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1360:in `block in execute_migration_in_transaction'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/transactions.rb:209:in `transaction'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1411:in `ddl_transaction'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1359:in `execute_migration_in_transaction'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1333:in `each'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1333:in `migrate_without_lock'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1282:in `block in migrate'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1432:in `block in with_advisory_lock'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:215:in `with_connection'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1447:in `with_advisory_lock_connection'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1428:in `with_advisory_lock'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1282:in `migrate'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1117:in `up'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/migration.rb:1092:in `migrate'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
/var/www/discourse/lib/tasks/db.rake:250:in `block (2 levels) in <main>'
/var/www/discourse/lib/distributed_mutex.rb:53:in `block in synchronize'
/var/www/discourse/lib/distributed_mutex.rb:49:in `synchronize'
/var/www/discourse/lib/distributed_mutex.rb:49:in `synchronize'
/var/www/discourse/lib/distributed_mutex.rb:34:in `synchronize'
/var/www/discourse/lib/tasks/db.rake:225:in `block in <main>'
/var/www/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.0.6/exe/rake:27:in `<top (required)>'
/usr/local/bin/bundle:25:in `load'
/usr/local/bin/bundle:25:in `<main>'

```

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [25 oktober 2023 om 16:13 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/3 "2023-10-25T16:13:59Z")

</div>

This could be a bug. I changed the subject to provide a bit more information.

What plugins do you have installed?

---

<div class="post-metadata">

### Author: ![Aditya\_Patadia](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/aditya_patadia/32/335619_2.png) [@Aditya\_Patadia](https://meta.discourse.org/u/Aditya_Patadia)
#### Post date: [25 oktober 2023 om 18:40 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/5 "2023-10-25T18:40:52Z")

</div>

How to find plugins?

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [25 oktober 2023 om 18:41 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/6 "2023-10-25T18:41:59Z")

</div>

something like

```plaintext
cd /var/discourse
grep clone containers/*

```

---

<div class="post-metadata">

### Author: ![Aditya\_Patadia](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/aditya_patadia/32/335619_2.png) [@Aditya\_Patadia](https://meta.discourse.org/u/Aditya_Patadia)
#### Post date: [25 oktober 2023 om 18:45 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/7 "2023-10-25T18:45:45Z")

</div>

I tried to find plugins directory and here are the ones listed.

```plaintext
chat discourse-details discourse-local-dates discourse-presence poll
checklist discourse-lazy-videos discourse-narrative-bot docker_manager styleguide

```

We did not install anything except themes.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [25 oktober 2023 om 18:48 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/8 "2023-10-25T18:48:47Z")

</div>

Do you not have an `app.yml` somewhere that’s what gets read when you do a rebuild?

But it looks like my idea isn’t going to explain anything.

---

<div class="post-metadata">

### Author: ![Aditya\_Patadia](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/aditya_patadia/32/335619_2.png) [@Aditya\_Patadia](https://meta.discourse.org/u/Aditya_Patadia)
#### Post date: [25 oktober 2023 om 18:51 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/9 "2023-10-25T18:51:27Z")

</div>

I found app.yml. There are no extra plugins listed there. As I told I am certain I did not install anything except themes.

Here are steps we did which led to this issue.

- tried to move all assets to S3 using `rake uploads:migrate_to_s3`
- above command failed saying 155 out of 161 assets were not moved
- we tried to restore to previous version by using “Rollback” on backup panel
- entire site crashed. nothing is working.
- when we tried to restore using command line, it says we are trying to restore while there are pending migrations
- to run migrations, we tried to rebuild but it led to this error.

Hope it gives some idea. Btw, right now our entire deployment is broken. What is best way out of this? We have most recent backup taken to S3 before we started any of this.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [25 oktober 2023 om 18:57 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/10 "2023-10-25T18:57:44Z")

</div>

> [@Aditya\_Patadia](#):
>
> we tried to restore to previous version by using “Rollback” on backup panel

The RDS backup panel? That’s probably where you went wrong.

> [@Aditya\_Patadia](#):
>
> We have most recent backup taken to S3 before we started any of this.

If restoring the most recent backup is OK, then I think I’d create a new database, update `app.yml` with the new database name, make sure that the S3 settings for the backup are in the yml file, rebuild, restore.

If you want to throw money at the problem you can contact me directly.

---

<div class="post-metadata">

### Author: ![Aditya\_Patadia](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/aditya_patadia/32/335619_2.png) [@Aditya\_Patadia](https://meta.discourse.org/u/Aditya_Patadia)
#### Post date: [25 oktober 2023 om 18:59 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/11 "2023-10-25T18:59:09Z")

</div>

Not RDS panel, but discourse panel.

Let us try for some time but if it does not work, we will contact you in some time.

---

<div class="post-metadata">

### Author: ![Aditya\_Patadia](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/aditya_patadia/32/335619_2.png) [@Aditya\_Patadia](https://meta.discourse.org/u/Aditya_Patadia)
#### Post date: [25 oktober 2023 om 20:21 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/12 "2023-10-25T20:21:24Z")

</div>

Fresh DB + Fresh machine and restore on that worked well. Thanks for prompt response.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [24 november 2023 om 20:22 UTC](https://meta.discourse.org/t/rebuild-fails-on-db-migrate-relation-form-templates-already-exists/283421/13 "2023-11-24T20:22:24Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.