Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 923620 - dev-db/postgresql: breaks with dev-libs/openssl-3.2.1-r1
Summary: dev-db/postgresql: breaks with dev-libs/openssl-3.2.1-r1
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: PgSQL Bugs
URL: https://www.postgresql.org/message-id...
Whiteboard:
Keywords:
Depends on:
Blocks: openssl32
  Show dependency tree
 
Reported: 2024-02-02 11:23 UTC by Patrick Lauer
Modified: 2024-02-06 03:57 UTC (History)
3 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Patrick Lauer gentoo-dev 2024-02-02 11:23:01 UTC
With openssl-3.2.1-r1 installed:

$ psql -U postgres -h 172.31.0.20
psql: error: connection to server at "172.31.0.20", port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
connection to server at "172.31.0.20", port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
double free or corruption (out)
Aborted

same machine, downgraded to 3.1.5:
$ psql -U postgres -h 172.31.0.21
psql (16.1)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

postgres=# 

reproduced on another machine. sad.


Portage 3.0.61 (python 3.11.7-final-0, default/linux/amd64/17.1, gcc-13, glibc-2.38-r10, 6.6.14-gentoo-x86_64 x86_64)
=================================================================
System uname: Linux-6.6.14-gentoo-x86_64-x86_64-AMD_Ryzen_9_3900X_12-Core_Processor-with-glibc2.38
KiB Mem:    65755708 total,  41121764 free
KiB Swap:   20971516 total,  20971516 free
Head commit of repository gentoo: d36558138eb686a683bb9a194302d8dec0af6c5c

sh bash 5.2_p26
ld GNU ld (Gentoo 2.41 p5) 2.41.0
app-misc/pax-utils:        1.3.7::gentoo
app-shells/bash:           5.2_p26::gentoo
dev-build/autoconf:        2.13-r8::gentoo, 2.72-r1::gentoo
dev-build/automake:        1.16.5-r2::gentoo
dev-build/cmake:           3.28.2::gentoo
dev-build/libtool:         2.4.7-r2::gentoo
dev-build/make:            4.4.1-r1::gentoo
dev-build/meson:           1.3.1-r1::gentoo
dev-lang/perl:             5.38.2-r1::gentoo
dev-lang/python:           3.11.7::gentoo, 3.12.1_p1::gentoo
dev-lang/rust:             1.74.1::gentoo
sys-apps/baselayout:       2.14-r1::gentoo
sys-apps/openrc:           0.53::gentoo
sys-apps/sandbox:          2.38::gentoo
sys-devel/binutils:        2.41-r5::gentoo
sys-devel/binutils-config: 5.5::gentoo
sys-devel/clang:           17.0.6::gentoo
sys-devel/gcc:             12.3.1_p20240112::gentoo, 13.2.1_p20240113-r1::gentoo
sys-devel/gcc-config:      2.11::gentoo
sys-devel/lld:             17.0.6::gentoo
sys-devel/llvm:            17.0.6::gentoo
sys-kernel/linux-headers:  6.7::gentoo (virtual/os-headers)
sys-libs/glibc:            2.38-r10::gentoo
Repositories:

gentoo
    location: /home/patrick/code/gentoo
    sync-type: git
    sync-uri: rsync://rsync.gentoo.org/gentoo-portage
    priority: -1000
    volatile: True

ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="@FREE"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -march=native -flto=8 -fuse-linker-plugin -ggdb3"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/lib64/libreoffice/program/sofficerc /usr/share/gnupg/qualified.txt"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-O2 -pipe -march=native -flto=8 -fuse-linker-plugin -ggdb3"
DISTDIR="/chroot/distfiles"
ENV_UNSET="CARGO_HOME DBUS_SESSION_BUS_ADDRESS DISPLAY GDK_PIXBUF_MODULE_FILE GOBIN GOPATH PERL5LIB PERL5OPT PERLPREFIX PERL_CORE PERL_MB_OPT PERL_MM_OPT XAUTHORITY XDG_CACHE_HOME XDG_CONFIG_HOME XDG_DATA_HOME XDG_RUNTIME_DIR XDG_STATE_HOME"
FCFLAGS="-O2 -pipe -march=native -flto=8 -fuse-linker-plugin -ggdb3"
FEATURES="assume-digests binpkg-docompress binpkg-dostrip binpkg-logs buildpkg buildpkg-live config-protect-if-modified distlocks ebuild-locks fixlafiles ipc-sandbox merge-sync multilib-strict network-sandbox news parallel-fetch pid-sandbox pkgdir-index-trusted preserve-libs protect-owned qa-unresolved-soname-deps sandbox sfperms splitdebug strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr"
FFLAGS="-O2 -pipe -march=native -flto=8 -fuse-linker-plugin -ggdb3"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
INSTALL_MASK="/etc/X11/xinit/xinitrc.d/80-dbus /usr/bin/dbus-launch"
LANG="C.UTF8"
LDFLAGS="-O2 -flto=8"
LEX="flex"
PKGDIR="/var/cache/binpkgs"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --exclude=/.git"
PORTAGE_TMPDIR="/var/tmp"
RUSTFLAGS="-C target-cpu=native"
SHELL="/bin/bash"
USE="X acl alsa amd64 apng bzip2 cli crypt cups dri ffmpeg fortran gdbm glamor gmp gpo iconv icu ipv6 lapack libtirpc lto minizip multilib ncurses nls opencl opengl openmp pam pcre pgo readline seccomp split-usr sqlite ssl system-llvm test-rust truetype udev unicode vaapi vdpau vulkan xattr xvmc zlib" ABI_X86="64 32" ADA_TARGET="gnat_2021" AMDGPU_TARGETS="gfx803" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd actions alias auth_basic authn_anon authn_dbm authn_file authz_dbm authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir env expires ext_filter file_cache filter headers include info log_config logio mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CALLIGRA_FEATURES="karbon sheets words" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" CPU_FLAGS_X86="aes avx avx2 f16c fma3 mmx mmxext pclmul popcnt rdrand sha sse sse2 sse3 sse4_1 sse4_2 sse4a ssse3" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock greis isync itrax mtk3301 ntrip navcom oceanserver oncore rtcm104v2 rtcm104v3 sirf skytraq superstar2 tsip tripmate tnt ublox" INPUT_DEVICES="libinput" KERNEL="linux" LCD_DEVICES="bayrad cfontz glk hd44780 lb216 lcdm001 mtxorb text" LUA_SINGLE_TARGET="lua5-1" LUA_TARGETS="lua5-1" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php8-1" POSTGRES_TARGETS="postgres15" PYTHON_SINGLE_TARGET="python3_11" PYTHON_TARGETS="python3_11" VIDEO_CARDS="radeon r600 radeonsi amdgpu" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipp2p iface geoip fuzzy condition tarpit sysrq proto logmark ipmark dhcpmac delude chaos account"
Unset:  ADDR2LINE, AR, ARFLAGS, AS, ASFLAGS, CC, CCLD, CONFIG_SHELL, CPP, CPPFLAGS, CTARGET, CXX, CXXFILT, ELFEDIT, EMERGE_DEFAULT_OPTS, EXTRA_ECONF, F77FLAGS, FC, GCOV, GPROF, LC_ALL, LD, LFLAGS, LIBTOOL, LINGUAS, MAKE, MAKEFLAGS, MAKEOPTS, NM, OBJCOPY, OBJDUMP, PORTAGE_BINHOST, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PYTHONPATH, RANLIB, READELF, SIZE, STRINGS, STRIP, YACC, YFLAGS
Comment 1 Patrick Lauer gentoo-dev 2024-02-02 12:51:02 UTC
I
Comment 2 Larry the Git Cow gentoo-dev 2024-02-02 13:10:10 UTC
The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=eb1867bf2f36efdf66d6fd2e7354e30bfeb70c43

