Bug 501251

Are you sure that the PC has not gone into standby mode or the NAS? It is known that this will interrupt the connection and digiKam is currently not reactivating this connection.

Maik

Yes, that's what I thought too. But I disabled power saving mode or sleep mode completely. Both devices ran through the night.
Could some software disconnect the connection after x hours of inactivity?

The linux kernel have some mechanism to shutdown the network socket when activity take a while. This can be the problem.

A paper explaining how to tune the socket keep alive settings on Linux kernel :

https://tldp.org/HOWTO/TCP-Keepalive-HOWTO/usingkeepalive.html

Also the TCP socket keep alive behavior depend of the OS:

https://forum.qt.io/topic/91397/what-does-qabstractsocket-keepaliveoption-actually-do/5?_=1741510336444&lang=en-US

The question is whether Synology does this too. It can be reached at any time using Quickconnect and Active Insight.
Hmm. To find out, I could run a debug all night.
The paper is too big for me. I don't work with Linux enough.

Look well in the paper there cat some cat to run in /proc to know the actual keep alive settings from the NAS. Under Windows it's another story...

The Windows keep alive settings is located in the registery database through this key :

\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\TCPIP\Parameters

Gilles

This reg entry is more for Windows servers so that the connection is terminated more quickly.
https://www.consic.de/de/einstellung-der-tcp-keepalive-zeit-fuer-windows-server

Could digikam ping the database every x minutes so that the connection remains active? Maybe also look for new entries in the albums after 1 hour of user inactivity?

Created attachment 179417 [details]
Output 20250315_093800

Hello,
Face scanning has been running for all photos for 10 hours. 15% is now complete. The connection to the database is stable. Now I wanted to confirm the faces found. The face tags in the photos have been deleted again. The entries in the database remain.
I've created an output. Three file names are at the beginning for the search so you can find the point more quickly.
There are errors there:
...."Lost connection to MySQL server during query" "2013" 2

Regards
Andy

Hi,

The 8.7.0 pre-release Windows installer from today have been rebuilt from
scratch with Qt 6.8.3, KDE 6.12, OpenCV 4.11 + CUDA support, Exiv2 0.28.5, ExifTool 13.27, ffmpeg 7, all image codecs updated to last version (jxl, avif, heif, aom, etc.).

Please try with this version to see if your problem still reproducible...

https://files.kde.org/digikam/

Thanks in advance
Best regards

Gilles Caulier

Created attachment 180268 [details]
20250414_222301 - Ausgabe

Hello Gilles,

The PC performed automatic face detection overnight.
This morning, I confirmed a few faces. But instead of adding new faces to the photo, all known markers were removed.
I've created an output. See photo "20230813_100218 - A6000.jpg"
Regards
Andy

Created attachment 180269 [details]
20250414_222301 - Bild1

And here

Andy

