pending synchonization at restart
frederic chaume
frederic.chaume at gmail.com
Mon Aug 31 17:07:17 BST 2026
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/20260831/fe0e6b6c/attachment-0001.htm>
More information about the Digikam-users
mailing list