Hello, I have another strange case. The MySQL server is running permanently on the Synology. Last night, another face recognition process was carried out on the PC. The PC was not in standby mode. This morning, I see a lot of recognized faces. I marked and confirmed these 100. In the preview image area, I can see some of the names that have already been assigned below the faces. These have disappeared image by image. The changes have been transferred to the JPGs. The overview of the unconfirmed faces has not otherwise changed. I now have 100 JPGs that no longer have any face areas. There still seems to be access to the database. Apparently, the face data was simply not written to the JPG again. I have now closed digikam and restarted it. The unconfirmed faces from last night are still displayed. If I confirm a face again as before, the areas and names are entered into the JPG. All faces and areas in the photo can be seen again. The areas are still in the database. That's very good! I had the same problem a few days ago. Best regards Andy
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