commit eb1867bf2f36efdf66d6fd2e7354e30bfeb70c43
Author:     Patrick Lauer <patrick@gentoo.org>
AuthorDate: 2024-02-02 13:08:15 +0000
Commit:     Patrick Lauer <patrick@gentoo.org>
CommitDate: 2024-02-02 13:09:57 +0000

    dev-db/postgresql: Restrict openssl version
    
    openssl-3.2 causes runtime failures.
    Fix is going to be in next postgresql release.
    
    Bug: https://bugs.gentoo.org/923620
    Signed-off-by: Patrick Lauer <patrick@gentoo.org>

 dev-db/postgresql/postgresql-12.17.ebuild | 3 ++-
 dev-db/postgresql/postgresql-13.13.ebuild | 3 ++-
 dev-db/postgresql/postgresql-14.10.ebuild | 3 ++-
 dev-db/postgresql/postgresql-15.5.ebuild  | 3 ++-
 dev-db/postgresql/postgresql-16.1.ebuild  | 3 ++-
 5 files changed, 10 insertions(+), 5 deletions(-)
Comment 3 Sam James archtester Gentoo Infrastructure gentoo-dev Security 2024-02-02 13:15:20 UTC
You need revbumps for that as openssl-3.2 didn't break ABI, so it won't be picked up otherwise (can't rely on := causing evaluation for you).
Comment 4 Larry the Git Cow gentoo-dev 2024-02-02 14:05:38 UTC
The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=7f9c4cc23884adb65595e0f125c41eaa09212c42

commit 7f9c4cc23884adb65595e0f125c41eaa09212c42
Author:     Patrick Lauer <patrick@gentoo.org>
AuthorDate: 2024-02-02 13:34:14 +0000
Commit:     Patrick Lauer <patrick@gentoo.org>
CommitDate: 2024-02-02 14:05:15 +0000

    dev-db/postgresql: backport openssl fixes
    
    Bug: https://bugs.gentoo.org/923620
    Signed-off-by: Patrick Lauer <patrick@gentoo.org>

 .../files/postgresql-12-openssl3.2.patch           | 178 ++++++++
 .../files/postgresql-13-openssl3.2.patch           | 172 ++++++++
 .../files/postgresql-14-openssl3.2.patch           | 195 +++++++++
 .../files/postgresql-15-openssl3.2.patch           | 194 +++++++++
 .../files/postgresql-16-openssl3.2.patch           | 216 ++++++++++
 dev-db/postgresql/postgresql-12.17-r1.ebuild       | 453 ++++++++++++++++++++
 dev-db/postgresql/postgresql-13.13-r1.ebuild       | 465 ++++++++++++++++++++
 dev-db/postgresql/postgresql-14.10-r1.ebuild       | 465 ++++++++++++++++++++
 dev-db/postgresql/postgresql-15.5-r1.ebuild        | 467 ++++++++++++++++++++
 dev-db/postgresql/postgresql-16.1-r1.ebuild        | 468 +++++++++++++++++++++
 10 files changed, 3273 insertions(+)
Comment 5 Miroslav Šulc gentoo-dev 2024-02-02 14:18:58 UTC
i just hit the same issue, it took me some time to find the cause and then this bug.
Comment 6 Sam James archtester Gentoo Infrastructure gentoo-dev Security 2024-02-06 03:57:43 UTC
All done then.