| Summary: | Having digiKam open for extended periods of time (12+hrs) the images will fail to load and thumbnails turn to the generic (universal) "image" icon | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | David <ticedoff8> |
| Component: | Database-Mysql | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | REPORTED --- | ||
| Severity: | normal | CC: | andreas.brockhinke, caulier.gilles, metzpinguin, sendtoworthington |
| Priority: | NOR | ||
| Version First Reported In: | 8.6.0 | ||
| Target Milestone: | --- | ||
| Platform: | Microsoft Windows | ||
| OS: | Microsoft Windows | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
|
Description
David
2025-04-15 19:58:00 UTC
MySQL servers have an interactive timeout and a wait timeout. The default value is 28800 seconds, which is 8 hours, after which the database connection is closed. So digiKam might need to use a timer to trigger a dummy query to the database server every hour. Maik If this is the case, and restarting digiKam is enough to instantly wake up the MariaDB, couldn't the better solution be to add something to the code that will overcome a comatose MySQL server (besides kicking it once an hour) or network interruptions? I'll do some research on the MariaDB to see if there is an interactive timeout and/or a wait timeout and if they are adjustable. I've also had this happen when doing digiKam operations that take days to complete (Auto-tag Scan is the latest). I can see activity on the phpMyAdmin "Status", btop shows system activity on the server. But at some point, the [Failed to load image] is displayed and not an image when I select it.. Update: I checked the descriptions for interactive timeout and a wait timeout. They are related to individual transactions, not the database as a whole. "MariaDB has always had the wait_timeout and interactive_timeout settings, which close connections after a certain period of inactivity." https://mariadb.com/kb/en/transaction-timeouts/ If a new transaction is attempted by the client, it should connect with no problems. Also, today I had this issue crop up in real time - as I was using digiKam I was looking at an album in a collection and was double-clicking on a preview to open it in the expanded view and everything was working fine. After scrolling through some previews and opening and closing them, I picked one to be the Album Thumbnail. The next time I tried to open a preview image to the expanded view, the <Fail to load image> error showed up. From that point on, the only "fix" was to restart digiKam. And it starts working again. I'm also running btop on the MariaDB server and watching activity. Everything looks normal until it isn't. At that point, btop shows no more incoming connections from the client I am using. After I restart the digKam app on the PC, I see normal activity on the MariaDB server. *** Bug 503892 has been marked as a duplicate of this bug. *** *** Bug 504250 has been marked as a duplicate of this bug. *** Just a note to all you guys tracking and fixing digiKam bugs (with thanks for your great work!): The "weird" behavior persists in the current version 8.7.0. After digiKam runs for a longer time (> 12h), the tag list is empty regardless of which image I select. Additionally, there are erratic side effects to other programs (menus that vanish, etc.). When re-starting, everything is back to normal for digiKam (but not for other programs that suffered side effects). Behaviour occured on two different machines (both with Windows 11, MariaDB 11.6.2) and fairly large image collections (> 400 k images, 20.000 tags) and therefore seems not to be related to hardware or third-party software issues. Remark: I reported this bug on 2025-05-17 as #504250 which has been marked as a duplicate of the bug reported in this thread. |