[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #81 from Petr Schonmann --- Ive tested digiKam-8.4.0-20240512T090210-Qt6-x86-64.appimage and seems the problem gone Im getting this query fyi 2024-05-20 18:33:59.244565 Digikam::ItemLister::listImageTagPropertySearch: Search query: 2024-05-20 18:33:59.244585 "SELECT DISTINCT Images.id, Images.name, Images.album,Albums.albumRoot,ImageInformation.rating, Images.category,ImageInformation.format, ImageInformation.creationDate, Images.modificationDate, Images.fileSize,ImageInformation.width, ImageInformation.height,ImageTagProperties.value, ImageTagProperties.property, ImageTagProperties.tagid FROM ImagesINNER JOIN ImageTagProperties ON ImageTagProperties.imageid=Images.idLEFT JOIN ImageInformation ON Images.id=ImageInformation.imageidINNER JOIN Albums ON Albums.id=Images.album WHERE Images.status=1 AND ( ( ( ImageTagProperties.tagid=? AND ImageTagProperties.property=? ) OR ( ImageTagProperties.tagid=? AND ImageTagProperties.property=? ) OR ( ImageTagProperties.tagid=? AND ImageTagProperties.property=? ) OR ( ImageTagProperties.tagid=? AND ImageTagProperties.property=? ) ) );" 2024-05-20 18:33:59.244608 QList(QVariant(int, 4538), QVariant(QString, "autodetectedPerson"), QVariant(int, 4538), QVariant(QString, "autodetectedFace"), QVariant(int, 4538), QVariant(QString, "ignoredFace"), QVariant(int, 4538), QVariant(QString, "tagRegion")) -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #80 from Maik Qualmann --- Can you please test the current AppImage to see if anything has changed with the problem? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #79 from Maik Qualmann --- Git commit 52cd672878919ed58cd28dbfa1cdf9316dc25f21 by Maik Qualmann. Committed on 11/05/2024 at 17:07. Pushed by mqualmann into branch 'master'. check for a valid index M +36 -18 core/app/items/views/digikamitemview.cpp https://invent.kde.org/graphics/digikam/-/commit/52cd672878919ed58cd28dbfa1cdf9316dc25f21 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #78 from Petr Schonmann --- Created attachment 169370 --> https://bugs.kde.org/attachment.cgi?id=169370=edit debug_log_20240511_010111.txt -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #77 from Maik Qualmann --- A new AppImage with more debug output is available, can you please create a new log? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #76 from Maik Qualmann --- Git commit 16a6c642968ff07cc097ac16283a904029d11a7b by Maik Qualmann. Committed on 08/05/2024 at 06:06. Pushed by mqualmann into branch 'master'. add more face engine debug M +2-2core/libs/database/tags/facetagseditor.cpp M +6-0core/utilities/facemanagement/workers/databasewriter.cpp M +1-1core/utilities/facemanagement/workers/trainerworker.cpp https://invent.kde.org/graphics/digikam/-/commit/16a6c642968ff07cc097ac16283a904029d11a7b -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #75 from Maik Qualmann --- Git commit 008d086ff3b2a850973ad4ebf23f4e6c49c1 by Maik Qualmann. Committed on 06/05/2024 at 20:21. Pushed by mqualmann into branch 'master'. this should also be a QExplicitlySharedDataPointer and add test debug M +2-2core/libs/database/item/containers/itemtagpair.cpp M +2-1core/libs/database/tags/facetagseditor.cpp M +2-2core/utilities/facemanagement/workers/trainerworker.cpp https://invent.kde.org/graphics/digikam/-/commit/008d086ff3b2a850973ad4ebf23f4e6c49c1 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #74 from Petr Schonmann --- Created attachment 169248 --> https://bugs.kde.org/attachment.cgi?id=169248=edit debug_digiKam-8.4.0-20240505T093946-Qt6-x86-64.txt -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #73 from Maik Qualmann --- Git commit ba72a838c6287bce85bcc30c4fd23e80659567fc by Maik Qualmann. Committed on 05/05/2024 at 08:01. Pushed by mqualmann into branch 'master'. Revert "the FaceTagsIface can be override" M +1-1core/libs/database/tags/facetagsiface.h M +1-1core/utilities/facemanagement/threads/facepipelinepackage.h https://invent.kde.org/graphics/digikam/-/commit/ba72a838c6287bce85bcc30c4fd23e80659567fc -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #72 from Maik Qualmann --- Ok, the cause is probably the virtual deconstructor, I can undo this. Objects in a QList should/must be copable and contain an assignment operator. Otherwise the compiler makes a default assignment operator, so the object in the QList would point to the same memory as the original object. This can lead to problems. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #71 from caulier.gil...@gmail.com --- Maik, With the commit from the comment 60, i think you introduce a potential slicing problem in classes FaceTagsIface and FacePipelineFaceTagsIface. https://github.com/KDE/clazy/blob/master/docs/checks/README-copyable-polymorphic.md See the tab Copyable Polymorphic from the last Clazy report : https://files.kde.org/digikam/reports/clazy_master.tar.xv Gilles -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #70 from Maik Qualmann --- Can you please test the current AppImage? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #69 from Maik Qualmann --- Git commit af2d341a7dd489dc8c5b324a303e8156d11a4404 by Maik Qualmann. Committed on 03/05/2024 at 10:41. Pushed by mqualmann into branch 'master'. remove items from model after face editing M +10 -10 core/app/items/views/digikamitemview.cpp https://invent.kde.org/graphics/digikam/-/commit/af2d341a7dd489dc8c5b324a303e8156d11a4404 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #68 from Maik Qualmann --- Are you using multicore option in the face engine settings of the people view? Please deactivate it once, restart if necessary and see if the problem also occurs. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #67 from Petr Schonmann --- Created attachment 169116 --> https://bugs.kde.org/attachment.cgi?id=169116=edit digikam_debug_467766_2024-05-02-another_debug_day.txt -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #66 from Maik Qualmann --- Another AppImage is available, please test again with debug log. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #65 from Maik Qualmann --- Git commit e917a7e1e913f23ca290280b39dbcb4df1f0e82e by Maik Qualmann. Committed on 02/05/2024 at 10:29. Pushed by mqualmann into branch 'master'. add assignment operator to FacePipelineFaceTagsIface M +14 -0core/utilities/facemanagement/threads/facepipelinepackage.cpp M +2-0core/utilities/facemanagement/threads/facepipelinepackage.h https://invent.kde.org/graphics/digikam/-/commit/e917a7e1e913f23ca290280b39dbcb4df1f0e82e -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #64 from Maik Qualmann --- Git commit ce8f53dfcfdd07adf2de473265f854fba2047e2c by Maik Qualmann. Committed on 01/05/2024 at 20:28. Pushed by mqualmann into branch 'master'. add test debug for FaceTagsIface M +2-1core/utilities/facemanagement/workers/trainerworker.cpp https://invent.kde.org/graphics/digikam/-/commit/ce8f53dfcfdd07adf2de473265f854fba2047e2c -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #63 from Petr Schonmann --- Created attachment 169083 --> https://bugs.kde.org/attachment.cgi?id=169083=edit digikam_debug_467766_2024-01-05-first_okay_second_not.txt -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #62 from Petr Schonmann --- Hi, i tried with new release digiKam-8.4.0-20240501T135922-Qt6-x86-64.appimage the first attempt was fine, no error, second, same error. Details in logs attached -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #61 from Maik Qualmann --- A new AppImage is available, can you please test whether the problem can still be reproduced? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #60 from Maik Qualmann --- Git commit 0f08fe600380954785a8a1dc65be3c09568b2548 by Maik Qualmann. Committed on 30/04/2024 at 20:35. Pushed by mqualmann into branch 'master'. add copy constructor and assignment operator to FaceTagsIface M +18 -0core/libs/database/tags/facetagsiface.cpp M +3-0core/libs/database/tags/facetagsiface.h https://invent.kde.org/graphics/digikam/-/commit/0f08fe600380954785a8a1dc65be3c09568b2548 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #59 from Petr Schonmann --- Created attachment 169046 --> https://bugs.kde.org/attachment.cgi?id=169046=edit digikam_debug_467766_2024-04-30-without-write-metadata.txt -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #58 from Maik Qualmann --- Yes, disable all 9 write options in the metadata settings. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #57 from Petr Schonmann --- Im not sure how to do that. Just uncheck in metadata configuration TAB Behavior all checked field and Sidecars uncheck write too ? Is it all setting which you need ? Or just which values in digikamrc to toggle would be fine too. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #56 from Maik Qualmann --- The test debug entry shows nothing unusual. As a test, can you please deactivate all metadata write options so that nothing is written to an image or sidecar? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #55 from Petr Schonmann --- Created attachment 168981 --> https://bugs.kde.org/attachment.cgi?id=168981=edit debuglog -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #54 from Petr Schonmann --- Tried with digiKam-8.4.0-20240428T104713-Qt6-x86-64.appimage Its attached, we exceed 64k limit comment :) -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #53 from Maik Qualmann --- @Petr, can you please create a new debug log with the current AppImage? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #52 from caulier.gil...@gmail.com --- It's under Progress... Gilles -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #51 from Maik Qualmann --- @Gilles, a new AppImage would be good. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #50 from Maik Qualmann --- Git commit c182425929dafc5339e964e13e887f01b09ef5b6 by Maik Qualmann. Committed on 28/04/2024 at 10:38. Pushed by mqualmann into branch 'master'. add Test debug for bug 467766 M +3-1core/libs/database/collection/collectionscanner_scan.cpp https://invent.kde.org/graphics/digikam/-/commit/c182425929dafc5339e964e13e887f01b09ef5b6 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #49 from Petr Schonmann --- Synology Drive Client is the desktop utility that provides file syncing and personal computer backup services on multiple client computers to a centralized server, Synology Drive Server. https://kb.synology.com/en-us/DSM/help/SynologyDriveClient/synologydriveclient?version=7 It act like other cloud clients. Its two way sync. If something changes on localhost, its uploaded to server, when something changed on server its pushed to localhost. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #48 from Maik Qualmann --- The sidecar file without the "jpg" extension comes from a sidecar setting "Sidecar filenames compatible with commercial programs". You probably activated this option at some point. But it doesn't matter for this problem, digiKam uses the sidecar depending on the setting. How should I imagine the Synology app, does it monitor the collection? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #47 from Petr Schonmann --- Created attachment 168919 --> https://bugs.kde.org/attachment.cgi?id=168919=edit Dsc00743.jpg.xmp -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #46 from Petr Schonmann --- Created attachment 168918 --> https://bugs.kde.org/attachment.cgi?id=168918=edit Dsc00743.xmp -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #45 from Petr Schonmann --- Collection is not currently on network drive. This is for a historical reason and I haven't changed the configuration yet. In past, collection was on network drive. Reading / Writing was slow - then i moved collection to ssd on localhost and just bind from synology drive app ( something like dropbox, onedrive )) The /data is btrfs if matters. /data/SynologyDrive/Photos /mnt/snorlax/Photos none defaults,bind 0 0 I can change to local collection from network share if this can cause the problem. Ive observed that file have ?? 2 sidecars ?? Can this be cause of our problems ? pschonmann@E495:~$ ls '/mnt/snorlax/Photos/Peta/!Jecna/Zeema/Laborky/Dsc00743'* -1 -lsah 88K -rw-r--r-- 1 pschonmann pschonmann 86K Jan 18 07:03 '/mnt/snorlax/Photos/Peta/!Jecna/Zeema/Laborky/Dsc00743.jpg' 8.0K -rw-r--r-- 1 pschonmann pschonmann 8.0K Jan 18 07:03 '/mnt/snorlax/Photos/Peta/!Jecna/Zeema/Laborky/Dsc00743.jpg.xmp' 8.0K -rw-r--r-- 1 pschonmann pschonmann 6.7K Feb 25 2023 '/mnt/snorlax/Photos/Peta/!Jecna/Zeema/Laborky/Dsc00743.xmp' Ill attach them after this post. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #44 from Maik Qualmann --- My guess is a problem with your network drive. Everything is OK until the sidecar file is written. We then re-read the metadata. Now the ItemInfo image ID== 0. I suspect that the network drive is no longer readable within a small time window. The fact that ExifTool can no longer load the metadata from the next image also indicates this. I would suspect some kind of client or file lock on the NAS, something like that is configurable on some NAS drives. A test would be to copy the collection to a USB drive or local hard drive and simply switch to this collection using the update function in the digiKam collection settings to see whether the problem occurs. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #43 from Petr Schonmann --- pschonmann@E495:~$ digikam -- digiKam Linux AppImage Bundle -- Use 'help' as CLI argument to know all available options for digiKam application. -- Notes: to integrate this bundle to your desktop, use AppImageLauncher. --to enable all debug messages on the console, use 'export QT_LOGGING_RULES="digikam*=true"'. --to extract the bundle contents locally, use option '--appimage-extract' on the command line. awk: cmd. line:1: warning: command line argument `/etc/upstream-release' is a directory: skipped awk: cmd. line:1: warning: command line argument `/etc/upstream-release' is a directory: skipped -- Detected host Linux linuxmint-64-21.3 -- AppImage mounted directory: /tmp/.mount_digiKaj0Nf6t Check library libudev.so.0 Check library libxcb-dri3.so.0 Check library libcrypto.so.1.1 Check library libssl.so.1.1 Check library libnss3.so Check library libnssutil3.so Check library libsmime3.so Check library libgmodule-2.0.so.0 Check library libgnutls.so.30 Check library libnettle.so.8 -- Preloading shared libs: :/usr/lib/x86_64-linux-gnu/libxcb-dri3.so.0:/usr/lib/x86_64-linux-gnu/libnss3.so:/usr/lib/x86_64-linux-gnu/libnssutil3.so:/usr/lib/x86_64-linux-gnu/libsmime3.so:/usr/lib/x86_64-linux-gnu/libgmodule-2.0.so.0:/usr/lib/x86_64-linux-gnu/libgnutls.so.30:/usr/lib/x86_64-linux-gnu/libnettle.so.8 Digikam::DXmlGuiWindow::setupIconTheme: Breeze icons resource file found Digikam::DXmlGuiWindow::setupIconTheme: Breeze-dark icons resource file found Digikam::unloadQtTranslationFiles: Qt standard translations removed: 8 Digikam::loadStdQtTranslationFiles: Qt standard translations path: "/tmp/.mount_digiKaj0Nf6t/usr/share/digikam/translations" Digikam::loadStdQtTranslationFiles: Language set to: "en_US" Digikam::loadStdQtTranslationFiles: Loaded Qt standard translations "en_US" from catalog "qt" Digikam::loadStdQtTranslationFiles: Loaded Qt standard translations "en_US" from catalog "qtbase" Digikam::loadStdQtTranslationFiles: Loaded Qt standard translations "en_US" from catalog "qtdeclarative" Digikam::loadStdQtTranslationFiles: Loaded Qt standard translations "en_US" from catalog "qtwebengine" Digikam::loadEcmQtTranslationFiles: Loaded Qt ECM translations "en" from catalog "kcoreaddons6_qt" Digikam::loadEcmQtTranslationFiles: Loaded Qt ECM translations "en" from catalog "kwidgetsaddons6_qt" Digikam::ApplicationSettings::setApplicationStyle: Switch to widget style: "" Digikam::ApplicationSettings::setApplicationFont: Switch to application font: QFont(Ubuntu,10,-1,5,400,0,0,0,0,0,0,0,0,0,0,1) Digikam::AlbumWatch::AlbumWatch: AlbumWatch use QFileSystemWatcher Digikam::AlbumManager::setDatabase: Database Parameters: Type:"QMYSQL" DB Core Name:"digikam" DB Thumbs Name: "digikam" DB Face Name:"digikam" DB Similarity Name: "digikam" Connect Options: "" Host Name: "db.lan" Host Port: 3306 WAL Mode:false Internal Server: false Internal Server Path:"" Internal Server Init Cmd:"" Internal Server Admin Cmd: "" Internal Server Program Cmd: "" Internal Server Upgrade Cmd: "" Username:"digikam" Password:"X" Digikam::DbEngineConfigSettingsLoader::readConfig: Loading SQL code from config file "/tmp/.mount_digiKaj0Nf6t/usr/share/digikam/database/dbconfig.xml" Digikam::DbEngineConfigSettingsLoader::readConfig: Checking XML version ID => expected: 3 found: 3 Digikam::CoreDbSchemaUpdater::update: Core database: running schema update Digikam::CoreDbSchemaUpdater::startUpdates: Core database: have a structure version 16 Digikam::CoreDbSchemaUpdater::makeUpdates: Core database: makeUpdates 16 to 16 Digikam::AlbumRootLocation::AlbumRootLocation: Creating new Location "/" uuid "networkshareid:?mountpath=/mnt/snorlax/Photos=6c90e74c-e7aa-4d07-bbe2-f8fee1ea3dbe" Digikam::CollectionManager::Private::getCollectionUUID: Found Location "/mnt/snorlax/Photos" with file uuid "6c90e74c..." Digikam::CollectionManager::updateLocations: Location for "/mnt/snorlax/Photos" is available: true => case sensitivity: 2 Digikam::LoadingCache::setCacheSize: Allowing a cache size of 891 MB Digikam::ThumbsDb::getSetting: ThumbDB SelectThumbnailSetting val ret = 0 Digikam::ThumbsDb::getSetting: ThumbDB SelectThumbnailSetting val ret = 0 Digikam::ThumbsDbSchemaUpdater::startUpdates: Thumbs database: have a structure version "3" Digikam::ThumbnailLoadThread::initializeThumbnailDatabase: Thumbnails database ready for use Digikam::SimilarityDb::getSetting: SimilarityDb SelectSimilaritySetting val ret = 0 Digikam::SimilarityDb::getSetting: SimilarityDb SelectSimilaritySetting val ret = 0 Digikam::SimilarityDbSchemaUpdater::startUpdates: Similarity database: have a structure version "1"
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #42 from Maik Qualmann --- I'm referring to the log from Comment 19. Your collection is not available at startup, after the first database query/item listing there is a Solid event and the collection becomes available. That's a strange behavior. A current complete log from the beginning would be good. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #41 from Maik Qualmann --- Git commit d472489b5457710d44c83ed6bac61c795e607646 by Maik Qualmann. Committed on 25/04/2024 at 19:18. Pushed by mqualmann into branch 'master'. show an error icon if the collection/album root is not available Related: bug 481888, bug 438845 M +17 -0core/libs/album/engine/albumthumbnailloader.cpp M +1-0core/libs/album/engine/albumthumbnailloader.h https://invent.kde.org/graphics/digikam/-/commit/d472489b5457710d44c83ed6bac61c795e607646 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #40 from Maik Qualmann --- I see in an old log that you uploaded here that your collection is not available for digiKam! Go to the digiKam collection settings and use the update function (round circle icon tool button) for the collection. Basically just confirm everything. Digikam::CollectionManager::updateLocations: location for "/mnt/snorlax/Photos" is available: false => case sensitivity: 1 Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #39 from Maik Qualmann --- No, these characters are allowed in file names. Can you post the beginning of the digiKam start as a log? Until the plugins load is sufficient. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766
--- Comment #38 from Petr Schonmann ---
Yeap, library is online and accessible
pschonmann@E495:~$ ls -lsah '/mnt/snorlax/Photos/Peta/!Jecna/lab7.jpg'
96K -rw-r--r-- 1 pschonmann pschonmann 94K Jan 18 05:52
'/mnt/snorlax/Photos/Peta/!Jecna/lab7.jpg'
Isnt problem in the exclamation mark or ( underscore #c31 ) or any nonaplhanum
char and escaping somewhere ?
Digikam::DMetadata::load: Loading metadata with "Exiv2" backend from
"/mnt/snorlax/Photos/Peta/!Jecna/lab7.jpg"
Digikam::DMetadata::setItemFacesMap: Set face region: 0.28375 0.141667 0.29625
0.516667
Digikam::DMetadata::setItemFacesMap: => set tag name: true
Digikam::DMetadata::setItemFacesMap: => set tag type: true
Digikam::DMetadata::setItemFacesMap: => set area struct: true
Digikam::DMetadata::setItemFacesMap: => set xpos: true
Digikam::DMetadata::setItemFacesMap: => set ypos: true
Digikam::DMetadata::setItemFacesMap: => set width: true
Digikam::DMetadata::setItemFacesMap: => set height: true
Digikam::DMetadata::setItemFacesMap: => set unit: true
Digikam::DMetadata::setItemFacesMap: Set face region: 0.675 0.368333 0.03875
0.065
Digikam::DMetadata::setItemFacesMap: => set tag name: true
Digikam::DMetadata::setItemFacesMap: => set tag type: true
Digikam::DMetadata::setItemFacesMap: => set area struct: true
Digikam::DMetadata::setItemFacesMap: => set xpos: true
Digikam::DMetadata::setItemFacesMap: => set ypos: true
Digikam::DMetadata::setItemFacesMap: => set width: true
Digikam::DMetadata::setItemFacesMap: => set height: true
Digikam::DMetadata::setItemFacesMap: => set unit: true
Digikam::MetadataHub::writeTags: Writing tags
Digikam::MetadataHub::writeTags: -- New Keywords
QList("Škola Tags", "Lukáš Zich", "Lidé", "Ječná", "Škola", "Jan Vašík")
Digikam::MetaEngine::setIptcKeywords:
"/mnt/snorlax/Photos/Peta/!Jecna/lab7.jpg" ==> New Iptc Keywords:
QList("Škola Tags", "Ječná", "Jan Vašík", "Lukáš Zich", "Škola", "Lidé")
Digikam::MetaEngine::save: MetaEngine::metadataWritingMode 1
Digikam::MetaEngine::save: Will write XMP sidecar for file "lab7.jpg"
Digikam::MetaEngine::Private::saveUsingExiv2: wroteComment: false
Digikam::MetaEngine::Private::saveUsingExiv2: wroteEXIF: true
Digikam::MetaEngine::Private::saveUsingExiv2: wroteIPTC: true
Digikam::MetaEngine::Private::saveUsingExiv2: wroteXMP: true
Digikam::MetaEngine::Private::saveUsingExiv2: File time stamp restored
Digikam::MetaEngine::save: Metadata for file "lab7.jpg" written to XMP sidecar.
Digikam::ItemMarkerTiler::slotSourceModelReset:
Digikam::ItemTagPairPriv::createGuarded: Attempt to create invalid tag pair
image id 0 tag id 295
Digikam::FaceUtils::identityForTag: Found FacesEngine identity 2084 for tag 295
Digikam::ItemTagPairPriv::createGuarded: Attempt to create invalid tag pair
image id 0 tag id 0
Digikam::FacialRecognitionWrapper::Private::trainIdentityBatch: Training 1
images for identity 2084
Digikam::RecognitionPreprocessor::Private::preprocess: Align face for OpenFace
neural network model
Digikam::OpenfacePreprocessor::process: type: 16
Digikam::OpenfacePreprocessor::process: Full object detection and landmard
computation finished
Digikam::OpenfacePreprocessor::process: Align face finished
Digikam::DNNFaceExtractor::getFaceEmbedding: Finish aligning face in 10 ms
Digikam::DNNFaceExtractor::getFaceEmbedding: Start neural network
Digikam::ItemTagPairPriv::createGuarded: Attempt to create invalid tag pair
image id 0 tag id 4538
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"INSERT INTO ImageTagProperties (imageid, tagid, property, value) VALUES(?, ?,
?, ?);"
Error messages: "QMYSQL: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`,
CONSTRAINT `ImageTagProperties_Images` FOREIGN KEY (`imageid`) REFERENCES
`Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" "1452" 2
Bound values: QList(QVariant(qlonglong, 0), QVariant(int, 295),
QVariant(QString, "tagRegion"), QVariant(QString, ""))
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"INSERT INTO ImageTagProperties (imageid, tagid, property, value) VALUES(?, ?,
?, ?);"
Error messages: "QMYSQL: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`,
CONSTRAINT `ImageTagProperties_Images` FOREIGN KEY (`imageid`) REFERENCES
`Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" "1452" 2
Bound values: QList(QVariant(qlonglong, 0), QVariant(int, 295),
QVariant(QString, "faceToTrain"), QVariant(QString, ""))
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"REPLACE INTO ImageTags (imageid, tagid) VALUES(?, ?);"
Error messages: "QMYSQL: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #37 from Maik Qualmann --- These messages from your last log are strange. You also write sidecar to JPG files, but this doesn't report any errors. Afterwards Exiftool cannot find the (original) file and an empty file path is reported. Is all your collection “online”? Digikam::ExifToolParser::exifToolAvailable: Check ExifTool availability: true Digikam::ExifToolParser::loadChunk: Cannot open source file to process with ExifTool... Digikam::DMetadata::loadUsingExifTool: Load metadata using ExifTool failed... Digikam::DMetadata::load: Loading metadata with "No Backend" backend from "" Digikam::MetadataHub::writeTags: Writing tags Digikam::MetadataHub::writeTags: Delete all keywords Digikam::MetaEngine::setIptcKeywords: "" ==> New Iptc Keywords: QList() Digikam::MetaEngine::applyChanges: Failed to apply changes: file path is empty! Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #36 from Petr Schonmann --- Created attachment 168772 --> https://bugs.kde.org/attachment.cgi?id=168772=edit Fresh DB from DK8.4.0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #35 from Petr Schonmann --- Created attachment 168771 --> https://bugs.kde.org/attachment.cgi?id=168771=edit Actual DB scheme -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #34 from Petr Schonmann --- Tried to change collation on tables, no change, still getting error. digikam.sql is my database schema after change digikam2.sql is newly created database in digikam 8.4.0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #33 from Petr Schonmann --- Probably found that tables have bad collation, db not *** mysql> SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'digikam' LIMIT 1; ++ | DEFAULT_COLLATION_NAME | ++ | utf8mb4_unicode_ci | ++ 1 row in set (0.00 sec) *** but the tables have utf8mb3_general_ci. Ill do alter them and lets see. *** root@db:~# for i in $(mysql -NB -D digikam -e 'show tables;');do echo -ne "$i:" && mysql -D digikam -e "show table status like \"$i\"\G" | grep Collation ;done | column -t AlbumRoots: Collation: utf8mb3_general_ci Albums: Collation: utf8mb3_general_ci CustomIdentifiers: Collation: utf8mb3_general_ci DownloadHistory: Collation: utf8mb3_general_ci FaceMatrices:Collation: utf8mb3_general_ci FaceSettings:Collation: utf8mb3_general_ci FilePaths: Collation: utf8mb3_general_ci Identities: Collation: utf8mb3_general_ci IdentityAttributes: Collation: utf8mb3_general_ci ImageComments: Collation: utf8mb3_general_ci ImageCopyright: Collation: utf8mb3_general_ci ImageHaarMatrix: Collation: utf8mb3_general_ci ImageHistory:Collation: utf8mb3_general_ci ImageInformation:Collation: utf8mb3_general_ci ImageMetadata: Collation: utf8mb3_general_ci ImagePositions: Collation: utf8mb3_general_ci ImageProperties: Collation: utf8mb3_general_ci ImageRelations: Collation: utf8mb3_general_ci ImageSimilarity: Collation: utf8mb3_general_ci ImageTagProperties: Collation: utf8mb3_general_ci ImageTags: Collation: utf8mb3_general_ci Images: Collation: utf8mb3_general_ci KDTree: Collation: utf8mb3_general_ci Searches:Collation: utf8mb3_general_ci Settings:Collation: utf8mb3_general_ci SimilaritySettings: Collation: utf8mb3_general_ci TagProperties: Collation: utf8mb3_general_ci Tags:Collation: utf8mb3_general_ci TagsTree:Collation: utf8mb3_general_ci ThumbSettings: Collation: utf8mb3_general_ci Thumbnails: Collation: utf8mb3_general_ci UniqueHashes:Collation: utf8mb3_general_ci VideoMetadata: Collation: utf8mb3_general_ci *** -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #32 from Maik Qualmann --- You sent me your database and I couldn't reproduce it with it. However, you are using your database with utf8mb4 and then the index might be too small to uniquely resolve entries. So far we have undone tests with utf8mb4 because there were problems. For utf8mb4 there are only 2 solutions, if it is really needed, either additional hash columns or require current MariaDB version to support larger index values. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 caulier.gil...@gmail.com changed: What|Removed |Added Version|8.2.0 |8.4.0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766
--- Comment #31 from Petr Schonmann ---
Yes, still reproducible. For example.
Digikam::DMetadata::load: Loading metadata with "Exiv2" backend from
"/mnt/snorlax/Photos/Peta/_TELEFON/2023/PXL_20230506_110913832.jpg"
Digikam::DMetadata::setItemFacesMap: Set face region: 0.367808 0.201058
0.120288 0.213404
Digikam::DMetadata::setItemFacesMap: => set tag name: true
Digikam::DMetadata::setItemFacesMap: => set tag type: true
Digikam::DMetadata::setItemFacesMap: => set area struct: true
Digikam::DMetadata::setItemFacesMap: => set xpos: true
Digikam::DMetadata::setItemFacesMap: => set ypos: true
Digikam::DMetadata::setItemFacesMap: => set width: true
Digikam::DMetadata::setItemFacesMap: => set height: true
Digikam::DMetadata::setItemFacesMap: => set unit: true
Digikam::MetadataHub::writeTags: Writing tags
Digikam::MetadataHub::writeTags: -- New Keywords
QList("Lenka Trčková")
Digikam::MetaEngine::setIptcKeywords:
"/mnt/snorlax/Photos/Peta/_TELEFON/2023/PXL_20230506_110913832.jpg" ==> New
Iptc Keywords: QList("Lenka Trčková")
Digikam::MetaEngine::save: MetaEngine::metadataWritingMode 1
Digikam::MetaEngine::save: Will write XMP sidecar for file
"PXL_20230506_110913832.jpg"
Digikam::MetaEngine::Private::saveUsingExiv2: wroteComment: false
Digikam::MetaEngine::Private::saveUsingExiv2: wroteEXIF: true
Digikam::MetaEngine::Private::saveUsingExiv2: wroteIPTC: true
Digikam::MetaEngine::Private::saveUsingExiv2: wroteXMP: true
Digikam::MetaEngine::Private::saveUsingExiv2: File time stamp restored
Digikam::MetaEngine::save: Metadata for file "PXL_20230506_110913832.jpg"
written to XMP sidecar.
Digikam::ItemTagPairPriv::createGuarded: Attempt to create invalid tag pair
image id 0 tag id 55
Digikam::FaceUtils::identityForTag: Found FacesEngine identity 2023 for tag 55
Digikam::ItemTagPairPriv::createGuarded: Attempt to create invalid tag pair
image id 0 tag id 0
Digikam::ItemTagPairPriv::createGuarded: Attempt to create invalid tag pair
image id 0 tag id 4538
Digikam::FacialRecognitionWrapper::Private::trainIdentityBatch: Training 1
images for identity 2023
Digikam::RecognitionPreprocessor::Private::preprocess: Align face for OpenFace
neural network model
Digikam::OpenfacePreprocessor::process: type: 16
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"INSERT INTO ImageTagProperties (imageid, tagid, property, value) VALUES(?, ?,
?, ?);"
Error messages: "QMYSQL: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`,
CONSTRAINT `ImageTagProperties_Images` FOREIGN KEY (`imageid`) REFERENCES
`Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" "1452" 2
Bound values: QList(QVariant(qlonglong, 0), QVariant(int, 55),
QVariant(QString, "tagRegion"), QVariant(QString, ""))
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"INSERT INTO ImageTagProperties (imageid, tagid, property, value) VALUES(?, ?,
?, ?);"
Error messages: "QMYSQL: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`ImageTagProperties`,
CONSTRAINT `ImageTagProperties_Images` FOREIGN KEY (`imageid`) REFERENCES
`Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" "1452" 2
Bound values: QList(QVariant(qlonglong, 0), QVariant(int, 55),
QVariant(QString, "faceToTrain"), QVariant(QString, ""))
Digikam::OpenfacePreprocessor::process: Full object detection and landmard
computation finished
Digikam::OpenfacePreprocessor::process: Align face finished
Digikam::DNNFaceExtractor::getFaceEmbedding: Finish aligning face in 13 ms
Digikam::DNNFaceExtractor::getFaceEmbedding: Start neural network
Digikam::BdEngineBackendPrivate::debugOutputFailedQuery: Failure executing
query:
"REPLACE INTO ImageTags (imageid, tagid) VALUES(?, ?);"
Error messages: "QMYSQL: Unable to execute statement" "Cannot add or update a
child row: a foreign key constraint fails (`digikam`.`ImageTags`, CONSTRAINT
`ImageTags_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE
CASCADE ON UPDATE CASCADE)" "1452" 2
Bound values: QList(QVariant(qlonglong, 0), QVariant(int, 55))
Digikam::ExifToolParser::exifToolAvailable: Check ExifTool availability: true
Digikam::ExifToolParser::loadChunk: Cannot open source file to process with
ExifTool...
Digikam::DMetadata::loadUsingExifTool: Load metadata using ExifTool failed...
Digikam::DMetadata::load: Loading metadata with "No Backend" backend from ""
Digikam::MetadataHub::writeTags: Writing tags
Digikam::MetadataHub::writeTags: Delete all keywords
Digikam::MetaEngine::setIptcKeywords: "" ==> New Iptc Keywords: QList()
Digikam::MetaEngine::applyChanges: Failed to apply changes: file path is empty!
Digikam::ItemMarkerTiler::slotSourceModelReset:
Digikam::ExifToolParser::exifToolAvailable: Check ExifTool availability: true
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #30 from caulier.gil...@gmail.com --- Hi all, The digiKam 8.4.0 Appimage bundle pre-release is now based on last modern frameworks Qt 6.7.0 and KDE 6.2.0. File can be downloaded at usual place : https://files.kde.org/digikam/ Take a care : the bundle is named with the suffix "-Qt6" not "-Qt5". This bundle is compiled under Ubuntu 22.04 and require a Linux with GlibC version >= 2.35 to run. Can you reproduce the dysfonction with this version? Thanks in advance Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #29 from Petr Schonmann --- Here is my percona config -- root@db:~# grep -v ^# /etc/mysql/percona-server.conf.d/mysqld.cnf /etc/mysql/percona-server.conf.d/petr.cnf | grep -v :$ /etc/mysql/percona-server.conf.d/mysqld.cnf:[mysqld] /etc/mysql/percona-server.conf.d/mysqld.cnf:user = mysql /etc/mysql/percona-server.conf.d/mysqld.cnf:pid-file = /var/run/mysqld/mysqld.pid /etc/mysql/percona-server.conf.d/mysqld.cnf:socket = /var/run/mysqld/mysqld.sock /etc/mysql/percona-server.conf.d/mysqld.cnf:port = 3306 /etc/mysql/percona-server.conf.d/mysqld.cnf:basedir= /usr /etc/mysql/percona-server.conf.d/mysqld.cnf:datadir= /var/lib/mysql /etc/mysql/percona-server.conf.d/mysqld.cnf:tmpdir = /tmp /etc/mysql/percona-server.conf.d/mysqld.cnf:lc-messages-dir = /usr/share/mysql /etc/mysql/percona-server.conf.d/mysqld.cnf:explicit_defaults_for_timestamp /etc/mysql/percona-server.conf.d/mysqld.cnf:log-error= /var/log/mysql/error.log /etc/mysql/percona-server.conf.d/mysqld.cnf:sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES /etc/mysql/percona-server.conf.d/mysqld.cnf:symbolic-links=0 /etc/mysql/percona-server.conf.d/petr.cnf:[mysqld] /etc/mysql/percona-server.conf.d/petr.cnf:collation_server= utf8mb4_unicode_ci /etc/mysql/percona-server.conf.d/petr.cnf:character_set_server= utf8mb4 /etc/mysql/percona-server.conf.d/petr.cnf:tmp_table_size = 1G /etc/mysql/percona-server.conf.d/petr.cnf:max_heap_table_size = 1G /etc/mysql/percona-server.conf.d/petr.cnf:key_buffer_size = 64M /etc/mysql/percona-server.conf.d/petr.cnf:max_allowed_packet = 128M /etc/mysql/percona-server.conf.d/petr.cnf:thread_stack= 192K /etc/mysql/percona-server.conf.d/petr.cnf:thread_cache_size = 8 /etc/mysql/percona-server.conf.d/petr.cnf:innodb_file_per_table = 1 /etc/mysql/percona-server.conf.d/petr.cnf:innodb_buffer_pool_size = 2G /etc/mysql/percona-server.conf.d/petr.cnf:innodb_print_all_deadlocks /etc/mysql/percona-server.conf.d/petr.cnf:innodb_flush_log_at_trx_commit = 2 /etc/mysql/percona-server.conf.d/petr.cnf:slow_query_log = 1 /etc/mysql/percona-server.conf.d/petr.cnf:slow_query_log_file = /var/log/mysql/mysql-slow.log /etc/mysql/percona-server.conf.d/petr.cnf:long_query_time = 1 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #28 from Maik Qualmann --- Hi Petr, I haven't been able to reproduce the problem with your database backup yet. I want to examine it further over the next few days. Do I see correctly in your backup file that you are running the database with utf8mb4? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 caulier.gil...@gmail.com changed: What|Removed |Added Version|8.0.0 |8.2.0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 Petr Schonmann changed: What|Removed |Added Platform|Mint (Ubuntu based) |Appimage --- Comment #27 from Petr Schonmann --- Problem Persists in digiKam-8.2.0-20231027T110727-x86-64-debug.appimage -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #26 from Petr Schonmann --- Hey Maik ! Enjoy your meal :) This bug isnt important, your meal is ! Ill be absolutelly happy with response time 48h with that large project as digikam is. Have a nice day. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #25 from Maik Qualmann --- Thanks for the MySQL backup. I was only able to test it briefly during my lunch break. I had given names to unknown faces. There was no error message. But according to the video, the problem occurs with unconfirmed faces. I'll test it further this evening. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #24 from Petr Schonmann --- Mysqldump download link sent to mail metzping...@gmail.com -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #23 from Maik Qualmann --- To find this bug, we need to be able to reproduce the problem and debug it ourselves. Could you provide me your MySQL digiKam core database as a MySQL backup file? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #22 from Petr Schonmann --- Im waiting for your turn :) nothing changes from my side :) For better understanding, there is video. https://share.schonmann.eu/s3d36z.mp4 First tag face - that not unconfirmed for right person, i tag to the right person generate error - showed in terminal Second one is just accept the right suggested face and this didnt generate error. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #21 from caulier.gil...@gmail.com --- Petr, Any feedback here ? Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #20 from Petr Schonmann --- Same situation, log attached https://bugs.kde.org/attachment.cgi?id=161271 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #19 from Petr Schonmann --- Created attachment 161271 --> https://bugs.kde.org/attachment.cgi?id=161271=edit Log for digiKam-8.2.0-20230828T081053-x86-64.appimage -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #18 from Petr Schonmann --- Tried to migrate mariadb from nas to dedicated mysql server. Its percona8 on debian12 - testing release, but seems stable Linux db 6.1.0-11-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-4 (2023-08-08) x86_64 root@db:~# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5616 Server version: 8.0.34-26 Percona Server (GPL), Release '26', Revision '2abf525b' mysql> use digikam; Database changed mysql> show tables; ++ | Tables_in_digikam | ++ | AlbumRoots | | Albums | | CustomIdentifiers | | DownloadHistory| | FaceMatrices | | FaceSettings | | FilePaths | | Identities | | IdentityAttributes | | ImageComments | | ImageCopyright | | ImageHaarMatrix| | ImageHistory | | ImageInformation | | ImageMetadata | | ImagePositions | | ImageProperties| | ImageRelations | | ImageSimilarity| | ImageTagProperties | | ImageTags | | Images | | KDTree | | Searches | | Settings | | SimilaritySettings | | TagProperties | | Tags | | TagsTree | | ThumbSettings | | Thumbnails | | UniqueHashes | | VideoMetadata | ++ 33 rows in set (0.00 sec) Some info from Settings about DB *** 13. row *** keyword: DBVersion value: 16 *** 14. row *** keyword: DBVersionRequired value: 5 mysql> DELETE FROM ImageTagProperties WHERE imageid NOT IN (SELECT id FROM Images); Query OK, 0 rows affected (0.04 sec) There is no rows that can be deleted. Ill try 8.2.0 nightly -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #17 from Maik Qualmann --- I see that we are already cleaning up the ImageTagProperties table. Have you already run the database cleaner in the maintenance tool with the option extented clean and shrink database? You can also try the following SQL command: DELETE FROM ImageTagProperties WHERE imageid NOT IN (SELECT id FROM Images); Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #16 from Maik Qualmann --- In the "ImageTagProperties" table there is an image ID that no longer exists in "Images". I will add a corresponding function in the database cleaner tool. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #15 from caulier.gil...@gmail.com --- What’s about the 8.2.0 pre release appimage bundle ? -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #14 from Petr Schonmann --- Problem persists in 8.1.0 Appimage -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #13 from caulier.gil...@gmail.com --- Hi all, what's the next step for this entry ? Gilles -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #12 from Petr Schonmann --- from table file i removed tables which doenst contain imageid column. root@nas:~# for table in $(cat tables);do echo -n "$table : " && mysql -D digikam -NBe "SELECT count(*) FROM $table WHERE imageid IS NULL;";echo;done ImageComments : 0 ImageCopyright : 0 ImageHaarMatrix : 0 ImageHistory : 0 ImageInformation : 0 ImageMetadata : 0 ImagePositions : 0 ImageProperties : 0 ImageTagProperties : 0 root@nas:~# for table in Images;do echo -n "$table : " && mysql -D digikam -NBe "SELECT count(*) FROM $table WHERE id IS NULL;";echo;done Images : 0 root@nas:~# for table in Images;do echo -n "$table : " && mysql -D digikam -NBe "SELECT count(*) FROM $table WHERE id = 0;";echo;done Images : 0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #11 from Maik Qualmann --- Note that for "Images" you need to test on column "id". Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #10 from Maik Qualmann --- Can you test again for "NULL" instead of "0"? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #9 from Petr Schonmann --- Seems all queries with imageid = 0 are empty root@nas:~# cat tables ImageComments ImageCopyright ImageHaarMatrix ImageHistory ImageInformation ImageMetadata ImagePositions ImageProperties ImageRelations Images ImageSimilarity ImageTagProperties root@nas:~# for table in $(cat tables);do echo -n "$table : " && mysql -D digikam -e "SELECT * FROM $table WHERE imageid = 0;";echo;done ImageComments : ImageCopyright : ImageHaarMatrix : ImageHistory : ImageInformation : ImageMetadata : ImagePositions : ImageProperties : ImageRelations : ERROR 1054 (42S22) at line 1: Unknown column 'imageid' in 'where clause' Images : ERROR 1054 (42S22) at line 1: Unknown column 'imageid' in 'where clause' ImageSimilarity : ERROR 1054 (42S22) at line 1: Unknown column 'imageid' in 'where clause' ImageTagProperties : -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #8 from Maik Qualmann --- The same for: SELECT * FROM ImageTagProperties WHERE imageid = 0; Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 --- Comment #7 from Petr Schonmann --- Its empty set ! Server version: 10.3.32-MariaDB Source distribution MariaDB [(none)]> use digikam Database changed MariaDB [digikam]> SELECT * FROM Images WHERE id = 0; Empty set (0.000 sec) -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 467766] MySQL foreign key error on a zero image id
https://bugs.kde.org/show_bug.cgi?id=467766 Maik Qualmann changed: What|Removed |Added Summary|QMYSQL3: Unable to execute |MySQL foreign key error on |statement" "Cannot add or |a zero image id |update a child row: a | |foreign key constraint | |fails | |(`digikam`.`ImageTagPropert | |ies`, CONSTRAINT| |`ImageTagProperties_Images` | |FOREIGN KEY (`imageid`) | |REFERENCES `Images` (`id`) | |ON DELETE CASCADE ON UPDATE | -- You are receiving this mail because: You are watching all bug changes.
