Bug 41597 - Update to 4.1 fails with univention-postgresql due to 3.2 errata components
Update to 4.1 fails with univention-postgresql due to 3.2 errata components
Status: CLOSED FIXED
Product: UCS
Classification: Unclassified
Component: Update - Release updates
UCS 4.1
Other Linux
: P5 critical (vote)
: UCS 4.1-2-errata
Assigned To: Janek Walkenhorst
Felix Botner
:
Depends on:
Blocks: 50627 40031 40515
  Show dependency treegraph
 
Reported: 2016-06-16 17:26 CEST by Janek Walkenhorst
Modified: 2019-12-11 13:41 CET (History)
2 users (show)

See Also:
What kind of report is it?: Bug Report
What type of bug is this?: 5: Major Usability: Impairs usability in key scenarios
Who will be affected by this bug?: 3: Will affect average number of installed domains
How will those affected feel about the bug?: 4: A User would return the product
User Pain: 0.343
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Janek Walkenhorst univentionstaff 2016-06-16 17:26:06 CEST
When updating to UCS 4.0 coming from UCS 3.2 not all errata scopes are deactivated:

  # ucr search --brief '^repository/online/component/[^/]+-errata$'
  repository/online/component/.*: <empty>
  repository/online/component/3.2-0-errata: false
  repository/online/component/3.2-1-errata: false
  repository/online/component/3.2-2-errata: false
  repository/online/component/3.2-3-errata: false
  repository/online/component/3.2-4-errata: false
  repository/online/component/3.2-5-errata: false
  repository/online/component/3.2-6-errata: false
  repository/online/component/3.2-7-errata: enabled
  repository/online/component/3.2-8-errata: enabled
  repository/online/component/4.0-0-errata: false
  repository/online/component/4.0-1-errata: false
  repository/online/component/4.0-2-errata: false
  repository/online/component/4.0-3-errata: false
  repository/online/component/4.0-4-errata: false
  repository/online/component/4.0-5-errata: enabled

this leads to postgresql-8.4 being available during the update to 4.1:

  # apt-cache policy postgresql-8.4
  postgresql-8.4:
    Installiert:           8.4.22lts6-0.29.201602291915
    Installationskandidat: 8.4.22lts6-0.29.201602291915
    Versionstabelle:
   *** 8.4.22lts6-0.29.201602291915 0
          500 http://updates.software-univention.de/3.2/maintained/component/ 3.2-8-errata/i386/ Packages
          100 /var/lib/dpkg/status
       8.4.22lts4-0.26.201509171802 0
          500 http://updates.software-univention.de/3.2/maintained/component/ 3.2-7-errata/i386/ Packages

this leads to apt trying to install {univention-,}postgresql-8.4 although postgresql-9.1 is already installed:

  [will be installed]:
    postgresql-8.4 univention-postgresql-8.4
  [will be updated]:
    postgresql-9.1 univention-postgresql

  Inst postgresql-9.1 [9.1.16-0.9.201509171755] (9.1.16-0.10.201510311538 Univention:updates.software-univention.de [i386]) []
  Inst postgresql-client-9.1 [9.1.16-0.9.201509171755] (9.1.16-0.10.201510311538 Univention:updates.software-univention.de [i386]) []
  […]
  Inst postgresql-8.4 (8.4.22lts6-0.29.201602291915 Univention Corporate Server:updates.software-univention.de [i386]) []
  Inst univention-postgresql [7.0.0-4.74.201407211112] (8.0.0-10.85.201511131445 Univention:updates.software-univention.de [all]) []
  Inst univention-postgresql-8.4 (8.0.0-10.85.201511131445 Univention:updates.software-univention.de [all]) []
  […]
  Conf postgresql-client-9.1 (9.1.16-0.10.201510311538 Univention:updates.software-univention.de [i386])
  […]
  Conf postgresql-9.1 (9.1.16-0.10.201510311538 Univention:updates.software-univention.de [i386])
  Conf postgresql-8.4 (8.4.22lts6-0.29.201602291915 Univention Corporate Server:updates.software-univention.de [i386])
  Conf univention-postgresql-8.4 (8.0.0-10.85.201511131445 Univention:updates.software-univention.de [all])
  Conf univention-postgresql (8.0.0-10.85.201511131445 Univention:updates.software-univention.de [all])

The update then fails with:
  iF  postgresql-8.4
  ii  postgresql-9.1
  iU  univention-postgresql
  iU  univention-postgresql-8.4

When going trough UCS 3.3 does not lead to the problem because <http://sdb.univention.de/1292> installs univention-postgresql-9.1, so apt does not have to decide between univention-postgresql-{8.4,9.1}.
Comment 1 Janek Walkenhorst univentionstaff 2016-07-12 12:13:39 CEST
r70926 Check if PostgreSQL 8.4 is installable (Bug #41597)
r70927 disable old (3.2-*) errata scopes if set (Bug #41597)
Comment 2 Felix Botner univentionstaff 2016-07-13 12:03:16 CEST
OK - update fails with 3.2 errata scopes and univention-postgres
     (due to installation of postgresql-8.4)
OK - update successful with apt.knut.univention.de with 3.2 errata scopes and 
     univention-postgres
OK - errata 3.2 scopes disabled during update
OK - postgresql-8.4 install test
Comment 3 Felix Botner univentionstaff 2016-07-18 11:09:39 CEST
scripts released, see 40515
Comment 4 Stefan Gohmann univentionstaff 2016-10-04 13:15:31 CEST
(In reply to Felix Botner from comment #3)
> scripts released, see 40515

OK, closed