Cannot add/update/delete packages via Web UI after upgrade to 22.1.9_1

[infinisourcekc]

As the title says... cannot add/update/delete any packages via the Web UI since upgrading to 22.1.9_1.  The backend logs have a plethora of entries like this below:

2022-07-03T12:43:53-05:00   Error   configd.py   [1cbda886-7d7c-45a8-98ba-6c7cd24e7d0f] Script action stderr returned "b'Child process pid=46025 terminated abnormally: Abort trap'"   
2022-07-03T12:43:53-05:00   Error   configd.py   [0c75a9d6-7e2d-46ec-83e8-1e8b3b1dc1f3] Script action failed with Command 'pkg rquery "%n|||%v|||%c|||%sh|||0|||0|||%L|||%R|||%o" ' returned non-zero exit status 134. at Traceback (most recent call last): File "/usr/local/opnsense/service/modules/processhandler.py", line 478, in execute subprocess.check_call(script_command, env=self.config_environment, shell=True, File "/usr/local/lib/python3.8/subprocess.py", line 364, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'pkg rquery "%n|||%v|||%c|||%sh|||0|||0|||%L|||%R|||%o" ' returned non-zero exit status 134.   
2022-07-03T12:41:07-05:00   Error   configd.py   [cf21ddcc-42a5-4bba-9243-7e2c70936480] Script action stderr returned "b'Child process pid=54713 terminated abnormally: Abort trap'"   
2022-07-03T12:41:07-05:00   Error   configd.py   [8a54585d-fb47-423f-b7f7-faf4199ca9fd] Script action failed with Command 'pkg rquery "%n|||%v|||%c|||%sh|||0|||0|||%L|||%R|||%o" ' returned non-zero exit status 134. at Traceback (most recent call last): File "/usr/local/opnsense/service/modules/processhandler.py", line 478, in execute subprocess.check_call(script_command, env=self.config_environment, shell=True, File "/usr/local/lib/python3.8/subprocess.py", line 364, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'pkg rquery "%n|||%v|||%c|||%sh|||0|||0|||%L|||%R|||%o" ' returned non-zero exit status 134.

Any idea how this can be resolved?  I've tried running a health audit from the frimware status page.  I've tried running a automatic resolver from the same page.  I can install pkg's via the CLI but something is messed up with the UI.

[cookiemonster]

By any chance the device hasn't rebooted after the upgrade?

[infinisourcekc]

Yeah it rebooted after the upgrade.  I'll try that later tonight when folks are in bed.

[infinisourcekc]

Just rebooted.  Still same issue.

[axsdenied]

Does rolling back to 22.1.9 alleviate the issue?

[franco]

Database broken? I'd suggest a full reset of packages with no configuration loss:

# opnsense-bootstrap


Cheers,
Franco

[infinisourcekc]

Thanks Franco.  That pretty much resolved everything.  Just have a straggler left in the plugins (os-sensei-db) that will not reinstall.  I think it's a leftover from before Zenarmor changed their name from Sensei to Zenarmor.

[franco]

Edit /conf/config.xml and remove "os-sensei-db" from the firmware plugins entry (system/firmware/plugins). It's a CSV so make sure to remove a comma as well if the list has multiple entries.


Cheers,
Franco