free pascal sqlite and mutithreading
lazarus / 64-FPC development

----------------------------------------------------------------------
Чебурашка · 2024-02-29 12:48

As emerges from

https://forum.lazarus.freepascal.org/index.php/topic,66432.0.html

if the following situation occurs:

there are multiple threadseach thread accesses one or more sqlite
databaseseach sqlite database is accessed only by one threadevery time
one database is accessed, all the connection/transation/query objects
are created and destroyed

It is possible to experience access violations, apparently due to the
malfunction of the multithreaded refcouting system implemented in the
fp software to wrap the libsqlite3.so (tested in linux, I have done no
test for windows).

At the moment the workaround is to call

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
InitializeSQLite(); 
before any sqlite db operation is made (example at program startup),
then and call

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ReleaseSQLite(); 
after all sqlite db operation were made (example at program end).