ISO: (FreeBSD-EN-21:08.freebsd-update) package installation problems after upgrading from FreeBSD 12.1-RELEASE

Affected packages seem to include:

• security/cyrus-sasl2
• databases/mysql57-server

[1/6] Installing psutils-1.17_5...
[1/6] Extracting psutils-1.17_5: 100%
[2/6] Installing groff-1.22.4_3...
[2/6] Extracting groff-1.22.4_3: 100%
[3/6] Installing cyrus-sasl-2.1.27_1...
*** Added group `cyrus' (id 60)
pw: user 'cyrus' disappeared during update
*** Failed to add user `cyrus'. Please add it manually.
[3/6] Extracting cyrus-sasl-2.1.27_1: 100%
chown: cyrus: illegal user name
[4/6] Installing protobuf-3.13.0,1...
[4/6] Extracting protobuf-3.13.0,1: 100%
[5/6] Installing mysql57-client-5.7.31_1...
[5/6] Extracting mysql57-client-5.7.31_1: 100%
[6/6] Installing mysql57-server-5.7.31_1...
===> Creating groups.
Creating group 'mysql' with gid '88'.
===> Creating users
Creating user 'mysql' with uid '88'.
pw: user 'mysql' disappeared during update
===> Creating homedir(s)
install: unknown user mysql
pkg: PRE-INSTALL script failed

In context:

mowa219-gjp4-vm-hellosystem-0% date ; uptime ; uname -v
Sun Jan 24 08:44:06 EST 2021
 8:44AM  up 2 mins, 0 users, load averages: 0.24, 0.09, 0.03
FreeBSD 12.2-RELEASE-p1 GENERIC 
mowa219-gjp4-vm-hellosystem-0% csh   
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % pkg query '%o %v %R' hello mysql57-server
helloSystem 0.4.0_0D18 unknown-repository
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % pkg info -x sql
py37-sqlite3-3.7.9_7
qt5-sql-5.15.0
qt5-sqldrivers-sqlite3-5.15.0
sqlite3-3.33.0,1
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % sudo /usr/sbin/freebsd-update install
Password:
src component not installed, skipped
Installing updates... done.
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % uname -KU
1202000 1202000
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % sudo pkg upgrade
Password:
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking for upgrades (1 candidates): 100%
Processing candidates (1 candidates): 100%
Checking integrity... done (0 conflicting)
Your packages are up to date.
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % pkg lock -l
Currently locked packages:
hello-0.4.0_0D18
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % sudo pkg install --dry-run mysql57-server
Updating FreeBSD repository catalogue...                                                                       
FreeBSD repository is up to date.                                                                              
All repositories are up to date.                                                                               
Checking integrity... done (0 conflicting)                                                                     
The following 6 package(s) will be affected (of 0 checked):                                                    
                                                                                                               
New packages to be INSTALLED:                                                                                  
        cyrus-sasl: 2.1.27_1                                                                                   
        groff: 1.22.4_3                                                                                        
        mysql57-client: 5.7.31_1                                                                               
        mysql57-server: 5.7.31_1                                                                               
        protobuf: 3.13.0,1                                                                                     
        psutils: 1.17_5                                                                                        
                                                                                                               
Number of packages to be installed: 6                                                                          
                                                                                                               
The process will require 240 MiB more space.                                                                   
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % sudo pkg install mysql57-server
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking integrity... done (0 conflicting)
The following 6 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
        cyrus-sasl: 2.1.27_1
        groff: 1.22.4_3
        mysql57-client: 5.7.31_1
        mysql57-server: 5.7.31_1
        protobuf: 3.13.0,1
        psutils: 1.17_5

Number of packages to be installed: 6

The process will require 240 MiB more space.

Proceed with this action? [y/N]: y
[1/6] Installing psutils-1.17_5...
[1/6] Extracting psutils-1.17_5: 100%
[2/6] Installing groff-1.22.4_3...
[2/6] Extracting groff-1.22.4_3: 100%
[3/6] Installing cyrus-sasl-2.1.27_1...
*** Added group `cyrus' (id 60)
pw: user 'cyrus' disappeared during update
*** Failed to add user `cyrus'. Please add it manually.
[3/6] Extracting cyrus-sasl-2.1.27_1: 100%
chown: cyrus: illegal user name
[4/6] Installing protobuf-3.13.0,1...
[4/6] Extracting protobuf-3.13.0,1: 100%
[5/6] Installing mysql57-client-5.7.31_1...
[5/6] Extracting mysql57-client-5.7.31_1: 100%
[6/6] Installing mysql57-server-5.7.31_1...
===> Creating groups.
Creating group 'mysql' with gid '88'.
===> Creating users
Creating user 'mysql' with uid '88'.
pw: user 'mysql' disappeared during update
===> Creating homedir(s)
install: unknown user mysql
pkg: PRE-INSTALL script failed
grahamperrin@mowa219-gjp4-vm-hellosystem-0:~ % 

---

No such problem with databases/mysql57-server if installation is performed with 12.1-RELEASE. Here’s the same virtual machine, rolled back to a snapshot:

https://user-images.githubusercontent.com/192271/105633441-7f3c8780-5e50-11eb-88a8-b56fe96709c2.mp4

– however https://www.freebsd.org/security/security.html#sup the expected end of life for 12.1-RELEASE is one week from now.