База данных Android комнаты заблокирована ⇐ Android

[Гость]

Я получал исключение «android.database.sqlite.SQLiteDatabaseLockedException» из рабочей среды.
Исключение произошло во время анализа ошибок. В базе данных моего проекта достаточно места. В проекте не используется многопроцессность. В помещении базы данных инкапсулированы транзакционные операции. Я не знаю, почему база данных заблокирована. Надеюсь на вашу помощь, спасибо!

Код: Выделить всё

this is exception

Process Name: 'com.geek.jk.weather'
Thread Name: 'kotlinx.coroutines.scheduling.CoroutineScheduler$Worker#DefaultDispatcher-worker-2'
Back traces starts.
android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5)
at android.database.sqlite.SQLiteConnection.nativeExecute(Native Method)
at android.database.sqlite.SQLiteConnection.execute(SQLiteConnection.java:553)
at android.database.sqlite.SQLiteSession.beginTransactionUnchecked(SQLiteSession.java:323)
at android.database.sqlite.SQLiteSession.beginTransaction(SQLiteSession.java:298)
at android.database.sqlite.SQLiteDatabase.beginTransaction(SQLiteDatabase.java:505)
at android.database.sqlite.SQLiteDatabase.beginTransaction(SQLiteDatabase.java:416)
at androidx.sqlite.db.framework.FrameworkSQLiteDatabase.beginTransaction(FrameworkSQLiteDatabase.java:1)
at androidx.room.RoomDatabase.beginTransaction(RoomDatabase.java:4)
at com.xiaoniu.unitionadbase.collie.dao.EventTrackDao_Impl$3.call(EventTrackDao_Impl.java:2)
at com.xiaoniu.unitionadbase.collie.dao.EventTrackDao_Impl$3.call(EventTrackDao_Impl.java:1)
at androidx.room.CoroutinesRoom$Companion$execute$2.invokeSuspend(CoroutinesRoom.kt:2)
at Rza.resumeWith(ContinuationImpl.kt:3)
at WIa.run(DispatchedTask.kt:18)
at androidx.room.TransactionExecutor$1.run(TransactionExecutor.java:1)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1113)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:588)
at java.lang.Thread.run(Thread.java:818)
Back traces ends.

база данных

Код: Выделить всё

@Database(entities = [CommonTrack::class, EventTrack::class], version = 1)
abstract class TrackDatabase : RoomDatabase() {
abstract fun CommonTrackDao(): CommonTrackDao
abstract fun EventTrackDao(): EventTrackDao

companion object {

private var instance: TrackDatabase? = null

fun getInstance(context: Context): TrackDatabase {
return instance ?: instance ?: buildDatabase(context).also { instance = it }

}

fun buildDatabase(context: Context): TrackDatabase {
if (instance == null) {
instance = Room.databaseBuilder(
context.applicationContext,
TrackDatabase::class.java,
"event_track.db"
).allowMainThreadQueries().build()

}
return instance as TrackDatabase
}
}

Использование базы данных

Код: Выделить всё

@Dao
abstract class EventTrackDao {

@Query("select * from event_table limit 50 ")
abstract suspend fun getEventTack():List

@Query("select count(*) from event_table")
abstract suspend fun getEventCounts():Int

@Insert(onConflict = OnConflictStrategy.REPLACE)
abstract suspend fun insertEventTrack(events: List):List

@Insert(onConflict = OnConflictStrategy.REPLACE)
abstract suspend fun insertEventTrack(event:EventTrack):Long

@Delete
abstract suspend  fun removeEvent(events: List)

Код: Выделить всё

val call=  TrackDatabase.getInstance(context).EventTrackDao().insertEventTrack(eventslist)

GlobalScope.launch(Dispatchers.IO) {
runCatching {
val
list=TrackDatabase.getInstance(context).EventTrackDao().getEventCounts()

}.onFailure {t ->

}
}

EventTrackDao_Impl

Код: Выделить всё

public final class EventTrackDao_Impl extends EventTrackDao {
private final RoomDatabase __db;

private final EntityInsertionAdapter __insertionAdapterOfEventTrack;

private final EntityDeletionOrUpdateAdapter  __deletionAdapterOfEventTrack;

public EventTrackDao_Impl(RoomDatabase __db) {
this.__db = __db;
this.__insertionAdapterOfEventTrack = new EntityInsertionAdapter(__db) {
@Override
public String createQuery() {
return "INSERT OR REPLACE INTO `event_table` (`event_param`,`ts`) VALUES (?,?)";
}

@Override
public void bind(SupportSQLiteStatement stmt, EventTrack value) {
if (value.getParam() == null) {
stmt.bindNull(1);
} else {
stmt.bindString(1, value.getParam());
}
stmt.bindLong(2, value.getTs());
}
};
this.__deletionAdapterOfEventTrack = new EntityDeletionOrUpdateAdapter(__db) {
@Override
public String createQuery() {
return "DELETE FROM `event_table` WHERE `event_param` = ?";
}

@Override
public void bind(SupportSQLiteStatement stmt, EventTrack value) {
if (value.getParam() == null) {
stmt.bindNull(1);
} else {
stmt.bindString(1, value.getParam());
}
}
};

}
}

Подробнее здесь: https://stackoverflow.com/questions/658 ... -is-locked