Baseflow / Baseflow/flutter_cache_manager

Getting a DatabaseException on startup: (database is locked (code 5 SQLITE_BUSY[5]))

Abierto
#429 2 comentarios 1 reacción 0 asignados Ver en GitHub
Lenguaje dominante
Dart
Estrellas
809
Forks
510
Merge medio
6 min
PR fusionados (30 d)
1

Descripción

## 🐛 Bug Report

Hi, I'm having a DatabaseException on the application's first load, when it tries to setup the database for the cache. The cache stays unusable for this first load, but the second time the application is opened it can work this out and then it will continue working every time.

This is a logcat output from Android:

```
09-05 16:18:26.154 19280 19371 I flutter : error DatabaseException(database is locked (code 5 SQLITE_BUSY[5])) sql 'BEGIN EXCLUSIVE' args [] during open, closing...
09-05 16:18:26.165 19280 19371 E flutter : [ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: DatabaseException(database is locked (code 5 SQLITE_BUSY[5])) sql 'BEGIN EXCLUSIVE' args []
09-05 16:18:26.165 19280 19371 E flutter : #0 wrapDatabaseException (package:sqflite/src/exception_impl.dart:11)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #1 SqfliteDatabaseMixin.txnSynchronized (package:sqflite_common/src/database_mixin.dart:465)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #2 SqfliteDatabaseMixinExt.txnBeginTransaction (package:sqflite_common/src/database_mixin.dart:353)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #3 SqfliteDatabaseMixin.beginTransaction (package:sqflite_common/src/database_mixin.dart:719)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #4 SqfliteDatabaseMixinExt._txnTransaction (package:sqflite_common/src/database_mixin.dart:330)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #5 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:33)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #6 SqfliteDatabaseMixin.txnSynchronized (package:sqflite_common/src/database_mixin.dart:490)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #7 SqfliteDatabaseMixin.doOpen (package:sqflite_common/src/database_mixin.dart:939)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #8 SqfliteDatabaseOpenHelper.openDatabase (package:sqflite_common/src/database.dart:46)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #9 SqfliteDatabaseFactoryMixin.openDatabase. (package:sqflite_common/src/factory_mixin.dart:110)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #10 ReentrantLock.synchronized. (package:synchronized/src/reentrant_lock.dart:37)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #11 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:33)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #12 CacheObjectProvider.open (package:flutter_cache_manager/src/storage/cache_info_repositories/cache_object_provider.dart:30)
09-05 16:18:26.165 19280 19371 E flutter :
09-05 16:18:26.165 19280 19371 E flutter : #13 CacheStore._getCacheDataFromDatabase (package:flutter_cache_manager/src/cache_store.dart:112)
09-05 16:18:26.165 19280 19371 E flutter :
```

At the moment I only tried this on Android, and I'm using version 3.3.1.

My first guess is that some other library may be using Sqlite at the same time, or some other thing like that, but anyways that doesn't seems to be a good reason to crash. Is this issue known?

Thank you

Guía de contribución

Abrir la guía de contribución

Línea de trabajo

Reproduce el fallo de la primera carga en Android con la versión 3.3.1 y, después, parte de CacheObjectProvider.open en package:flutter_cache_manager/src/storage/cache_info_repositories/cache_object_provider.dart y de CacheStore._getCacheDataFromDatabase en cache_store.dart. Sigue la ruta de BEGIN EXCLUSIVE a través de sqflite y determina por qué la base de datos de caché está bloqueada durante el inicio; se considera completado cuando la primera carga abre la caché sin una excepción SQLITE_BUSY no controlada.

Escrito por el modelo de indexación a partir del texto del issue.

Evaluación

Stack tecnológico
dart, flutter, sqlite
Área
databases, mobile-dev
Tipo de issue
Error
Dificultad
3/5
Tiempo estimado
1-2 días
Estado de actividad
Estancado
Claridad
Necesita aclaración
Aptitud para principiantes
35/100

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.