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:
Quote2022-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.
By any chance the device hasn't rebooted after the upgrade?
Yeah it rebooted after the upgrade. I'll try that later tonight when folks are in bed.
Just rebooted. Still same issue.
Does rolling back to 22.1.9 alleviate the issue?
Database broken? I'd suggest a full reset of packages with no configuration loss:
# opnsense-bootstrap
Cheers,
Franco
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.
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