<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#ffffff">
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??)<br>
<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
Regards,<br>
Andrej<br>
<br>
<div class="moz-cite-prefix">On 31/01/2024 16:36, Art Zemon wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAN+RJV7-zU3BWHhSDvz99Kszg9wY0n6hU+Ry2BmvhkViXg8M4g@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">Andrej,</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">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.</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">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. </div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">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.</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">
-- Art Z.</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Jan 31, 2024 at
1:57 AM Andrej Valencic <<a
href="mailto:andrej.valencic@zoho.com"
moz-do-not-send="true" class="moz-txt-link-freetext">andrej.valencic@zoho.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Lately
I found this little annoyance when using digiKam 8.3.0<br>
<br>
I have a Win 11 PC with MariaDB 10.11.6 and DK - all on
system SSD disk. <br>
My two collections are on the other SSD disk in the same
machine.<br>
<br>
Usually I have DK open all the time in the background and
only switch to <br>
it when I need. So I found out that after (a very) long time
of no <br>
activity on the PC (like overnight when the PC goes to
sleep) when I <br>
come back and try to use DK again it doesn't see any
collection anymore. <br>
It just shows the initial screen with info about DK and no
albums are <br>
present - even if I go to settings there are no collections
visible. <br>
Then after I close and start DK again everything is back to
normal - all <br>
collections/albums are visible.<br>
<br>
I tried this again with debugging on and in the log I see
some failed <br>
connection to the database. Also in the Windows log there
are warnings <br>
about aborted connection to MariaDB:<br>
<br>
Level Date and Time Source Event ID Task
Category<br>
Warning 31/01/2024 08:02:37 MariaDB 100 None
"Aborted <br>
connection 26 to db: 'dk' user: 'digikam' host: 'localhost'
(Got timeout <br>
reading communication packets)<br>
<br>
I'm not sure if this is the problem but somebody might take
a look into <br>
this.<br>
<br>
P.S. The debug log is from the complete session: DK after
sleep and no <br>
collections and then after restart with everything working.<br>
<br>
Regards,<br>
Andrej</blockquote>
</div>
<br clear="all">
<div><br>
</div>
<span class="gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><font face="georgia, serif">My
blog: <a
href="https://CheerfulCurmudgeon.com/" target="_blank"
moz-do-not-send="true">CheerfulCurmudgeon.com</a></font></div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr"><i
style="color:rgb(34,34,34);font-family:georgia,serif"><span
style="color:rgb(0,0,0)"></span></i><i
style="color:rgb(34,34,34);font-family:georgia,serif"><span
style="color:rgb(0,0,0)">In a
place where there are no
humans, strive to be human.
[Pirkei Avot 2:5]</span></i></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>