Symptoms:
YYYY-DD-MM HH:MM:SS,576 [loggable.py:102]: ==========VCSA Deployment Progress Report==========
Task: Run firstboot scripts.(FAILED 84/100) - Starting VMware Appliance Monitoring Service...
Error: An error occurred while starting service 'statsmonitor'
Error: Failed to start Appliance Stats Monitoring service.
YYYY-DD-MM HH:MM:SS,576 [loggable.py:102]: The VCSA deployment has failed
YYYY-DD-MM HH:MM:SS.641Z Starting statsmonitor
YYYY-DD-MM HH:MM:SS.865Z statsmonitor firstboot failed due to <cis.componentStatus.ErrorInfo object at 0x7f9146e21b90>.
YYYY-DD-MM HH:MM:SS.859Z ERROR starting statsmonitor rc: 2, stdout: , stderr: Start service request failed. Error: Service crashed while starting
YYYY-DD-MM HH:MM:SS.835Z info StatsMonitor[47911] [Originator@6876 sub=StatsMonitor] SqliteStorageEngine using SQLite version: 3.34.1
YYYY-DD-MM HH:MM:SS.843Z error StatsMonitor[47911] [Originator@6876 sub=StatsMonitor] Failed to execute SQL CREATE TABLE IF NOT EXISTS "sm_stats_metadata" ( stat_id VARCHAR(128), stat_table_name VARCHAR(128), stat_metadata VARCHAR(512), CONSTRAINT "pk_sm_stats_metadata" PRIMARY KEY (stat_id), CONSTRAINT "uniq_sm_stats_metadata" UNIQUE (stat_table_name));
YYYY-DD-MM HH:MM:SS.852Z error StatsMonitor[47911] [Originator@6876 sub=StatsMonitor] Unable to open and initialize storage engine: attempt to write a readonly database
YYYY-DD-MM HH:MM:SS.852Z info StatsMonitor[47911] [Originator@6876 sub=StatsMonitor] Exiting with status=false.
To workaround the issue, please follow the below mentioned steps: