android.database.sqlite.SQLiteReadOnlyDatabaseException:

Open

#1,330 opened on Feb 29, 2020 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language: Java
Stars: 11.1k
Forks: 2.2k
PR merge metrics: No merged PRs in 30d

Description

android.database.sqlite.SQLiteReadOnlyDatabaseException:
at android.database.sqlite.SQLiteConnection.nativeExecuteForChangedRowCount (SQLiteConnection.java)
at android.database.sqlite.SQLiteConnection.executeForChangedRowCount (SQLiteConnection.java:962)
at android.database.sqlite.SQLiteSession.executeForChangedRowCount (SQLiteSession.java:754)
at android.database.sqlite.SQLiteStatement.executeUpdateDelete (SQLiteStatement.java:64)
at android.database.sqlite.SQLiteDatabase.executeSql (SQLiteDatabase.java:2228)
at android.database.sqlite.SQLiteDatabase.execSQL (SQLiteDatabase.java:2155)
at com.liulishuo.filedownloader.database.SqliteDatabaseImpl.removeConnections (SqliteDatabaseImpl.java:120)
at com.liulishuo.filedownloader.database.RemitDatabase.syncCacheToDB (RemitDatabase.java:102)
at com.liulishuo.filedownloader.database.RemitDatabase.access$200 (RemitDatabase.java:39)
at com.liulishuo.filedownloader.database.RemitDatabase$1.handleMessage (RemitDatabase.java:76)
at android.os.Handler.dispatchMessage (Handler.java:102)
at android.os.Looper.loop (Looper.java:216)
at android.os.HandlerThread.run (HandlerThread.java:65)

Filedownloader version: 1.7.4
Test Device: Samsung Galaxy M30s (m30s), Android 9
This error is reported on Android 9 & !0

Contributor guide

No contributing guide indexed for this repository

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Research direction

Start by tracing removeConnections in SqliteDatabaseImpl.java and syncCacheToDB in RemitDatabase.java, where the reported read-only exception occurs. Reproduce the failure with FileDownloader 1.7.4 on the reported Android devices, then identify and validate a fix so this database operation no longer fails under those conditions.

Written by the indexing model from the issue text.

Assessment

Tech stack: android, java
Domain: database, mobile-dev
Issue type: Bug
Difficulty: 4/5
Estimated time: 3-5 days
Activity status: Stale
Clarity: Needs clarification
Newbie friendliness: 25/100