I confirmed upon restore the sqlite file exists but sqlite-wal does not - it won’t open without that file. Correct. For context, WAL stands for Write-Ahead Logging and is part of the architecture sqlite uses to maintain data integrity. I guess/suspect that it's not be backed up because, assuming the database is being properly managed, it should generally be empty anytime it would have been backed up (because the contents were merged into the file at close/suspend). You can read more about it here: https://www.sqlite.org/wal.html But the critical point is: ...Beginning with version 3.22.0 (2018-01-22), a read-only WAL-mode database file can be opened if the -shm and -wal files already exist or those files can be created or the database is immutable. SO, basically, yes, what you're seeing is expected behavior. Shifting to the workaround side, I would to three things: (1) Implement a fallback there's a problem, open the app UI. It's likely that you've identified the primary (possibly only) issue here, but I'm a
Topic:
App & System Services
SubTopic:
iCloud & Data
Tags: