Zammad Install | Rocky 9 | Postgresql issues

Technical assistance
1

Infos:

  • Used Zammad version: 7.0
  • Used Zammad installation type: package
  • Operating system: Rocky 9
  • Browser + version:

Expected behavior:

No DB issues and full deployment

Actual behavior:

# Updating translations...
/opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'PG::Connection#exec': PG::ForeignKeyViolation: ERROR:  insert or update on table "translations" violates foreign key constraint "fk_rails_d6e6d9635d" (ActiveRecord::InvalidForeignKey)
DETAIL:  Key (created_by_id)=(1) is not present in table "users".

	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements#perform_query'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:556:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:1017:in 'block in ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:986:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:555:in 'block in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/notifications/instrumenter.rb:58:in 'ActiveSupport::Notifications::Instrumenter#instrument'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:1137:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#log'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:554:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:591:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:547:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_exec_query'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:693:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:73:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:259:in 'block in ActiveRecord::ConnectionAdapters::QueryCache#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:297:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:80:in 'ActiveRecord::ConnectionAdapters::QueryCache::Store#compute_if_absent'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:295:in 'block in ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:294:in 'ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:259:in 'ActiveRecord::ConnectionAdapters::QueryCache#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_rows'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:96:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_values'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/adapters/postgresql_adapter.rb:33:in 'ActiveRecord::Import::PostgreSQLAdapter#insert_many'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:835:in 'block in ActiveRecord::Base.import_without_validations_or_callbacks'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'Enumerable#each_slice'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'ActiveRecord::Base.import_without_validations_or_callbacks'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:771:in 'ActiveRecord::Base.import_with_validations'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:702:in 'ActiveRecord::Base.import_helper'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:536:in 'ActiveRecord::Base.bulk_import'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:107:in 'Translation::SynchronizesFromPo::ClassMethods#sync_locale_from_po'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:54:in 'block (2 levels) in Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/transaction.rb:626:in 'block in ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/transaction.rb:623:in 'ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:367:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:359:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/transactions.rb:233:in 'block in ActiveRecord::Transactions::ClassMethods#transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in 'ActiveRecord::ConnectionAdapters::ConnectionPool#with_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_handling.rb:312:in 'ActiveRecord::ConnectionHandling#with_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/transactions.rb:232:in 'ActiveRecord::Transactions::ClassMethods#transaction'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:53:in 'block in Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/relation/delegation.rb:101:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/relation/delegation.rb:101:in 'ActiveRecord::Delegation#each'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:52:in 'Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in '<main>'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'Kernel#eval'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'block in Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/execution_wrapper.rb:91:in 'ActiveSupport::ExecutionWrapper.wrap'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:70:in 'Rails::Command::RunnerCommand#conditional_executor'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:48:in 'Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/command.rb:28:in 'Thor::Command#run'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/invocation.rb:127:in 'Thor::Invocation#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:178:in 'Rails::Command::Base#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor.rb:538:in 'Thor.dispatch'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:73:in 'Rails::Command::Base.perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:65:in 'block in Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:143:in 'Rails::Command.with_argv'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:63:in 'Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands.rb:18:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/bin/rails:4:in '<main>'
/opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'PG::Connection#exec': ERROR:  insert or update on table "translations" violates foreign key constraint "fk_rails_d6e6d9635d" (PG::ForeignKeyViolation)
DETAIL:  Key (created_by_id)=(1) is not present in table "users".

	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements#perform_query'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:556:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:1017:in 'block in ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:986:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:555:in 'block in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/notifications/instrumenter.rb:58:in 'ActiveSupport::Notifications::Instrumenter#instrument'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:1137:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#log'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:554:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:591:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:547:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_exec_query'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:693:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:73:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:259:in 'block in ActiveRecord::ConnectionAdapters::QueryCache#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:297:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:80:in 'ActiveRecord::ConnectionAdapters::QueryCache::Store#compute_if_absent'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:295:in 'block in ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:294:in 'ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:259:in 'ActiveRecord::ConnectionAdapters::QueryCache#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_rows'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:96:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_values'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/adapters/postgresql_adapter.rb:33:in 'ActiveRecord::Import::PostgreSQLAdapter#insert_many'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:835:in 'block in ActiveRecord::Base.import_without_validations_or_callbacks'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'Enumerable#each_slice'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'ActiveRecord::Base.import_without_validations_or_callbacks'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:771:in 'ActiveRecord::Base.import_with_validations'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:702:in 'ActiveRecord::Base.import_helper'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:536:in 'ActiveRecord::Base.bulk_import'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:107:in 'Translation::SynchronizesFromPo::ClassMethods#sync_locale_from_po'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:54:in 'block (2 levels) in Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/transaction.rb:626:in 'block in ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/transaction.rb:623:in 'ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:367:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:359:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/transactions.rb:233:in 'block in ActiveRecord::Transactions::ClassMethods#transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in 'ActiveRecord::ConnectionAdapters::ConnectionPool#with_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_handling.rb:312:in 'ActiveRecord::ConnectionHandling#with_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/transactions.rb:232:in 'ActiveRecord::Transactions::ClassMethods#transaction'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:53:in 'block in Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/relation/delegation.rb:101:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/relation/delegation.rb:101:in 'ActiveRecord::Delegation#each'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:52:in 'Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in '<main>'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'Kernel#eval'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'block in Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/execution_wrapper.rb:91:in 'ActiveSupport::ExecutionWrapper.wrap'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:70:in 'Rails::Command::RunnerCommand#conditional_executor'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:48:in 'Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/command.rb:28:in 'Thor::Command#run'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/invocation.rb:127:in 'Thor::Invocation#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:178:in 'Rails::Command::Base#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor.rb:538:in 'Thor.dispatch'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:73:in 'Rails::Command::Base.perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:65:in 'block in Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:143:in 'Rails::Command.with_argv'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:63:in 'Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands.rb:18:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/bin/rails:4:in '<main>'
# No custom packages detected...
# Configuring Elasticsearch...
/opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require': Interrupt
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/core_ext/kernel.rb:34:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activejob-8.0.4/lib/active_job/base.rb:3:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/core_ext/kernel.rb:34:in 'Kernel#require'
	from /opt/zammad/app/jobs/application_job.rb:3:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/core_ext/kernel.rb:26:in 'Kernel#require'
	from /opt/zammad/app/jobs/active_job_lock_cleanup_job.rb:3:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/core_ext/kernel.rb:26:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/cref.rb:62:in 'Module#const_get'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/cref.rb:62:in 'Zeitwerk::Cref#get'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/eager_load.rb:173:in 'block in Zeitwerk::Loader::EagerLoad#actual_eager_load_dir'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/helpers.rb:47:in 'block in Zeitwerk::Loader::Helpers#ls'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/helpers.rb:25:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/helpers.rb:25:in 'Zeitwerk::Loader::Helpers#ls'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/eager_load.rb:168:in 'Zeitwerk::Loader::EagerLoad#actual_eager_load_dir'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/eager_load.rb:17:in 'block (2 levels) in Zeitwerk::Loader::EagerLoad#eager_load'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/eager_load.rb:16:in 'Hash#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/eager_load.rb:16:in 'block in Zeitwerk::Loader::EagerLoad#eager_load'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/eager_load.rb:10:in 'Thread::Mutex#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader/eager_load.rb:10:in 'Zeitwerk::Loader::EagerLoad#eager_load'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader.rb:431:in 'block in Zeitwerk::Loader.eager_load_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/registry/loaders.rb:10:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/registry/loaders.rb:10:in 'Zeitwerk::Registry::Loaders#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/loader.rb:429:in 'Zeitwerk::Loader.eager_load_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/application/finisher.rb:79:in 'block in <module:Finisher>'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/initializable.rb:32:in 'BasicObject#instance_exec'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/initializable.rb:32:in 'Rails::Initializable::Initializer#run'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/initializable.rb:61:in 'block in Rails::Initializable#run_initializers'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:231:in 'block in TSort.tsort_each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:353:in 'block (2 levels) in TSort.each_strongly_connected_component'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:434:in 'TSort.each_strongly_connected_component_from'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:352:in 'block in TSort.each_strongly_connected_component'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:350:in 'Rails::Initializable::Collection#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:350:in 'Method#call'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:350:in 'TSort.each_strongly_connected_component'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:229:in 'TSort.tsort_each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/tsort-0.2.0/lib/tsort.rb:208:in 'TSort#tsort_each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/initializable.rb:60:in 'Rails::Initializable#run_initializers'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/application.rb:444:in 'Rails::Application#initialize!'
	from /opt/zammad/config/environment.rb:7:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/zeitwerk-2.7.4/lib/zeitwerk/core_ext/kernel.rb:34:in 'Kernel#require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/application.rb:420:in 'Rails::Application#require_environment!'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/actions.rb:20:in 'Rails::Command::Actions#boot_application!'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:30:in 'Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/command.rb:28:in 'Thor::Command#run'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/invocation.rb:127:in 'Thor::Invocation#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:178:in 'Rails::Command::Base#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor.rb:538:in 'Thor.dispatch'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:73:in 'Rails::Command::Base.perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:65:in 'block in Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:143:in 'Rails::Command.with_argv'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:63:in 'Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands.rb:18:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/bin/rails:4:in '<main>'

