pending synchonization at restart
Gilles Caulier
caulier.gilles at gmail.com
Mon Aug 31 15:51:02 BST 2026
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/20260831/503336ac/attachment-0001.htm>
More information about the Digikam-users
mailing list