pending synchonization at restart
Gilles Caulier
caulier.gilles at gmail.com
Tue Sep 1 11:53:53 BST 2026
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 <+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 <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 <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/20260901/bea7d7d1/attachment-0001.htm>
More information about the Digikam-users
mailing list