[Crash] Corrupt data in SQLite/Core Data – Unresolved error Error Domain=NSSQLiteErrorDomain Code=11

[joshheald]

Description

We have a number of crash logs spiking in Sentry over the last few releases.

They appear to all be related to Code 11 SQLite database errors, which indicate data corruption.

Suggested remedy so far:

• Try @pmusolino‘s Core Data improvement PR: Enhance Thread Safety in Core Data Management #12805
• Try rebuilding the database when we find corrupt data. This might need to be a project, or at least some time carved out for one or more engineers to focus on getting it right. Probably requires further investigation to find out which.
• Have each team take a close look at their contributions to 19.7, 19.8 and 20.0 releases, to see whether anything might have increased the crash rates here that I’ve missed.

See this CUW post for full context: peaMlT-Rx-p2

[dangermattic]

🚫 Please add a type label (e.g. type: enhancement) and a feature label (e.g. feature: stats) to this issue.

[sentry-io]

Sentry Issue: WOOCOMMERCE-IOS-1MTX

[sentry-io]

Sentry Issue: WOOCOMMERCE-IOS-1MTQ

[sentry-io]

Sentry Issue: WOOCOMMERCE-IOS-1NNC

[sentry-io]

Sentry Issue: WOOCOMMERCE-IOS-1NMZ