Bug 468348

Summary: MySQL remote database: After hibernation, no enlarge window, no display
Product: [Applications] digikam Reporter: Andy <zunar>
Component: Faces-RecognitionAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles
Priority: NOR    
Version First Reported In: 7.10.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed/Implemented In: 8.2.0
Sentry Crash Report:

Description Andy 2023-04-10 08:05:29 UTC 
STEPS TO REPRODUCE
Hello,
I'm just recognizing faces in many thousands of photos.
I also set up a MariaDB on the Synology for this purpose. The performance is certainly not particularly good, but it works. Finding faces took many days with all four CPU cores. I run Face Recognition with a single CPU-Core.
My problem is: I always shut down the PC to hibernate mode. The next day, digikam continues with the detection. The program is visible in the taskbar. But when I try to enlarge it, nothing happens. In the task manager I can see that the program is working at about 20% and so is the synology.
If I right click on digikam in the task bar and click on "digiKam", digikam starts again in a new instance.
So I can't do any other work in digikam, for example to confirm the faces that have already been recognized.
I can only close digikam via the task manager and then restart it. Face recognition must then be restarted.

SOFTWARE/OS VERSIONS
Windows: 10
Comment 1 caulier.gilles 2023-04-11 06:16:22 UTC 
Well, it’s simple: the network socket is broken at system restoration time and application must be lost.
Comment 2 Andy 2023-04-11 11:07:51 UTC 
Understood. So digiKam must always be closed before the PC goes into standby/hibernate mode or the wife switches to your user account. Otherwise the problem happens.
Comment 3 caulier.gilles 2023-05-03 12:35:54 UTC 
Hi Andy,

It must be closed with a remote database. If you use a local one as sqlite, the problem do not exists (i use it and hibernate my computer without problem).

Best regards.

Gilles Caulier
Comment 4 caulier.gilles 2023-05-03 12:37:26 UTC 
Maik,

Perhaps we can at least verify if the socket still valid while using a remote database, as the network connexion can be broken for multiple reasons.

I think the socket must have a time out to catch which can be used to show a message box.

Gilles
Comment 5 Andy 2023-05-03 19:11:27 UTC 
Hello Gilles,

I migrated the database back to SQLite two weeks ago. This runs stable. However, this is on the Synology in a shared folder. Even after the idle state, digikam continues to work with face recognition.
I read that two computers can access a SQLite database. But then digikam no longer reacts.

Andy
Comment 6 caulier.gilles 2023-05-04 02:33:59 UTC 
>I migrated the database back to SQLite two weeks ago. This runs stable. However, this is on the Synology in a shared folder. Even after the idle >state, digikam continues to work with face recognition.

Fine.

>I read that two computers can access a SQLite database. But then digikam no longer reacts.

No, it's wrong. Sqlite database cannot be shared through the network. Also it cannot be hosted in the network share. Only a remote Mysql/Mariadb database can be used in these conditions. 

Gilles Caulier