-
Notifications
You must be signed in to change notification settings - Fork 93
Description
Hello,
First of all thanks for creating such wonderful small framework wrapper for Sqlite for thread safety. I am trying to integrate it in my app that uses 3 threads to read/write content in database, It is working at first sight very well except I am getting crash regularly when trying to select rows from database. I am also not sure what is causing it but crashing on all system (10.8/10.9.5/10.10 too) mostly on same line number.
In my system I have created a shared instance of EGODatabase and using it for all DB related operation from all three threads. Please confirm if it is fine or I need to change it:
. Below are crash threads:
Thread 0:: Dispatch queue: com.apple.main-thread
0 libsystem_kernel.dylib 0x00007fff8bf2bae6 fsync + 10
1 libsqlite3.dylib 0x00007fff88c7a858 unixSync + 56
2 libsqlite3.dylib 0x00007fff88c82dfe syncJournal + 414
3 libsqlite3.dylib 0x00007fff88c7a5f6 sqlite3PagerCommitPhaseOne + 1526
4 libsqlite3.dylib 0x00007fff88c6906d sqlite3BtreeCommitPhaseOne + 685
5 libsqlite3.dylib 0x00007fff88c2b933 sqlite3VdbeHalt + 3539
6 libsqlite3.dylib 0x00007fff88c5de4e sqlite3VdbeExec + 54766
7 libsqlite3.dylib 0x00007fff88c502ab sqlite3_step + 3691
8 com.xxx.xxx 0x0000000105585c16 -[EGODatabase executeUpdate:parameters:] + 678
And second is:
Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0 libsystem_kernel.dylib 0x00007fff885e9292 __kill + 10
1 com.xx.xx 0x0000000102b9118a CLSSignalHandler + 212
2 libsystem_platform.dylib 0x00007fff907625aa _sigtramp + 26
3 libsqlite3.dylib 0x00007fff8ec1235b sqlite3PExpr + 187
4 libsqlite3.dylib 0x00007fff8eb535a9 yy_reduce + 489
5 libsqlite3.dylib 0x00007fff8eb53326 sqlite3Parser + 278
6 libsqlite3.dylib 0x00007fff8eb520e1 sqlite3RunParser + 305
7 libsqlite3.dylib 0x00007fff8eb5197e sqlite3Prepare + 734
8 libsqlite3.dylib 0x00007fff8eb5157f sqlite3LockAndPrepare + 191
9 libsqlite3.dylib 0x00007fff8ebd7c7c sqlite3_prepare + 28
10 com.accessagility.wlancontroller 0x0000000102b3444d -[EGODatabase executeQuery:parameters:] + 381 (EGODatabase.m:261)
11 com.accessagility.wlancontroller 0x0000000102b341d2 -[EGODatabase executeQueryWithParameters:] + 754 (EGODatabase.m:238)
12 com.xxx.xxx 0x0000000102abe529 +[TSDatabase getTestProifleIDs:] + 473 (TSDatabase.m:69)
Any help will be appreciated greatly.
Thanks.
MP