(In reply to Andy from comment #12)
> Created attachment 180268 [details]
> 20250414_222301 - Ausgabe
> 
> Hello Gilles,
> 
> The PC performed automatic face detection overnight.
> This morning, I confirmed a few faces. But instead of adding new faces to
> the photo, all known markers were removed.
> I've created an output. See photo "20230813_100218 - A6000.jpg"
> Regards
> Andy

Hi Andy, it looks like digiKam lost connection to the DB.  I see

> "SELECT imageid FROM ImageTagProperties LEFT JOIN Images ON Images.id=ImageTagProperties.imageid  WHERE tagid=? AND property=? AND >Images.status=1 LIMIT 1;" 
>Error messages: "QMYSQL: Der Befehl konnte nicht initialisiert werden" "Lost connection to MySQL server during query" "2013" 2 
>Bound values:  QList()
>digikam.dbengine: Failure executing query:

Over and over in the log file.  Maybe Gilles or Maik can give more information, but that doesn't look like normal operations.

Cheers,
Mike

Hi,

Has the database connection completely crashed?
Because I can still switch to other albums or other people in digiKam and the thumbnails load. 

Regards, Andy

Andy,

We need to know more about the infrastructure that you use. Network types, computers + OS, databases (local or remote), remote files (NAS or local), shared accounts, anti-virus, etc.

Best

Gilles Caulier

AMD Phenom II 1100T, ASUS M4A88T-V EVO, Windows 10 Pro 
AMD Ryzen™ 7 7800X3D, Prozessor, MSI B650 Board, Windows 10 Pro 
Synology NAS DS918+

1 6-Port Switch, 1GbE LAN-Ports
1 FritzBox 7490

Database: remote
MariaDB-Server: Synology / Docker

No shared accounts.
ESET NOD32 Antivirus on both Windows PCs
Windows Firewall

(In reply to Andy from comment #17)
> AMD Phenom II 1100T, ASUS M4A88T-V EVO, Windows 10 Pro 
> AMD Ryzen™ 7 7800X3D, Prozessor, MSI B650 Board, Windows 10 Pro 
> Synology NAS DS918+
> 
> 1 6-Port Switch, 1GbE LAN-Ports
> 1 FritzBox 7490
> 
> Database: remote
> MariaDB-Server: Synology / Docker
> 
> No shared accounts.
> ESET NOD32 Antivirus on both Windows PCs
> Windows Firewall

Hi Andy,
Is this still an issue?  I've tried and tried, but I can't reproduct the issue.

Cheers,
Mike

Hi Mike, 
I'll run digiKam again tonight. I think it might take 6-8 hours.

Regards
Andy

Created attachment 180714 [details]
20250427_221900

Hello Mike,
digiKam has been detecting new faces for about seven hours. I haven't touched the PC. Now I've confirmed two faces. But instead of adding them, all tags and contacts were deleted from the JPG metadata.
It seems as if only one module of the program is no longer working properly and can no longer access the database.
The JPGs are at the top of the output.
Unfortunately, I don't have a current debug version of digiKam.

Regards
Andy

(In reply to Andy from comment #20)
> Created attachment 180714 [details]
> 20250427_221900
> 
> Hello Mike,
> digiKam has been detecting new faces for about seven hours. I haven't
> touched the PC. Now I've confirmed two faces. But instead of adding them,
> all tags and contacts were deleted from the JPG metadata.
> It seems as if only one module of the program is no longer working properly
> and can no longer access the database.
> The JPGs are at the top of the output.
> Unfortunately, I don't have a current debug version of digiKam.
> 
> Regards
> Andy

Hi Andy,
We think we found the issue.  Please retry with the latest version and let us know if the issue is still happening.

Cheers,
Mike

Hi Mike,

The latest version on the download page is digiKam-8.7.0-20250504T170139-Qt6-Win64.exe. The problem still exists here.
Maybe Gilles still has internet problems.

Regards
Andy

yes, i'm not at home and i let's my lead computer on to build the bundles.

I go back at home in 3 weeks, not before. I will try to find an alternative here...

Hi Mike!
With version digiKam-8.7.0-20250507T170157-Qt6-Win64, the PC ran face recognition for many hours last night. This morning, the familiar problem occurred again. Metadata was deleted from the file, and no new data was written.
Could a new output help? It gets extremely large.

Regards
Andy

(In reply to Andy from comment #24)
> Hi Mike!
> With version digiKam-8.7.0-20250507T170157-Qt6-Win64, the PC ran face
> recognition for many hours last night. This morning, the familiar problem
> occurred again. Metadata was deleted from the file, and no new data was
> written.
> Could a new output help? It gets extremely large.
> 
> Regards
> Andy

Hi Andy,
yes, I'll beed a new backtrace to see what's going on.  Thank you!

Cheers,
Mike

Created attachment 181113 [details]
20250509_202001 Ausgabe

Hi Mike,
here's the new backtrace.
Started last night at 10 p.m. This morning at 6 a.m., a face was successfully confirmed. (Up to line 171)
Today at 8:15 p.m., another face was confirmed. But with error messages.

Regards
Andy

Hi Mike,

Could it be that the program, or part of it, crashed? It won't close?
I keep noticing that when I install a new version, I get a message saying that digiKam needs to be closed.
In the Task Manager, I see "Advanced digital photo management application" under "Background processes." I can only close it in the Task Manager.

Regards
Andy

(In reply to Andy from comment #27)
> Hi Mike,
> 
> Could it be that the program, or part of it, crashed? It won't close?
> I keep noticing that when I install a new version, I get a message saying
> that digiKam needs to be closed.
> In the Task Manager, I see "Advanced digital photo management application"
> under "Background processes." I can only close it in the Task Manager.
> 
> Regards
> Andy

Hi Andy,
It looks like you're losing the connection to the MySQL Database.

> Error messages: "QMYSQL: Die Abfrage konnte nicht ausgeführt werden" "Lost connection to MySQL server during query" "2013" 2 

I see this error message (or similar ones) over and over in the log.  Maybe Maik or Gilles can add a comment.  I don't know the code very well that manages the connection to the DB.

Gilles?  Maik?  Any ideas?

Cheers,
Mike

A way to investiguate in-deep with Qt is to enable ALL debug traces. This is very very verbose but it can help to understand some point done by QtSql module in the background.

Try to run digiKam like this : 

export QT_LOGGING_RULES="*qt*=true" && digikam

Gilles Caulier

Hi Gilles,
Was your message addressed to me?
I think your command doesn't work on Windows.

Regards 
Andy

(In reply to Andy from comment #30)
> Hi Gilles,
> Was your message addressed to me?
> I think your command doesn't work on Windows.
> 
> Regards 
> Andy

Hi Andy,
On Windows, you need to update your environment variables in the System Settings to change QT_LOGGING_RULES.  Based on the numerous backtraces you've already sent, I'm assuming you've set this before.  yes?

Cheers,
Mike

Hi Mike,

That's correct.
Name: QT_LOGGING_RULES
Old value: digikam*=true
New value: "*qt*=true"                ???

Regards
Andy

Created attachment 181193 [details]
Ausgabe 20250512_061201

Hi Mike,

Here's the backtrace from last night.
I wasn't sure if the value was correct, so I just let it run.

Regards
Andy

The connection to your MySQL server is lost, and this is due to timeouts on your server. There's nothing digiKam can do about it.

Maik

Hi Maik,

That was a good point from you.
https://docs.rackspace.com/docs/how-to-change-the-mysql-timeout-on-a-server
I'll test higher values ​​than 8 hours.

Regards
Andy

Hello Maik,

I'm wondering if it's a good idea to increase the timeout. Eventually, even this time will expire.
I could increase the time to 24 hours or more. Then I'll have a chance to perform an interactive action.
Do you know which timeout you're referring to? wait_timeout or interactive_timeout?
Could digiKam simulate an interactive action after a while so the countdown starts over?

Regards
Andy

Hi!
I've adjusted the values. I'm fine with that.
wait_timeout = 86400
interactive_timeout = 86400

There's an advisor in phpmyadmin. Does it make sense to follow the suggestions?

For example, this recommendation:
This means that joins perform full table scans. Using indexes on the columns used in the join conditions will speed up joins considerably.

Regards
Andy

(In reply to Andy from comment #37)
> Hi!
> I've adjusted the values. I'm fine with that.
> wait_timeout = 86400
> interactive_timeout = 86400
> 
> There's an advisor in phpmyadmin. Does it make sense to follow the
> suggestions?
> 
> For example, this recommendation:
> This means that joins perform full table scans. Using indexes on the columns
> used in the join conditions will speed up joins considerably.
> 
> Regards
> Andy

Hi Andy,
Can you attach the phpmyadmin report?  It would be nice to see all the recommendations.

Cheers,
Mike

Created attachment 181614 [details]
Advisor1

Hi Mike,

Here are the advisor's recommendations

Regards
Andy

(In reply to Andy from comment #39)
> Created attachment 181614 [details]
> Advisor1
> 
> Hi Mike,
> 
> Here are the advisor's recommendations
> 
> Regards
> Andy

Hi Andy,
Thank you!  I'll add this to my 8.8.0 To Do list.

Cheers,
Mike