Latest chatwoot update is breaking the app for me.

[Kinzi]

It seems like it's stuck in starting, not being able to run the DB migration.
1.53.1 worked without problems.

Will roll back now, but would be cool if this can get solved soon.

Here are the logs:

Jul 21 19:15:51 => Starting chatwoot
Jul 21 19:15:51 => Sourcing /app/data/env.sh
Jul 21 19:15:51 => Upgrading existing db
Jul 21 19:15:58 /root/.rbenv/versions/3.4.4/lib/ruby/gems/3.4.0/gems/reline-0.3.6/lib/reline/terminfo.rb:2: warning: /root/.rbenv/versions/3.4.4/lib/ruby/3.4.0/fiddle.rb was loaded from the standard library, but will no longer be part of the default gems starting from Ruby 3.5.0.
Jul 21 19:15:58 You can add fiddle to your Gemfile or gemspec to silence this warning.
Jul 21 19:15:58 Also please contact the author of reline-0.3.6 to request adding fiddle into its gemspec.
Jul 21 19:15:59 W, [2026-07-21T16:15:59.308574 #11]  WARN -- :
Jul 21 19:15:59 !!! RubyLLM's legacy acts_as API is deprecated and will be removed in RubyLLM 2.0.0. Please consult the migration guide at https://rubyllm.com/upgrading-to-1-7/
Jul 21 19:15:59 2026-07-21T16:15:59Z 
Jul 21 19:15:59 I, [2026-07-21T16:15:59.632637 #11]  INFO -- : [rake ip_lookup:setup] IP_LOOKUP_API_KEY empty. Skipping geoip database setup
Jul 21 19:16:00 => Healthcheck error: Error: connect ECONNREFUSED 172.18.19.134:3000
Jul 21 19:16:00 I, [2026-07-21T16:16:00.165470 #11]  INFO -- : Migrating to AddInboxScopeToEmailTemplates (20260706000000)
Jul 21 19:16:00 == 20260706000000 AddInboxScopeToEmailTemplates: migrating ====================
Jul 21 19:16:00 -- add_column(:email_templates, :inbox_id, :integer)
Jul 21 19:16:00 -> 0.0038s
Jul 21 19:16:00 -- add_index(:email_templates, :inbox_id, {name: "index_email_templates_on_inbox_id"})
Jul 21 19:16:00 -> 0.0050s
Jul 21 19:16:00 -- remove_index(:email_templates, {name: "index_email_templates_on_name_and_account_id"})
Jul 21 19:16:00 bin/rails aborted!
Jul 21 19:16:00 StandardError: An error has occurred, this and all later migrations canceled: (StandardError)
Jul 21 19:16:00 2026-07-21T16:16:00Z 
Jul 21 19:16:00 PG::UndefinedObject: ERROR:  index "index_email_templates_on_name_and_account_id" does not exist
Jul 21 19:16:00 /app/code/db/migrate/20260706000000_add_inbox_scope_to_email_templates.rb:6:in 'AddInboxScopeToEmailTemplates#up'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:26:in 'block (3 levels) in <main>'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:18:in 'Array#each'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:18:in 'block (2 levels) in <main>'
Jul 21 19:16:00 2026-07-21T16:16:00Z 
Jul 21 19:16:00 Caused by:
Jul 21 19:16:00 ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  index "index_email_templates_on_name_and_account_id" does not exist (ActiveRecord::StatementInvalid)
Jul 21 19:16:00 /app/code/db/migrate/20260706000000_add_inbox_scope_to_email_templates.rb:6:in 'AddInboxScopeToEmailTemplates#up'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:26:in 'block (3 levels) in <main>'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:18:in 'Array#each'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:18:in 'block (2 levels) in <main>'
Jul 21 19:16:00 2026-07-21T16:16:00Z 
Jul 21 19:16:00 Caused by:
Jul 21 19:16:00 PG::UndefinedObject: ERROR:  index "index_email_templates_on_name_and_account_id" does not exist (PG::UndefinedObject)
Jul 21 19:16:00 /app/code/db/migrate/20260706000000_add_inbox_scope_to_email_templates.rb:6:in 'AddInboxScopeToEmailTemplates#up'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:26:in 'block (3 levels) in <main>'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:18:in 'Array#each'
Jul 21 19:16:00 /app/code/lib/tasks/db_enhancements.rake:18:in 'block (2 levels) in <main>'
Jul 21 19:16:00 Tasks: TOP => db:migrate
Jul 21 19:16:00 (See full trace by running task with --trace)

[andreasdueren]

@Kinzi

Hit the exact same issue yesterday — same migration, same error. Root cause: the 1.54.0 migration AddInboxScopeToEmailTemplates tries to drop the index index_email_templates_on_name_and_account_id, but on instances installed at certain older Chatwoot versions that index never existed. Postgres throws PG::UndefinedObject, and since db:migrate runs on every boot, the app is stuck in a restart loop. (Upstream bug — the migration should use if_exists: true.)

Fix without rolling back (no data is touched — you just create the index so the migration can drop it):

1. Stop the crash loop:

cloudron debug --app <chatwoot-app-id>

2. Safety check — make sure there are no duplicate email templates (the migration later adds unique indices that would fail on duplicates):

cloudron exec --app <app-id> -- bash -c \
  'psql "$CLOUDRON_POSTGRESQL_URL" -c "SELECT name, template_type, locale, account_id, COUNT(*) FROM email_templates GROUP BY 1,2,3,4 HAVING COUNT(*)>1;"'

Expected: (0 rows). If you get rows, dedupe first.

3. Create the missing index:

cloudron exec --app <app-id> -- bash -c \
  'psql "$CLOUDRON_POSTGRESQL_URL" -c "CREATE UNIQUE INDEX index_email_templates_on_name_and_account_id ON email_templates (name, account_id);"'

4. Run the migration manually (in debug mode the start script hasn't populated the Rails env, so map the Cloudron addon vars):

cloudron exec --app <app-id> -- bash -c '
  export POSTGRES_DATABASE="$CLOUDRON_POSTGRESQL_DATABASE" \
         POSTGRES_USERNAME="$CLOUDRON_POSTGRESQL_USERNAME" \
         POSTGRES_PASSWORD="${CLOUDRON_POSTGRESQL_PASSWORD}" \
         POSTGRES_HOST="$CLOUDRON_POSTGRESQL_HOST" \
         POSTGRES_PORT="$CLOUDRON_POSTGRESQL_PORT" \
         REDIS_URL="redis://$CLOUDRON_REDIS_HOST:$CLOUDRON_REDIS_PORT" \
         REDIS_PASSWORD="${CLOUDRON_POSTGRESQL_PASSWORD}" \
         RAILS_ENV=production
  source /app/data/env.sh
  cd /app/code && bin/rails db:migrate'

Watch for AddInboxScopeToEmailTemplates: migrated — the remaining pending migrations run right after.

5. Leave debug mode:

cloudron debug --app <app-id> --disable

App should be back within ~30s. Rolling back to 1.53.1 only postpones this — it'll hit again on the next update until the package/upstream guards the remove_index with if_exists: true.

[joseph]

@andreasdueren so, is this an upstream bug?

[Kinzi]

Thanks @andreasdueren this worked!

Needed a minute to figure the CLI part out as I hadn't used that before (it's on your machine not on the server or the app container for everybody else)

Also make sure to fill in the password env var names in step 4.

[andreasdueren]

@joseph not sure, seems to only affect installations of a certain age. I guess upstream or Cloudron could do what I did manually. But unless more people will reach out this is an isolated issue.

[andreasdueren]

@Kinzi yes forgot to look up the correct Postgres ENV lol

[fbartels]

@andreasdueren @joseph overall the upstream project does not seem to be very good with database topics. I recently wanted to create some workflows in my older installation and first needed to fix some indexes as well before the app responded successfully.

My installation ran into this upgrade issue as well, thanks for the commands. Instead of running the last database migrations myself I just disabled the recovery mode and restarted the app.

[humpty]

I have a 2 year old installation with the same issue. I'm not sure how to do the CLI thing. Initially, I tried the code in terminal and in putty totally missing Kinzi's note at first. I'll just revert and wait for a proper package.

[andreasdueren]

@humpty Here this should work:

1. create backup of chatwoot in case something goes bad
2. put app into recovery mode
3. enter web terminal and enter

set -euo pipefail

source /app/data/env.sh

export FRONTEND_URL="${CLOUDRON_APP_ORIGIN}"
export REDIS_URL="redis://${CLOUDRON_REDIS_HOST}:${CLOUDRON_REDIS_PORT}"
export REDIS_PASSWORD="${CLOUDRON_POSTGRESQL_PASSWORD}"
export POSTGRES_DATABASE="${CLOUDRON_POSTGRESQL_DATABASE}"
export POSTGRES_USERNAME="${CLOUDRON_POSTGRESQL_USERNAME}"
export POSTGRES_PASSWORD="${CLOUDRON_POSTGRESQL_PASSWORD}"
export POSTGRES_HOST="${CLOUDRON_POSTGRESQL_HOST}"
export POSTGRES_PORT="${CLOUDRON_POSTGRESQL_PORT}"
export RAILS_ENV=production

echo "Checking for duplicate email templates..."
psql "$CLOUDRON_POSTGRESQL_URL" -v ON_ERROR_STOP=1 -c "
SELECT name, template_type, locale, account_id, inbox_id, COUNT(*)
FROM email_templates
GROUP BY name, template_type, locale, account_id, inbox_id
HAVING COUNT(*) > 1;
"

echo "Creating missing legacy index if needed..."
psql "$CLOUDRON_POSTGRESQL_URL" -v ON_ERROR_STOP=1 -c "
CREATE UNIQUE INDEX IF NOT EXISTS index_email_templates_on_name_and_account_id
ON email_templates (name, account_id);
"

echo "Running Chatwoot database migrations..."
cd /app/code
bundle exec rails db:migrate

echo "Done. Now disable Recovery Mode / Debug Mode and restart the app."

4. when prompted, take app out of recovery mode

[humpty]

My attempts didn't work as the app didn't want to start.

1- Should the app be updated to the broken 1.54 or stick with the working 1.53.1?
2- Should I paste the entire code above in one-shot? If not, then my other attempt by pasting one line at a time didn't work either? I'll try pasting in sections as they're pasted above.

Fixed.

To answer my own questions.
1- Yes, apply the code to broken package 1.54.
2- Apply code one section at a time.

App package 1.54.0 now starts as it should. Thank you @andreasdueren

[andreasdueren]

@humpty You need to update it first, then follow those steps. In theory the entire code copied and pasted into the terminal should work, but you can also paste them line by line. Unfortunately I can't test this.

[humpty]

@andreasdueren one line at a time didn't work nor pasting it whole. I pasted them one section at a time and that worked. The "export" lines were done one at a time though. But the "echo" ones had to be as one. e.g.

echo "Checking for duplicate email templates..."
psql "$CLOUDRON_POSTGRESQL_URL" -v ON_ERROR_STOP=1 -c "
SELECT name, template_type, locale, account_id, inbox_id, COUNT(*)
FROM email_templates
GROUP BY name, template_type, locale, account_id, inbox_id
HAVING COUNT(*) > 1;
"

This was pasted in one go.