Bug 445693

Summary: SQLite -> MySQL (recognition.db not migrated)
Product: [Applications] digikam Reporter: hgx9j8a34lvl
Component: Database-MigrationAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED WORKSFORME    
Severity: normal CC: caulier.gilles, metzpinguin
Priority: NOR    
Version First Reported In: 7.4.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: Version Fixed/Implemented In: 7.4.0
Sentry Crash Report:
Attachments: option on windows - database

Description hgx9j8a34lvl 2021-11-18 12:43:26 UTC 
SUMMARY

While I migrated from SQLLite to MySQL (external server), the recognition.db file is still used (not migrated)

STEPS TO REPRODUCE
1. DigiKam with SQLite
2. Use of face recognition features
3. Migrate to MySQL
4. Restarting PC

OBSERVED RESULT
recognition.db is still used by digikam

EXPECTED RESULT
recognition.db should have been migrated to MySQL and Digikam should not use the file anymore

SOFTWARE/OS VERSIONS
Windows: 10

ADDITIONAL INFORMATION
Comment 1 Maik Qualmann 2021-11-18 12:53:00 UTC 
No the recognition DB is no longer used, just like the thumbnail DB. Did you switch to SQLite in digiKam Settings-> Database after migrating?  The recognition DB must be created with the maintenance tool and the option to rebuild the training data.

Maik
Comment 2 Maik Qualmann 2021-11-18 12:53:58 UTC 
I mean, of course, switched to MySQL in the database settings.

Maik
Comment 3 hgx9j8a34lvl 2021-11-18 13:56:52 UTC 
Created attachment 143695 [details]
option on windows - database

screenshot of the settings
Comment 4 hgx9j8a34lvl 2021-11-18 13:57:58 UTC 
yes, could it be something missing in the windows version? there is no specific database input in the settings/migrate screen
Comment 5 Maik Qualmann 2021-11-18 14:22:10 UTC 
No, nothing is missing in the Windows version. With the settings in your screenshot, the SQLite DB is definitely no longer used. Remember that if you use different databases that these must all be set up, we described on the Requirements tab.

Maik
Comment 6 hgx9j8a34lvl 2021-11-18 14:35:26 UTC 
ok, so we have this bug that the file: recognition.db is still used by digiKam (sqlite), or is it expected?
Comment 7 Maik Qualmann 2021-11-18 17:00:24 UTC 
No, the recognition.db is not used if you are using MySQL. How do you come to the conclusion that the file will continue to be used? 

Maik
Comment 8 Maik Qualmann 2021-11-25 21:21:16 UTC 
Since it is technically not possible in digiKam that a SQLite recognition.db is still used after the switch to MySQL, I close the bug.

Maik
Comment 9 hgx9j8a34lvl 2021-11-26 13:08:45 UTC 
just checking on my side, and the last time the file was modified was 2 weeks ago. so I am not sure whether the problem was connected to digikam (and a reboot was somehow required) whether by a different process (AV...) anyway, issue fixed