Bug 468348 - MySQL remote database: After hibernation, no enlarge window, no display
Summary: MySQL remote database: After hibernation, no enlarge window, no display
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Faces-Recognition (show other bugs)
Version: 7.10.0
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-10 08:05 UTC by Andy
Modified: 2023-10-15 03:48 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 8.2.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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