Hi Team, I have a new server Zammad was installed after this, a backup copy of the old Zammad server is made, then we log in as a zammad user and start the Zammad restore:
zammad@hds:/opt/zammad/contrib/backup$ ./zammad_restore.sh
# Zammad restored started - Wed Nov 3 19:57:50 UTC 2021!
The restore will delete your current config and database!
Be sure to have a backup available!
Enter 'yes' if you want to proceed!
Restore?: yes
Enter file date to restore:
20210924114632
20211103185016
File date: 20210924114632
Enter db date to restore:
20210924114632
20211103185016
DB date: 20210924114632
# Stopping Zammad
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to stop 'zammad.service'.
Authenticating as: Ubuntu (adminsoc)
Password: Failed to stop zammad.service: Connection timed out
See system logs and 'systemctl status zammad.service' for details.
polkit-agent-helper-1: pam_authenticate failed: Authentication failure
# Checking requirements
# ... Dropping current database zammad
PG::ObjectInUse: ERROR: database "zammad" is being accessed by other users
DETAIL: There are 11 other sessions using the database.
Couldn't drop database 'zammad'
rake aborted!
ActiveRecord::StatementInvalid: PG::ObjectInUse: ERROR: database "zammad" is being accessed by other users
DETAIL: There are 11 other sessions using the database.
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `async_exec'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `block (2 levels) in execute'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:91:in `block in execute'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:728:in `block (2 levels) in log'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:727:in `block in log'6.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:90:in `execute'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/postgresql/schema_statements.rb:54:in `drop_database'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/postgresql_database_tasks.rb:34:in `drop'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:192:in `drop'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:208:in `block in drop_current'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:479:in `block (2 levels) in each_current_configuration'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:476:in `each'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:476:in `block in each_current_configuration'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:475:in `each'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:475:in `each_current_configuration'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:207:in `drop_current'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/railties/databases.rake:62:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/rake-13.0.6/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli/exec.rb:63:in `load'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli/exec.rb:63:in `kernel_load'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli/exec.rb:28:in `run'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli.rb:494:in `exec'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/vendor/thor/lib/thor.rb:392:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli.rb:30:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/vendor/thor/lib/thor/base.rb:485:in `start'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli.rb:24:in `start'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/exe/bundle:49:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/friendly_errors.rb:130:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/exe/bundle:37:in `<top (required)>'
/opt/zammad/bin/bundle:5:in `load'
/opt/zammad/bin/bundle:5:in `<main>'
Caused by:
PG::ObjectInUse: ERROR: database "zammad" is being accessed by other users
DETAIL: There are 11 other sessions using the database.
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `async_exec'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `block (2 levels) in execute'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:91:in `block in execute'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:728:in `block (2 levels) in log'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-6.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
6.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:727:in `block in log'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activesupport-/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/connection_adapters/postgresql/schema_statements.rb:54:in `drop_database'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/postgresql_database_tasks.rb:34:in `drop'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:192:in `drop'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:208:in `block in drop_current'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/tasks/database_tasks.rb:479:in `block (2 levels) in each_current_configuration'6.0.4.1/lib/active_record/tasks/database_tasks.rb:207:in `drop_current'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/railties/databases.rake:62:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/activerecord-6.0.4.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/rake-13.0.6/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli/exec.rb:63:in `load'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli/exec.rb:63:in `kernel_load'
2.2.16/lib/bundler/vendor/thor/lib/thor/base.rb:485:in `start'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/cli.rb:24:in `start'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/exe/bundle:49:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/lib/bundler/friendly_errors.rb:130:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/2.7.0/gems/bundler-2.2.16/exe/bundle:37:in `<top (required)>'
/opt/zammad/bin/bundle:5:in `load'
/opt/zammad/bin/bundle:5:in `<main>'
Tasks: TOP => db:drop:_unsafe
(See full trace by running task with --trace)
# ... Creating database zammad for owner zammad
Password:
su: Authentication failure
# Restoring PostgreSQL DB
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation "public.chat_topics" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation "public.chat_topics" does not exist
ALTER TABLE
DROP INDEX
DROP INDEX
DROP INDEX
ERROR: index "index_mentions_on_mentionable_type_and_mentionable_id" does not exist
DROP INDEX
DROP INDEX
DROP INDEX
ERROR: index "index_chat_topics_on_name" does not exist
DROP INDEX
DROP INDEX
DROP INDEX
ALTER TABLE
ERROR: cannot drop constraint users_pkey on table public.users because other objects depend on it
DETAIL: constraint fk_rails_5e7c1bf746 on table public.core_workflows depends on index public.users_pkey
constraint fk_rails_50bf89399d on table public.core_workflows depends on index public.users_pkey
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation "public.chat_topics" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation "public.chat_topics" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
DROP SEQUENCE
DROP TABLE
DROP SEQUENCE
ERROR: cannot drop table public.users because other objects depend on it
DETAIL: constraint fk_rails_5e7c1bf746 on table public.core_workflows depends on table public.users
constraint fk_rails_50bf89399d on table public.core_workflows depends on table public.users
HINT: Use DROP ... CASCADE to drop the dependent objects too.
DROP TABLE
DROP SEQUENCE
DROP TABLE
DROP SEQUENCE
DROP TABLE
ERROR: sequence "chat_topics_id_seq" does not exist
ERROR: table "chat_topics" does not exist
DROP SEQUENCE
DROP TABLE
DROP SEQUENCE
DROP TABLE
SET
SET
CREATE TABLE
CREATE SEQUENCE
ALTER SEQUENCE
CREATE TABLE
CREATE SEQUENCE
ALTER SEQUENCE
CREATE SEQUENCE
ALTER SEQUENCE
ERROR: relation "users" already exists
CREATE SEQUENCE
ALTER SEQUENCE
CREATE TABLE
CREATE SEQUENCE
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COPY 0
COPY 1268
COPY 1
COPY 3
COPY 264
COPY 1
COPY 4
COPY 6
COPY 7
COPY 3
COPY 12
COPY 2321
COPY 7
COPY 44
COPY 548
COPY 0
COPY 75013
COPY 6
COPY 30
ERROR: duplicate key value violates unique constraint "users_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY users, line 1
COPY 0
setval
--------
429431
(1 row)
setval
--------
8946
(1 row)
setval
--------
14
(1 row)
setval
--------
311
(1 row)
setval
--------
317
(1 row)
setval
--------
1
(1 row)
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: multiple primary keys for table "users" are not allowed
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "schedulers" violates foreign key constraint "fk_rails_08966259e8"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "online_notifications" violates foreign key constraint "fk_rails_0c0055c5df"
DETAIL: Key (created_by_id)=(13) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "overviews" violates foreign key constraint "fk_rails_13fe2fde45"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "stores" violates foreign key constraint "fk_rails_17354e2aa6"
DETAIL: Key (created_by_id)=(14) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "mentions" violates foreign key constraint "fk_rails_1b711e94aa"
DETAIL: Key (user_id)=(8) is not present in table "users".
ERROR: insert or update on table "knowledge_base_answer_translations" violates foreign key constraint "fk_rails_20d30feefb"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "report_profiles" violates foreign key constraint "fk_rails_214a4c247b"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "histories" violates foreign key constraint "fk_rails_317bea7955"
DETAIL: Key (created_by_id)=(14) is not present in table "users".
ERROR: insert or update on table "channels" violates foreign key constraint "fk_rails_32268ed43d"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "text_modules" violates foreign key constraint "fk_rails_343b2c0fce"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "triggers" violates foreign key constraint "fk_rails_35c0846653"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "avatars" violates foreign key constraint "fk_rails_36592d9368"
DETAIL: Key (updated_by_id)=(14) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "ticket_articles" violates foreign key constraint "fk_rails_38b783461b"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "ticket_articles" violates foreign key constraint "fk_rails_3cb6a3675a"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "jobs" violates foreign key constraint "fk_rails_3e355905b6"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "postmaster_filters" violates foreign key constraint "fk_rails_4b17873e0f"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "authorizations" violates foreign key constraint "fk_rails_4ecef5b8c5"
DETAIL: Key (user_id)=(171) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "groups" violates foreign key constraint "fk_rails_55ff2495b5"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "knowledge_base_answers" violates foreign key constraint "fk_rails_564f85e760"
DETAIL: Key (published_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "tickets" violates foreign key constraint "fk_rails_5685ed71b0"
DETAIL: Key (customer_id)=(69) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "activity_streams" violates foreign key constraint "fk_rails_5e0981116b"
DETAIL: Key (created_by_id)=(25) is not present in table "users".
ERROR: insert or update on table "tags" violates foreign key constraint "fk_rails_5f245fd6a7"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "organizations" violates foreign key constraint "fk_rails_6b945c40b8"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "chat_sessions" violates foreign key constraint "fk_rails_6d2ee2e9b7"
DETAIL: Key (user_id)=(13) is not present in table "users".
ERROR: insert or update on table "karma_activity_logs" violates foreign key constraint "fk_rails_6d31f4fe31"
DETAIL: Key (user_id)=(22) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "avatars" violates foreign key constraint "fk_rails_7f23a117cf"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "triggers" violates foreign key constraint "fk_rails_7f3d25350f"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "signatures" violates foreign key constraint "fk_rails_82877eeea3"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "text_modules" violates foreign key constraint "fk_rails_84148bfddb"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "macros" violates foreign key constraint "fk_rails_84f97aa218"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "groups_users" violates foreign key constraint "fk_rails_8546c71994"
DETAIL: Key (user_id)=(13) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "stats_stores" violates foreign key constraint "fk_rails_8b167ccaf8"
DETAIL: Key (created_by_id)=(250) is not present in table "users".
ERROR: insert or update on table "translations" violates foreign key constraint "fk_rails_8cb1380a17"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "knowledge_base_answers" violates foreign key constraint "fk_rails_9310a46d9c"
DETAIL: Key (archived_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "tickets" violates foreign key constraint "fk_rails_939b990649"
DETAIL: Key (owner_id)=(13) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "postmaster_filters" violates foreign key constraint "fk_rails_99ae723fc6"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "chat_agents" violates foreign key constraint "fk_rails_99fffe7295"
DETAIL: Key (updated_by_id)=(14) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "ticket_time_accountings" violates foreign key constraint "fk_rails_a206f3ed55"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "email_addresses" violates foreign key constraint "fk_rails_a24ae390cf"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "mentions" violates foreign key constraint "fk_rails_ab5f91f9d0"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "chat_messages" violates foreign key constraint "fk_rails_af8ea0a844"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "online_notifications" violates foreign key constraint "fk_rails_bc45d196c5"
DETAIL: Key (user_id)=(14) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "report_profiles" violates foreign key constraint "fk_rails_c0dbdacc53"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "ticket_articles" violates foreign key constraint "fk_rails_c2dbb9e7aa"
DETAIL: Key (origin_by_id)=(110) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "jobs" violates foreign key constraint "fk_rails_c4f56411f8"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "chats" violates foreign key constraint "fk_rails_cb3fe7fa69"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "mentions" violates foreign key constraint "fk_rails_cf60468410"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "chat_agents" violates foreign key constraint "fk_rails_d009868f7d"
DETAIL: Key (created_by_id)=(14) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "karma_users" violates foreign key constraint "fk_rails_d2cc0e2912"
DETAIL: Key (user_id)=(86) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "translations" violates foreign key constraint "fk_rails_d6e6d9635d"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "roles_users" violates foreign key constraint "fk_rails_e2a7142459"
DETAIL: Key (user_id)=(8) is not present in table "users".
ERROR: insert or update on table "knowledge_base_answer_translations" violates foreign key constraint "fk_rails_e55f86d7ec"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "user_devices" violates foreign key constraint "fk_rails_e700a96826"
DETAIL: Key (user_id)=(8) is not present in table "users".
ERROR: insert or update on table "object_manager_attributes" violates foreign key constraint "fk_rails_e812039563"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "roles" violates foreign key constraint "fk_rails_e85422db7e"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "organizations" violates foreign key constraint "fk_rails_edec76c076"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "tickets" violates foreign key constraint "fk_rails_edf0f77848"
DETAIL: Key (updated_by_id)=(8) is not present in table "users".
ERROR: insert or update on table "online_notifications" violates foreign key constraint "fk_rails_ee155e3c0c"
DETAIL: Key (updated_by_id)=(13) is not present in table "users".
ERROR: insert or update on table "cti_caller_ids" violates foreign key constraint "fk_rails_f03ef195fa"
DETAIL: Key (user_id)=(27) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "channels" violates foreign key constraint "fk_rails_f1fc2a34ff"
DETAIL: Key (created_by_id)=(8) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "taskbars" violates foreign key constraint "fk_rails_f3c54fdb6d"
DETAIL: Key (user_id)=(15) is not present in table "users".
ALTER TABLE
ERROR: insert or update on table "tickets" violates foreign key constraint "fk_rails_f694a04b71"
DETAIL: Key (created_by_id)=(26) is not present in table "users".
ALTER TABLE
ALTER TABLE
ERROR: insert or update on table "recent_views" violates foreign key constraint "fk_rails_fa835b7d0c"
DETAIL: Key (created_by_id)=(13) is not present in table "users".
ALTER TABLE
# Restoring Files
# Ensuring correct file rights ...
# Clearing Cache ...
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/railtie/configuration.rb:97:in `method_missing': undefined method `websocket_session_store' for #<Rails::Application::Configuration:0x000055d346786f80> (NoMethodError)
from /opt/zammad/config/initializers/log_websocket_session_store.rb:3:in `<main>'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:285:in `block in load'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:257:in `load_dependency'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:285:in `load'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/engine.rb:663:in `block in load_config_initializer'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/notifications.rb:170:in `instrument'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/engine.rb:662:in `load_config_initializer'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/engine.rb:620:in `block (2 levels) in <class:Engine>'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/engine.rb:619:in `each'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/engine.rb:619:in `block in <class:Engine>'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/initializable.rb:32:in `instance_exec'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/initializable.rb:32:in `run'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/initializable.rb:61:in `block in run_initializers'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:228:in `block in tsort_each'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:422:in `block (2 levels) in each_strongly_connected_component_from'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:431:in `each_strongly_connected_component_from'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:421:in `block in each_strongly_connected_component_from'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/initializable.rb:50:in `each'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/initializable.rb:50:in `tsort_each_child'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:415:in `call'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:415:in `each_strongly_connected_component_from'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:349:in `block in each_strongly_connected_component'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:347:in `each'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:347:in `call'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:347:in `each_strongly_connected_component'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:226:in `tsort_each'
from /opt/zammad/vendor/ruby-2.6.8/lib/ruby/2.6.0/tsort.rb:205:in `tsort_each'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/initializable.rb:60:in `run_initializers'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/application.rb:361:in `initialize!'
from /opt/zammad/config/environment.rb:5:in `<main>'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:21:in `require'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:21:in `block in require_with_bootsnap_lfi'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/loaded_features_index.rb:65:in `register'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:20:in `require_with_bootsnap_lfi'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:29:in `require'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:291:in `block in require'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:257:in `load_dependency'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:291:in `require'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/application.rb:337:in `require_environment!'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/command/actions.rb:28:in `require_environment!'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/command/actions.rb:15:in `require_application_and_environment!'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/commands/runner/runner_command.rb:29:in `perform'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/thor-1.1.0/lib/thor/command.rb:27:in `run'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/thor-1.1.0/lib/thor/invocation.rb:127:in `invoke_command'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/thor-1.1.0/lib/thor.rb:392:in `dispatch'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/command/base.rb:69:in `perform'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/command.rb:46:in `invoke'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/railties-5.2.4.6/lib/rails/commands.rb:18:in `<main>'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:21:in `require'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:21:in `block in require_with_bootsnap_lfi'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/loaded_features_index.rb:65:in `register'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:20:in `require_with_bootsnap_lfi'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:29:in `require'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:291:in `block in require'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:257:in `load_dependency'
from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies.rb:291:in `require'
from /opt/zammad/bin/rails:9:in `<main>'
./zammad_restore.sh: line 39: _zammad: command not found
# Starting Zammad
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to start 'zammad.service'.
Authenticating as: Ubuntu (adminsoc)
Password: Failed to start zammad.service: Connection timed out
See system logs and 'systemctl status zammad.service' for details.
polkit-agent-helper-1: pam_authenticate failed: Authentication failure
# Zammad restored successfully - Wed Nov 3 20:02:33 UTC 2021!
Here in the sections where it asks to place the password, it did not put anything and it automatically continued, and as you see at the end it indicates that everything is satisfactorily.
