Public bug reported:

When upgrading Ubuntu 22.04 to 24.04, otrs2 is not upgraded correctly.

The otrs2 upgrade script to 6.5.6-1 attempts to add columns to postgres
database tables calendar_appointment_plugin, oauth2_token,
oauth2_token_config

However, in the old version 6.2.2-2, these 3 tables don't exist at all,
not even without the new columns.

1) root@aev-usee-otrs:~# lsb_release -rd
No LSB modules are available.
Description:    Ubuntu 24.04.1 LTS
Release:        24.04
2) root@aev-usee-otrs:~# apt-cache policy otrs2
otrs2:
  Installed: 6.2.2-2
  Candidate: 6.5.6-1
  Version table:
     6.5.6-1 500
        500 https://sstapt.ctie.etat.lu/ubuntu noble/universe amd64 Packages
 *** 6.2.2-2 100
        100 /var/lib/dpkg/status

(The problem happened with the 6.5.6-1 version. The output here is from
a second attempt where I held the package. I also had to hold
libsisimai-perl btw)

3) What I expected to happen: Database upgrade should succeed, i.e.
tables need to be created first before adding additional columns to them

4) What happened instead: the upgrade attempted to add column
dbcrud_uuid to table oauth2_token_config, however the table
oauth2_token_config did not exist at all

** Affects: otrs2 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2091391

Title:
  otrs2 is not upgraded correctly when going from 22.04 to 24.04

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/otrs2/+bug/2091391/+subscriptions


-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to