From nobody Fri Feb 18 08:12:49 2022 X-Original-To: ports@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 1243D19DCA3F for ; Fri, 18 Feb 2022 08:13:11 +0000 (UTC) (envelope-from freebsd@gushi.org) Received: from prime.gushi.org (prime.gushi.org [IPv6:2620:137:6000:10::142]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "prime.gushi.org", Issuer "RapidSSL TLS DV RSA Mixed SHA256 2020 CA-1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4K0PZt0Gdrz3j9f for ; Fri, 18 Feb 2022 08:13:09 +0000 (UTC) (envelope-from freebsd@gushi.org) Received: from smtpclient.apple ([IPv6:2601:602:0:5:70ca:2f38:b871:a2b3]) (authenticated bits=0) by prime.gushi.org (8.16.1/8.16.1) with ESMTPSA id 21I8CsDO076312 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO); Fri, 18 Feb 2022 00:12:55 -0800 (PST) (envelope-from freebsd@gushi.org) DKIM-Filter: OpenDKIM Filter v2.10.3 prime.gushi.org 21I8CsDO076312 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gushi.org; s=prime2014; t=1645171976; bh=HqdSiw5pUG0o6NEg70nLMIDEmvjk/Y/F5ztjqriCbbs=; h=From:Subject:Date:In-Reply-To:Cc:To:References; z=From:=20Dan=20Mahoney=20|Subject:=20Re:=20p5-d bd-pg|Date:=20Fri,=2018=20Feb=202022=2000:12:49=20-0800|In-Reply-T o:=20|Cc:=20ports@ freebsd.org|To:=20Christoph=20Moench-Tegeder=20|References:=20<760559B7-EE1A-421D-BB8A-8402A9305FF6@gushi.org>=0 D=0A=20=0D=0A=20; b=DJdmr2ikPvPVf2A+y3WYaKB5sKgU9lSU83OWFRl3beZV8a0bVTVytbw0/mR5UwOpY AcV1kjmS5RFnErhJ4t66UPzs+e6eFObvCgfvUcyIwpxOgW8RpLsFYzw0Jh5tZRXzFG BrKuQ72/pyODwP8LxlbUsRPkMewF2lx631JItoRhNVZfxj41cexeB6DAiVUKFR3i7u G5G63eVsGmu7SCm5Yok/cR2csrse+25ACvAHlhLuXkOEzit90y18PxuO5TpPVj+nt4 LYa7m0Rm14H1l0kMzU9F8OUeRtPRSySyOPxMNXjplvbnAQ2tD8x36/rjq29IDxXlYQ qhs8f2iPQeBwg== X-Authentication-Warning: prime.gushi.org: Host [IPv6:2601:602:0:5:70ca:2f38:b871:a2b3] claimed to be smtpclient.apple From: Dan Mahoney Message-Id: <75FF81DA-9B77-46B2-AA54-2715DAAAC88F@gushi.org> Content-Type: multipart/alternative; boundary="Apple-Mail=_006587CE-578B-4CAE-BD7F-7449AD95A743" List-Id: Porting software to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-ports List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.60.0.1.1\)) Subject: Re: p5-dbd-pg Date: Fri, 18 Feb 2022 00:12:49 -0800 In-Reply-To: Cc: ports@freebsd.org To: Christoph Moench-Tegeder References: <760559B7-EE1A-421D-BB8A-8402A9305FF6@gushi.org> X-Mailer: Apple Mail (2.3693.60.0.1.1) X-Rspamd-Queue-Id: 4K0PZt0Gdrz3j9f X-Spamd-Bar: ------ Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gushi.org header.s=prime2014 header.b=DJdmr2ik; dmarc=pass (policy=none) header.from=gushi.org; spf=pass (mx1.freebsd.org: domain of freebsd@gushi.org designates 2620:137:6000:10::142 as permitted sender) smtp.mailfrom=freebsd@gushi.org X-Spamd-Result: default: False [-6.20 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; TO_DN_SOME(0.00)[]; MV_CASE(0.50)[]; R_SPF_ALLOW(-0.20)[+mx]; HAS_XAW(0.00)[]; RCVD_DKIM_ARC_DNSWL_MED(-0.50)[]; RCVD_IN_DNSWL_MED(-0.20)[2620:137:6000:10::142:from]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[gushi.org,none]; DKIM_TRACE(0.00)[gushi.org:+]; NEURAL_HAM_SHORT(-1.00)[-1.000]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; ASN(0.00)[asn:393507, ipnet:2620:137:6000::/44, country:US]; MID_RHS_MATCH_FROM(0.00)[]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; R_DKIM_ALLOW(-0.20)[gushi.org:s=prime2014]; FROM_HAS_DN(0.00)[]; DWL_DNSWL_MED(-2.00)[gushi.org:dkim]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; TO_MATCH_ENVRCPT_SOME(0.00)[]; MLMMJ_DEST(0.00)[ports]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[] X-ThisMailContainsUnwantedMimeParts: N --Apple-Mail=_006587CE-578B-4CAE-BD7F-7449AD95A743 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Just to touch on this again, this is the output of the pkg upgrade that = messed this up: New packages to be INSTALLED: postgresql13-client: 13.5 Installed packages to be UPGRADED: bash: 5.1.8 -> 5.1.12 bash-completion: 2.11,2 -> 2.11_1,2 bind-tools: 9.16.22 -> 9.16.25 boost-libs: 1.72.0_5 -> 1.72.0_6 ca_root_nss: 3.69_1 -> 3.71 db5: 5.3.28_7 -> 5.3.28_8 expat: 2.4.3 -> 2.4.4 freetype2: 2.11.0 -> 2.11.1 fribidi: 1.0.10 -> 1.0.11 gdbm: 1.21 -> 1.22 glib: 2.70.0_1,2 -> 2.70.3,2 gnupg: 2.3.2 -> 2.3.3_2 graphviz: 2.44.1_15 -> 2.44.1_18 harfbuzz: 3.0.0 -> 3.2.0 icu: 69.1,1 -> 70.1_1,1 jpeg-turbo: 2.1.1 -> 2.1.1_1 libXfixes: 5.0.3_2 -> 6.0.0 libXft: 2.3.3 -> 2.3.4 libdrm: 2.4.107_1,1 -> 2.4.109,1 libglvnd: 1.3.4 -> 1.4.0 libgpg-error: 1.42 -> 1.43 libpaper: 1.1.24.4 -> 1.1.28 libssh2: 1.9.0_3,3 -> 1.10.0,3 libtasn1: 4.17.0 -> 4.18.0 llvm11: 11.0.1_2 -> 11.0.1_4 mesa-libs: 21.1.8 -> 21.3.4 nano: 5.8 -> 5.9 open-vm-tools-nox11: 11.3.5,2 -> 11.3.5_1,2 openldap24-client: 2.4.59_2 -> 2.4.59_4 p5-Apache-LogFormat-Compiler: 0.35 -> 0.36 p5-B-Hooks-EndOfScope: 0.24 -> 0.25 p5-Cookie-Baker: 0.09 -> 0.11 p5-Cpanel-JSON-XS: 4.26 -> 4.27 p5-Date-Manip: 6.83 -> 6.85 p5-DateTime-Locale: 1.32 -> 1.33 p5-DateTime-TimeZone: 2.47,1 -> 2.51,1 p5-Encode: 3.12 -> 3.16 p5-Filesys-Notify-Simple: 0.12_1 -> 0.14 p5-HTTP-Headers-Fast: 0.21 -> 0.22 p5-HTTP-Message: 6.33 -> 6.35 p5-HTTP-Tiny: 0.078 -> 0.080 p5-IO-Socket-SSL: 2.072 -> 2.073 p5-JavaScript-Minifier-XS: 0.14 -> 0.15 p5-Log-Any: 1.707 -> 1.710 p5-MIME-Types: 2.21 -> 2.22 p5-Mozilla-CA: 20200520 -> 20211001 p5-POSIX-strftime-Compiler: 0.41 -> 0.44 p5-Plack: 1.0047 -> 1.0048 p5-Scalar-List-Utils: 1.59,1 -> 1.60,1 p5-Test-Simple: 1.302187 -> 1.302188 p5-Try-Tiny: 0.30 -> 0.31 p5-URI: 5.09 -> 5.10 p5-libwww: 6.57 -> 6.59 pango: 1.48.7 -> 1.48.11 pciids: 20210829 -> 20211124 postfix: 3.6.2_1,1 -> 3.6.3,1 postgresql12-client: 12.8 -> 12.9 postgresql12-server: 12.8 -> 12.9 python37: 3.7.12 -> 3.7.12_1 python38: 3.8.12 -> 3.8.12_1 rubygem-json_pure: 2.5.1 -> 2.6.1 sqlite3: 3.35.5_3,1 -> 3.35.5_4,1 vim: 8.2.3458 -> 8.2.3745 wayland: 1.19.0_1 -> 1.20.0 xorgproto: 2021.4 -> 2021.5 Installed packages to be REINSTALLED: p5-DBD-Pg-3.15.0 (direct dependency changed: = postgresql13-client) p5-Heap-0.80_1 (ABI changed: 'freebsd:12:x86:64' -> = 'freebsd:12:*') p5-Pg-2.1.1_6,1 (direct dependency changed: postgresql13-client) Number of packages to be installed: 1 Number of packages to be upgraded: 65 Number of packages to be reinstalled: 3 The process will require 13 MiB more space. 236 MiB to be downloaded. Proceed with this action? [y/N]: y (Why did the pkg dependency solver not cause an upgrade to = postgresql13-server?) -Dan > On Jan 20, 2022, at 10:13 AM, Dan Mahoney wrote: >=20 >=20 >=20 >> On Jan 20, 2022, at 9:38 AM, Christoph Moench-Tegeder = wrote: >>=20 >> ## Dan Mahoney (freebsd@gushi.org): >>=20 >>> On doing a routine pkg upgrade at the dayjob, the perl module = p5-DBD-pg >>> forced an upgrade from postgresql12-client to postgresql13-client = (which >>> uninstalled postgresql12-server). >>=20 >> p5-DBD-Pg uses the "default" postgresql version, which switched from >> 12 to 13 in Octobe r(or with the Quarterly switch, depending on what >> you use). >> If you build your own packages, you could pin the default postgresql >> version according to your needs via the make.conf mechanism, that is >> DEFAULT_VERSIONS+=3D pgsql=3D12 as an example. >=20 > The whole point of using pkg is that I should not have to build my own = packages. >=20 > My ticket system was down for several hours while I reinstalled = postgresql12 (which uininstalled p5-dbd-pg), dumped a 3.5G db, and then = reinstalled postgresql13-server, and reimported, because that's what you = have to do when you upgrade postgres. (I hate this about postgres, but = it is what it is). >=20 > Worse still, the initial install of p5-dbd-pg pulled in = postgres13-client, but DID NOT DELETE postgres12-client or = postgres12-server, so I assumed the whole "these things can coexist" = problem had been fixed. As people had said, the actual client is stable = -- and besides which, a 13 client can talk to a 12 DB (as it might do = over the internet). The SECOND pkg upgrade then wiped out the = postgresql12 stuff. >=20 > For a perl module that could be flavored so it works with whatever = thing you have installed. (It doesn't call for a specific version, it = just has uses =3D pgsql). >=20 > Had I seen this level of fail coming, I would have deployed on a = parallel VM, or done the db dump beforehand, but the initial pkg upgrade = did not show it was deleting postgres 12. >=20 > Luckily, this ticket system is internal, and we have a process to = cache inbound tickets on our border MXes, so it wasn't the end of the = world, but it was still annoying. >=20 > (We have backups, of course, but they're not down-to-the-transaction). >=20 > -Dan --Apple-Mail=_006587CE-578B-4CAE-BD7F-7449AD95A743 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Just = to touch on this again, this is the output of the pkg upgrade that = messed this up:

New packages to be INSTALLED:
  =       postgresql13-client: 13.5

Installed packages to be = UPGRADED:
        bash: 5.1.8 = -> 5.1.12
        = bash-completion: 2.11,2 -> 2.11_1,2
  =       bind-tools: 9.16.22 -> 9.16.25
        boost-libs: 1.72.0_5 -> = 1.72.0_6
        ca_root_nss: = 3.69_1 -> 3.71
        db5: = 5.3.28_7 -> 5.3.28_8
        = expat: 2.4.3 -> 2.4.4
      =   freetype2: 2.11.0 -> 2.11.1
    =     fribidi: 1.0.10 -> 1.0.11
  =       gdbm: 1.21 -> 1.22
  =       glib: 2.70.0_1,2 -> 2.70.3,2
        gnupg: 2.3.2 -> = 2.3.3_2
        graphviz: = 2.44.1_15 -> 2.44.1_18
      =   harfbuzz: 3.0.0 -> 3.2.0
    =     icu: 69.1,1 -> 70.1_1,1
  =       jpeg-turbo: 2.1.1 -> 2.1.1_1
        libXfixes: 5.0.3_2 -> = 6.0.0
        libXft: 2.3.3 = -> 2.3.4
        libdrm: = 2.4.107_1,1 -> 2.4.109,1
      =   libglvnd: 1.3.4 -> 1.4.0
    =     libgpg-error: 1.42 -> 1.43
  =       libpaper: 1.1.24.4 -> 1.1.28
        libssh2: 1.9.0_3,3 -> = 1.10.0,3
        libtasn1: = 4.17.0 -> 4.18.0
        = llvm11: 11.0.1_2 -> 11.0.1_4
    =     mesa-libs: 21.1.8 -> 21.3.4
  =       nano: 5.8 -> 5.9
  =       open-vm-tools-nox11: 11.3.5,2 -> = 11.3.5_1,2
        = openldap24-client: 2.4.59_2 -> 2.4.59_4
  =       p5-Apache-LogFormat-Compiler: 0.35 -> = 0.36
        = p5-B-Hooks-EndOfScope: 0.24 -> 0.25
  =       p5-Cookie-Baker: 0.09 -> 0.11
        p5-Cpanel-JSON-XS: 4.26 -> = 4.27
        p5-Date-Manip: = 6.83 -> 6.85
        = p5-DateTime-Locale: 1.32 -> 1.33
    =     p5-DateTime-TimeZone: 2.47,1 -> 2.51,1
        p5-Encode: 3.12 -> = 3.16
        = p5-Filesys-Notify-Simple: 0.12_1 -> 0.14
  =       p5-HTTP-Headers-Fast: 0.21 -> 0.22
        p5-HTTP-Message: 6.33 -> = 6.35
        p5-HTTP-Tiny: = 0.078 -> 0.080
        = p5-IO-Socket-SSL: 2.072 -> 2.073
    =     p5-JavaScript-Minifier-XS: 0.14 -> 0.15
        p5-Log-Any: 1.707 -> = 1.710
        p5-MIME-Types: = 2.21 -> 2.22
        = p5-Mozilla-CA: 20200520 -> 20211001
  =       p5-POSIX-strftime-Compiler: 0.41 -> = 0.44
        p5-Plack: 1.0047 = -> 1.0048
        = p5-Scalar-List-Utils: 1.59,1 -> 1.60,1
  =       p5-Test-Simple: 1.302187 -> 1.302188
        p5-Try-Tiny: 0.30 -> = 0.31
        p5-URI: 5.09 -> = 5.10
        p5-libwww: 6.57 = -> 6.59
        pango: = 1.48.7 -> 1.48.11
        = pciids: 20210829 -> 20211124
    =     postfix: 3.6.2_1,1 -> 3.6.3,1
 =       postgresql12-client: 12.8 -> 12.9
        postgresql12-server: 12.8 -> = 12.9
        python37: 3.7.12 = -> 3.7.12_1
        = python38: 3.8.12 -> 3.8.12_1
    =     rubygem-json_pure: 2.5.1 -> 2.6.1
        sqlite3: 3.35.5_3,1 -> = 3.35.5_4,1
        vim: = 8.2.3458 -> 8.2.3745
        = wayland: 1.19.0_1 -> 1.20.0
      =   xorgproto: 2021.4 -> 2021.5

Installed packages to be = REINSTALLED:
        = p5-DBD-Pg-3.15.0 (direct dependency changed: = postgresql13-client)
        = p5-Heap-0.80_1 (ABI changed: 'freebsd:12:x86:64' -> = 'freebsd:12:*')
        = p5-Pg-2.1.1_6,1 (direct dependency changed: = postgresql13-client)

Number of packages to be installed: 1
Number of packages to be upgraded: 65
Number of packages to be reinstalled: 3

The process will require = 13 MiB more space.
236 MiB to be = downloaded.

Proceed with this action? [y/N]: y

(Why did the pkg dependency solver not = cause an upgrade to postgresql13-server?)

-Dan

On Jan 20, 2022, at 10:13 AM, = Dan Mahoney <freebsd@gushi.org> wrote:



On Jan 20, 2022, at 9:38 AM, = Christoph Moench-Tegeder <cmt@burggraben.net> wrote:

## Dan Mahoney (freebsd@gushi.org):

On doing a routine pkg = upgrade at the dayjob, the perl module p5-DBD-pg
forced an = upgrade from postgresql12-client to postgresql13-client (which
uninstalled postgresql12-server).

p5-DBD-Pg uses the "default" = postgresql version, which switched from
12 to 13 in Octobe = r(or with the Quarterly switch, depending on what
you = use).
If you build your own packages, you could pin the = default postgresql
version according to your needs via the = make.conf mechanism, that is
DEFAULT_VERSIONS+=3D pgsql=3D12= as an example.

The whole point of using pkg is that I should not have to = build my own packages.

My ticket system was down for several hours while I = reinstalled postgresql12 (which uininstalled p5-dbd-pg), dumped a 3.5G = db, and then reinstalled postgresql13-server, and reimported, because = that's what you have to do when you upgrade postgres.  (I hate this = about postgres, but it is what it is).

Worse still, the initial install of p5-dbd-pg pulled in = postgres13-client, but DID NOT DELETE postgres12-client or = postgres12-server, so I assumed the whole "these things can coexist" = problem had been fixed.  As people had said, the actual client is = stable -- and besides which, a 13 client can talk to a 12 DB (as it = might do over the internet).  The SECOND pkg upgrade then wiped out = the postgresql12 stuff.

For a perl module that could be flavored so it works with = whatever thing you have installed.  (It doesn't call for a specific = version, it just has uses =3D pgsql).

Had I seen this level of fail coming, I would have deployed = on a parallel VM, or done the db dump beforehand, but the initial pkg = upgrade did not show it was deleting postgres 12.

Luckily, this ticket system is = internal, and we have a process to cache inbound tickets on our border = MXes, so it wasn't the end of the world, but it was still = annoying.

(We have = backups, of course, but they're not down-to-the-transaction).

-Dan

= --Apple-Mail=_006587CE-578B-4CAE-BD7F-7449AD95A743--