Closed Bug 1067299 Opened 10 years ago Closed 6 years ago

Checking and trying to repair databases if an error occurred

Categories

(Firefox :: Bookmarks & History, enhancement)

Product:
Firefox
Component:
Bookmarks & History
Version:
32 Branch
Platform:
x86_64
Linux
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED WORKSFORME

People

(Reporter: sworddragon2, Unassigned)

Details

User Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:32.0) Gecko/20100101 Firefox/32.0
Build ID: 20140910020313



Actual results:

On deleting some bookmarks they doesn't got deleted anymore so that I have made a deeper look into it. The PRAGMA integrity_check; statement returned errors like "row 290 missing from index moz_items_annos_itemattributeindex" which seems to point just to a damaged index.


Expected results:

1. If an error on any database appears (like in this case an entry could not be deleted) an integrity check could be done and reported to the user in case of errors.
2. It could be tried to automatically repair the database (in this case a REINDEX; statement should be enough).
Severity: normal → enhancement
Component: Untriaged → Bookmarks & History
we do this on idle already.
Status: UNCONFIRMED → RESOLVED
Closed: 6 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.