SQLite database lock errors on montage-beta cause intermittent failures

[lgelauff]

The montage-beta instance is currently configured to use SQLite (sqlite:///tmp_montage.db) instead of MySQL. SQLite does not handle concurrent requests well, which causes occasional database is locked errors when multiple requests hit the server simultaneously.

This is not urgent — montage-beta is a testing environment and not in active use. However, it may explain intermittent errors or false positives when testing on beta.

The fix is straightforward: switch the db_url in config.beta.yaml back to the MySQL connection (which is currently commented out).

[ayushshukla1807]

Hey @lgelauff, thanks for raising this. Since config.beta.yaml is not tracked in the central git repository and is exclusively managed per-deployment on Toolforge natively, navigating the SQLite locks requires an administrator to SSH directly into the instance and modify the file. I am leaving this open for the DevOps/Maintainer team with beta access to deploy the MySQL connection string update directly to the beta cluster.

[lgelauff]

I agree, this is probably a straight forward fix. I just want to make sure that this was not a conscious choice by @mahmoud @Jayprakash-SE to use SQlite instead of MySQL.