Invalid NS_ERROR_FILE_CORRUPTED error during large transaction (w/testcase)

RESOLVED WONTFIX

Status

()

--
major
RESOLVED WONTFIX
11 years ago
10 years ago

People

(Reporter: dan-bugzilla, Unassigned)

Tracking

1.8 Branch
Points:
---

Firefox Tracking Flags

(Not tracked)

Details

Attachments

(1 attachment)

1.74 KB, application/x-xpinstall
Details
(Reporter)

Description

11 years ago
User-Agent:       Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
Build Identifier: Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6

Database corruption error testcase at shaver's and mfinkle's request in #extdev.

The database passes PRAGMA integrity_check. This particular testcase does not actually corrupt the database, but we've seen that happening as well--will try to come up with a simple testcase for that.

A dump and restore of the database, a VACUUM, or the deletion of tables causes the test to pass.

Reproducible: Always

Steps to Reproduce:
1. Install corruptdb.xpi (attached)
2. Download http://www.zotero.org/download/bugzilla/db.sqlite.zip and extract db.sqlite to %PROFILE_DIR%/extensions/corruptdb@zotero.org/
3. Load chrome://corruptdb/content/corrupt.xul
Actual Results:  
executeSimpleSQL fails with an NS_ERROR_FILE_CORRUPTED error, and a "fail" message appears.

Expected Results:  
SQL transaction should complete successfully, and a "pass" message should appear.

Reproduced on OS X and Windows XP. Does not happen in 3.0a7 (though rather problematic for our users in 2.0.0.6).

Sorry for the DB size. This is a database from a user, with unnecessary tables removed and most remaining data replaced with gibberish strings.
(Reporter)

Comment 1

11 years ago
Created attachment 277977 [details]
Test Case Extension
(Reporter)

Updated

11 years ago
Version: unspecified → 1.8 Branch
hrm, we have an older version of sqlite on branch...
(Reporter)

Comment 3

11 years ago
For what it's worth, I just tried the command-line client for SQLite 3.3.4 (which, as far as I can tell, is the version in 2.0.0.6) and the same transaction works fine.
I'm sorry to say that we won't be fixing this on branch (for Firefox 2.0).  The good news is that Firefox 3.0 is using a much newer version of SQLite (version 3.5.9), so you shouldn't see this in Firefox 3.  Sorry this doesn't work for Firefox 2.0.
Status: UNCONFIRMED → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.