464236 - Ubiquity failed to work when ubiquity_suggestion_memory.sqlite is corrupted

Status: RESOLVED INCOMPLETE

(Mozilla Labs :: Ubiquity, enhancement)

Description

[Jjgod Jiang]

User-Agent:       Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en-us) AppleWebKit/528.1 (KHTML, like Gecko) Version/4.0 Safari/528.1
Build Identifier: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.3) Gecko/2008092414 Firefox/3.0.3

When the SQLite database file ubiquity_suggestion_memory.sqlite got corrupted, Ubiquity will failed to launch, producing errors like:

Component returned failure code: 0x8052000b ( NS_ERROR_FILE_CORRUPTED) [mozIStorageService.openDatabase...

in the Error Console. Eventually, it will results gUbiquity variable to be null.

A workaround is to delete that file, let Ubiquity to recreate it.

Reproducible: Always

Steps to Reproduce:
1. Destory the structure of ubiquity_suggestion_memory.sqlite (by accident or on purpose)
2. Open Firefox with Ubiquity installed
Actual Results:  
Ubiquity failed to work without any prompt.

Expected Results:  
Ubiquity should first try to fix that file. (I think there should be some SQLite utilities for that.)

If it failed, prompt the user that database is corrupted, ask if it should try to recreate it.

Comment 1

[Gordon P. Hemsley [:GPHemsley]]

Given how uncommon it is for this to happen, and how easy it is to just delete the corrupt file, I'm marking this as a request for enhancement. But I'm also confirming it.

Comment 2

[Takanori MATSUURA]

This bug lies at rest in the graveyard.