Weird errors after update from 25.7 to 25.7.1

[crazywolf13]

I got these errors:

Code Select Expand

***GOT REQUEST TO UPDATE***
Currently running OPNsense 25.7 (amd64) at Tue Aug  5 21:36:40 CEST 2025
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Checking for upgrades (16 candidates): .......... done
Processing candidates (16 candidates): .......... done
The following 16 package(s) will be affected (of 0 checked):

Installed packages to be UPGRADED:
boost-libs: 1.88.0_1 -> 1.88.0_2
curl: 8.14.1 -> 8.15.0
ivykis: 0.43.2 -> 0.43.2_1
jq: 1.8.0 -> 1.8.1
libucl: 0.9.2_1 -> 0.9.2_2
nspr: 4.36 -> 4.37
nss: 3.113.1_1 -> 3.114
opnsense: 25.7 -> 25.7.1_1
os-wol: 2.5_1 -> 2.5_3
py311-certifi: 2025.6.15 -> 2025.7.14
py311-duckdb: 1.3.1_1 -> 1.3.2
py311-typing-extensions: 4.14.0 -> 4.14.1
sudo: 1.9.17p1 -> 1.9.17p2
syslog-ng: 4.8.2_3 -> 4.8.2_4
tailscale: 1.84.2 -> 1.86.0
telegraf: 1.35.1 -> 1.35.1_1

Number of packages to be upgraded: 16

94 MiB to be downloaded.
[1/16] Fetching boost-libs-1.88.0_2.pkg: .......... done
[2/16] Fetching nss-3.114.pkg: .......... done
[3/16] Fetching tailscale-1.86.0.pkg: .......... done
[4/16] Fetching jq-1.8.1.pkg: .......... done
[5/16] Fetching syslog-ng-4.8.2_4.pkg: .......... done
[6/16] Fetching ivykis-0.43.2_1.pkg: .......... done
[7/16] Fetching py311-certifi-2025.7.14.pkg: .......... done
[8/16] Fetching telegraf-1.35.1_1.pkg: .......... done
[9/16] Fetching os-wol-2.5_3.pkg: . done
[10/16] Fetching curl-8.15.0.pkg: .......... done
[11/16] Fetching nspr-4.37.pkg: .......... done
[12/16] Fetching libucl-0.9.2_2.pkg: .......... done
[13/16] Fetching opnsense-25.7.1_1.pkg: .......... done
[14/16] Fetching py311-duckdb-1.3.2.pkg: .......... done
[15/16] Fetching py311-typing-extensions-4.14.1.pkg: .......... done
[16/16] Fetching sudo-1.9.17p2.pkg: .......... done
Checking integrity... done (0 conflicting)
[1/16] Upgrading py311-typing-extensions from 4.14.0 to 4.14.1...
[1/16] Extracting py311-typing-extensions-4.14.1: .......... done
[2/16] Upgrading py311-certifi from 2025.6.15 to 2025.7.14...
[2/16] Extracting py311-certifi-2025.7.14: .......... done
[3/16] Upgrading nspr from 4.36 to 4.37...
[3/16] Extracting nspr-4.37: .
pkg-static: Fail to set time on /usr/local/include/nspr/obsolete/.pkgtemp.pralarm.h.b4rjuQUQoSI6:No such file or directory
[3/16] Extracting nspr-4.37... done
Starting web GUI...rm: /tmp/lighttpdcompress/usr/local/opnsense/www/assets: Directory not empty
rm: /tmp/lighttpdcompress/usr/local/opnsense/www: Directory not empty
rm: /tmp/lighttpdcompress/usr/local/opnsense: Directory not empty
rm: /tmp/lighttpdcompress/usr/local: Directory not empty
rm: /tmp/lighttpdcompress/usr: Directory not empty
done.
***DONE***


I assume this is not critical but I though I report it before it potentially breaks installs.

[crazywolf13]

Also the update does not seem to go away, if I click check for updates, is shows the 25.7.1 release notes again, and runs some sort of update again:

Code Select Expand

***GOT REQUEST TO UPDATE***
Currently running OPNsense 25.7 (amd64) at Tue Aug  5 21:43:49 CEST 2025
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Checking for upgrades (14 candidates): .......... done
Processing candidates (14 candidates): .......... done
Checking integrity... done (0 conflicting)
The following 14 package(s) will be affected (of 0 checked):

