digiKam lost collections after sleep/wakeup of PC

[Andrej Valencic]

Thanks for this info, I was expecting it to be connected to MariaDB 
somehow although (if I remember well) this was not happening with some 
earlier versions of DK (8.2 maybe??)

But then I found out that after this problem occurs and I don's see any 
albums/collections I can still see pictures (thumbnails) in all the 
other sections like Tags, Dates, Timeline. So it looks like there is 
some connection to the databases after all - as much as I know 
thumbnails are all stored in the database?! Of course I can not work on 
any photo because the collections are not available to DK unless I 
restart the program.

And I don't think this is due to MariaDB shutting down on sleep/suspend 
because the other program using the databases, namely HeidiSQL is still 
working OK after PC resumes from sleep - I can browse and see all the 
databases.

Anyway it's not a big deal, I only have to live with closing DK when not 
using it and the starting it again when needed.

Regards,
Andrej

On 31/01/2024 16:36, Art Zemon wrote:
> Andrej,
>
> I have a similar situation. I run digiKam + MariaDB on a Linux laptop. 
> I found that I could suspend/resume if the laptop was not suspended 
> too long, otherwise, digiKam stopped working. It turned out that the 
> actual problem was MariaDB, not digiKam. I think that when MariaDB 
> fails to write to the disk for too long, it assumes that there is a 
> serious problem and it stops running.
>
> The solution was to add a couple of scripts to my laptop. When the 
> laptop begins to suspend, it shuts down MariaDB. When it resumes, it 
> starts MariaDB.
>
> I do not keep digiKam running when I am not using it, especially 
> through suspend/resume cycles. I do not know how digiKam will behave 
> when the MariaDB server restarts.
>
> -- Art Z.
>
>
> On Wed, Jan 31, 2024 at 1:57 AM Andrej Valencic 
> <andrej.valencic at zoho.com> wrote:
>
>     Lately I found this little annoyance when using digiKam 8.3.0
>
>     I have a Win 11 PC with MariaDB 10.11.6 and DK - all on system SSD
>     disk.
>     My two collections are on the other SSD disk in the same machine.
>
>     Usually I have DK open all the time in the background and only
>     switch to
>     it when I need. So I found out that after (a very) long time of no
>     activity on the PC (like overnight when the PC goes to sleep) when I
>     come back and try to use DK again it doesn't see any collection
>     anymore.
>     It just shows the initial screen with info about DK and no albums are
>     present - even if I go to settings there are no collections visible.
>     Then after I close and start DK again everything is back to normal
>     - all
>     collections/albums are visible.
>
>     I tried this again with debugging on and in the log I see some failed
>     connection to the database. Also in the Windows log  there are
>     warnings
>     about aborted connection to MariaDB:
>
>     Level    Date and Time    Source    Event ID    Task Category
>     Warning    31/01/2024 08:02:37    MariaDB    100    None "Aborted
>     connection 26 to db: 'dk' user: 'digikam' host: 'localhost' (Got
>     timeout
>     reading communication packets)
>
>     I'm not sure if this is the problem but somebody might take a look
>     into
>     this.
>
>     P.S. The debug log is from the complete session: DK after sleep
>     and no
>     collections and then after restart with everything working.
>
>     Regards,
>     Andrej
>
>
>
> -- 
> My blog: CheerfulCurmudgeon.com <https://CheerfulCurmudgeon.com/>
> ///In a place where there are no humans, strive to be human. [Pirkei 
> Avot 2:5]/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20240202/f529be0e/attachment-0001.htm>