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?

[Swepilot]

Having the same issue when loading cached map tiles using flutter_map. I'm using a local sqlite database for other parts of the app. It only seems to happen when loading several map layers at the same time. A few map layers loaded at the same time does not produce this problem. Any ideas?

[aBuder]

I have the same problem with 100 images

[mhorizon]

I used database for other part of my app and have the same problem with images in list

[no-response[bot]]

This issue has been automatically closed because there has been no response to our request for more information from the original author. With only the information that is currently in the issue, we don't have enough information to take action. Please reach out if you have or find the answers we need so that we can investigate further.

[Saifallak]

@baseflow this should be reopened

[renefloor]

It would be great if anybody can give a reproducible example, because things that 'happen sometimes' are really hard to fix.

[andynvt]

any updates?

[MrVipinVijayan]

I am also facing this issue. App getting stuck.

[MrVipinVijayan]

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

[Nithinjovee]

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

this Error crash my app i have simple code , 1000+ images listview

[mustafa-707]

2024 still facing it cached_network_image: ^3.4.1

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

it looks the delete query in this package not doing it in transaction correctly