Installed packages to be UPGRADED:
boost-libs: 1.88.0_1 -> 1.88.0_2
curl: 8.14.1 -> 8.15.0
ivykis: 0.43.2 -> 0.43.2_1
jq: 1.8.0 -> 1.8.1
libucl: 0.9.2_1 -> 0.9.2_2
nspr: 4.36 -> 4.37
nss: 3.113.1_1 -> 3.114
opnsense: 25.7 -> 25.7.1_1
os-wol: 2.5_1 -> 2.5_3
py311-duckdb: 1.3.1_1 -> 1.3.2
sudo: 1.9.17p1 -> 1.9.17p2
syslog-ng: 4.8.2_3 -> 4.8.2_4
tailscale: 1.84.2 -> 1.86.0
telegraf: 1.35.1 -> 1.35.1_1

Number of packages to be upgraded: 14
[1/14] Upgrading nspr from 4.36 to 4.37...
[1/14] Extracting nspr-4.37: .......... done
[2/14] Upgrading boost-libs from 1.88.0_1 to 1.88.0_2...
[2/14] Extracting boost-libs-1.88.0_2:
pkg-static: Fail to set time on /usr/local/include/boost/accumulators/framework/accumulators/.pkgtemp.external_accumulator.hpp.YyAuB2at1MjE:No such file or directory
[2/14] Extracting boost-libs-1.88.0_2... done
Starting web GUI...done.
***DONE***


[franco]

You can try a cleanup audit (firmware: status) and then retry the update.

Due to related update issues this will be in 25.7.2 which automates the process so you just need to check for updates again and proceed where the update stopped:

https://github.com/opnsense/core/commit/ea75da8a35c484a


Cheers,
Franco

[crazywolf13]

@fran

You can try a cleanup audit (firmware: status) and then retry the update.

Due to related update issues this will be in 25.7.2 which automates the process so you just need to check for updates again and proceed where the update stopped:

https://github.com/opnsense/core/commit/ea75da8a35c484a


Cheers,
Franco

Hi,
I just tried the cleanup, which seemed to work, then retry the update, but it failed again:

Code Select Expand

***GOT REQUEST TO UPDATE***
Currently running OPNsense 25.7 (amd64) at Fri Aug 22 20:31:55 CEST 2025
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Checking for upgrades (39 candidates): .......... done
Processing candidates (39 candidates): .......... done
The following 39 package(s) will be affected (of 0 checked):

Installed packages to be UPGRADED:
boost-libs: 1.88.0_1 -> 1.88.0_2
curl: 8.14.1 -> 8.15.0
ivykis: 0.43.2 -> 0.43.2_1
jq: 1.8.0 -> 1.8.1
krb5: 1.21.3_1 -> 1.22
libinotify: 20240724_2 -> 20240724_3
libpfctl: 0.15 -> 0.16
libucl: 0.9.2_1 -> 0.9.2_2
lighttpd: 1.4.79 -> 1.4.81
nss: 3.113.1_1 -> 3.115
opnsense: 25.7 -> 25.7.2
opnsense-lang: 25.1.11 -> 25.7.2
opnsense-update: 25.7 -> 25.7.2
os-telegraf: 1.12.12_1 -> 1.12.13
os-wol: 2.5_1 -> 2.5_3
perl5: 5.40.2_2 -> 5.40.3_2
php83: 8.3.23 -> 8.3.24
php83-ctype: 8.3.23 -> 8.3.24
php83-curl: 8.3.23 -> 8.3.24
php83-dom: 8.3.23 -> 8.3.24
php83-filter: 8.3.23 -> 8.3.24
php83-gettext: 8.3.23 -> 8.3.24
php83-ldap: 8.3.23 -> 8.3.24
php83-mbstring: 8.3.23 -> 8.3.24
php83-pcntl: 8.3.23 -> 8.3.24
php83-pdo: 8.3.23 -> 8.3.24
php83-session: 8.3.23 -> 8.3.24
php83-simplexml: 8.3.23 -> 8.3.24
php83-sockets: 8.3.23 -> 8.3.24
php83-sqlite3: 8.3.23_1 -> 8.3.24
php83-xml: 8.3.23 -> 8.3.24
php83-zlib: 8.3.23 -> 8.3.24
py311-duckdb: 1.3.1_1 -> 1.3.2
py311-jq: 1.8.0_1 -> 1.10.0
py311-numpy: 1.26.4_6,1 -> 1.26.4_7,1
python311: 3.11.13 -> 3.11.13_1
sudo: 1.9.17p1 -> 1.9.17p2
syslog-ng: 4.8.2_3 -> 4.8.2_4
telegraf: 1.35.1 -> 1.35.3_1

