Can't Repro
Status Update
Comments
el...@google.com <el...@google.com> #2
[Empty comment from Monorail migration]
[Monorail components: -Platform>DevTools Blink>CSS]
[Monorail components: -Platform>DevTools Blink>CSS]
Description
Version used:2.4.0-2.5.0
Devices/Android versions reproduced on: android8.0
If this is a bug in the library, we would appreciate if you could attach:
- Sample project to trigger the issue.
- A screenrecord or screenshots showing the issue (if UI related).
Hello, we are a company that manufactures smart home products. We encountered a problem when using the room database component on a smart home central control screen product, and tried to locate the problem but could not locate the problem. in the process of restarting. Our product has a scenario of frequent writing to the database, and the number of entries is mostly, and it also involves multi-table joint operations.
The following is the error log when the problem occurs:
database corruption at line 60977 of [553a923c82]
statement aborts at 3: (SELET + FROW d ictionary lERE tictype? and parent wide? order by dic orderl database disk inage is nalformed
database disk image is malformed
At the same time, I also uploaded the log in the attachment. Although the log is sometimes different, it is basically similar.
We tried to upgrade the room database to solve this problem, but it didn’t solve it. Our main suspicion now is the problem of the room synchronization mechanism. When the device is powered off and restarted, the data in the memory is incomplete, and the database is damaged when it is written locally. , Is there any such problem in the room itself, or is there a problem with our usage scenario? If there is a problem with our usage scenario, can you provide us with a good idea to avoid the risk point of this problem.
thanks