Bug 1183118

Summary:	Upgrade to Leap 15.3 does not work for postgresql
Product:	[openSUSE] openSUSE Distribution	Reporter:	Axel Braun <axel.braun>
Component:	Upgrade Problems	Assignee:	Reinhard Max <max>
Status:	RESOLVED FIXED	QA Contact:	Jiri Srain <jsrain>
Severity:	Normal
Priority:	P5 - None	CC:	behlert, dimstar, duge, gyribeiro, jmassaguerpla, lubos.kocman, maint-coord, meissner, mlin, zkalmar
Version:	Leap 15.3
Target Milestone:	---
Hardware:	Other
OS:	Other
Whiteboard:
Found By:	---	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description Axel Braun 2021-03-05 18:36:10 UTC

Problem: postgresql12-llvmjit-12.5-lp152.3.13.1.aarch64 requires postgresql12-server = 12.5-lp152.3.13.1, but this requirement cannot be provided
  deleted providers: postgresql12-server-12.5-lp152.3.13.1.aarch64
 Solution 1: deinstallation of postgresql-llvmjit-12.0.1-lp152.3.3.2.noarch
 Solution 2: keep obsolete postgresql12-server-12.5-lp152.3.13.1.aarch64
 Solution 3: break postgresql12-llvmjit-12.5-lp152.3.13.1.aarch64 by ignoring some of its dependencies

Looks like there is no postgresql12-llvmjit in Leap 15.3
Instead we have a postgresql-llvmjit in version 12-8.11.3 , and only 83b. Is this package obsolete? Should this not be resolved automatically by zypper dup?

Comment 1 Reinhard Max 2021-03-12 13:46:51 UTC

Hmm - it looks like several things went wrong, leading to this situation:

The current postgresql and postgresql{11,12,13} packages produce the llvmjit subpackage only when they are being built for openSUSE, but not for SLE, because clang is not supportet there.

For Leap 15.2 the packages coming from SLE were rebuilt in an openSUSE context, so the llvmjit subpackage was there, but Leap 15.3 gets the binary packages that were built for SLE15-SP3, so the llvmjit subpackage is missing.

And as if that wouldn't be enough confusion, SLE15-SP3 (and hence Leap 15.3) inherits the postgresql-llvmjit-12-8.11.3 binary RPM from an older SP where the spec file did not yet contain the exclusion for SLE.

So, Axel, to get your installation into a clesn state you can chose solution 1.

I think for cleaning this up we should do the following:

 1. Stop suppressing the build of the llvmjit subpackages on SLE.
 2. Suppress delivery of llvmjit to SLE.
 3. Make sure it does get delivered to Leap.
 4. Make sure that abandoned subpackages of an older version of a package do not get inherited by newer SPs that don't contain the newer version.

Comment 2 Stefan Behlert 2021-03-12 13:52:24 UTC

This sounds like a good plan. We can build the package, and ship it to LEAP/PackageHub, This should not be an issue. IIRC we do it for other packages/subpackage combination, too.

Comment 6 Swamp Workflow Management 2021-05-05 19:22:45 UTC

SUSE-OU-2021:1518-1: An update that has two optional fixes can now be installed.

Category: optional (low)
Bug References: 1179945,1183118
CVE References: 
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql10-10.16-8.32.1
SUSE Linux Enterprise Module for Legacy Software 15-SP3 (src):    postgresql10-10.16-8.32.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql10-10.16-8.32.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 7 Swamp Workflow Management 2021-05-10 19:15:49 UTC

openSUSE-OU-2021:0703-1: An update that has two optional fixes can now be installed.

Category: optional (low)
Bug References: 1179945,1183118
CVE References: 
JIRA References: 
Sources used:
openSUSE Leap 15.2 (src):    postgresql10-10.16-lp152.2.18.1, postgresql12-12.6-lp152.3.19.1

Comment 9 OBSbugzilla Bot 2021-05-14 14:20:03 UTC

This is an autogenerated message for OBS integration:
This bug (1183118) was mentioned in
https://build.opensuse.org/request/show/893131 Factory / postgresql96
https://build.opensuse.org/request/show/893132 Factory / postgresql10
https://build.opensuse.org/request/show/893133 Factory / postgresql11
https://build.opensuse.org/request/show/893134 Factory / postgresql12
https://build.opensuse.org/request/show/893135 Factory / postgresql13

Comment 10 OBSbugzilla Bot 2021-05-18 14:20:03 UTC

This is an autogenerated message for OBS integration:
This bug (1183118) was mentioned in
https://build.opensuse.org/request/show/894073 Factory / postgresql

Comment 11 Reinhard Max 2021-05-20 12:28:56 UTC

done.

Comment 12 Swamp Workflow Management 2021-05-27 19:16:16 UTC

SUSE-SU-2021:1782-1: An update that solves two vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1183118,1183168,1185924,1185925
CVE References: CVE-2021-32027,CVE-2021-32028
JIRA References: 
Sources used:
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql10-10.17-4.16.4
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql10-10.17-4.16.4

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 13 Swamp Workflow Management 2021-05-27 19:21:12 UTC

