DB update incomplete after unattended upgrade

  • Used Zammad version: 5.4.0-1679657495.4658f661.focal
  • Used Zammad installation type: package
  • Operating system: Ubuntu 20.04 LTS
  • Browser + version: irrelevant

Expected behavior:

  • Zammad works as it used to be

Actual behavior:

  • apt seems to have upgraded the zammad version on 03/25/2023 from 5.3.1-1675424755.1737dccb.focal to 5.4.0-1679657495.4658f661.focal. This must have taken place unattended. I assume that apt has the automatic upgrade activated.
    During this upgrade it looks like the database upgrade was not (fully) successful. Maybe because postgresql was upgraded at the same time by apt.
    When I try to login I receive an error that the app column in table taskbars is missing. That correspond to the script name 20230120163410_taskbars_add_apps_support.rb that I have found in db/migrate folder.
    I’ve found the apt log file which states that these updated were done on saturday but I can’t find any log according to the update itself. Is there any chance to rerun the update scripts to the database? Is there any log file to find out what has gone wrong?
    This happened to two different installations in my responsibility.

I would appreciate highly any help.

Steps to reproduce the behavior:

  • Unattended upgrade from version 5.3.1-1675424755.1737dccb.focal to 5.4.0-1679657495.4658f661.focal

Don’t update your database server and Zammad at the same time.

And as the documentation suggests: Don’t update unattended. Other wise you may find suprises without any knowledge of what actually hit the fan.

Run your migrations. Preferably run the whole postinstall script that’s running during an upgrade: /opt/zammad/contrib/packager.io/postinstall.sh