Steps to reproduce the behavior:

Running the below after installing a elasticsearch and postgres and installing the repo.

dnf install zammad

2

What version of postgres did you install?

3

Postgres is running 13.23 version

4

Can you try to install postgresql server (and ensure it’s started), before installing Zammad?
It’s just a feeling, but my bet is that the provided error message isn’t the first one (it might be a lot output so).

Because usually you’d also see a ton of migration messages and those should have failed too (at least in my guess).

5

Thanks for the details, i actually did that. I installed postgres and elasticsearch manually first because the rpm package just kept failing…

Steps taken after the “dnf install zammad” didnt work is

sudo -u postgres psql -v ON_ERROR_STOP=1 <<SQL
-- terminate sessions
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='zammad';

DROP DATABASE IF EXISTS zammad;
DROP ROLE IF EXISTS zammad;

CREATE ROLE zammad LOGIN PASSWORD '${ZPASS}';
CREATE DATABASE zammad OWNER zammad ENCODING 'UTF8';
SQL

updated the database config file with the new password

sudo /opt/zammad/contrib/packager.io/postinstall.sh

but all i get are errors during the postinstall.

udo /opt/zammad/contrib/packager.io/postinstall.sh
# Enforcing Redis...
# Creating Redis bootstart
# Starting Redis server
# Redis server is running.
# (Re)creating init scripts
Nothing to do.
Nothing to do.
Nothing to do.
# Enabling Zammad on boot
# Stopping Zammad
# Clear cache...
/opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'PG::Connection#exec': PG::UndefinedTable: ERROR:  relation "settings" does not exist (ActiveRecord::StatementInvalid)
LINE 10:  WHERE a.attrelid = '"settings"'::regclass
                             ^

	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 
....

connection_adapters/postgresql/database_statements.rb:167:in 'PG::Connection#exec': ERROR:  relation "settings" does not exist (PG::UndefinedTable)
LINE 10:  WHERE a.attrelid = '"settings"'::regclass
                             ^
...
# database.yml found. Updating db...
== 20120101000001 CreateBase: migrating =======================================
-- create_table(:sessions, {id: :integer})
   -> 0.0239s
......................

