Problem with tickets after Zammad update

[fredtz]

Infos:

• Used Zammad version: 3.3.x
• Used Zammad installation source: (source, package, …) - yum package updater
  zammad-3.3.0-1588686729.008ca499.centos7.x86_64
• Operating system: Centos 7.8
• Browser + version: Chrome 81.0.x

Good day. After automated upgrade of OS by cron we faced with problem of Zammad support system tickets update. It does not allow to modify or create any ticket

Expected behavior:

• We want to update or close a dozen of previously created tickets.

Actual behavior:

• Creation of new tickets or closing old ones does not possible.

Steps to reproduce the behavior:

• Seems like we lost some tables and relations in our Postgres SQL DB. We tried to follow your recommendations in Zammad 3.1.x to 3.2.0 update. PG::DuplicateTable: ERROR: relation "groups_macros" already exists for finishing of migration but unfortunately it not help. Here is some excerpt from cli

before migration
zammad run rake db:version

Current version: 20171207000001

after migration
[root@support conf.d]# zammad run rake db:version

Current version: 20180327170847

[fredtz]

• some extracts from migration update log:

[root@support conf.d]# zammad run rails db:migrate --trace
** Invoke db:migrate (first_time)
** Invoke db:load_config (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:load_config
** Execute db:migrate
== 20171213000001 ChangeAuthorizationTokenSize: migrating =====================
– change_column(:authorizations, :token, :string, {:limit=>2500})
-> 0.0731s
== 20171213000001 ChangeAuthorizationTokenSize: migrated (0.0761s) ============

== 20180108000001 ChangeExchangeExternalSyncIdentifier: migrating =============
== 20180108000001 ChangeExchangeExternalSyncIdentifier: migrated (0.0030s) ====

== 20180111000001 LdapSamaccountnameToUid: migrating ==========================
== 20180111000001 LdapSamaccountnameToUid: migrated (0.0437s) =================

== 20180116000001 SettingTicketNumberIgnoreSystemIdSupport: migrating =========
== 20180116000001 SettingTicketNumberIgnoreSystemIdSupport: migrated (0.0237s)

== 20180128000001 ChatAddIpCountry: migrating =================================
– add_column(:chats, :block_ip, :string, {:limit=>5000, :null=>true})
-> 0.0343s
– add_column(:chats, :block_country, :string, {:limit=>5000, :null=>true})
-> 0.0005s
== 20180128000001 ChatAddIpCountry: migrated (0.0360s) ========================

== 20180202000001 SidebarCustomerOpenTicketColored: migrating =================
== 20180202000001 SidebarCustomerOpenTicketColored: migrated (0.0260s) ========

== 20180202000002 CustomLdapLoginAttribute: migrating =========================
== 20180202000002 CustomLdapLoginAttribute: migrated (0.0075s) ================

== 20180220000001 SettingAttachmentPreview: migrating =========================
== 20180220000001 SettingAttachmentPreview: migrated (0.0402s) ================

== 20180220000002 SettingUserOrganizationSelectorWithEmail: migrating =========
== 20180220000002 SettingUserOrganizationSelectorWithEmail: migrated (0.0237s)

== 20180220171219 CheckForObjectAttributes: migrating =========================
== 20180220171219 CheckForObjectAttributes: migrated (0.8810s) ================

== 20180226085743 Issue1660FixTreeSelectConfigurations: migrating =============
== 20180226085743 Issue1660FixTreeSelectConfigurations: migrated (0.0022s) ====

== 20180306084119 CustomHtmlEmailCssFont: migrating ===========================
== 20180306084119 CustomHtmlEmailCssFont: migrated (0.0080s) ==================

== 20180320000001 SettingTableGroupByShowCount: migrating =====================
== 20180320000001 SettingTableGroupByShowCount: migrated (0.0241s) ============

== 20180327170847 Issue1905ExchangeLoginFromRemoteId: migrating ===============
== 20180327170847 Issue1905ExchangeLoginFromRemoteId: migrated (0.0193s) ======

== 20180410000001 CleanupUserPreferencesNotificationSound2: migrating =========
rails aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedTable: ERROR: relation “active_job_locks” does not exist
LINE 8: WHERE a.attrelid = ‘“active_job_locks”’::regc…
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = ‘“active_job_locks”’::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
…

Caused by:
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation “active_job_locks” does not exist
LINE 8: WHERE a.attrelid = ‘“active_job_locks”’::regc…
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = ‘“active_job_locks”’::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
…