mac: app can sometimes fail to startup due to failed database migration; clear-all-date works around it

[chwarwick]

The application failed to start because of failed migrations, log information below:

Sourcegraph App version: 2023.7.4+1332.fc76a9c675 darwin arm64

FATAL sourcegraph svcmain/svcmain.go:263 github.com/sourcegraph/sourcegraph/internal/service/svcmain.run.func1 failed to start service {"Resource": {"service.name": "sourcegraph-backend", "service.version": "2023.7.4+1332.fc76a9c675", "service.instance.id": "MacBook.local"}, "Attributes": {"service": "frontend", "error": "failed to connect to frontend database: dirty database: schema \"frontend\" marked the following migrations as failed: 1648051770\nThe target schema is marked as dirty and no other migration operation is seen running on this schema. The last migration operation over this schema has failed (or, at least, the migrator instance issuing that migration has died). Please contact [email protected] for further assistance."}}

[emidoots]

I saw this once before but I'm not sure why. Using System tray -> Cody -> Troubleshooting -> Clear all data fixed it of course

[vaibhavkumar-sf]

Same issue

[vaibhavkumar-sf]

Solved .. it was because I installed extension in VSCODE first .. I removed VSCODE, then installed APP again, and it is working now.