SQLite Lib Crash

Karbon · Post by **Karbon** » Thu Aug 21, 2003 8:44 pm

Hey El_Choni (or anyone else that knows), is it safe to use the SQLite userlib functions from inside a thread?

The SQlite guys tell me the windows DLL is compiled with -DTHREADSAFE by default so the library should be OK. The code below crashes big time on the first call of SQLiteExec() in the thread but is fine outside it.

For the database just a test table with three int fields will do.

Code: Select all

Procedure test_sqlite(go.l)
  
  Protected s_query.s
  
  For count = 1 To 10
    
    s_query.s = "INSERT INTO test values("+Str(Random(1000))+","+Str(Random(1000))+","+Str(Random(1000))+")"

    exec_result.l =  SQLiteExec(s_query)
  
    If exec_result <> 0 
    
      Debug SQLiteError(exec_result)
    
    EndIf
    
  Next
  
EndProcedure
 
init_result.l = InitSQLite("sqlite.dll")

If init_result = #False
  
  Debug "Initialize Failed "
  
  End
  
EndIf

Debug "SQLite Version: " + SQLiteDllVersion()

SQLiteOpen("ix.dat")

CreateThread(@test_sqlite(),1)

End

Thanks!

Karbon · Post by **Karbon** » Fri Aug 22, 2003 1:49 am

The crash is triggered by the call to SQLiteError() inside the thread.. I also tried putting the SQLiteOpen("ix.dat") inside the thread itself but then it crashes on SQLiteOpen()

*stares blankly at the ASM source*

El_Choni · Post by **El_Choni** » Fri Aug 22, 2003 5:08 pm

Can't help you right now, I'll fix it when I'm back to Spain, in September. Sorry for the inconvenience.

Regards,

Karbon · Post by **Karbon** » Fri Aug 22, 2003 5:26 pm

Can you give me a hint as to what it might be - I'll have a go at fixing it

I'm nowhere near good with ASM but I'm willing to try!

Thanks!

El_Choni · Post by **El_Choni** » Sat Aug 30, 2003 9:25 pm

My tip: implement Thread Local Storage in the lib XD (I was doing just exactly that before my holydays fell over my head). I would wait for September if I were you, but you can try yourself, it won't harm you.

Karbon · Post by **Karbon** » Sun Aug 31, 2003 2:16 am

I'll wait for you to do it - that stuff is still a bit over my head!

Thanks !!!!

Karbon · Post by **Karbon** » Mon Sep 15, 2003 6:57 pm

El_Choni · Post by **El_Choni** » Tue Sep 16, 2003 10:15 am

Haven't forgotten it, I'm moving this week, so I can't code right now

Karbon · Post by **Karbon** » Tue Sep 16, 2003 4:34 pm

Good luck with the move!

Kale · Post by **Kale** » Thu Oct 30, 2003 12:42 am

Has this lib now been updated? where can i get the latest version?

Karbon · Post by **Karbon** » Thu Oct 30, 2003 1:00 am

Not that I've heard.. If you find out please let me know!