602815 - Startup crash [@ sqlite3Fts3GetVarint ]

Status: RESOLVED WORKSFORME

(MailNews Core :: Database, defect)

Description

[Ludovic Hirlimann [:Usul]]

Crash ID 659b0085-89c6-43f4-a382-c22a92101007, no comments in the crashes we have so far.

0  	libsqlite3.dylib  	sqlite3Fts3GetVarint  	 db/sqlite3/src/sqlite3.c:107100
1 	libsqlite3.dylib 	sqlite3Fts3GetVarint32 	db/sqlite3/src/sqlite3.c:107115
2 	libsqlite3.dylib 	fts3SegReaderNext 	db/sqlite3/src/sqlite3.c:112988
3 	libsqlite3.dylib 	sqlite3Fts3SegReaderIterate 	db/sqlite3/src/sqlite3.c:114257
4 	libsqlite3.dylib 	fts3SegmentMerge 	db/sqlite3/src/sqlite3.c:114354
5 	libsqlite3.dylib 	fts3AllocateSegdirIdx 	db/sqlite3/src/sqlite3.c:112931
6 	libsqlite3.dylib 	fts3SegmentMerge 	db/sqlite3/src/sqlite3.c:114313
7 	libsqlite3.dylib 	fts3AllocateSegdirIdx 	db/sqlite3/src/sqlite3.c:112931
8 	libsqlite3.dylib 	sqlite3Fts3PendingTermsFlush 	db/sqlite3/src/sqlite3.c:114400
9 	libsqlite3.dylib 	fts3PendingTermsDocid 	db/sqlite3/src/sqlite3.c:112726
10 	libsqlite3.dylib 	fts3UpdateMethod 	db/sqlite3/src/sqlite3.c:114732
11 	libsqlite3.dylib 	sqlite3Step 	db/sqlite3/src/sqlite3.c:65285
12 	libsqlite3.dylib 	sqlite3_step 	db/sqlite3/src/sqlite3.c:58000
13 	thunderbird-bin 	mozilla::storage::AsyncExecuteStatements::executeStatement 	storage-backport/src/mozStorageAsyncStatementExecution.cpp:345
14 	thunderbird-bin 	mozilla::storage::AsyncExecuteStatements::executeAndProcessStatement 	storage-backport/src/mozStorageAsyncStatementExecution.cpp:292
15 	thunderbird-bin 	mozilla::storage::AsyncExecuteStatements::bindExecuteAndProcessStatement 	storage-backport/src/mozStorageAsyncStatementExecution.cpp:274
16 	thunderbird-bin 	mozilla::storage::AsyncExecuteStatements::Run 	storage-backport/src/mozStorageAsyncStatementExecution.cpp:597
17 	libxpcom_core.dylib 	nsThread::ProcessNextEvent 	xpcom/threads/nsThread.cpp:527
18 	libxpcom_core.dylib 	NS_ProcessNextEvent_P 	nsThreadUtils.cpp:250
19 	libxpcom_core.dylib 	nsThread::ThreadFunc 	xpcom/threads/nsThread.cpp:254
20 	libnspr4.dylib 	_pt_root 	nsprpub/pr/src/pthreads/ptthread.c:228
21 	libSystem.B.dylib 	_pthread_start 	
22 	libSystem.B.dylib 	thread_start

Comment 1

[Wayne Mery (:wsmwk)]

ludo, is bp-659b0085-89c6-43f4-a382-c22a92101007 your crash in v3.1.5, or a tester?

Not Mac-only.

I vaguely remember looking at this in the past, and thinking the stack might be a close match to one of our other crashes - but I no longer remember which.

from http://crash-stats.mozilla.com/query/query?product=Thunderbird&version=ALL%3AALL&range_value=4&range_unit=days&date=10%2F08%2F2010+03%3A03%3A33&query_search=signature&query_type=contains&query=Fts3&build_id=&hang_type=any&do_query=1

"I keep getting this crash message and as a result my in basket fails. I tried reloading thunderbird but that had no effect. I also cannot send attachment prior to the recent crashes. My operating systenm is windows xp and my provider is embarqmail.com" from bp-20f01ffc-a02e-47ea-bc2c-559be2100911 (dzmar)

Going back further:
- ~75% of crashes look like they might be during startup, however ...
- 99% of the comments state it crashes *during* search (no comments about crashing during startup)
- big uptick in crashes at v3.0.4.  Prior to that, almost non-existent a) zero crashes prior to v3.0.2, b) no more than a couple v3.0.3 and v3.0.2 crashes per week, c) no significant # crashes with Fts3 in signature. ... so perhaps the increase is a regression, or it morphed from another crash signature. 

crashes with sqlite in sig from 12/4/2009 - 12/8/2009 are
 sqlite3DbMallocRaw
arena_dalloc_small | arena_dalloc | free | sqlite3_free | pcache1TruncateUnsafe
arena_dalloc_small | arena_dalloc | free | sqlite3_free | vdbeFreeOpArray
arena_dalloc_small | arena_dalloc | free | sqlite3_free | sqlite3DbFree
arena_dalloc_small | arena_dalloc | free | sqlite3_free | sqlite3VdbeDelete
mozilla::storage::Row::initialize(sqlite3_stmt*)
sqlite3Update
free | sqlite3_free | sqlite3SrcListDelete
sqlite3MemSize
sqlite3Error
sqlite3PageFree

Comment 2

[Ludovic Hirlimann [:Usul]]

(In reply to comment #1)
> ludo, is bp-659b0085-89c6-43f4-a382-c22a92101007 your crash in v3.1.5, or a
> tester?

There'd be a comment if it would be my crash :D

Comment 3

[Wayne Mery (:wsmwk)]

sqlite3Fts3GetVarint still exists in v3.1.10

bp-14773324-3c97-49f0-ae2a-9bfee2110502
EXCEPTION_ACCESS_VIOLATION_READ
0x0
0	sqlite3.dll	sqlite3Fts3GetVarint	db/sqlite3/src/sqlite3.c:107100
1	sqlite3.dll	fts3SegReaderNext	db/sqlite3/src/sqlite3.c:112988
2	sqlite3.dll	sqlite3Fts3SegReaderIterate	db/sqlite3/src/sqlite3.c:114257
3	sqlite3.dll	fts3SegmentMerge	db/sqlite3/src/sqlite3.c:114356
4	sqlite3.dll	fts3AllocateSegdirIdx	db/sqlite3/src/sqlite3.c:112931
5	sqlite3.dll	fts3SegmentMerge	db/sqlite3/src/sqlite3.c:114313
6	sqlite3.dll	fts3AllocateSegdirIdx	db/sqlite3/src/sqlite3.c:112931
7	sqlite3.dll	sqlite3Fts3PendingTermsFlush	db/sqlite3/src/sqlite3.c:114400
8	sqlite3.dll	sqlite3VtabSync	db/sqlite3/src/sqlite3.c:94013
9	sqlite3.dll	vdbeCommit	db/sqlite3/src/sqlite3.c:56036
10	sqlite3.dll	sqlite3VdbeHalt	db/sqlite3/src/sqlite3.c:56503
11	sqlite3.dll	sqlite3VdbeExec	db/sqlite3/src/sqlite3.c:62185
12	sqlite3.dll	sqlite3Step	db/sqlite3/src/sqlite3.c:57936
13	sqlite3.dll	sqlite3_step	db/sqlite3/src/sqlite3.c:58002
14	thunderbird.exe	mozilla::storage::AsyncExecuteStatements::executeStatement	storage-backport/src/mozStorageAsyncStatementExecution.cpp:345
15	thunderbird.exe	mozilla::storage::AsyncExecuteStatements::executeAndProcessStatement	storage-backport/src/mozStorageAsyncStatementExecution.cpp:292
16	thunderbird.exe	mozilla::storage::AsyncExecuteStatements::Run	storage-backport/src/mozStorageAsyncStatementExecution.cpp:601

Comment 4

[Wayne Mery (:wsmwk)]

These crashes are gone as of version 9