ERRO[0007] error handling request error="database is locked"

[ahmedash95]

On a +15k concurrent traffic, it gives me a database is locked error, I know its from SQLite database but what issue cause this locking?

[prologic]

SQLite is not great for concurrent writes. You want to use a database more suited to high volume write transactions.

[ahmedash95]

I'm new to fathom, so what is available databases to use instead of sqlite ?

[prologic]

Pretty sure you can use mysql. Follow the docs on custom configuration

[prologic]

MySQL will at least give you better concurrent write performance; especially on MyRocks. YMMV

[ahmedash95]

Thanks @prologic for ur help.