SUSE-SU-2021:1784-1: An update that solves three vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1183118,1183168,1185924,1185925,1185926
CVE References: CVE-2021-32027,CVE-2021-32028,CVE-2021-32029
JIRA References: 
Sources used:
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql13-13.3-3.9.2, postgresql13-13.3-3.9.3
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql13-13.3-3.9.2, postgresql13-13.3-3.9.3

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 14 Swamp Workflow Management 2021-05-27 19:23:51 UTC

SUSE-SU-2021:1785-1: An update that solves three vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1183118,1183168,1185924,1185925,1185926
CVE References: CVE-2021-32027,CVE-2021-32028,CVE-2021-32029
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP3 (src):    postgresql13-13.3-5.10.1
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql13-13.3-5.10.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP2 (src):    postgresql13-13.3-5.10.1
SUSE Linux Enterprise Module for Basesystem 15-SP3 (src):    postgresql13-13.3-5.10.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql13-13.3-5.10.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 15 Swamp Workflow Management 2021-05-27 19:25:27 UTC

SUSE-SU-2021:1783-1: An update that solves four vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1182040,1183118,1183168,1185924,1185925,1185926
CVE References: CVE-2021-32027,CVE-2021-32028,CVE-2021-32029,CVE-2021-3393
JIRA References: 
Sources used:
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql12-12.7-3.15.3
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql12-12.7-3.15.3

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 20 Reinhard Max 2021-06-10 12:12:44 UTC

*** Bug 1186856 has been marked as a duplicate of this bug. ***

Comment 25 Jordi Massaguer 2021-06-15 08:43:25 UTC

Hi! Any news on this one? Thanks.

Comment 26 Marcus Meissner 2021-06-15 08:56:09 UTC

current update would not be instalable on SLES.

wauiting for a resubmit from Reinhard

Comment 27 Reinhard Max 2021-06-15 12:34:39 UTC

I am a bit lost here, because compiling with llvmjit enabled leaves traces deep inside Makefiles and so within server-devel, so that server extensions can also take advantage of the JIT compilation.

So, I fear I have to revert it all and disable llvmjit again, for SLE and Leap, if we don't see a chance to get it into SLE in a supported form without having to provide full support LLVM and clang, which the maintainers don't want at this point.

Comment 28 Marcus Meissner 2021-06-15 12:35:38 UTC

hmm, perhaps we can just drop the implicit requiores

Comment 29 Marcus Meissner 2021-06-15 12:36:10 UTC

 %if %{with llvm}
-Requires:       clang
-Requires:       llvm
+Recommends:     clang
+Recommends:     llvm
 %endif

Comment 30 Marcus Meissner 2021-06-15 12:37:27 UTC

i made this changes locally already. If they are fine we can move forward

Comment 31 Marcus Meissner 2021-06-15 12:50:00 UTC

we could ship llvm and clang via packagehub subpackages.hmm

Comment 32 Reinhard Max 2021-06-15 13:07:38 UTC