Number of packages to be upgraded: 39

140 MiB to be downloaded.
[1/39] Fetching lighttpd-1.4.81.pkg: .......... done
[2/39] Fetching php83-filter-8.3.24.pkg: ... done
[3/39] Fetching opnsense-update-25.7.2.pkg: ..... done
[4/39] Fetching php83-curl-8.3.24.pkg: ...... done
[5/39] Fetching boost-libs-1.88.0_2.pkg: .......... done
[6/39] Fetching py311-numpy-1.26.4_7,1.pkg: .......... done
[7/39] Fetching nss-3.115.pkg: .......... done
[8/39] Fetching php83-ldap-8.3.24.pkg: ..... done
[9/39] Fetching jq-1.8.1.pkg: .......... done
[10/39] Fetching krb5-1.22.pkg: .......... done
[11/39] Fetching php83-simplexml-8.3.24.pkg: .... done
[12/39] Fetching php83-pdo-8.3.24.pkg: ....... done
[13/39] Fetching syslog-ng-4.8.2_4.pkg: .......... done
[14/39] Fetching php83-sockets-8.3.24.pkg: ...... done
[15/39] Fetching py311-jq-1.10.0.pkg: ....... done
[16/39] Fetching php83-pcntl-8.3.24.pkg: ... done
[17/39] Fetching php83-sqlite3-8.3.24.pkg: .... done
[18/39] Fetching python311-3.11.13_1.pkg: .......... done
[19/39] Fetching libinotify-20240724_3.pkg: .... done
[20/39] Fetching ivykis-0.43.2_1.pkg: .......... done
[21/39] Fetching php83-session-8.3.24.pkg: ..... done
[22/39] Fetching php83-mbstring-8.3.24.pkg: .......... done
[23/39] Fetching php83-gettext-8.3.24.pkg: . done
[24/39] Fetching telegraf-1.35.3_1.pkg: .......... done
[25/39] Fetching php83-zlib-8.3.24.pkg: ... done
[26/39] Fetching os-wol-2.5_3.pkg: . done
[27/39] Fetching php83-ctype-8.3.24.pkg: . done
[28/39] Fetching curl-8.15.0.pkg: .......... done
[29/39] Fetching php83-8.3.24.pkg: .......... done
[30/39] Fetching os-telegraf-1.12.13.pkg: .. done
[31/39] Fetching libpfctl-0.16.pkg: .. done
[32/39] Fetching php83-xml-8.3.24.pkg: ... done
[33/39] Fetching php83-dom-8.3.24.pkg: .......... done
[34/39] Fetching libucl-0.9.2_2.pkg: .......... done
[35/39] Fetching perl5-5.40.3_2.pkg: .......... done
[36/39] Fetching opnsense-25.7.2.pkg: .......... done
[37/39] Fetching py311-duckdb-1.3.2.pkg: .......... done
[38/39] Fetching sudo-1.9.17p2.pkg: .......... done
[39/39] Fetching opnsense-lang-25.7.2.pkg: .......... done
Checking integrity... done (0 conflicting)
[1/39] Upgrading python311 from 3.11.13 to 3.11.13_1...
pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages( origin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, automatic, licenselogic, time, manifestdigest, dep_formula, vital)VALUES( 'lang/python311', 'python311', '3.11.13_1', 'Interpreted object-oriented programming language', 'Python is an interpreted object-oriented programming language, and is
often compared to Tcl, Perl or Scheme.', '[{"message":"Note that some standard Python modules are provided as separate ports\nas they require additional dependencies. They are available as:\n\npy311-gdbm       databases/py-gdbm@py311\npy311-sqlite3    databases/py-sqlite3@py311\npy311-tkinter    x11-toolkits/py-tkinter@py311","type":"install"}]', 'FreeBSD:14:amd64', 'python@FreeBSD.org', 'https://www.python.org/', '/usr/local', 211048567, 1, 1, NOW(), '2$2$n7q3f14jmcorkwcqbzfescqd858unir8uqe7fgbc5qbpdqq4u3ccueyyeeytcup49a9efi9etmg3earnbrunefij6uzjd9bp65hxfkb', NULL, 0 ) in file pkgdb.c:1633: database disk image is malformed
Starting web GUI...done.
***DONE***
Some other error previously before cleanup:

Code Select Expand

[1/39] Extracting python311-3.11.13_1:
pkg-static: Fail to set time on /usr/local/include/python3.11/.pkgtemp.ceval.h.4FtuqDzVA0Ss:No such file or directory

[TrexRox77]

I upgraded to 25.7 and effectively made my device a brick! I tried a fresh install of 25.7 and did a conf restore, but still a brick ended up reverted to 25.1 and am back up running but not very impressed with the QA that appears to not have been done.

[opnonce]

Just want to chime in here because I have seen consistent file system corruption when upgrading to 25.7.1

I did some tests on the same production hardware and ran 2 tests which ended the same. B test started with 24.7 upgrade every version and the up from 25.7 to 25.7.1 caused file system corruption, ending up in a reboot and a broken system.

This is a video of the A test where I just upgraded from a freshly installed 25.7 to 25.7.1 and well you can see the results.

[crazywolf13]

Still experiencing this error with an upgrade to 25.7.2

@franco

Code Select Expand

***GOT REQUEST TO UPDATE***
Currently running OPNsense 25.7 (amd64) at Mon Aug 25 07:55:17 CEST 2025
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Checking for upgrades (39 candidates): .......... done
Processing candidates (39 candidates): .......... done
The following 39 package(s) will be affected (of 0 checked):

Installed packages to be UPGRADED:
boost-libs: 1.88.0_1 -> 1.88.0_2
curl: 8.14.1 -> 8.15.0
ivykis: 0.43.2 -> 0.43.2_1
jq: 1.8.0 -> 1.8.1
krb5: 1.21.3_1 -> 1.22
libinotify: 20240724_2 -> 20240724_3
libpfctl: 0.15 -> 0.16
libucl: 0.9.2_1 -> 0.9.2_2
lighttpd: 1.4.79 -> 1.4.81
nss: 3.113.1_1 -> 3.115
opnsense: 25.7 -> 25.7.2
opnsense-lang: 25.1.11 -> 25.7.2
opnsense-update: 25.7 -> 25.7.2
os-telegraf: 1.12.12_1 -> 1.12.13
os-wol: 2.5_1 -> 2.5_3
perl5: 5.40.2_2 -> 5.40.3_2
php83: 8.3.23 -> 8.3.24
php83-ctype: 8.3.23 -> 8.3.24
php83-curl: 8.3.23 -> 8.3.24
php83-dom: 8.3.23 -> 8.3.24
php83-filter: 8.3.23 -> 8.3.24
php83-gettext: 8.3.23 -> 8.3.24
php83-ldap: 8.3.23 -> 8.3.24
php83-mbstring: 8.3.23 -> 8.3.24
php83-pcntl: 8.3.23 -> 8.3.24
php83-pdo: 8.3.23 -> 8.3.24
php83-session: 8.3.23 -> 8.3.24
php83-simplexml: 8.3.23 -> 8.3.24
php83-sockets: 8.3.23 -> 8.3.24
php83-sqlite3: 8.3.23_1 -> 8.3.24
php83-xml: 8.3.23 -> 8.3.24
php83-zlib: 8.3.23 -> 8.3.24
py311-duckdb: 1.3.1_1 -> 1.3.2
py311-jq: 1.8.0_1 -> 1.10.0
py311-numpy: 1.26.4_6,1 -> 1.26.4_7,1
python311: 3.11.13 -> 3.11.13_1
sudo: 1.9.17p1 -> 1.9.17p2
syslog-ng: 4.8.2_3 -> 4.8.2_4
telegraf: 1.35.1 -> 1.35.3_1

Number of packages to be upgraded: 39

140 MiB to be downloaded.
[1/39] Fetching lighttpd-1.4.81.pkg: .......... done
[2/39] Fetching php83-filter-8.3.24.pkg: ... done
[3/39] Fetching opnsense-update-25.7.2.pkg: ..... done
[4/39] Fetching php83-curl-8.3.24.pkg: ...... done
[5/39] Fetching boost-libs-1.88.0_2.pkg: .......... done
[6/39] Fetching py311-numpy-1.26.4_7,1.pkg: .......... done
[7/39] Fetching nss-3.115.pkg: .......... done
[8/39] Fetching php83-ldap-8.3.24.pkg: ..... done
[9/39] Fetching jq-1.8.1.pkg: .......... done
[10/39] Fetching krb5-1.22.pkg: .......... done
[11/39] Fetching php83-simplexml-8.3.24.pkg: .... done
[12/39] Fetching php83-pdo-8.3.24.pkg: ....... done
[13/39] Fetching syslog-ng-4.8.2_4.pkg: .......... done
[14/39] Fetching php83-sockets-8.3.24.pkg: ...... done
[15/39] Fetching py311-jq-1.10.0.pkg: ....... done
[16/39] Fetching php83-pcntl-8.3.24.pkg: ... done
[17/39] Fetching php83-sqlite3-8.3.24.pkg: .... done
[18/39] Fetching python311-3.11.13_1.pkg: .......... done
[19/39] Fetching libinotify-20240724_3.pkg: .... done
[20/39] Fetching ivykis-0.43.2_1.pkg: .......... done
[21/39] Fetching php83-session-8.3.24.pkg: ..... done
[22/39] Fetching php83-mbstring-8.3.24.pkg: .......... done
[23/39] Fetching php83-gettext-8.3.24.pkg: . done
[24/39] Fetching telegraf-1.35.3_1.pkg: .......... done
[25/39] Fetching php83-zlib-8.3.24.pkg: ... done
[26/39] Fetching os-wol-2.5_3.pkg: . done
[27/39] Fetching php83-ctype-8.3.24.pkg: . done
[28/39] Fetching curl-8.15.0.pkg: .......... done
[29/39] Fetching php83-8.3.24.pkg: .......... done
[30/39] Fetching os-telegraf-1.12.13.pkg: .. done
[31/39] Fetching libpfctl-0.16.pkg: .. done
[32/39] Fetching php83-xml-8.3.24.pkg: ... done
[33/39] Fetching php83-dom-8.3.24.pkg: .......... done
[34/39] Fetching libucl-0.9.2_2.pkg: .......... done
[35/39] Fetching perl5-5.40.3_2.pkg: .......... done
[36/39] Fetching opnsense-25.7.2.pkg: .......... done
[37/39] Fetching py311-duckdb-1.3.2.pkg: .......... done
[38/39] Fetching sudo-1.9.17p2.pkg: .......... done
[39/39] Fetching opnsense-lang-25.7.2.pkg: .......... done
Checking integrity... done (0 conflicting)
[1/39] Upgrading python311 from 3.11.13 to 3.11.13_1...
pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages( origin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, automatic, licenselogic, time, manifestdigest, dep_formula, vital)VALUES( 'lang/python311', 'python311', '3.11.13_1', 'Interpreted object-oriented programming language', 'Python is an interpreted object-oriented programming language, and is
often compared to Tcl, Perl or Scheme.', '[{"message":"Note that some standard Python modules are provided as separate ports\nas they require additional dependencies. They are available as:\n\npy311-gdbm       databases/py-gdbm@py311\npy311-sqlite3    databases/py-sqlite3@py311\npy311-tkinter    x11-toolkits/py-tkinter@py311","type":"install"}]', 'FreeBSD:14:amd64', 'python@FreeBSD.org', 'https://www.python.org/', '/usr/local', 211048567, 1, 1, NOW(), '2$2$n7q3f14jmcorkwcqbzfescqd858unir8uqe7fgbc5qbpdqq4u3ccueyyeeytcup49a9efi9etmg3earnbrunefij6uzjd9bp65hxfkb', NULL, 0 ) in file pkgdb.c:1633: database disk image is malformed
Starting web GUI...done.
***DONE***

[crazywolf13]

Linking this to https://forum.opnsense.org/index.php?topic=48594 as it seems to be the same issue.

[crazywolf13]

Is any more details needed?
Can I somehow correct that db, or what is the cause of this?