766489 - IndexedDB: can't reopen an existing database after firefox restart

Status: RESOLVED DUPLICATE of bug 774250

(Firefox :: Untriaged, defect)

Description

[Maxime RETY]

User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.54 Safari/536.5

Steps to reproduce:

My company developped a js application relying on persistent storage (3 indexedDB databases).

It is used every day by thousands of customers, 1500 of whom are on Firefox 12 and 13.

Among them, between 50 and 100 people experience an issue where :
  - the app is working fine the very first time it is loaded (creating the 3 indexedDB databases)
  - after refreshing the page (F5) several times, the app is still working fine (reusing the 3 indexedDB databases)
  - but after restarting the browser, at least one of the indexedDB databases can't be reopened.


Actual results:

Nevermind how many times we restart the browser or reload the page now, trying to reopen the database will raise an exception with errorCode 1 (unknown error).

With a remote control tool, I tried to gather clues to track down the issue, but I did not spot anything unusual.
The issue is still occurring when using a new Firefox profile or after Firefox re-install (versions 12 and 13).
After clearing storage in Page Info, the app works fine again, until Firefox is restarted.

Unfortunately, I did not manage to reproduce this issue on any computer I have direct access to (Win XP/7, MacOS 10.6/10.7). But every day some of our customers encounter this issue, and we're not able to help them.


Expected results:

Can anyone point me in the right direction in finding what's causing the breakage ?

Thanks in advance.

Comment 1

[Maxime RETY]

We still see this issue every day on Firefox 12 -> 16.

We tried serveral debug builds of Firefox on the computer of one of our customers.

Here is what we've seen when trying to re-open an indexedDB database after Firefox restart :

With 2012-07-11-mozilla-central-debug :

WARNING: NS_ENSURE_TRUE(rc == SQLITE_OK) failed: file e:/builds/moz2_slave/m-cen-w32-dbg/build/storage/src/mozStorageService.cpp, line 925
WARNING: NS_ENSURE_SUCCESS(rv, rv) failed with result 0x80520015: file e:/builds/moz2_slave/m-cen-w32-dbg/build/dom/indexedDB/IndexedDatabaseManager.cpp, line 881
WARNING: NS_ENSURE_SUCCESS(rv, ((nsresult) (((PRUint32)(1) <<31) | ((PRUint32)(33+0x45)<<16) | ((PRUint32)(1))))) failed with result 0x80520015: file e:/builds/moz2_slave/m-cen-w32-dbg/build/dom/indexedDB/OpenDatabaseHelper.cpp, line 1613

With 2012-07-11-mozilla-beta-debug :

WARNING: NS_ENSURE_TRUE(rc == SQLITE_OK) failed: file e:/builds/moz2_slave/m-beta-w32-dbg/build/storage/src/mozStorageService.cpp, line 924
WARNING: NS_ENSURE_SUCCESS(rv, rv) failed with result 0x80520015: file e:/builds/moz2_slave/m-beta-w32-dbg/build/dom/indexedDB/IndexedDatabaseManager.cpp, line 767
WARNING: NS_ENSURE_SUCCESS(rv, ((nsresult) (((PRUint32)(1) <<31) | ((PRUint32)(33+0x45)<<16) | ((PRUint32)(1))))) failed with result 0x80520015: file e:/builds/moz2_slave/m-beta-w32-dbg/build/dom/indexedDB/OpenDatabaseHelper.cpp, line 1627


The result "0x80520015" suggests a NS_ERROR_FILE_ACCESS_DENIED.

This error comes from the "sqlite3_quota_file" function in "db/sqlite3/src/test_quota.c".

I'm not sure of what's causing this error yet...

Comment 2

[Eric Abouaf]

Hi,

I had the same problem. 

I found out that the Firefox call to sqlite3_quota_file does not pass the filename in UTF8, which causes this error when you have accents in the file path.

Cf: https://bugzilla.mozilla.org/show_bug.cgi?id=774250

Comment 3

[Maxime RETY]

Eric to the rescue!

I confirm that the customers seeing this issue have UTF-8 chars in the path of their profile folder (the Windows user name defaults to "Propriétaire" in France).

I hope it can be fixed soon.

Comment 4

[Kyle Huey (Exited; not receiving bugmail, old account, do not use)]

Hi Maxime,

Can you retest your application in an appropriate version of Firefox now that Bug 774250 is fixed?

Comment 5

[Maxime RETY]

Hi Kyle,

I confirm that my application can successfully reopen a database after a browser restart, when using Aurora 17.0a2 (2012-09-24) or the latest Nightly build.

It's still broken on the latest beta though.

I thought that the patch had landed on the beta, hadn't it yet ?

Comment 6

[Kyle Huey (Exited; not receiving bugmail, old account, do not use)]

Beta 4 is from before I landed that patch.  I think we'll be shipping a beta 5 this week that should have the patch.

Thanks for testing this!

Comment 7

[Maxime RETY]

Great news, I'm looking forward to trying the next beta.

Thanks for the fix!