pkg killed on FreeBSD upgrade to 14

From: Frank Leonhardt <freebsd-doc_at_fjl.co.uk>
Date: Fri, 08 Dec 2023 18:43:22 UTC
I'm not sure whether this is a question or a warning.

I upgraded my "latest" FreeBSD box to 14.0-RELEASE. It basically runs 
local DNS and a DHCP server so it's not a huge deal if it's trashed, and 
is therefore the first to get upgraded. It was originally installed with 
12.0 and has been updated to everything in between.

I got "bad vibes" going to from 13.2->14.0 - warnings that seemed 
reasonable about stuff missing from /src/ and suchlike that I didn't 
expect to see, but no actual errors as far as I could tell.

On completion, however, pkg was no longer working - the following error 
message:

'ld-elf.so.1: Shared object "libssl.so.111" not found, required by "pkg"'

My suspicion is that this was something to do with OpenSSL being updated 
in 14.0 but I decided I'd had enough and did a (successful) rollback 
rather than trying to figure it out and relinking libraries.

Has anyone else had the same problem, and what are the runes to avoid it 
should I decide to have another go?

Thanks, Frank.