Issues after upgrade

[weirdyang]

I've a module which creates tables and initializes a service using tenant module startup events.

I'm now running into a couple of issues since upgrading to 2.0.0:

With SQLite, I am now getting this error SQLite Error 6: 'database schema is locked: main'. on the initial startup after enabling the module, in my service I run a query to get a list of documents.
What could be causing this?

I tried using a ShellScope.AddDeferred task instead to do initialization but it threw another error, about a collection can't be modified while being enumerated.
How can I checke if the shell is initialized before running my query?

{ "timestamp": "2024-09-20 12:18:05.2085", "level": "FATAL", "message": "Unable to start MqttWorkerService", "callSite": "OrchardCore.Mqtt.Profiles.Services.MqttStartupService.InitializeAsync", "exception": "SQLite Error 6: 'database schema is locked: main'.", "stacktrace": "   at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()\r\n   at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()\r\n   at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()\r\n   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n