When attempting to load a SQLite database including a WAL file, the database itself loads with success, but the WAL is stuck in "loading..." state (text appearing next to filename in left pane).
I have observed this issue in 3 out of 4 tested databases.
Reviewing the log especially for the ones with observed issues, many lines appear with these messages: "Could not read record<JAVA class name>"
For example
Could not read recordjava.nio.BufferUnderflowExceptionCould not read recordjava.lang.IllegalArgumentException: newPosition > limit: (4436 > 4096) (4436 just an example but real value observed, could also be 4208, 5808, etc.)
The databases with issues were significantly larger in filesize than the one without issue.
| SQLite database filename |
Filesize |
Filesize WAL |
| scdb-27.sqlite |
41.712 KB |
3.561 KB |
| gallery.encrypteddb.decrypted |
13.532 KB |
1.483 KB |
| Photos.sqlite |
824.156 KB |
17 KB |
(Note stuck loading Photos.sqlite both main DB + WAL file - perhaps I am not patient enough... waiting "only" an hour or so...)
When attempting to load a SQLite database including a WAL file, the database itself loads with success, but the WAL is stuck in "loading..." state (text appearing next to filename in left pane).
I have observed this issue in 3 out of 4 tested databases.
Reviewing the log especially for the ones with observed issues, many lines appear with these messages:
"Could not read record<JAVA class name>"For example
Could not read recordjava.nio.BufferUnderflowExceptionCould not read recordjava.lang.IllegalArgumentException: newPosition > limit: (4436 > 4096)(4436 just an example but real value observed, could also be 4208, 5808, etc.)The databases with issues were significantly larger in filesize than the one without issue.
(Note stuck loading
Photos.sqliteboth main DB + WAL file - perhaps I am not patient enough... waiting "only" an hour or so...)