536688 - Infinite indexing of messages caused by problems with "gloda.datastore" requests

Status: RESOLVED WORKSFORME

(Thunderbird :: Folder and Message Lists, defect)

Description

[Ryan Kaskel]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/532.6 (KHTML, like Gecko) Chrome/4.0.266.0 Safari/532.6
Build Identifier: Thunderbird 3.0 (Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0)

This problem only started to happen after the upgrade to 3.0. It also never happened on my other machine which runs an identical OS but is inherently different because it isn't the same. Anyway here are some details that might be relevant:

As far as a I can tell, this has to do with a permissions problem with a SQLite datbase file.  Here is a listing of my default profile:

ryan@ryan-laptop:~/.mozilla-thunderbird/rdl715on.default$ pwd
/home/ryan/.mozilla-thunderbird/rXXXXXon.default
ryan@ryan-laptop:~/.mozilla-thunderbird/rdl715on.default$ ls -l
total 11680
-rw-r--r-- 1 ryan ryan       0 2009-08-22 12:56 abook-1.mab
-rw-r--r-- 1 ryan ryan   35435 2009-12-24 11:54 abook.mab
-rw-r--r-- 1 ryan ryan    1131 2009-12-20 11:14 blocklist.xml
drwxr-xr-x 2 root root    4096 2009-12-13 23:07 Cache
-rw------- 1 ryan ryan   65536 2009-12-24 11:55 cert8.db
-rw------- 1 ryan ryan     148 2009-12-13 23:06 compatibility.ini
-rw-r--r-- 1 ryan ryan  181889 2009-12-20 12:53 compreg.dat
-rw-r--r-- 1 root root    2048 2009-12-13 23:06 cookies.sqlite
-rw-r--r-- 1 ryan ryan     206 2009-08-26 18:31 downloads.rdf
drwxr-xr-x 4 ryan ryan    4096 2009-12-24 00:53 extensions
-rw-r--r-- 1 ryan ryan     320 2009-12-20 12:53 extensions.cache
-rw-r--r-- 1 ryan ryan     315 2009-12-20 12:53 extensions.ini
-rw-r--r-- 1 ryan ryan    6956 2009-12-20 12:53 extensions.rdf
-rw-r--r-- 1 root root     268 2009-12-13 23:09 folderTree.json
-rw-r--r-- 1 root root 6111232 2009-12-13 23:09 global-messages-db.sqlite
-rw-r--r-- 1 ryan ryan    2180 2009-12-18 19:28 history.mab
drwxr-xr-x 7 ryan ryan    4096 2009-08-22 15:08 ImapMail
-rw-r--r-- 1 ryan ryan     309 2009-08-24 17:45 install.log
-rw------- 1 ryan ryan   16384 2009-12-24 11:55 key3.db
-rw-r--r-- 1 ryan ryan   20367 2009-12-24 00:47 localstore.rdf
drwxr-xr-x 4 ryan ryan    4096 2009-12-13 23:06 Mail
-rw-r--r-- 1 root root     482 2009-12-13 23:06 mailViews.dat
-rw-r--r-- 1 ryan ryan     607 2009-12-24 11:55 mimeTypes.rdf
drwx------ 2 root root    4096 2009-12-13 23:06 minidumps
drwx------ 2 ryan ryan    4096 2009-12-19 02:13 OfflineCache
-rw-r--r-- 1 ryan ryan   18308 2009-12-24 11:55 panacea.dat
-rw-r--r-- 1 root root    2048 2009-12-13 23:06 permissions.sqlite
-rw------- 1 root root    2709 2009-12-13 23:07 pluginreg.dat
-rwxr-xr-x 1 ryan ryan   21464 2009-12-24 11:55 prefs.js
-rw------- 1 ryan ryan   16384 2009-12-13 23:06 secmod.db
-rw-r--r-- 1 ryan ryan     250 2009-12-24 11:55 session.json
-rw------- 1 root root    1015 2009-12-13 23:07 signons3.txt
-rw-r--r-- 1 root root   14336 2009-12-13 23:07 signons.sqlite
-rw------- 1 ryan ryan     613 2009-08-22 15:09 signons.txt
-rw-r--r-- 1 ryan ryan  119285 2009-11-26 22:38 training.dat
-rw-r--r-- 1 ryan ryan       0 2009-08-22 12:53 urlclassifier2.sqlite
-rw-r--r-- 1 root root   32768 2009-12-13 23:07 urlclassifier3.sqlite
drwxr-xr-x 2 ryan ryan    4096 2009-08-22 12:32 US
-rw-r--r-- 1 ryan ryan      10 2009-12-24 11:55 virtualFolders.dat
-rw-r--r-- 1 ryan ryan 2532707 2009-12-20 12:53 XPC.mfasl
-rw-r--r-- 1 ryan ryan  128302 2009-12-20 12:53 xpti.dat
-rw-r--r-- 1 ryan ryan 2492200 2009-12-24 11:41 XUL.mfasl



Reproducible: Always

Steps to Reproduce:
1. Open Thunderbird
2. View message indexing going on infinitely ... see screenshot http://www2.ryankaskel.com/misc/images/screenshots/thunderbird_indexing1.png 
3. Open error console and see the following messages I think relate to sqlite:
2009-12-24 00:48:43	gloda.datastore	ERROR	Async queryFromQuery error: 1: Problem creating async statement.
2009-12-24 00:48:44	gloda.datastore	ERROR	got error in _asyncTrackerListener.handleError(): 8: attempt to write a readonly database
(these messages continue on infinitely until I exit the application

Actual Results:  
The message indexing goes on in what seems like an infinitely loop maybe because of a permissions error on the sqlite database that handles message indexing.

Expected Results:  
I expect the message indexing operating to complete.

Comment 1

[Ryan Kaskel]

Fixed by changing the ownership on the ~/.mozilla-thunderbird directory.  I use Ubuntuzilla and ran Thunderbird as root using "sudo" instead of "gksudo" or the like.  This was warned against in the Ubuntuzilla documentation. [1] This fix was to run the following command:
ryan@ryan-laptop:~$ sudo chown -R ryan:ryan /home/ryan/.mozilla-thunderbird/
Obivously replacing your username where appropriate.

Cheers.