Docker-Compose Update to V4 Fails

oczempas · May 21, 2021, 11:43am

Infos:

Used Zammad version: 3.6.x
Used Zammad installation type: docker-compose
Operating system: Ubuntu 20.04 LTS
Browser + version: Chrome Version 90.0.4430.212 (Offizieller Build) (64-Bit)

Expected behavior:

Updating from 3.6 to v4
Migrating successful database

Actual behavior:

Migration of database fails

Steps to reproduce the behavior:

Docker-compose down
git pull
docker-compose pull
docker-compose up

Errorlog:
zammad-init_1 | rake aborted!
zammad-init_1 | StandardError: An error has occurred, this and all later migrations canceled:
zammad-init_1 |
zammad-init_1 | Validation failed: Endpoint Invalid endpoint!
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/validations.rb:80:in raise_validation_error' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/validations.rb:52:in save!’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in block in save!' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:387:in block in with_transaction_returning_status’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:212:in transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:385:in with_transaction_returning_status' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in save!’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/suppressor.rb:48:in save!' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:53:in create!’
zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:47:in webhook_create' zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:37:in block in record_upgrade’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:70:in block (2 levels) in find_each' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:70:in each’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:70:in block in find_each' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:136:in block in find_in_batches’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:238:in block in in_batches' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:222:in loop’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:222:in in_batches' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:135:in find_in_batches’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:69:in find_each' zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:34:in record_upgrade’
zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:8:in up' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:817:in exec_migration’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:798:in block (2 levels) in migrate' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:797:in block in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in with_connection' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:796:in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:977:in migrate' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1292:in block in execute_migration_in_transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1343:in block in ddl_transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in block in transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:239:in block in within_new_transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:236:in within_new_transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:212:in transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1343:in ddl_transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1291:in execute_migration_in_transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1263:in block in migrate_without_lock' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1262:in each’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1262:in migrate_without_lock' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1210:in block in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1363:in with_advisory_lock' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1210:in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1036:in up' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1011:in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/tasks/database_tasks.rb:172:in migrate' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/railties/databases.rake:60:in block (2 levels) in ’
zammad-init_1 | /usr/local/bin/bundle:23:in load' zammad-init_1 | /usr/local/bin/bundle:23:in ’
zammad-init_1 |
zammad-init_1 | Caused by:
zammad-init_1 | ActiveRecord::RecordInvalid: Validation failed: Endpoint Invalid endpoint!
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/validations.rb:80:in raise_validation_error' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/validations.rb:52:in save!’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in block in save!' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:387:in block in with_transaction_returning_status’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:212:in transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:385:in with_transaction_returning_status' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in save!’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/suppressor.rb:48:in save!' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:53:in create!’
zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:47:in webhook_create' zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:37:in block in record_upgrade’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:70:in block (2 levels) in find_each' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:70:in each’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:70:in block in find_each' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:136:in block in find_in_batches’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:238:in block in in_batches' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:222:in loop’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:222:in in_batches' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:135:in find_in_batches’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:69:in find_each' zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:34:in record_upgrade’
zammad-init_1 | /opt/zammad/db/migrate/20210118095820_issue_3372_webhooks_admin_view.rb:8:in up' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:817:in exec_migration’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:798:in block (2 levels) in migrate' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:797:in block in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in with_connection' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:796:in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:977:in migrate' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1292:in block in execute_migration_in_transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1343:in block in ddl_transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in block in transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:239:in block in within_new_transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:236:in within_new_transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:212:in transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1343:in ddl_transaction' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1291:in execute_migration_in_transaction’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1263:in block in migrate_without_lock' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1262:in each’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1262:in migrate_without_lock' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1210:in block in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1363:in with_advisory_lock' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1210:in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1036:in up' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/migration.rb:1011:in migrate’
zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/tasks/database_tasks.rb:172:in migrate' zammad-init_1 | /usr/local/bundle/gems/activerecord-5.2.4.5/lib/active_record/railties/databases.rake:60:in block (2 levels) in ’
zammad-init_1 | /usr/local/bin/bundle:23:in load' zammad-init_1 | /usr/local/bin/bundle:23:in ’
zammad-init_1 | Tasks: TOP => db:migrate
zammad-init_1 | (See full trace by running task with --trace)
zammad-init_1 | I, [2021-05-21T11:34:59.049129 #20-47317279930700] INFO – : Setting.set(‘models_searchable’, [“Organization”, “User”, “Ticket”, “KnowledgeBase::Answer::Translation”, “Chat::Session”])
zammad-init_1 | I, [2021-05-21T11:34:59.361305 #20-47317279930700] INFO – : Migrating to Issue3372WebhooksAdminView (20210118095820)
zammad-init_1 | == 20210118095820 Issue3372WebhooksAdminView: migrating =======================
zammad-init_1 | – create_table(:webhooks)
zammad-init_1 | → 0.0082s

imakiro · May 24, 2021, 12:09pm

I have the same issue.

oczempas · May 31, 2021, 6:43am

Did you find a solution?

oczempas · June 10, 2021, 8:09am

Can anybody help? Has it something todo with webhooks? I have one configured…

oczempas · July 5, 2021, 12:49pm

Hi,

found the problem. You have to delete all entries from the db related to webhooks. Then you can update and recreate the webhooks.

Best regards,
Oliver

MrGeneration · July 16, 2021, 1:43pm

Do you happen to remember what exact values lived in that column in question?
Doesn’t sound like our migration did well enough (or the data was somewhat off possibly).

oczempas · July 16, 2021, 2:03pm

Hi,

I had a trigger configured which reacts if the Group Was assigned to ‘XXX’ and then it fired a webhook to http://10.X.X.X:8080

Hope it helps to find the Problem

Best regards,
Oliver

oczempas · July 16, 2021, 2:06pm

I have Backups, so i could rebuild it if u interested

MrGeneration · July 29, 2021, 2:17pm

Thanks for the further remarks.
I did use a snapshotted Zammad 3.6 package installation and was rolling back if updates were successful.

I’m afraid I couldn’t force the situation you experienced and believe this may be due one of the following reasons:

docker-compose is super different in terms of the application itself (press [X] to doubt)
it may have been fixed already by either rolling release of Zammad 4.1

To be fair. I upgraded from 3.6.1 to 4.1 (to be very precise).
So right now I’m hoping the issue is generally gone.

Thanks for the further input again!

system · November 26, 2021, 2:17pm

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