# Updating translations...
/opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'PG::Connection#exec': PG::ForeignKeyViolation: ERROR:  insert or update on table "translations" violates foreign key constraint "fk_rails_d6e6d9635d" (ActiveRecord::InvalidForeignKey)
DETAIL:  Key (created_by_id)=(1) is not present in table "users".

	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:167:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements#perform_query'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:556:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:1017:in 'block in ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:986:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:555:in 'block in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/notifications/instrumenter.rb:58:in 'ActiveSupport::Notifications::Instrumenter#instrument'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract_adapter.rb:1137:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#log'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:554:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:591:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_execute'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:547:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_exec_query'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:693:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:73:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:259:in 'block in ActiveRecord::ConnectionAdapters::QueryCache#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:297:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:80:in 'ActiveRecord::ConnectionAdapters::QueryCache::Store#compute_if_absent'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:295:in 'block in ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:294:in 'ActiveRecord::ConnectionAdapters::QueryCache#cache_sql'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/query_cache.rb:259:in 'ActiveRecord::ConnectionAdapters::QueryCache#select_all'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_rows'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:96:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_values'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/adapters/postgresql_adapter.rb:33:in 'ActiveRecord::Import::PostgreSQLAdapter#insert_many'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:835:in 'block in ActiveRecord::Base.import_without_validations_or_callbacks'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'Enumerable#each_slice'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:831:in 'ActiveRecord::Base.import_without_validations_or_callbacks'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:771:in 'ActiveRecord::Base.import_with_validations'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:702:in 'ActiveRecord::Base.import_helper'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-import-2.2.0/lib/activerecord-import/import.rb:536:in 'ActiveRecord::Base.bulk_import'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:107:in 'Translation::SynchronizesFromPo::ClassMethods#sync_locale_from_po'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:54:in 'block (2 levels) in Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/transaction.rb:626:in 'block in ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/transaction.rb:623:in 'ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:367:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#within_new_transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/database_statements.rb:359:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/transactions.rb:233:in 'block in ActiveRecord::Transactions::ClassMethods#transaction'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:422:in 'ActiveRecord::ConnectionAdapters::ConnectionPool#with_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/connection_handling.rb:312:in 'ActiveRecord::ConnectionHandling#with_connection'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/transactions.rb:232:in 'ActiveRecord::Transactions::ClassMethods#transaction'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:53:in 'block in Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/relation/delegation.rb:101:in 'Array#each'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activerecord-8.0.4/lib/active_record/relation/delegation.rb:101:in 'ActiveRecord::Delegation#each'
	from /opt/zammad/app/models/translation/synchronizes_from_po.rb:52:in 'Translation::SynchronizesFromPo::ClassMethods#sync'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in '<main>'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'Kernel#eval'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'block in Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/execution_wrapper.rb:91:in 'ActiveSupport::ExecutionWrapper.wrap'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:70:in 'Rails::Command::RunnerCommand#conditional_executor'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:48:in 'Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/command.rb:28:in 'Thor::Command#run'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/invocation.rb:127:in 'Thor::Invocation#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:178:in 'Rails::Command::Base#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor.rb:538:in 'Thor.dispatch'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:73:in 'Rails::Command::Base.perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:65:in 'block in Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:143:in 'Rails::Command.with_argv'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:63:in 'Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands.rb:18:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/bin/rails:4:in '<main>'

# No custom packages detected...
# Configuring Elasticsearch...
-- Nevermind, no es_url is set, leaving Elasticsearch untouched ...!
-- The above is all right if you don't want to use Elasticsearch (locally) - if this is not intended, consult https://docs.zammad.org !
/opt/zammad/app/models/setting.rb:45:in 'Setting.set': Can't find config setting 'es_url' (RuntimeError)
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in '<main>'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'Kernel#eval'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:49:in 'block in Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/activesupport-8.0.4/lib/active_support/execution_wrapper.rb:91:in 'ActiveSupport::ExecutionWrapper.wrap'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:70:in 'Rails::Command::RunnerCommand#conditional_executor'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands/runner/runner_command.rb:48:in 'Rails::Command::RunnerCommand#perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/command.rb:28:in 'Thor::Command#run'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor/invocation.rb:127:in 'Thor::Invocation#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:178:in 'Rails::Command::Base#invoke_command'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/thor-1.5.0/lib/thor.rb:538:in 'Thor.dispatch'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command/base.rb:73:in 'Rails::Command::Base.perform'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:65:in 'block in Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:143:in 'Rails::Command.with_argv'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/command.rb:63:in 'Rails::Command.invoke'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/railties-8.0.4/lib/rails/commands.rb:18:in '<main>'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'Kernel.require'
	from /opt/zammad/vendor/ruby-3.4.8/lib/ruby/3.4.0/bundled_gems.rb:82:in 'block (2 levels) in Kernel#replace_require'
	from /opt/zammad/vendor/bundle/ruby/3.4.0/gems/bootsnap-1.22.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:33:in 'Kernel#require'
	from /opt/zammad/bin/rails:4:in '<main>'
# Enforcing 0600 on database.yml ...
# Starting Zammad
# Creating webserver bootstart
# Restarting webserver nginx - please check if all required modules are enabled in case webserver fails to start.
6

I’m out of ideas, sorry. This seems to lay deeper and I don’t have enough free time to hike down the Rocky road (sorry).