(In reply to Marcus Meissner from comment #29)
>  %if %{with llvm}
> -Requires:       clang
> -Requires:       llvm
> +Recommends:     clang
> +Recommends:     llvm
>  %endif

This would make the package installable, but the question is if the package is also usable in this form, i.e. if it can compile server extensions without LLVM support.

Comment 33 Swamp Workflow Management 2021-06-17 16:18:05 UTC

SUSE-SU-2021:1994-1: An update that solves three vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1183118,1183168,1185924,1185925,1185926
CVE References: CVE-2021-32027,CVE-2021-32028,CVE-2021-32029
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql12-12.7-8.20.1
SUSE Linux Enterprise Module for Legacy Software 15-SP3 (src):    postgresql12-12.7-8.20.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql12-12.7-8.20.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 34 Swamp Workflow Management 2021-06-18 22:16:48 UTC

SUSE-RU-2021:2087-1: An update that has one recommended fix can now be installed.

Category: recommended (moderate)
Bug References: 1183118
CVE References: 
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql-13-4.9.3
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP2 (src):    postgresql-13-4.9.3
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql-13-4.9.3

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 36 Swamp Workflow Management 2021-06-24 13:16:39 UTC

openSUSE-RU-2021:0912-1: An update that has one recommended fix can now be installed.

Category: recommended (moderate)
Bug References: 1183118
CVE References: 
JIRA References: 
Sources used:
openSUSE Leap 15.2 (src):    postgresql-13-lp152.3.9.1

Comment 37 Reinhard Max 2021-06-28 09:59:55 UTC

(In reply to Marcus Meissner from comment #29)
>  %if %{with llvm}
> -Requires:       clang
> -Requires:       llvm
> +Recommends:     clang
> +Recommends:     llvm
>  %endif

I meanwhile found a way to package postgresqlXX-server-devel in a way that makes LLVM optional. By patching a Makefile I got it to build server extensions with LLVM support if the core was built with LLVM support and both, clang and llvm are installerd. If any of the three conditions is not met, the extension will be built without support for LLVM. Will submit this soon.

Comment 38 Swamp Workflow Management 2021-07-01 22:19:09 UTC

SUSE-RU-2021:2228-1: An update that has one recommended fix can now be installed.

Category: recommended (moderate)
Bug References: 1183118
CVE References: 
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP3 (src):    postgresql-13-10.3.3
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (src):    postgresql-13-10.3.3
SUSE Linux Enterprise Module for Basesystem 15-SP3 (src):    postgresql-13-10.3.3

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 39 Swamp Workflow Management 2021-07-09 22:20:17 UTC

SUSE-RU-2021:2290-1: An update that has two recommended fixes can now be installed.

Category: recommended (moderate)
Bug References: 1183118,1187751
CVE References: 
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP3 (src):    postgresql13-13.3-5.13.1
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql13-13.3-5.13.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (src):    postgresql13-13.3-5.13.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP2 (src):    postgresql13-13.3-5.13.1
SUSE Linux Enterprise Module for Basesystem 15-SP3 (src):    postgresql13-13.3-5.13.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql13-13.3-5.13.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 40 Swamp Workflow Management 2021-07-10 10:25:49 UTC

openSUSE-SU-2021:1994-1: An update that solves three vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1183118,1183168,1185924,1185925,1185926
CVE References: CVE-2021-32027,CVE-2021-32028,CVE-2021-32029
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql12-12.7-8.20.1

Comment 41 Swamp Workflow Management 2021-07-10 22:34:15 UTC

openSUSE-RU-2021:2290-1: An update that has two recommended fixes can now be installed.

Category: recommended (moderate)
Bug References: 1183118,1187751
CVE References: 
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql13-13.3-5.13.1

Comment 42 Swamp Workflow Management 2021-07-10 22:46:05 UTC

openSUSE-RU-2021:2228-1: An update that has one recommended fix can now be installed.

Category: recommended (moderate)
Bug References: 1183118
CVE References: 
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql-13-10.3.3

Comment 43 Swamp Workflow Management 2021-07-11 13:39:29 UTC

SUSE-SU-2021:1785-2: An update that solves three vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1183118,1183168,1185924,1185925,1185926
CVE References: CVE-2021-32027,CVE-2021-32028,CVE-2021-32029
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (src):    postgresql13-13.3-5.10.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 44 Swamp Workflow Management 2021-07-11 13:46:37 UTC

openSUSE-SU-2021:1785-1: An update that solves three vulnerabilities and has three fixes is now available.

Category: security (moderate)
Bug References: 1179945,1183118,1183168,1185924,1185925,1185926
CVE References: CVE-2021-32027,CVE-2021-32028,CVE-2021-32029
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql13-13.3-5.10.1

Comment 45 Swamp Workflow Management 2021-08-19 16:28:21 UTC

SUSE-SU-2021:2777-1: An update that solves two vulnerabilities and has four fixes is now available.

Category: security (moderate)
Bug References: 1179765,1179945,1183118,1183168,1185924,1185925
CVE References: CVE-2021-32027,CVE-2021-32028
JIRA References: 
Sources used:
SUSE Linux Enterprise Server for SAP 15 (src):    postgresql10-10.17-4.35.1
SUSE Linux Enterprise Server 15-LTSS (src):    postgresql10-10.17-4.35.1
SUSE Linux Enterprise High Performance Computing 15-LTSS (src):    postgresql10-10.17-4.35.1
SUSE Linux Enterprise High Performance Computing 15-ESPOS (src):    postgresql10-10.17-4.35.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 47 Swamp Workflow Management 2021-10-20 16:20:30 UTC

SUSE-SU-2021:3481-1: An update that solves two vulnerabilities and has 8 fixes is now available.

Category: security (important)
Bug References: 1178961,1179765,1179945,1183118,1183168,1185924,1185925,1185952,1187751,1190177
CVE References: CVE-2021-32027,CVE-2021-32028
JIRA References: 
Sources used:
SUSE OpenStack Cloud Crowbar 9 (src):    postgresql10-10.18-4.19.6
SUSE OpenStack Cloud Crowbar 8 (src):    postgresql10-10.18-4.19.6
SUSE OpenStack Cloud 9 (src):    postgresql10-10.18-4.19.6
SUSE OpenStack Cloud 8 (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Server for SAP 12-SP4 (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Server for SAP 12-SP3 (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Server 12-SP4-LTSS (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Server 12-SP3-LTSS (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Server 12-SP3-BCL (src):    postgresql10-10.18-4.19.6
SUSE Linux Enterprise Server 12-SP2-BCL (src):    postgresql10-10.18-4.19.6
HPE Helion Openstack 8 (src):    postgresql10-10.18-4.19.6

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 50 Reinhard Max 2022-02-04 11:37:28 UTC

I think this is done, but feel free to reopen, if not.