A similar error is observed when checking the status of the sosrest service:
systemctl status sosrest.service -l
mm dd Hr:min:sec sosrest[1861]: During handling of the above exception, another exception occurred:
mm dd Hr:min:sec sosrest[1861]: Traceback (most recent call last):
mm dd Hr:min:sec sosrest[1861]: File "framework/workflowhandler.py", line 154, in get_workflow_status
mm dd Hr:min:sec sosrest[1861]: File "framework/dbinterface/db_api.py", line 415, in db_to_json
mm dd Hr:min:sec sosrest[1861]: framework.dbinterface.db_api.DBException: Converting from db to json failed
mm dd Hr:min:sec sosrest[1861]: During handling of the above exception, another exception occurred:
mm dd Hr:min:sec sosrest[1861]: Traceback (most recent call last):
mm dd Hr:min:sec sosrest[1861]: File "sosapi/controllers/statusapi2.py", line 72, in sos_status
mm dd Hr:min:sec sosrest[1861]: File "framework/workflowhandler.py", line 166, in get_workflow_status
mm dd Hr:min:sec sosrest[1861]: AssertionError: Convert from db to json failed
A similar error is observed in the vcf-sos.log:/var/log/vmware/vcf/sddc-support/vcf-sos.log:
mm dd Hr:min:sec ERROR [vcf_sos] [db_api.py::return_a_session::70::MainThread] DB commit failed
mm dd Hr:min:sec INFO [vcf_sos] [db_api.py::return_a_session::73::MainThread] Closing session
mm dd Hr:min:sec ERROR [vcf_sos] [db_api.py::db_to_json::413::MainThread] Converting to JSON from db failed
mm dd Hr:min:sec ERROR [vcf_sos] [db_api.py::db_to_json::414::MainThread] Traceback (most recent call last):
File "/opt/vmware/sddc-support/services/../framework/../dependency/sqlalchemy/engine/base.py", line 1968, in _exec_single_context
self.dialect.do_execute(
File "/opt/vmware/sddc-support/services/../framework/../dependency/sqlalchemy/engine/default.py", line 920, in do_execute
cursor.execute(statement, parameters)
sqlite3.DatabaseError: database disk image is malformed
VMware Cloud Foundation 4.x
VMware Cloud Foundation 5.x
One of the required files for the sosrest service is out of sync
Potential causes:
Note: This will remove the backup history from SDDC Manager
This requires changes in the SDDC manager database. Kindly ensure to take a snapshot of the SDDC Manager before making the changes
systemctl stop sosrest.service
mv /opt/vmware/vcf/sddc-support/soservice.db /home/vcf
mv /opt/vmware/vcf/sddc-support/status.json /home/vcf
mv /opt/vmware/vcf/sddc-support/.status-tmp.json /home/vcf
/usr/pgsql/13/bin/psql -h localhost -U postgres -d platform -c "delete from task_metadata where task_url like '%sos%'"
/usr/pgsql/13/bin/psql -h localhost -U postgres -d platform -c "delete from task_metadata where task_type='SDDCMANAGER_BACKUP'"
psql -h localhost -U postgres
\c
delete from task_metadata where task_url like '%sos%';
delete from task_metadata where task_type='SDDCMANAGER_BACKUP';
systemctl start sosrest.service
/opt/vmware/vcf/operationsmanager/scripts/cli/sddcmanager_restart_services.sh