# Cannot run zammad run rake db:migrate after upgrade

**URL:** https://community.zammad.org/t/cannot-run-zammad-run-rake-db-migrate-after-upgrade/7154
**Category:** Technical assistance
**Created:** [June 23, 2021, 10:20am UTC](https://community.zammad.org/t/cannot-run-zammad-run-rake-db-migrate-after-upgrade/7154 "2021-06-23T10:20:00Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![navic](https://community.zammad.org/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@navic](https://community.zammad.org/u/navic)
#### Post date: [June 23, 2021, 10:20am UTC](https://community.zammad.org/t/cannot-run-zammad-run-rake-db-migrate-after-upgrade/7154/1 "2021-06-23T10:20:00Z")

</div>

- Used Zammad version: 4.1.0
- Used Zammad installation type: Package
- Operating system: Ubuntu 18.04
- Browser + version: All browsers

I am trying to upgrade from version 3.6 to 4.1. The “apt upgrade” runs through without any errors but tickets are not shown and pages like webhooks does not get loaded. On tickets page I receive this error " Status Code: 422. {“error”:“PG::UndefinedTable: ERROR: relation “mentions” does not exist\nLINE 8: WHERE a.attrelid = ‘“mentions”’::regclass\n ^\n: SELECT a.attname, formattype(a.atttypid, a.atttypmod),\n pggetexpr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,\n c.collname, coldescription(a.attrelid, a.attnum) AS.."  
So I tried “zammad run rake db:migrate” as mentioned here [https://community.zammad.org/t/status-code-422-on-tickets-after-update-to-newest-version-4/6550](https://community.zammad.org/t/status-code-422-on-tickets-after-update-to-newest-version-4/6550) but that does not work at all.

### Expected behavior:

- I can migrate the db

### Actual behavior:

- Migration gets aborted

```auto
zammad run rake db:migrate
== 20201110000001 MentionInit: migrating ======================================
-- create_table(:mentions)
   -> 0.1220s
-- add_index(:mentions, [:mentionable_id, :mentionable_type, :user_id], {:unique=>true, :name=>"index_mentions_mentionable_user"})
   -> 0.0062s
-- add_foreign_key(:mentions, :users, {:column=>:created_by_id})
   -> 0.0036s
-- add_foreign_key(:mentions, :users, {:column=>:updated_by_id})
   -> 0.0018s
-- add_foreign_key(:mentions, :users, {:column=>:user_id})
   -> 0.0020s
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

Validation failed: Image source is invalid
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/validations.rb:80:in `raise_validation_error'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/validations.rb:52:in `save!'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:315:in `block in save!'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:212:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:315:in `save!'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/suppressor.rb:48:in `save!'
/opt/zammad/db/migrate/20201110000001_mention_init.rb:54:in `block in update_users'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/db/migrate/20201110000001_mention_init.rb:47:in `update_users'
/opt/zammad/db/migrate/20201110000001_mention_init.rb:21:in `change'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:814:in `exec_migration'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:797:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:796:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:977:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1343:in `block in ddl_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:212:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1343:in `ddl_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1262:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1210:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1036:in `up'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1011:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:28:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:463:in `exec'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:27:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:18:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:30:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:22:in `<top (required)>'
/opt/zammad/bin/bundle:3:in `load'
/opt/zammad/bin/bundle:3:in `<main>'

Caused by:
ActiveRecord::RecordInvalid: Validation failed: Image source is invalid
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/validations.rb:80:in `raise_validation_error'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/validations.rb:52:in `save!'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:315:in `block in save!'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:212:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:385:in `with_transaction_returning_status'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:315:in `save!'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/suppressor.rb:48:in `save!'
/opt/zammad/db/migrate/20201110000001_mention_init.rb:54:in `block in update_users'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/db/migrate/20201110000001_mention_init.rb:47:in `update_users'
/opt/zammad/db/migrate/20201110000001_mention_init.rb:21:in `change'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:814:in `exec_migration'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:797:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:796:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:977:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1343:in `block in ddl_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:212:in `transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1343:in `ddl_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1262:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1210:in `block in migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1210:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1036:in `up'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/migration.rb:1011:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:28:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:463:in `exec'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:27:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:18:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:30:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:22:in `<top (required)>'
/opt/zammad/bin/bundle:3:in `load'
/opt/zammad/bin/bundle:3:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

### Steps to reproduce the behavior:

* apt update
apt upgrade
zammad run rake db:migrate
```

---

<div class="post-metadata">

### Author: ![MrGeneration](https://community.zammad.org/user_avatar/community.zammad.org/mrgeneration/32/9260_2.png) [@MrGeneration](https://community.zammad.org/u/MrGeneration)
#### Post date: [June 23, 2021, 1:06pm UTC](https://community.zammad.org/t/cannot-run-zammad-run-rake-db-migrate-after-upgrade/7154/2 "2021-06-23T13:06:28Z")

</div>

You’re affected by this bug:

> <https://github.com/zammad/zammad/issues/3617>
>
> \### Infos:
> 
> \* Used Zammad version: 4.1.X
> \* Installation method (source, packa…ge, ..): helm chart
> \* Operating system: kubernetes / Container-Optimized OS 
> \* Database + version: PostgreSQL 13 
> \* Elasticsearch version: Version that is bundled with zammad
> \* Browser + version: Firefox 89
> \* Ticket: #1088409
> 
> 
> \### Expected behavior:
> 
> \* A user account should be created for new users that login via Office/Microsoft 365/azure active directory the first time
> \* A user who was created via Office/Microsoft 365/azure active directory should be editable
> 
> \### Actual behavior:
> 
> \* Users that login via Office/Microsoft 365/azure active directory the first time will get 422 "Image source is invalid" error page
> \* Users who were created via Office/Microsoft 365/azure active directory will throw a 422 "Image source is invalid" when editing this user.
> 
> 
> \### Steps to reproduce the behavior:
> 
> \* Try to login the first time via Office/Microsoft 365/azure active directory in zammad
> 
> \### Log
> \`\`\`
> I, \[2021-06-16T07:58:32.455599 #1-47408603520580\] INFO -- : Started PUT "/api/v1/users/8" for 10.52.7.10 at 2021-06-16 07:58:32 +0000
> I, \[2021-06-16T07:58:32.464278 #1-47408603520580\] INFO -- : Processing by UsersController#update as JSON
> I, \[2021-06-16T07:58:32.464678 #1-47408603520580\] INFO -- : Parameters: {"login"=\>"c4d43dc3-7851-44f2-8d47-e18240dd3dc3", "firstname"=\>"\*\*\*", "lastname"=\>"\*\*\*", "email"=\>"\*\*\*", "web"=\>"", "password"=\>"\[FILTERED\]", "phone"=\>"", "fax"=\>"", "mobile"=\>"", "street"=\>"", "zip"=\>"", "city"=\>"", "country"=\>"", "organization\_id"=\>"3", "department"=\>"", "note"=\>"", "role\_ids"=\>\["1", "2", "3"\], "group\_ids"=\>{"2"=\>"full", "5"=\>"full"}, "active"=\>true, "updated\_at"=\>"2021-06-14T08:11:24.177Z", "address"=\>"", "vip"=\>false, "industry"=\>"", "id"=\>"8"}
> E, \[2021-06-16T07:58:32.508382 #1-47408603520580\] ERROR -- : Validation failed: Image source is invalid (ActiveRecord::RecordInvalid)
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/validations.rb:80:in \`raise\_validation\_error'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/validations.rb:52:in \`save!'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:315:in \`block in save!'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:387:in \`block in with\_transaction\_returning\_status'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:265:in \`transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:212:in \`transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:385:in \`with\_transaction\_returning\_status'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:315:in \`save!'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/suppressor.rb:48:in \`save!'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/persistence.rb:441:in \`block in update!'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:387:in \`block in with\_transaction\_returning\_status'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:265:in \`transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:212:in \`transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:385:in \`with\_transaction\_returning\_status'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/persistence.rb:439:in \`update!'
> /opt/zammad/app/controllers/users\_controller.rb:133:in \`block in update'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/locking/pessimistic.rb:84:in \`block in with\_lock'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:267:in \`block in transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/connection\_adapters/abstract/transaction.rb:239:in \`block in within\_new\_transaction'
> /usr/local/lib/ruby/2.6.0/monitor.rb:235:in \`mon\_synchronize'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/connection\_adapters/abstract/transaction.rb:236:in \`within\_new\_transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:267:in \`transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:212:in \`transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/transactions.rb:301:in \`transaction'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/locking/pessimistic.rb:82:in \`with\_lock'
> /opt/zammad/app/controllers/users\_controller.rb:130:in \`update'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal/basic\_implicit\_render.rb:6:in \`send\_action'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/abstract\_controller/base.rb:194:in \`process\_action'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal/rendering.rb:30:in \`process\_action'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/abstract\_controller/callbacks.rb:42:in \`block in process\_action'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/callbacks.rb:109:in \`block in run\_callbacks'
> /opt/zammad/app/controllers/application\_controller/has\_secure\_content\_security\_policy\_for\_downloads.rb:18:in \`block (4 levels) in \<module:HasSecureContentSecurityPolicyForDownloads\>'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/notifications.rb:180:in \`subscribed'
> /opt/zammad/app/controllers/application\_controller/has\_secure\_content\_security\_policy\_for\_downloads.rb:17:in \`block (3 levels) in \<module:HasSecureContentSecurityPolicyForDownloads\>'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/notifications.rb:180:in \`subscribed'
> /opt/zammad/app/controllers/application\_controller/has\_secure\_content\_security\_policy\_for\_downloads.rb:16:in \`block (2 levels) in \<module:HasSecureContentSecurityPolicyForDownloads\>'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/callbacks.rb:118:in \`instance\_exec'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/callbacks.rb:118:in \`block in run\_callbacks'
> /opt/zammad/app/controllers/application\_controller/handles\_transitions.rb:14:in \`handle\_transaction'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/callbacks.rb:118:in \`block in run\_callbacks'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/callbacks.rb:136:in \`run\_callbacks'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/abstract\_controller/callbacks.rb:41:in \`process\_action'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal/rescue.rb:22:in \`process\_action'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal/instrumentation.rb:34:in \`block in process\_action'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/notifications.rb:168:in \`block in instrument'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/notifications/instrumenter.rb:23:in \`instrument'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/notifications.rb:168:in \`instrument'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal/instrumentation.rb:32:in \`process\_action'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal/params\_wrapper.rb:256:in \`process\_action'
> /usr/local/bundle/gems/activerecord-5.2.4.6/lib/active\_record/railties/controller\_runtime.rb:24:in \`process\_action'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/abstract\_controller/base.rb:134:in \`process'
> /usr/local/bundle/gems/actionview-5.2.4.6/lib/action\_view/rendering.rb:32:in \`process'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal.rb:191:in \`dispatch'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_controller/metal.rb:252:in \`dispatch'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/routing/route\_set.rb:52:in \`dispatch'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/routing/route\_set.rb:34:in \`serve'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/journey/router.rb:52:in \`block in serve'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/journey/router.rb:35:in \`each'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/journey/router.rb:35:in \`serve'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/routing/route\_set.rb:840:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:420:in \`call\_app!'
> /usr/local/bundle/gems/omniauth-saml-1.10.1/lib/omniauth/strategies/saml.rb:89:in \`other\_phase'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:190:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in \`call!'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in \`call'
> /usr/local/bundle/gems/omniauth-1.9.1/lib/omniauth/builder.rb:45:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/tempfile\_reaper.rb:15:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/etag.rb:27:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/conditional\_get.rb:40:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/head.rb:12:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/http/content\_security\_policy.rb:18:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:266:in \`context'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:260:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/cookies.rb:670:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/callbacks.rb:28:in \`block in call'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/callbacks.rb:98:in \`run\_callbacks'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/callbacks.rb:26:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/debug\_exceptions.rb:61:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/show\_exceptions.rb:33:in \`call'
> /usr/local/bundle/gems/railties-5.2.4.6/lib/rails/rack/logger.rb:38:in \`call\_app'
> /usr/local/bundle/gems/railties-5.2.4.6/lib/rails/rack/logger.rb:26:in \`block in call'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/tagged\_logging.rb:71:in \`block in tagged'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/tagged\_logging.rb:28:in \`tagged'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/tagged\_logging.rb:71:in \`tagged'
> /usr/local/bundle/gems/railties-5.2.4.6/lib/rails/rack/logger.rb:26:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/remote\_ip.rb:81:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/request\_id.rb:27:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/method\_override.rb:24:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/runtime.rb:22:in \`call'
> /usr/local/bundle/gems/activesupport-5.2.4.6/lib/active\_support/cache/strategy/local\_cache\_middleware.rb:29:in \`call'
> /usr/local/bundle/gems/actionpack-5.2.4.6/lib/action\_dispatch/middleware/executor.rb:14:in \`call'
> /usr/local/bundle/gems/rack-2.2.3/lib/rack/sendfile.rb:110:in \`call'
> /usr/local/bundle/gems/railties-5.2.4.6/lib/rails/engine.rb:524:in \`call'
> /usr/local/bundle/gems/puma-4.3.8/lib/puma/configuration.rb:228:in \`call'
> /usr/local/bundle/gems/puma-4.3.8/lib/puma/server.rb:718:in \`handle\_request'
> /usr/local/bundle/gems/puma-4.3.8/lib/puma/server.rb:472:in \`process\_client'
> /usr/local/bundle/gems/puma-4.3.8/lib/puma/server.rb:328:in \`block in run'
> /usr/local/bundle/gems/puma-4.3.8/lib/puma/thread\_pool.rb:134:in \`block in spawn\_thread'
> /usr/local/bundle/gems/logging-2.2.2/lib/logging/diagnostic\_context.rb:474:in \`block in create\_with\_logging\_context'
> \`\`\`
> 
> Yes I'm sure this is a bug and no feature request or a general question.

**Very dirty** workaround would be the following.

> **Dangerzone**
>
> ## Dear future anon finding this post
> 
> **Please be aware that the following operation is dangerous and can potentially harm your installation. Only run this command if you are 1 0 0 0 % SURE you’re affected by the issue described in above linked issue. Have a backup.**
> 
> `zammad run rails r "User.where.not(image_source: nil).update_all(image_source: '')"`

---

<div class="post-metadata">

### Author: ![navic](https://community.zammad.org/letter_avatar_proxy/v4/letter/n/b77776/32.png) [@navic](https://community.zammad.org/u/navic)
#### Post date: [June 23, 2021, 2:08pm UTC](https://community.zammad.org/t/cannot-run-zammad-run-rake-db-migrate-after-upgrade/7154/3 "2021-06-23T14:08:39Z")

</div>

Thanks for the quick reply.

The workaround did the trick in my test environment. But I think I’ll wait with updating the production environment until the bug is officially closed.

---

<div class="post-metadata">

### Author: ![system](https://community.zammad.org/uploads/default/original/1X/5c5afaea2d23f811dbec33cd4edb02fa29d3262f.png) [@system](https://community.zammad.org/u/system)
#### Post date: [October 21, 2021, 2:08pm UTC](https://community.zammad.org/t/cannot-run-zammad-run-rake-db-migrate-after-upgrade/7154/4 "2021-10-21T14:08:54Z")

</div>

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