pending synchonization at restart
frederic chaume
frederic.chaume at gmail.com
Tue Sep 1 10:29:04 BST 2026
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/20260901/d9115b57/attachment-0001.htm>
More information about the Digikam-users
mailing list