Hi I am using SQLite Fts3 table for indexing the some raw data. I have got a crash when I search for some special string pattern.
I have done the following steps before its crashed: 1) PREPARED the statement using sqlite3_prepare 2) BIND the text using sqlite3_bind_text for the string ( search string) 3) STEP the query.(Here I got error "database disk image is malformed" .) I am calling the above 3 steps repeatedly after certain delay. But once I got the above error, Its Its crashing during next cycle(when PREPARE) Query caused to crash. "SELECT COUNT([contact].[id]) cnt FROM fts_contact JOIN contact ON [contact].[id] = [fts_contact].[rowid] AND [fts_contact] match ? WHERE [contact].[rowid] IN(SELECT [contact_id] FROM analytics_email JOIN contact_email_link WHERE contact_email_link.email_ address_id = analytics_email.email_address_id AND total_sent > 0 GROUP BY [contact_id]) " SQLite Version: 3.6.16 OS Version: Mac OS X 10.5.8 (9L31a) Please find the stack trace below when application crashed 0 libSystem.B.dylib 0x962bfbba tiny_free_list_add_ptr + 139 1 libSystem.B.dylib 0x962be67c tiny_malloc_from_free_list + 898 2 libSystem.B.dylib 0x962b71cd szone_malloc + 180 3 libSystem.B.dylib 0x962b70d8 malloc_zone_malloc + 81 4 libSystem.B.dylib 0x962b706c malloc + 55 5 sampletest 0x00101ca9 sqlite3MemMalloc + 32 6 sampletest 0x00102869 mallocWithAlarm + 167 7 sampletest 0x0010292a sqlite3Malloc + 84 8 sampletest 0x00103168 sqlite3DbMallocRaw + 183 9 sampletest 0x0010308d sqlite3DbMallocZero + 25 10 sampletest 0x001331e2 sqlite3ExprAlloc + 101 11 sampletest 0x00133419 sqlite3PExpr + 41 12 sampletest 0x001630fa spanExpr + 47 13 sampletest 0x001650f2 yy_reduce + 6489 14 sampletest 0x00166c60 sqlite3Parser + 211 15 sampletest 0x00167b08 sqlite3RunParser + 516 16 sampletest 0x0013c46f sqlite3NestedParse + 193 17 sampletest 0x0013e79d sqlite3EndTable + 957 18 sampletest 0x00163ed0 yy_reduce + 1847 19 sampletest 0x00166c60 sqlite3Parser + 211 20 sampletest 0x00167b92 sqlite3RunParser + 654 21 sampletest 0x0015c0ef sqlite3_declare_vtab + 188 22 sampletest 0x0016fb53 constructVtab + 550 23 sampletest 0x0016fc0f fulltextConnect + 94 24 sampletest 0x0015baad vtabCallConstructor + 165 25 sampletest 0x0015be20 sqlite3VtabCallConnect + 187 26 sampletest 0x0013ebde sqlite3ViewGetColumnNames + 46 27 sampletest 0x00154e61 selectExpander + 618 28 sampletest 0x00130c7d sqlite3WalkSelect + 61 29 sampletest 0x001554a2 sqlite3SelectExpand + 55 30 sampletest 0x001555e4 sqlite3SelectPrep + 62 31 sampletest 0x00155c06 sqlite3Select + 264 32 sampletest 0x0016459f yy_reduce + 3590 33 sampletest 0x00166c60 sqlite3Parser + 211 34 sampletest 0x00167b92 sqlite3RunParser + 654 35 sampletest 0x0014efbd sqlite3Prepare + 374 36 sampletest 0x0014f305 sqlite3LockAndPrepare + 113 37 sampletest 0x0014f474 sqlite3_prepare + 53 Can you please help me to resolve this issue. Thanks Regards Subbi Reddy K _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
