Stop celery using systemctl stop indico-celery (make sure it is fully stopped, ps aux | grep celery should not show anything besides possibly the grep command itself), then delete /opt/indico/tmp/celerybeat-schedule, then start celery again.
Not sure what caused your issue, but since it seems to have a problem with the scheduler’s db, so deleting it should solve it.