pending synchonization at restart

frederic chaume frederic.chaume at gmail.com
Thu Sep 3 16:37:50 BST 2026


Hi Gilles

I have created a new DB (took several hours to proceed) , result seems 
ok, and for information DB is 2 times smaller than the corrupted one.
I just loose the saved advanced search and the folder properties. Is 
there a way to recover ?

I'm running debugview filtering "errors" and for the time being, nothing 
abnormal.

For information, hopfully I saved the digikam metadata advanced 
settings, before creating a new DB , so I have been able to reload it 
and use the synchronization with DXO.

Thanks a lot for your help and will let you know fi I'm facing again 
those freeze situation.

Regards
Frederic



Le 01/09/2026 à 13:52, Gilles Caulier a écrit :
> Hi Frederic,
>
> Hi more and less it's the workflow. At restart digiKam will ask for 
> the collection and where is located the database. Use the button 
> Create New Database on the bottom of the dialog.
>
> Best regards
>
> Gilles Caulier
>
> Le mar. 1 sept. 2026 à 13:15, frederic chaume 
> <frederic.chaume at gmail.com> a écrit :
>
>     understood
>
>     so next step is to restart with a fresh DB, right ? Can you
>     precise how to proceed , thinking to stop DK, remove Db and
>     restart DK. Is that enough ?
>
>
>     frederic
>     Le 01/09/2026 à 12:53, Gilles Caulier a écrit :
>>     Hi Frederic,
>>
>>     Yes, the database cannot be touched due to corruptions or
>>     malformed contents. So it's normal that before and after the
>>     maintenance nothing change...
>>
>>     Best regards
>>
>>     Gilles Caulier
>>
>>     Le mar. 1 sept. 2026 à 12:33, frederic chaume
>>     <frederic.chaume at gmail.com> a écrit :
>>
>>         Gilles
>>
>>         Just rerun maintenance tools again but with debug view
>>         Found following messages, see below
>>
>>         This confirm the DB corruption. , right?
>>         so next step is to restart with a fresh DB, right ? Can you
>>         precise how to proceed , thinking to stop DK, remove Db and
>>         restart DK. Is that enough ?
>>
>>         regards
>>         Frederic
>>
>>          "DELETE FROM Thumbnails WHERE id=:0;"
>>         Error messages: "Impossible de récupérer la ligne"
>>         "database disk image is malformed" "11" 1
>>         Bound values:  QList(QVariant(int, 226891))
>>         digikam.dbengine: Failure executing query:
>>          "DELETE FROM Thumbnails WHERE id=:0;"
>>         Error messages: "Impossible de récupérer la ligne"
>>         "database disk image is malformed" "11" 1
>>         Bound values:  QList(QVariant(int, 516784))
>>         digikam.thumbsdb: Could not start the removal of ""  due to
>>         error
>>         digikam.general: One job is done
>>         Digikam::DatabaseTask(0x2a303943000) time: 1400524
>>         digikam.dbengine: WARNING !!! Transaction count is 1 when
>>         destroying database!!!
>>         digikam.maintenance: List of Pending Jobs is empty
>>         digikam.maintenance: Faces DB is clean.
>>         digikam.maintenance: Found 59575 image ids that are
>>         referenced in similarity db but not used.
>>         digikam.maintenance: Creating a database task for removing
>>         stale image id entries from similarity db.
>>         digikam.general: Action Thread run 1 new jobs
>>         digikam.general: One job is done
>>         Digikam::DatabaseTask(0x2a30721f3e0) time: 2331
>>         digikam.maintenance: List of Pending Jobs is empty
>>         digikam.general: Action Thread run 1 new jobs
>>         digikam.maintenance: Shrinking databases
>>         digikam.database: Failed integrity check for SQLite core
>>         database: "wrong # of entries in index image_status_index"
>>         digikam.maintenance: Integrity check for core DB failed. Will
>>         not vacuum.
>>         digikam.database: Failed integrity check for SQLite thumbnail
>>         database: "*** in database main ***\nTree 2 page 4087277 cell
>>         0: invalid page number 4245518588\nTree 2 page 4087214 cell
>>         0: invalid page number 2543449262\nTree 2 page 4087192 cell
>>         1: invalid page number 1989601594\nTree 2 page 4087168 cell
>>         2: invalid page number 2282729473\nTree 2 page 4087168 cell
>>         0: invalid page number 3079188245\nTree 2 page 4087155 cell
>>         0: invalid page number 1367568241\nTree 2 page 4087139 cell
>>         0: invalid page number 1619541267\nTree 2 page 4087108 cell
>>         0: invalid page number 2484542021\nTree 2 page 4087080 cell
>>         0: invalid page number 3050765754\nTree 2 page 4087074 cell
>>         1: invalid page number 425636694\nTree 2 page 4087066 cell 0:
>>         invalid page number 2720391427\nTree 2 page 4087038 cell 0:
>>         invalid page number 1294591941\nTree 2 page 4087023 cell 0:
>>         invalid page number 2364799556\nTree 2 page 4087004 cell 1:
>>         invalid page number 2916350661\nTree 2 page 4086970 cell 0:
>>         invalid page number 2816116134\nTree 2 page 4086960 cell 0:
>>         invalid page number 2329730588\nTree 2 page 4086945 cell 0:
>>         invalid page number 1705933643\nTree 2 page 4086927 cell 0:
>>         invalid page number 990215723\nTree 2 page 4086911 cell 0:
>>         invalid page number 3081192065\nTree 2 page 4086893 cell 0:
>>         invalid page number 2565581624\nPage 5357198: never
>>         used\nPage 5357199: never used\nPage 5357200: never
>>         used\nPage 5357201: never used\nPage 5357202: never
>>         used\nPage 5357204: never used\nPage 5357205: never
>>         used\nPage 5357206: never used\nPage 5357207: never
>>         used\nPage 5357208: never used\nPage 5357209: never
>>         used\nPage 5357210: never used\nPage 5357211: never
>>         used\nPage 5357212: never used\nPage 5357213: never
>>         used\nPage 5357214: never used\nPage 5357215: never
>>         used\nPage 5357216: never used\nPage 5357217: never
>>         used\nPage 5357218: never used\nPage 5357219: never
>>         used\nPage 5357220: never used\nPage 5357221: never
>>         used\nPage 5357222: never used\nPage 5357223: never
>>         used\nPage 5357224: never used\nPage 5357225: never
>>         used\nPage 5357226: never used\nPage 5357227: never
>>         used\nPage 5357228: never used\nPage 5357229: never
>>         used\nPage 5357230: never used\nPage 5357231: never
>>         used\nPage 5357232: never used\nPage 5357233: never
>>         used\nPage 5357234: never used\nPage 5357236: never
>>         used\nPage 5357237: never used\nPage 5357238: never
>>         used\nPage 5357239: never used\nPage 5357240: never
>>         used\nPage 5357241: never used\nPage 5357243: never
>>         used\nPage 5357244: never used\nPage 5357245: never
>>         used\nPage 5357246: never used\nPage 5357247: never
>>         used\nPage 5357248: never used\nPage 5357249: never
>>         used\nPage 5357250: never used\nPage 5357251: never
>>         used\nPage 5357252: never used\nPage 5357253: never
>>         used\nPage 5357254: never used\nPage 5357255: never
>>         used\nPage 5357257: never used\nPage 5357258: never
>>         used\nPage 5357259: never used\nPage 5357260: never
>>         used\nPage 5357261: never used\nPage 5357262: never
>>         used\nPage 5357263: never used\nPage 5357264: never
>>         used\nPage 5357265: never used\nPage 5357266: never
>>         used\nPage 5357267: never used\nPage 5357268: never
>>         used\nPage 5357269: never used\nPage 5357270: never
>>         used\nPage 5357271: never used\nPage 5357272: never
>>         used\nPage 5357273: never used\nPage 5357274: never
>>         used\nPage 5357275: never used\nPage 5357276: never
>>         used\nPage 5357277: never used\nPage 5357278: never
>>         used\nPage 5357279: never used\nPage 5357280: never
>>         used\nPage 5357281: never used"
>>         digikam.maintenance: Integrity check for thumbnails DB
>>         failed. Will not vacuum.
>>         digikam.maintenance: Finished vacuuming of recognition DB.
>>         Integrity check after vacuuming was positive.
>>         digikam.maintenance: Finished vacuuming of similarity DB.
>>         Integrity check after vacuuming was positive.
>>         digikam.general: One job is done
>>         Digikam::DatabaseTask(0x2a30721ea80) time: 223314
>>         digikam.maintenance: List of Pending Jobs is empty
>>         digikam.maintenance: stage3
>>         digikam.maintenance: stage4
>>         digikam.maintenance: stage5
>>         digikam.maintenance: stage6
>>         digikam.maintenance: stage7
>>         digikam.maintenance: stage8
>>         digikam.maintenance: stage9
>>         digikam.general: Event is dispatched using KDE desktop notifier
>>         kf.notifications: No event config could be found for event id
>>         "digiKam Maintenance" under notifyrc file for app "digikam"
>>         digikam.general: Finish Main Thread
>>         digikam.general: Finish Main Thread
>>
>>
>>         Le 01/09/2026 à 11:29, frederic chaume a écrit :
>>>         Bonjour Gilles
>>>
>>>         After a backup , I have executed "Tools/Database maintenance
>>>         : perform database cleaning" with all options set.
>>>         It tooks some minutes to execute, but when I compare the
>>>         backup and the active database, I notice that:
>>>         - digikam4.db and thumbnails-digikam.db files are exactly
>>>         same size (backup and active)
>>>         - all db files in active directory (the one configured in DK
>>>         settings) have the date of November 2024
>>>
>>>         is that normal ?
>>>
>>>         regards
>>>         frederic
>>>
>>>
>>>
>>>
>>>
>>>         Le 31/08/2026 à 18:07, frederic chaume a écrit :
>>>>         Thanks Gilles for your advice.
>>>>
>>>>         Will proceed following steos:
>>>>         - backup DB (already doing it from time to time, but
>>>>         keeping only the last version,  cannot store an history for
>>>>         a 500M DB file, don't have enough disk space)
>>>>         - run the Tools/Database maintenance : perform database
>>>>         cleaning
>>>>         - run the Tools/Database maintenance : perform sync
>>>>         metadata and database (from file to DB)
>>>>
>>>>         and will see if it is  better. (filter debugview on
>>>>         "database disk image is malformed" )
>>>>         I will also see to run a cleaning of windows registry
>>>>
>>>>         Note that for "jpg is written to XMP sidecar". My settings
>>>>         is "write to XMP for read-only items only"
>>>>
>>>>         regards
>>>>         Frederic
>>>>
>>>>
>>>>
>>>>         Le 31/08/2026 à 16:51, Gilles Caulier a écrit :
>>>>>
>>>>>
>>>>>         Le lun. 31 août 2026 à 09:21, frederic chaume
>>>>>         <frederic.chaume at gmail.com> a écrit :
>>>>>
>>>>>             Hi Gilles
>>>>>
>>>>>             thanks for your analysis.
>>>>>             Answers/questions in blue inline
>>>>>
>>>>>             regards
>>>>>             Frederic
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>             Le 30/08/2026 à 11:42, Gilles Caulier a écrit :
>>>>>>             Just at start of the application, when the icon view
>>>>>>             is populated from the database we can read :
>>>>>>
>>>>>>             00000506 59.79187012 11348 digikam.dbengine: Failure
>>>>>>             executing query:
>>>>>>             00000507 59.79187012 11348 "REPLACE INTO Images (
>>>>>>             album, name, status, category, modificationDate,
>>>>>>             fileSize, uniqueHash )  VALUES (:0,:1,:2,:3,:4,:5,:6);"
>>>>>>             00000508 59.79187012 11348 Error messages:
>>>>>>             "Impossible de récupérer la ligne" "database disk
>>>>>>             image is malformed" "779" 1
>>>>>>             00000509 59.79187012 11348 Bound values:
>>>>>>              QList(QVariant(int, 1053), QVariant(QString,
>>>>>>             "20181016_121649.jpg"), QVariant(int, 1),
>>>>>>             QVariant(int, 1), QVariant(QDateTime,
>>>>>>             QDateTime(2021-04-10 17:14:42.190 UTC+2
>>>>>>             Qt::LocalTime)), QVariant(qlonglong, 2821819),
>>>>>>             QVariant(QString, "61b16a737e8f3d7b4f104998ab36650d"))
>>>>>>             00000510 59.79508972 11348 digikam.database:
>>>>>>             Finishing took 4 ms
>>>>>>
>>>>>>             It's clear the database file is corrupted. Why ? I
>>>>>>             don't know. We already see more and more sqlite
>>>>>>             database corruption under Windows, perhaps due to the
>>>>>>             anti-virus running in the background, i don't
>>>>>>             know yet. From my side I use digiKam in my office
>>>>>>             under Windows 11 controlled by my company (to
>>>>>>             reference all photo taken in my office aka device,
>>>>>>             hardware, room, working place, laboratory,
>>>>>>             experiment, etc), with Norton AV in the background
>>>>>>             where is set an exception to l'ets run digiKam
>>>>>>             properly and this lets all collection and database
>>>>>>             files live alone without constraint. I never saw the
>>>>>>             sqlite database corrupted (all running on my Dell
>>>>>>             Laptop with large NVME storages).
>>>>>             Is there something I can do regarding DB corrupted?
>>>>>             clean? rebuild (but how long it will take ?) ?
>>>>>             I never run the database cleaning from maintenance.
>>>>>             Can it help ?
>>>>>
>>>>>
>>>>>         First backup the database files. This is the priority. In
>>>>>         second stage, run the Tools/Database maintenance to see if
>>>>>         it can help. After that close digiKam and restart. Check
>>>>>         if the latency problem are solved...
>>>>>
>>>>>>
>>>>>>             For this kind of error message:
>>>>>>
>>>>>>             00000506 59.79187012 11348 digikam.dbengine: Failure
>>>>>>             executing query:
>>>>>>             00000507 59.79187012 11348 "REPLACE INTO Images (
>>>>>>             album, name, status, category, modificationDate,
>>>>>>             fileSize, uniqueHash )  VALUES (:0,:1,:2,:3,:4,:5,:6);"
>>>>>>             00000508 59.79187012 11348 Error messages:
>>>>>>             "Impossible de récupérer la ligne" "database disk
>>>>>>             image is malformed" "779" 1
>>>>>>             00000509 59.79187012 11348 Bound values:
>>>>>>              QList(QVariant(int, 1053), QVariant(QString,
>>>>>>             "20181016_121649.jpg"), QVariant(int, 1),
>>>>>>             QVariant(int, 1), QVariant(QDateTime,
>>>>>>             QDateTime(2021-04-10 17:14:42.190 UTC+2
>>>>>>             Qt::LocalTime)), QVariant(qlonglong, 2821819),
>>>>>>             QVariant(QString, "61b16a737e8f3d7b4f104998ab36650d"))
>>>>>>             00000510 59.79508972 11348 digikam.database:
>>>>>>             Finishing took 4 ms
>>>>>>
>>>>>>             This is a native Windows desktop notifier failure.
>>>>>>             Nothing important as it's not database related. This
>>>>>>             is strange because later a similar notification is
>>>>>>             pushed successfully. Windows environnement looks ugly.
>>>>>>
>>>>>>             This one is important as file cannot be found. Why?
>>>>>>
>>>>>>             00001862 42845.85546875 11348 digikam.general: Action
>>>>>>             Thread run 12 new jobs
>>>>>>             00001863 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a66a30)
>>>>>>             time: 4
>>>>>>             00001864 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a66da0)
>>>>>>             time: 6
>>>>>>             00001865 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a67200)
>>>>>>             time: 3
>>>>>>             00001866 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a67890)
>>>>>>             time: 8
>>>>>>             00001867 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a66a80)
>>>>>>             time: 5
>>>>>>             00001868 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a67c00)
>>>>>>             time: 1
>>>>>>             00001869 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a671b0)
>>>>>>             time: 2
>>>>>>             00001870 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a67110)
>>>>>>             time: 7
>>>>>>             00001871 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a67480)
>>>>>>             time: 3
>>>>>>             00001872 42845.86328125 11348 digikam.general: One
>>>>>>             job is done Digikam::MetadataSyncTask(0x20706a67660)
>>>>>>             time: 1
>>>>>>             00001873 42845.87500000 11348 digikam.metaengine:
>>>>>>             Cannot load metadata from file with Exiv2 backend:
>>>>>>             D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/P1003747_Dx90.jpg  (Error #
>>>>>>             10 :  "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/P1003747_Dx90.jpg: Failed to
>>>>>>             open the data source: No such file or directory
>>>>>>             (errno = 2)"
>>>>>>
>>>>>>             Here it's the metadata synchronizer working in the
>>>>>>             background. So Exiv2 generates exceptions which can
>>>>>>             introduce time latency.
>>>>>>
>>>>>>             Looks also another one :
>>>>>>
>>>>>>             00001897 42846.00781250 11348
>>>>>>             <tel:+7%20812%20501-13-48> digikam.general: Detected
>>>>>>             change, triggering rescan of
>>>>>>             "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/"
>>>>>>             00001898 42846.03906250 11348 digikam.metaengine:
>>>>>>             Metadata for file "P1003747_Dx90.jpg" written to XMP
>>>>>>             sidecar.
>>>>>>             00001899 42846.11328125 11348 digikam.general:
>>>>>>             Detected change, triggering rescan of
>>>>>>             "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/"
>>>>>>             00001900 42846.11718750 11348 digikam.metaengine:
>>>>>>             wroteComment:  false
>>>>>>             00001901 42846.12109375 11348 digikam.metaengine:
>>>>>>             wroteEXIF:  true
>>>>>>             00001902 42846.12109375 11348 digikam.metaengine:
>>>>>>             wroteIPTC:  true
>>>>>>             00001903 42846.12109375 11348 digikam.metaengine:
>>>>>>             wroteXMP:  true
>>>>>>             00001904 42846.12109375 11348 digikam.general:
>>>>>>             Detected change, triggering rescan of
>>>>>>             "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/"
>>>>>>             00001905 42846.12109375 11348 digikam.metaengine:
>>>>>>             Metadata for file "P1003747.RW2" written to XMP sidecar.
>>>>>>             00001906 42846.12500000 11348 digikam.metaengine:
>>>>>>             Cannot load metadata from file with Exiv2 backend:
>>>>>>             D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/P1003747_Dx90.jpg  (Error #
>>>>>>             10 :  "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/P1003747_Dx90.jpg: Failed to
>>>>>>             open the data source: No such file or directory
>>>>>>             (errno = 2)"
>>>>>
>>>>>             Such kind of file, once generated , is intented to be
>>>>>             moved to another Album
>>>>>             Is this can happen if the file is moved between
>>>>>             setting the metadata and before launching
>>>>>             synchronization ? If yes, that mean that metadata for
>>>>>             this file will never be updated in the DB?
>>>>>
>>>>>
>>>>>         I don't know. But in all cases this kind of error does not
>>>>>         load the file metadata at all, and yes the database
>>>>>         contents can be not homogeneous.
>>>>>
>>>>>
>>>>>             Also wondering why "Metadata for file
>>>>>             "P1003747_Dx90.jpg" is written to XMP sidecar."
>>>>>             shouldn't use XMP for Jpeg, no?
>>>>>
>>>>>
>>>>>         This depends on your needs. If you want the original files
>>>>>         untouched, yes. Also consider ExifTool backend where the
>>>>>         IO operations are processed to play metadata (it's more
>>>>>         powerful than Exiv2, but not faster...
>>>>>
>>>>>
>>>>>
>>>>>>
>>>>>>             You really have a problem at this storage location,
>>>>>>             or the database contents are not properly up-to-date
>>>>>>             corresponding to the collection contents.
>>>>>             How to update the DB ? in maintenance menu, I see a
>>>>>             "sync metadata and database", can it be run to solve
>>>>>             it , using the read from file direction ?
>>>>>
>>>>>
>>>>>         If the DB files are corrupted, no way. I hope that all
>>>>>         digiKam properties are stored in files metadata (or xmp
>>>>>         sidecar). Creating a new DB sounds like the more safe way
>>>>>         to go. But this will not solve the base of the problem.
>>>>>         Why have the DB files been corrupted one time ? This can
>>>>>         happen one more time...
>>>>>
>>>>>>
>>>>>>             This one is related to the thumbnails processing:
>>>>>>
>>>>>>             00001922 42846.17187500 11348 digikam.general:
>>>>>>             Generating thumbnail for:
>>>>>>             "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/P1003747_Dx90.jpg"
>>>>>>             00001923 42846.17187500 11348 digikam.general: Failed
>>>>>>             to generate thumbnail for:
>>>>>>             "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/P1003747_Dx90.jpg"
>>>>>>             00001924 42846.17187500 11348 digikam.general:
>>>>>>             Thumbnail is null for
>>>>>>              "D:/images/Pellicules/Pellicule
>>>>>>             2026/2026-08/2026-08-25/P1003747_Dx90.jpg"
>>>>>>
>>>>>>             It's always relevant of the same album.
>>>>>>
>>>>>>             These errors are not relevant of digiKam. It's the
>>>>>>             chrome install failure :
>>>>>>
>>>>>>             00002015 42950.33984375 13912 [0827/080238
>>>>>>             <tel:0%20827%2008%2002%2038>.667:ERROR:third_party\crashpad\crashpad\util\file\filesystem_win.cc:128]
>>>>>>             GetFileAttributes
>>>>>>             C:\Users\famil\AppData\Local\Google\Chrome\User
>>>>>>             Data\Crashpad\attachments\484eb780-549b-4714-9168-1b249d8237a1:
>>>>>>             Le fichier spécifié est introuvable. (0x2)
>>>>>>             00002016 42950.33984375 13912 [0827/080238
>>>>>>             <tel:0%20827%2008%2002%2038>.668:ERROR:third_party\crashpad\crashpad\util\file\filesystem_win.cc:128]
>>>>>>             GetFileAttributes
>>>>>>             C:\Users\famil\AppData\Local\Google\Chrome\User
>>>>>>             Data\Crashpad\attachments\847eff80-ab44-430d-9695-a18c08e984df:
>>>>>>             Le fichier spécifié est introuvable. (0x2)
>>>>>>
>>>>>>             Something crashes in the background and can introduce
>>>>>>             more time latency in your system.
>>>>>>
>>>>>>             For this one, what's that ? It's an internal sqlite
>>>>>>             session from the system or another application
>>>>>>             running in the background? You have plenty of this
>>>>>>             kind of traces:
>>>>>>
>>>>>>             00004987 46830.67578125 11436 [2026-08-27
>>>>>>             09:07:18.9897317] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 59: interrupted; [SELECT
>>>>>>             00004988 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00004989 46830.67578125 11436 FROM ( SELECT
>>>>>>             00004990 46830.67578125 11436 Count([Filter2].[A1])
>>>>>>             AS [A1]
>>>>>>             00004991 46830.67578125 11436 FROM ( SELECT
>>>>>>             00004992 46830.67578125 11436  1 AS [A1]
>>>>>>             00004993 46830.67578125 11436  FROM  [Items] AS
>>>>>>             [Extent1]
>>>>>>             00004994 46830.67578125 11436  LEFT OUTER JOIN
>>>>>>             [Sources] AS [Extent2] ON ([Extent1].[SourceId] =
>>>>>>             [Extent2].[Id]) AND
>>>>>>             ([Extent2].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource')
>>>>>>             00004995 46830.67578125 11436  WHERE
>>>>>>             (([Extent1].[ItemTypeDiscriminator] =
>>>>>>             'EFDOPInputItem') AND (CASE WHEN ([Extent2].[Id] IS
>>>>>>             NULL) THEN NULL ELSE '2X0X0X' END LIKE '2X0X%')) AND
>>>>>>             (( EXISTS (SELECT
>>>>>>             00004996 46830.67578125 11436 1 AS [C1]
>>>>>>             00004997 46830.67578125 11436 FROM  [Sources] AS
>>>>>>             [Extent3]
>>>>>>             00004998 46830.67578125 11436 INNER JOIN [Metadatas]
>>>>>>             AS [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>>>>             00004999 46830.67578125 11436 WHERE
>>>>>>             (([Extent3].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource') AND (
>>>>>>             00005000 46830.67578125 11436 [2026-08-27
>>>>>>             09:07:18.9897317] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 59: interrupted; [SELECT
>>>>>>             00005001 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00005002 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005003 46830.67578125 11436 Count([Filter2].[A1])
>>>>>>             AS [A1]
>>>>>>             00005004 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005005 46830.67578125 11436  1 AS [A1]
>>>>>>             00005006 46830.67578125 11436  FROM  [Items] AS
>>>>>>             [Extent1]
>>>>>>             00005007 46830.67578125 11436  LEFT OUTER JOIN
>>>>>>             [Sources] AS [Extent2] ON ([Extent1].[SourceId] =
>>>>>>             [Extent2].[Id]) AND
>>>>>>             ([Extent2].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource')
>>>>>>             00005008 46830.67578125 11436  WHERE
>>>>>>             (([Extent1].[ItemTypeDiscriminator] =
>>>>>>             'EFDOPInputItem') AND (CASE WHEN ([Extent2].[Id] IS
>>>>>>             NULL) THEN NULL ELSE '2X0X0X' END LIKE '2X0X%')) AND
>>>>>>             (( EXISTS (SELECT
>>>>>>             00005009 46830.67578125 11436 1 AS [C1]
>>>>>>             00005010 46830.67578125 11436 FROM  [Sources] AS
>>>>>>             [Extent3]
>>>>>>             00005011 46830.67578125 11436 INNER JOIN [Metadatas]
>>>>>>             AS [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>>>>             00005012 46830.67578125 11436 WHERE
>>>>>>             (([Extent3].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource') AND (
>>>>>>             00005013 46830.67578125 11436 [2026-08-27
>>>>>>             09:07:18.9897317] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 59: interrupted; [SELECT
>>>>>>             00005014 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00005015 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005016 46830.67578125 11436 Count([Filter2].[A1])
>>>>>>             AS [A1]
>>>>>>             00005017 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005018 46830.67578125 11436  1 AS [A1]
>>>>>>             00005019 46830.67578125 11436  FROM  [Items] AS
>>>>>>             [Extent1]
>>>>>>             00005020 46830.67578125 11436  LEFT OUTER JOIN
>>>>>>             [Sources] AS [Extent2] ON ([Extent1].[SourceId] =
>>>>>>             [Extent2].[Id]) AND
>>>>>>             ([Extent2].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource')
>>>>>>             00005021 46830.67578125 11436  WHERE
>>>>>>             (([Extent1].[ItemTypeDiscriminator] =
>>>>>>             'EFDOPInputItem') AND (CASE WHEN ([Extent2].[Id] IS
>>>>>>             NULL) THEN NULL ELSE '2X0X0X' END LIKE '2X0X%')) AND
>>>>>>             (( EXISTS (SELECT
>>>>>>             00005022 46830.67578125 11436 1 AS [C1]
>>>>>>             00005023 46830.67578125 11436 FROM  [Sources] AS
>>>>>>             [Extent3]
>>>>>>             00005024 46830.67578125 11436 INNER JOIN [Metadatas]
>>>>>>             AS [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>>>>             00005025 46830.67578125 11436 WHERE
>>>>>>             (([Extent3].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource') AND (
>>>>>>             00005026 46830.67578125 11436 [2026-08-27
>>>>>>             09:07:18.9897317] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 59: interrupted; [SELECT
>>>>>>             00005027 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00005028 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005029 46830.67578125 11436 Count([Filter2].[A1])
>>>>>>             AS [A1]
>>>>>>             00005030 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005031 46830.67578125 11436  1 AS [A1]
>>>>>>             00005032 46830.67578125 11436  FROM  [Items] AS
>>>>>>             [Extent1]
>>>>>>             00005033 46830.67578125 11436  LEFT OUTER JOIN
>>>>>>             [Sources] AS [Extent2] ON ([Extent1].[SourceId] =
>>>>>>             [Extent2].[Id]) AND
>>>>>>             ([Extent2].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource')
>>>>>>             00005034 46830.67578125 11436  WHERE
>>>>>>             (([Extent1].[ItemTypeDiscriminator] =
>>>>>>             'EFDOPInputItem') AND (CASE WHEN ([Extent2].[Id] IS
>>>>>>             NULL) THEN NULL ELSE '2X0X0X' END LIKE '2X0X%')) AND
>>>>>>             (( EXISTS (SELECT
>>>>>>             00005035 46830.67578125 11436 1 AS [C1]
>>>>>>             00005036 46830.67578125 11436 FROM  [Sources] AS
>>>>>>             [Extent3]
>>>>>>             00005037 46830.67578125 11436 INNER JOIN [Metadatas]
>>>>>>             AS [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>>>>             00005038 46830.67578125 11436 WHERE
>>>>>>             (([Extent3].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource') AND (
>>>>>>             00005039 46830.67578125 11436 [2026-08-27
>>>>>>             09:07:18.9897317] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 59: interrupted; [SELECT
>>>>>>             00005040 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00005041 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005042 46830.67578125 11436 Count([Filter2].[A1])
>>>>>>             AS [A1]
>>>>>>             00005043 46830.67578125 11436 FROM ( SELECT
>>>>>>             00005044 46830.67578125 11436  1 AS [A1]
>>>>>>             00005045 46830.67578125 11436  FROM  [Items] AS
>>>>>>             [Extent1]
>>>>>>             00005046 46830.67578125 11436  LEFT OUTER JOIN
>>>>>>             [Sources] AS [Extent2] ON ([Extent1].[SourceId] =
>>>>>>             [Extent2].[Id]) AND
>>>>>>             ([Extent2].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource')
>>>>>>             00005047 46830.67578125 11436  WHERE
>>>>>>             (([Extent1].[ItemTypeDiscriminator] =
>>>>>>             'EFDOPInputItem') AND (CASE WHEN ([Extent2].[Id] IS
>>>>>>             NULL) THEN NULL ELSE '2X0X0X' END LIKE '2X0X%')) AND
>>>>>>             (( EXISTS (SELECT
>>>>>>             00005048 46830.67578125 11436 1 AS [C1]
>>>>>>             00005049 46830.67578125 11436 FROM  [Sources] AS
>>>>>>             [Extent3]
>>>>>>             00005050 46830.67578125 11436 INNER JOIN [Metadatas]
>>>>>>             AS [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>>>>             00005051 46830.67578125 11436 WHERE
>>>>>>             (([Extent3].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource') AND (
>>>>>>             00005052 46831.84375000 11436 [2026-08-27
>>>>>>             09:07:20.1733485] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 42: interrupted; [SELECT
>>>>>>             00005053 46831.84375000 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00005054 46831.84375000 11436 FROM ( SELECT
>>>>>>             00005055 46831.84375000 11436 Count([Filter4].[A1])
>>>>>>             AS [A1]
>>>>>>             00005056 46831.84375000 11436 FROM ( SELECT
>>>>>>             00005057 46831.84375000 11436  1 AS [A1]
>>>>>>             00005058 46831.84375000 11436  FROM ( SELECT
>>>>>>             [Extent1].[Id] AS [Id1], [Extent1].[CreationDate] AS
>>>>>>             [CreationDate], [Extent1].[ModificationDate] AS
>>>>>>             [ModificationDate], [Extent1].[Name] AS [Name1],
>>>>>>             [Extent1].[StoreRating] AS [StoreRating],
>>>>>>             [Extent1].[StoreSettings] AS [StoreSettings],
>>>>>>             [Extent1].[StoreProcessingStatus] AS
>>>>>>             [StoreProcessingStatus], [Extent1].[Uuid] AS [Uuid1],
>>>>>>             [Extent1].[StoreOrientation] AS [StoreOrientation],
>>>>>>             [Extent1].[StorePickOrReject] AS [StorePickOrReject],
>>>>>>             [Extent1].[StoreMetadataVersion] AS
>>>>>>             [StoreMetadataVersion], [Extent1].[StoreFormat] AS
>>>>>>             [StoreForma
>>>>>>             00005059 46831.84375000 11436 [2026-08-27
>>>>>>             09:07:20.1733485] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 59: interrupted; [SELECT
>>>>>>             00005060 46831.84375000 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00005061 46831.84375000 11436 FROM ( SELECT
>>>>>>             00005062 46831.84375000 11436 Count([Filter2].[A1])
>>>>>>             AS [A1]
>>>>>>             00005063 46831.84375000 11436 FROM ( SELECT
>>>>>>             00005064 46831.84375000 11436  1 AS [A1]
>>>>>>             00005065 46831.84375000 11436  FROM  [Items] AS
>>>>>>             [Extent1]
>>>>>>             00005066 46831.84375000 11436  LEFT OUTER JOIN
>>>>>>             [Sources] AS [Extent2] ON ([Extent1].[SourceId] =
>>>>>>             [Extent2].[Id]) AND
>>>>>>             ([Extent2].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource')
>>>>>>             00005067 46831.84375000 11436  WHERE
>>>>>>             (([Extent1].[ItemTypeDiscriminator] =
>>>>>>             'EFDOPInputItem') AND (CASE WHEN ([Extent2].[Id] IS
>>>>>>             NULL) THEN NULL ELSE '2X0X0X' END LIKE '2X0X%')) AND
>>>>>>             (( EXISTS (SELECT
>>>>>>             00005068 46831.84375000 11436 1 AS [C1]
>>>>>>             00005069 46831.84375000 11436 FROM  [Sources] AS
>>>>>>             [Extent3]
>>>>>>             00005070 46831.84375000 11436 INNER JOIN [Metadatas]
>>>>>>             AS [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>>>>             00005071 46831.84375000 11436 WHERE
>>>>>>             (([Extent3].[SourceTypeDiscriminator] =
>>>>>>             'EFDOPFileSource') AND (
>>>>>>             00005072 46831.84375000 11436 [2026-08-27
>>>>>>             09:07:20.1733485] System.Data.SQLite (Log): SQLite
>>>>>>             error (9): statement aborts at 71: interrupted; [SELECT
>>>>>>             00005073 46831.84375000 11436 [GroupBy1].[A1] AS [C1]
>>>>>>             00005074 46831.84375000 11436 FROM ( SELECT
>>>>>>             00005075 46831.84375000 11436 Count([Filter3].[A1])
>>>>>>             AS [A1]
>>>>>>             00005076 46831.84375000 11436 FROM ( SELECT
>>>>>>             00005077 46831.84375000 11436  1 AS [A1]
>>>>>>             00005078 46831.84375000 11436  FROM   (SELECT
>>>>>>             [Extent1].[Id] AS [Id1], [Extent1].[CreationDate] AS
>>>>>>             [CreationDate], [Extent1].[ModificationDate] AS
>>>>>>             [ModificationDate], [Extent1].[Name] AS [Name1],
>>>>>>             [Extent1].[StoreRating] AS [StoreRating],
>>>>>>             [Extent1].[StoreSettings] AS [StoreSettings],
>>>>>>             [Extent1].[StoreProcessingStatus] AS
>>>>>>             [StoreProcessingStatus], [Extent1].[Uuid] AS [Uuid1],
>>>>>>             [Extent1].[StoreOrientation] AS [StoreOrientation],
>>>>>>             [Extent1].[StorePickOrReject] AS [StorePickOrReject],
>>>>>>             [Extent1].[StoreMetadataVersion] AS
>>>>>>             [StoreMetadataVersion], [Extent1].[StoreFormat] AS
>>>>>>             [StoreForm
>>>>>>
>>>>>>             ... Perhaps something comming another 3rdparty
>>>>>>             application installled on your system (:=))):
>>>>>>
>>>>>>             00005190 46887.89062500 11348 digikam.general:
>>>>>>             Resolved file path: "E:\\Applications\\DxO\\DxO
>>>>>>             PhotoLab 8\\DxO.PhotoLab.exe"
>>>>>>             00005191 46887.89843750 11348 digikam.general:
>>>>>>             Resolved file path: "E:\\Applications\\GIMP
>>>>>>             3\\bin\\gimp-3.exe"
>>>>>>             00005192 46887.90625000 11348 digikam.general:
>>>>>>             Resolved file path: "E:\\Applications\\ON1\\ON1\\ON1
>>>>>>             Effects 2025\\ON1 Effects 2025.exe"
>>>>>>             00005193 46887.94921875 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\DxO\\DxO
>>>>>>             PhotoLab 6\\DxO.PhotoLab.exe"
>>>>>>             00005194 46887.94921875 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\DxO\\DxO
>>>>>>             PhotoLab 6\\DxO.PhotoLab.exe"
>>>>>>             00005195 46887.94921875 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\DxO\\DxO
>>>>>>             PhotoLab 7\\DxO.PhotoLab.exe"
>>>>>>             00005196 46887.94921875 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\DxO\\DxO
>>>>>>             PhotoLab 7\\DxO.PhotoLab.exe"
>>>>>>             00005197 46887.95703125 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\GIMP
>>>>>>             2\\bin\\gimp-2.10.exe"
>>>>>>             00005198 46887.95703125 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\GIMP
>>>>>>             2\\bin\\gimp-2.10.exe"
>>>>>>             00005199 46887.96093750 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files
>>>>>>             (x86)\\IrfanView\\i_view32.exe"
>>>>>>             00005200 46887.96093750 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files
>>>>>>             (x86)\\IrfanView\\i_view32.exe"
>>>>>>             00005201 46887.96093750 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files
>>>>>>             (x86)\\IrfanView\\i_view32.exe"
>>>>>>             00005202 46887.96093750 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\IrfanView\\i_view64.exe"
>>>>>>             00005203 46887.96093750 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\IrfanView\\i_view64.exe"
>>>>>>             00005204 46887.96484375 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\IrfanView\\i_view64.exe"
>>>>>>             00005205 46887.96875000 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\Corel\\Corel
>>>>>>             PaintShop Pro 2023 (64-bit)\\Corel PaintShop Pro.exe"
>>>>>>             00005206 46887.96875000 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\Corel\\Corel
>>>>>>             PaintShop Pro 2023 (64-bit)\\Corel PaintShop Pro.exe"
>>>>>>             00005207 46887.96875000 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files\\Corel\\Corel
>>>>>>             PaintShop Pro 2023 (64-bit)\\Corel PaintShop Pro.exe"
>>>>>>             00005208 46887.97656250 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\digiKam\\showfoto.exe"
>>>>>>             00005209 46887.98046875 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\digiKam\\showfoto.exe"
>>>>>>             00005210 46887.98046875 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\digiKam\\showfoto.exe"
>>>>>>             00005211 46887.98437500 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files
>>>>>>             (x86)\\XnView\\xnview.exe"
>>>>>>             00005212 46887.98437500 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files
>>>>>>             (x86)\\XnView\\xnview.exe"
>>>>>>             00005213 46887.98437500 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program Files
>>>>>>             (x86)\\XnView\\xnview.exe"
>>>>>>             00005214 46887.98828125 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\XnViewMP\\xnviewmp.exe"
>>>>>>             00005215 46887.98828125 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\XnViewMP\\xnviewmp.exe"
>>>>>>             00005216 46887.98828125 11348 digikam.general:
>>>>>>             Resolved file path: "C:\\Program
>>>>>>             Files\\XnViewMP\\xnviewmp.exe"
>>>>>>             00005217 46887.98828125 11348 digikam.general:
>>>>>>             Resolved file path: "E:\\Applications\\DxO\\DxO
>>>>>>             PhotoLab 8\\DxO.PhotoLab.exe"
>>>>>>             00005218 46887.98828125 11348 digikam.general:
>>>>>>             Resolved file path: "E:\\Applications\\GIMP
>>>>>>             3\\bin\\gimp-3.exe"
>>>>>>
>>>>>>             As DXO, Corel, or ON1 ???
>>>>>             but where DK is finding those path? every applications
>>>>>             shown int path "C:\\Program Files\" doesn't exist anymore
>>>>>
>>>>>
>>>>>         It's the information reported by the Window API, typically
>>>>>         stored in the registration database. Sounds like the
>>>>>         uninstallation of these applications has been dirty done.
>>>>>
>>>>>>
>>>>>>             And finally:
>>>>>>
>>>>>>             00082665 305921.93750000 11348 digikam.dbengine:
>>>>>>             Detected locked database file. There is an active
>>>>>>             transaction. Waited but giving up now.
>>>>>>             00082666 305921.93750000 11348 digikam.dbengine:
>>>>>>             Failure executing query:
>>>>>>             00082667 305921.93750000 11348 "INSERT OR IGNORE INTO
>>>>>>             ImageInformation ( imageid, rating, creationDate,
>>>>>>             digitizationDate, orientation, width, height, format,
>>>>>>             colorDepth, colorModel ) VALUES ( :0, :1, :2, :3, :4,
>>>>>>             :5, :6, :7, :8, :9 );"
>>>>>>             00082668 305921.93750000 11348 Error messages:
>>>>>>             "Impossible de récupérer la ligne" "database is
>>>>>>             locked" "5" 1
>>>>>>             00082669 305921.93750000 11348 Bound values:
>>>>>>              QList(QVariant(qlonglong, 128219), QVariant(int, 1),
>>>>>>             QVariant(QDateTime, QDateTime(2020-09-08 19:12:00.000
>>>>>>             UTC+2 Qt::LocalTime)), QVariant(QDateTime,
>>>>>>             QDateTime(2020-09-08 19:12:00.000 UTC+2
>>>>>>             Qt::LocalTime)), QVariant(int, 1), QVariant(int,
>>>>>>             4608), QVariant(int, 3456), QVariant(QString, "JPG"),
>>>>>>             QVariant(int, 8), QVariant(int, 5))
>>>>>>             00082670 305921.93750000 11348 digikam.dbengine:
>>>>>>             Error while executing DBAction [
>>>>>>             "changeItemInformation" ] Statement [ "INSERT OR
>>>>>>             IGNORE INTO ImageInformation ( imageid, :fieldList )
>>>>>>             VALUES ( :id, :valueList );" ]
>>>>>>             00082671 305921.93750000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 0
>>>>>>             00082672 305922.03125000 11348 digikam.geoiface: ----
>>>>>>             00082673 305922.03125000 11348 digikam.geoiface: ----
>>>>>>             00082674 305922.03125000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 9750
>>>>>>             00082675 305922.06250000 11348 digikam.geoiface: ----
>>>>>>             00082676 305922.06250000 11348 digikam.geoiface: ----
>>>>>>             00082677 305922.18750000 11348 digikam.geoiface: ----
>>>>>>             00082678 305922.18750000 11348 digikam.geoiface: ----
>>>>>>             00082679 305922.21875000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 250
>>>>>>             00082680 305922.21875000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 250
>>>>>>             00082681 305922.28125000 11348 digikam.geoiface: ----
>>>>>>             00082682 305922.28125000 11348 digikam.geoiface: ----
>>>>>>             00082683 305922.34375000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 250
>>>>>>             00082684 305922.43750000 11348 digikam.geoiface: ----
>>>>>>             00082685 305922.46875000 11348 digikam.geoiface: ----
>>>>>>             00082686 305922.46875000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 250
>>>>>>             00082687 305922.71875000 11348 digikam.geoiface: ----
>>>>>>             00082688 305922.71875000 11348 digikam.geoiface: ----
>>>>>>             00082689 305922.78125000 11348 digikam.geoiface: ----
>>>>>>             00082690 305922.78125000 11348 digikam.geoiface: ----
>>>>>>             00082691 305922.90625000 11348 digikam.geoiface: ----
>>>>>>             00082692 305922.90625000 11348 digikam.geoiface: ----
>>>>>>             00082693 305922.93750000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 500
>>>>>>             00082694 305923.06250000 11348 digikam.geoiface: ----
>>>>>>             00082695 305923.06250000 11348 digikam.geoiface: ----
>>>>>>             00082696 305923.06250000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 750
>>>>>>             00082697 305923.18750000 11348 digikam.geoiface: ----
>>>>>>             00082698 305923.18750000 11348 digikam.geoiface: ----
>>>>>>             00082699 305923.18750000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 10000
>>>>>>             00082700 305923.21875000 11348 digikam.dbengine:
>>>>>>             Detected locked database file. There is an active
>>>>>>             transaction. Waited but giving up now.
>>>>>>             00082701 305923.21875000 11348 digikam.dbengine:
>>>>>>             Failure executing query:
>>>>>>             00082702 305923.21875000 11348 "INSERT OR IGNORE INTO
>>>>>>             ImageInformation ( imageid, rating, creationDate,
>>>>>>             digitizationDate, orientation, width, height, format,
>>>>>>             colorDepth, colorModel ) VALUES ( :0, :1, :2, :3, :4,
>>>>>>             :5, :6, :7, :8, :9 );"
>>>>>>             00082703 305923.21875000 11348 Error messages:
>>>>>>             "Impossible de récupérer la ligne" "database is
>>>>>>             locked" "5" 1
>>>>>>             00082704 305923.21875000 11348 Bound values:
>>>>>>              QList(QVariant(qlonglong, 349804), QVariant(int, 1),
>>>>>>             QVariant(QDateTime, QDateTime(2024-04-25 19:13:18.000
>>>>>>             UTC+2 Qt::LocalTime)), QVariant(QDateTime,
>>>>>>             QDateTime(2024-04-25 19:13:18.000 UTC+2
>>>>>>             Qt::LocalTime)), QVariant(int, 1), QVariant(int,
>>>>>>             5464), QVariant(int, 3640), QVariant(QString, "JPG"),
>>>>>>             QVariant(int, 8), QVariant(int, 5))
>>>>>>             00082705 305923.21875000 11348 digikam.dbengine:
>>>>>>             Error while executing DBAction [
>>>>>>             "changeItemInformation" ] Statement [ "INSERT OR
>>>>>>             IGNORE INTO ImageInformation ( imageid, :fieldList )
>>>>>>             VALUES ( :id, :valueList );" ]
>>>>>>             00082706 305923.21875000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 0
>>>>>>             00082707 305923.25000000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 500
>>>>>>             00082708 305923.37500000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 250
>>>>>>             00082709 305923.46875000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 10000
>>>>>>             00082710 305923.50000000 11348 digikam.dbengine:
>>>>>>             Detected locked database file. There is an active
>>>>>>             transaction. Waited but giving up now.
>>>>>>             00082711 305923.50000000 11348 digikam.dbengine:
>>>>>>             Failure executing query:
>>>>>>             00082712 305923.50000000 11348 "DELETE FROM
>>>>>>             ImagePositions WHERE imageid=:0;"
>>>>>>             00082713 305923.50000000 11348 Error messages:
>>>>>>             "Impossible de récupérer la ligne" "database is
>>>>>>             locked" "5" 1
>>>>>>             00082714 305923.50000000 11348 Bound values:
>>>>>>              QList(QVariant(qlonglong, 149838))
>>>>>>             00082715 305923.50000000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 0
>>>>>>             00082716 305923.53125000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 500
>>>>>>             00082717 305923.56250000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 500
>>>>>>             00082718 305923.59375000 11348 digikam.dbengine:
>>>>>>             Database is locked. Waited 500
>>>>>>
>>>>>>             Why is the database locked here? Perhaps a file
>>>>>>             descriptor open take rights on the sqlite files and
>>>>>>             block access to digiKam, or something like that. The AV ?
>>>>>             seems the reason of freezing, as this never end.
>>>>>             Using Defender
>>>>>
>>>>>
>>>>>         Defender is a pain on Windows. I remember the VLC team's
>>>>>         post one week ago about the time latency to open MP3 files
>>>>>         for playing, due to the AV lock.
>>>>>
>>>>>         https://pcmasterinsider.com/vlc-windows-11-microsoft-defender-startup-delay/
>>>>>
>>>>>         Windows is definitely so far to be used safety for a
>>>>>         production usages (this is my viewpoint, i'm using
>>>>>         Linux and macOS)
>>>>>
>>>>>         Best regards
>>>>>
>>>>>         Gilles Caulier
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20260903/ee3b681d/attachment-0001.htm>


More information about the Digikam-users mailing list