database is locked

[kekxv]

how fix database is locked when run ASYNC?

[lganzzzo]

Hello @kekxv ,

Most probably you are getting database is locked error when trying to read/write DB from multiple threads simultaneously.

To fix that just set you DB connection pool to max 1 connection

[kekxv]

@lganzzzo thank you for your reply.

you mean maxResources?I tried changing it to 1 but it became very slow. include select.

Will database is locked exist between reading and writing? Can add a write lock?