2 forum posts by user borrrden
Post: Use of unitialized variable in 3.32.1
(artifact: 45a4a60854 user: borrrden)
Note the use of
Post: Troubleshooting corrupt indexes
(artifact: 0ae020f9c9 user: borrrden)
Posting this on behalf of a colleague who "doggedly denies the existence of the new forum":
We've found a few database instances with index corruption, and I'm unsure how to troubleshoot it.
The symptom is SELECT queries failing with
The indexes aren't fancy. The one with the row-missing errors is simply
The other indexes are all of the form
I'm sure this custom function could conceivably cause this sort of error if it weren't properly deterministic, but it's been in use for a few years and pretty well tested, and I've never seen a bug with index corruption like this.
And I'm baffled how something as simple as the
We're using SQLite 3.28, statically linked into the app, on Android.