790922 - android.database.sqlite.SQLiteDatabaseLockedException: database is locked: retrycount exceeded at android.database.sqlite.SQLiteQuery.nativeFillWindow(Native Method) on ICS

Status: RESOLVED WONTFIX

(Firefox for Android Graveyard :: General, defect)

Description

[Scoobidiver (away)]

There are 276 crashes across channels over the last four week, including bp-07bfd2c8-0672-4526-9d09-d2e242120913.
It's #260 top crasher in 15.0.1.

The first frames of the Java stack trace are:
android.database.sqlite.SQLiteDatabaseLockedException: database is locked: retrycount exceeded
	at android.database.sqlite.SQLiteQuery.nativeFillWindow(Native Method)
	at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:86)
	at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:164)
	at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:156)
	at android.content.ContentResolver.query(ContentResolver.java:317)

More reports at:
https://crash-stats.mozilla.com/report/list?signature=android.database.sqlite.SQLiteDatabaseLockedException%3A+database+is+locked%3A+retrycount+exceeded+at+android.database.sqlite.SQLiteQuery.nativeFillWindow%28Native+Method%29

Comment 1

[Chris Peterson [:cpeterson]]

lucasr, could this be related to the locked SQLite database problems you had to workaround months ago? The Bookmarks DB is locked.

Here is the rest of the stack trace:

android.database.sqlite.SQLiteDatabaseLockedException: database is locked: retrycount exceeded
at android.database.sqlite.SQLiteQuery.nativeFillWindow(Native Method)
at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:86)
at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:164)
at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:156)
at android.content.ContentResolver.query(ContentResolver.java:317)
at org.mozilla.gecko.db.LocalBrowserDB.isBookmark(LocalBrowserDB.java:402)
at org.mozilla.gecko.db.BrowserDB.isBookmark(BrowserDB.java:142)
at org.mozilla.gecko.Tab$6.doInBackground(Tab.java:385)
at org.mozilla.gecko.Tab$6.doInBackground(Tab.java:381)
at org.mozilla.gecko.util.GeckoAsyncTask$BackgroundTaskRunnable.run(GeckoAsyncTask.java:34)
at android.os.Handler.handleCallback(Handler.java:605)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:137)
at org.mozilla.gecko.util.GeckoBackgroundThread.run(GeckoBackgroundThread.java:31)

Comment 2

[Scoobidiver (away)]

(In reply to Chris Peterson (:cpeterson) from comment #1)
> Here is the rest of the stack trace:
If I didn't provide the full stack trace, it's because they are various. It can be:
android.database.sqlite.SQLiteDatabaseLockedException: database is locked: retrycount exceeded
	at android.database.sqlite.SQLiteQuery.nativeFillWindow(Native Method)
	at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:86)
	at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:164)
	at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:156)
	at android.content.ContentResolver.query(ContentResolver.java:318)
	at org.mozilla.gecko.db.LocalBrowserDB.filterAllSites(LocalBrowserDB.java:166)
	at org.mozilla.gecko.db.LocalBrowserDB.getTopSites(LocalBrowserDB.java:190)
	at org.mozilla.gecko.db.BrowserDB.getTopSites(BrowserDB.java:101)
	at org.mozilla.gecko.AboutHomeContent.loadTopSites(AboutHomeContent.java:257)
	at org.mozilla.gecko.AboutHomeContent.access$400(AboutHomeContent.java:59)
	at org.mozilla.gecko.AboutHomeContent$9.run(AboutHomeContent.java:288)
	at android.os.Handler.handleCallback(Handler.java:605)
	at android.os.Handler.dispatchMessage(Handler.java:92)
	at android.os.Looper.loop(Looper.java:137)
	at org.mozilla.gecko.util.GeckoBackgroundThread.run(GeckoBackgroundThread.java:31)

android.database.sqlite.SQLiteDatabaseLockedException: database is locked: retrycount exceeded
	at android.database.sqlite.SQLiteQuery.nativeFillWindow(Native Method)
	at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:86)
	at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:164)
	at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:156)
	at android.content.ContentResolver.query(ContentResolver.java:318)
	at org.mozilla.gecko.db.LocalBrowserDB.getUrlForKeyword(LocalBrowserDB.java:437)
	at org.mozilla.gecko.db.BrowserDB.getUrlForKeyword(BrowserDB.java:140)
	at org.mozilla.gecko.AwesomeBar.openUserEnteredAndFinish(AwesomeBar.java:361)
	at org.mozilla.gecko.AwesomeBar.access$300(AwesomeBar.java:50)
	at org.mozilla.gecko.AwesomeBar$5.onKey(AwesomeBar.java:197)
	at android.view.View.dispatchKeyEvent(View.java:5549)
	at android.view.ViewGroup.dispatchKeyEvent(ViewGroup.java:1246)

and so on.

Comment 3

[Chris Peterson [:cpeterson]]

oh, I didn't realize there was more than one database affected.

Lucas, do all these databases share the same SQLite file? Are these queries all contending for the same file?

Comment 4

[Naoki Hirata :nhirata (please use needinfo instead of cc)]

Still seeing this bug in 21 and down.  

I don't see this in 22 as of yet.  I think bug 843005 was patched to fix REL 11 and higher. and was pushed 4/09.  Is that correct?

There are crashes from 4/12 build : 
ex. https://crash-stats.mozilla.com/report/index/94c6fd56-4a71-4845-bb0f-45ead2130415 which show a REL of 15.

Comment 5

[Robert Kaiser]

It looks like in the last few days (since Apr 11), some volume of crashes have shifted from bug 752828 over to this one - across different releases, at least 20 and above.

Comment 6

[Robert Kaiser]

This signature has scooped up between half and all of the decline of bug 752828 since the release of 20.0.1 and 21.0b2, apparently.

Comment 7

[Scoobidiver (away)]

It's #8 top crasher in 21.0 and #55 in 22.0a2.

It seems to happen a lot on Sony ST21.

More reports at:
https://crash-stats.mozilla.com/report/list?signature=android.database.sqlite.SQLiteDatabaseLockedException%3A+database+is+locked%3A+retrycount+exceeded%3A+at+android.database.sqlite.SQLiteQuery.nativeFillWindow%28Native+Method%29

Comment 8

[Scoobidiver (away)]

It's #32 crasher in 22.0 and #86 in 23.0b1 so no longer a top crash.

Comment 9

[Robert Kaiser]

Interestingly, it looks like all those crashes have API level 15 and ARMv7, on all kinds of devices though, see the android devices split on the signature summary tab of https://crash-stats.mozilla.com/report/list?signature=android.database.sqlite.SQLiteDatabaseLockedException%3A%20database%20is%20locked%3A%20retrycount%20exceeded%20at%20android.database.sqlite.SQLiteQuery.nativeFillWindow%28Native%20Method%29

Comment 10

[BugBot [:suhaib / :marco/ :calixte]]

Closing because no crashes reported for 12 weeks.

Comment 11

[BugBot [:suhaib / :marco/ :calixte]]

Closing because no crashes reported for 12 weeks.