database locked

[yayxs]

Warning database has been locked for 0：00：10.000000. Make sure you always use the transaction object for database operations during a trasection

[renefloor]

Can you reproduce this?

[Saifallak]

getting alot of this warning

I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction

i think it's happening when opening a page with alots of cached images

[davidmartos96]

I started to notice this as well when loading some cached images.
I am not able to reproduce it constantly, but my app has like 10 cached images in the home page, and it seems to lock when some days have passed after opening my deployed app, so it may be something regarding the loading of old / invalid images from the cache.

[zinwalin]

getting alot of this warning

I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
I/flutter ( 9137): Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction

i think it's happening when opening a page with alots of cached images

same here.

[renefloor]

Are you also use a database for other parts of your app?

[zinwalin]

Are you also use a database for other parts of your app?

It happens only in pages which used cached_network_image.

[renefloor]

Are you also use a database for other parts of your app?

It happens only in pages which used cached_network_image.

I understand, but that was not my question. I'm just trying to understand what is going wrong.

My question was if you use a database in other parts of your app. Do you use sqflite or anything similar that is also calling a database?

[hooshyar]

Hello, I have the same problem, I'm not using any kind of database yet, only API requests.

[hooshyar]

When I load for example 3-4 images, there isn't a problem, but when image count rises the error appears and screen locks, I can guess that writing more than 4-5 large files to the Database without using transactions, causes this.

[ariefwijaya]

I have the same problem here,

06-19 02:50:20.815 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:20.922 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:20.930 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:21.020 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:21.048 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:21.237 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:21.582 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:21.610 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:22.081 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:22.082 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:22.082 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction
06-19 02:50:22.082 29857-30011/com.tcel.musicatl I/flutter: Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction

[imran-samed]

Any solution for this ??
I'm also facing same issue.

I have 300+ images in ListView

[jim-blip]

I have the same problem.

• Listview with around 100 images I need to cache.
• I am not using a local database anywhere else in this app (not knowingly).

Is there a workaround available?