Bugzilla – Bug 1183118
Upgrade to Leap 15.3 does not work for postgresql
Last modified: 2023-11-09 10:20:25 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?
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.
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.
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.
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
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
This is an autogenerated message for OBS integration: This bug (1183118) was mentioned in https://build.opensuse.org/request/show/894073 Factory / postgresql
done.
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.
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.
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.
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.
*** Bug 1186856 has been marked as a duplicate of this bug. ***
Hi! Any news on this one? Thanks.
current update would not be instalable on SLES. wauiting for a resubmit from Reinhard
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.
hmm, perhaps we can just drop the implicit requiores
%if %{with llvm} -Requires: clang -Requires: llvm +Recommends: clang +Recommends: llvm %endif
i made this changes locally already. If they are fine we can move forward
we could ship llvm and clang via packagehub subpackages.hmm
(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.
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.
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.
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
(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.
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.
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.
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
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
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
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.
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
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.
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.
I think this is done, but feel free to reopen, if not.