esqlite return "error = 21"

[mmzeeman]

esqlite return "error = 21"

[mmzeeman]

Could it be SQLITE_MISUSE?

#define SQLITE_MISUSE      21   /* Library used incorrectly */

That can happen when a connection is shared between multiple processes/threads. Or that a query was already done or errored earlier.

Before 0.8 every connection had its own associated os level thread. It looks like you were already using the never version which uses dirty schedulers.

The later releases have been small fixes, and sqlite version updates.

[mmzeeman]

With version > 0.8 you must be really sure to serialize requests to SQLite. The plus side is that connections are now much more light weight.

[Zabrane]

@mmzeeman thanks a lot, that was it. The new version is much faster and the process who opens the DB originally closes it earlier than before.
Keep up the work ;-)

[mmzeeman]

👍

Thanks for your reply... It is always nice to hear from people using this library.