Firefox endless crash after using a specific page (SQLLiteBlobTooBigException)

[SpraxDev]

Steps to reproduce

Can't test it myself as it endlessly crashes but I suspect:

1. Visit https://huggingface.co/spaces/akhaliq/Detic, a demo page for an AI model if I am not mistaken
2. Upload an image twice (in my case trying to upload a second one made it crash and never recover from it), not reloading a page

Expected behavior

When Firefox crashes to at least only mark the tab as broke or crashed

Actual behavior

• The whole app crashes and occasionally crashes while in the background (Firefox's auto crash reporter seems to work/run just fine)
• I can no longer open the App
• I can not click on URLs in other apps that would normally open Firefox (I don't see it crash or trying to open but it probably does?)
• Clearing the cache in Android settings doesn't help (clearing app data probably would but I'd like to avoid that)

I'd like to add the stack trace I can see in the Android Feedback/Bug report dialog but I cannot copy from it so here is a part of it I wrote down (Tell me if you need the whole thing, but maybe you can see my report in your dashboard already):

android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=11
  at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
  at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:1001)
//  ... # Getting tiered of android.database stuff
  at mozilla.components.feature.recentlyclosed.db.RecentlyClosedTabDao_Impl$4.call(RecentlyClosedTabDao_Impl.java:12)
  at androidx.room.CoroutinesRoom$Companion$createFlow$1$1.invokeSuspend(CoroutinesRoom.kt:8)
// ... # The following is kotlin coroutines androidx.room.TransactionExecutor and finally some java ThreadPoolExecutor worker

Device information

• Android device: OnePlus Nord (AC2003)

• Fenix version: ?

• SDK version: 30

• Android/Release version: 11

• Firefox app version: 96.2.0

edit: after writing down the stack trace from my phone, it should probably have been a bug report 😅

┆Issue is synchronized with this Jira Task

[mcarare]

The app on the link provided does not work anymore.
We should re-evaluate this after changes in Recently tabs are merged and the corresponding changes in Fenix are merged.

[grigoryk]

This should be fixed by mozilla-mobile/android-components#11688. We are now try/catching get/add interactions with the recently closed tabs storage, so any issues there won't resolve in a crash. We can monitor volume of these via RecentlyClosedTabsStorageException in Sentry.

Related - interactions with the file storage part of this is now off the startup path, so any IO issues encountered there won't result in a startup crash either.

Please re-open this if you're still having issues.

[SpraxDev]

I've received (at least) 2 Firefox updates via the Google Play Store and am still unable to open Firefox without crashing instantly.

I am on version 97.3.0 (package version is 2015866875). I found my error on crash-stats.mozilla.org.
Should the fix already be available in my version?

[SpraxDev]

Please re-open this if you're still having issues.

Sorry @grigoryk but can this be reopened? Or should I create a new ticket instead?

[FoxTrotte]

I am having this exact same issue.