Try this solution:
Run on the leader:
pio kill --job-name monitor
rm /tmp/local_intermittent_pioreactor_metadata.sqlite
sudo systemctl restart pioreactor_startup_run@mqtt_to_db_streaming.service
sudo systemctl restart pioreactor_startup_run@monitor.service
And check that things work with:
sudo systemctl status pioreactor_startup_run@mqtt_to_db_streaming.service