SQLite support is broken

[Cirras]

Background

• EOSERV does all of its database operations in one big transaction on the main thread.
• SQLite only supports one simultaneous write transaction.

Problem

• Since the addition of asynchronous database operations on background threads for the LoginManager, SQLite support has been broken.

Reproduction case

• Configure EOSERV to use an SQLite database
• Create an account
• Account creation will fail, and a Database_QueryFailed exception will be raised.
• The error message from SQLite is "database is locked"

See

• World::BeginDB
• SQLite: Transaction

[ethanmoffat]

Thanks for this, easy repro. I'll start working on a solution.

FYI setting TimedSave=0m in the configuration seems to work around it. I'll be focusing on improving that functionality so the db doesn't constantly have an open pending transaction.

[Cirras]

I assume this issue is fixed since 12302ec.
Is there any other obvious work to be done in this area?

[ethanmoffat]

Oh you're right - I forgot about this issue since I've been tracking tasks on clickup.