[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #20 from uwe.hai...@gmx.net --- I have finished testing the maintenance modules: - searching duplicates ok - rebuild fingerprints ok - searching new items ok - thumbnails ok - quality sort ok (but very slow - 2 days?) - synchronizing metadata (both directions) leads to segementation vault & crash Sorry, I can't see any error message for the segementation vault in the shell (zsh). How can I get the informations you need? uhai -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #19 from uwe.hai...@gmx.net --- (In reply to caulier.gilles from comment #16) > >That's it: max-allowed-packet was 4096. I set it to 16.777.216 -> > >facerecognition works first >time ever :-)) > > Where do you tune this settings exactly ? > > Gilles Caulier in mariadb via phpmyadmin. (settings - max-allowed-packets) works fine. maintenance thumbnails & fingerprints work - now testing duplicates uhai -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #18 from caulier.gil...@gmail.com --- > no language pack l18n for digikam in Gentoo?? No idea. No Gentoo here. At least, digiKam is released with whole translations pack. After, each packager make packages following distro rules... Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #17 from caulier.gil...@gmail.com --- >How can I fix this? Can I set up the tables via phpmyadmin? Is there a doku >for the db->structure? And how can I fill this hand made tables? The errors come from Thumbnail database which can be broken due to previous crash. This database only contain wavelets compressed thumbs. You can drop it and recreate the database in mysql as at init. The database contents will be recreated automatically. Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #16 from caulier.gil...@gmail.com --- >That's it: max-allowed-packet was 4096. I set it to 16.777.216 -> >facerecognition works first >time ever :-)) Where do you tune this settings exactly ? Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #15 from uwe.hai...@gmx.net --- I couldn't solve all of the above mentioned problems: 1 - done 2 - no language pack l18n for digikam in Gentoo?? 3 - Breeze icons are installed now, but some icons miss in digikam 4 - same -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #14 from uwe.hai...@gmx.net --- That's it: max-allowed-packet was 4096. I set it to 16.777.216 -> facerecognition works first time ever :-)) But some error messages are still on: digikam.general: Allowing a cache size of 200 MB digikam.dbengine: Prepare failed! digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword=?;" Error messages: "QMYSQL3: Unable to prepare statement" "Table 'digikam.ThumbSettings' doesn't exist" 1146 2 Bound values: () digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword='DBThumbnailsVersion';" Error messages: "QMYSQL: Unable to execute query" "Table 'digikam.ThumbSettings' doesn't exist" 1146 2 Bound values: (QVariant(QString, "DBThumbnailsVersion")) digikam.dbengine: Error while executing DBAction [ "SelectThumbnailSetting" ] Statement [ "SELECT value FROM ThumbSettings WHERE keyword=:keyword;" ] digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret = 1 digikam.dbengine: Prepare failed! digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword=?;" Error messages: "QMYSQL3: Unable to prepare statement" "Table 'digikam.ThumbSettings' doesn't exist" 1146 2 Bound values: () digikam.dbengine: Failure executing query: "SELECT value FROM ThumbSettings WHERE keyword='DBThumbnailsVersionRequired';" Error messages: "QMYSQL: Unable to execute query" "Table 'digikam.ThumbSettings' doesn't exist" 1146 2 Bound values: (QVariant(QString, "DBThumbnailsVersionRequired")) digikam.dbengine: Error while executing DBAction [ "SelectThumbnailSetting" ] Statement [ "SELECT value FROM ThumbSettings WHERE keyword=:keyword;" ] How can I fix this? Can I set up the tables via phpmyadmin? Is there a doku for the db-structure? And how can I fill this hand made tables? I will test the other functions of maintenance separatly an give feedback uhai -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #13 from caulier.gil...@gmail.com --- This file : https://bugs.kde.org/show_bug.cgi?id=365354 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #12 from uwe.hai...@gmx.net --- (In reply to caulier.gilles from comment #11) > 1/ The crash appears in face engine. Sound a similar problem reported in > this file : > > https://bugs.kde.org/process_bug.cgi Maybe the link is incomplete? > > 2/ I18n : install digiKam translations packages. I can't find this package in portage. Still looking > > 3/ Install Breeze icon-sets. > > 4/ Idem 3. Got it. Thanks for the hint! media-gfx/digikam misses this dependencie > > 5/ Most of plugins are migrated to digiKam core. It still only Web services > tool in kipi-plugins. ok, that's fine. makes it easier. Thanks a lot for the support. uhai -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #11 from caulier.gil...@gmail.com --- 1/ The crash appears in face engine. Sound a similar problem reported in this file : https://bugs.kde.org/process_bug.cgi 2/ I18n : install digiKam translations packages. 3/ Install Breeze icon-sets. 4/ Idem 3. 5/ Most of plugins are migrated to digiKam core. It still only Web services tool in kipi-plugins. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #10 from uwe.hai...@gmx.net --- ok, I got digikam-5.0.0 now. The problem still exists. I have the stderr from zsh in a file with 622 MB. This are the last lines: --- digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.facesengine: detectMultiScale gave (QRect(298,406 146x146)) digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 0 digikam.facesengine: detectMultiScale: image size 226 226 searchIncrement 1.1 grouping 3 flags 0 min size 88 88 digikam.database: No location could be retrieved for "" digikam.general: Entry QRect(1301,444 534x535)456overlapsQRect(1301,444 534x535)456, skipping digikam.facesengine: detectMultiScale gave (QRect(41,42 145x145)) digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 1 digikam.facesengine: detectMultiScale: image size 226 226 searchIncrement 1.1 grouping 3 flags 0 min size 88 88 digikam.facesengine: detectMultiScale gave (QRect(39,35 161x161)) digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 2 digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 3 digikam.facesengine: detectMultiScale: image size 226 226 searchIncrement 1.1 grouping 3 flags 0 min size 88 88 digikam.facesengine: detectMultiScale gave () digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 4 digikam.facesengine: detectMultiScale: image size 226 226 searchIncrement 1.1 grouping 3 flags 0 min size 88 88 digikam.facesengine: detectMultiScale gave (QRect(69,39 139x139)) digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 5 digikam.facesengine: feature QRectF(0,0 0.6x0.6) QRect(298,406 146x146) QRect(298,406 88x88) digikam.facesengine: detectMultiScale: image size 88 88 searchIncrement 1.1 grouping 2 flags 0 min size 15 15 digikam.facesengine: detectMultiScale gave (QRect(29,45 26x39)) digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 6 digikam.facesengine: feature QRectF(0.4,0 0.6x0.6) QRect(298,406 146x146) QRect(356,406 88x88) digikam.facesengine: detectMultiScale: image size 88 88 searchIncrement 1.1 grouping 2 flags 0 min size 15 15 digikam.facesengine: detectMultiScale gave (QRect(27,45 26x39)) digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 7 digikam.facesengine: feature QRectF(0.2,0.25 0.6x0.6) QRect(298,406 146x146) QRect(327,443 88x88) digikam.facesengine: detectMultiScale: image size 88 88 searchIncrement 1.1 grouping 2 flags 0 min size 15 15 digikam.facesengine: detectMultiScale gave () digikam.facesengine: Verifying face QRect(298,406 146x146) using cascade 8 digikam.facesengine: feature QRectF(0.1,0.4 0.8x0.6) QRect(298,406 146x146) QRect(313,464 117x88) digikam.facesengine: detectMultiScale: image size 117 88 searchIncrement 1.1 grouping 2 flags 0 min size 15 15 digikam.facesengine: detectMultiScale gave () digikam.general: Found 1 faces in "2012-04-02 19.17.13.JPG" QSize(1944, 2592) QSize(1944, 2592) digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.general: Entry QRect(1369,290 346x347)456overlapsQRect(1369,290 346x347)456, skipping digikam.general: Check for finish: 51 packages, 0 infos to filter, hasFinished() false digikam.general: Entry QRect(1557,949 211x211)456overlapsQRect(1557,949 211x211)456, skipping --- Do you think, the file will help? A few problems are new: - can't change to german - no right bar in the album view (comment, tags, map etc...) - no settings for the import, import doesn't work - only 15 kipiplugins? starting digikam leads to this message: "Error message: The database is not valid: the "DBThumbnailsVersion" setting does not exist. The current database schema version cannot be verified. Try to start with an empty database." This comes since updating to 5.0.0.. Thanks for your support uhai -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 caulier.gil...@gmail.com changed: What|Removed |Added Version|4.2.0 |4.14.0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 --- Comment #9 from uwe.hai...@gmx.net --- The latest (unstable) release for Gentoo / portage is 4.14.0-r1. The problem still exists with this release. The 5.0.0 isn't available for portage yet... I will report. Just an idea: Some pictures are tagged with names without a face selected. This is a relict from older releases. Newer pictures are tagged with marked faces. Perhaps this is a problem? Face recognition leads here to a crash too. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 329091] MySQL : Maintenance leads to crash digiKam
https://bugs.kde.org/show_bug.cgi?id=329091 caulier.gil...@gmail.com changed: What|Removed |Added Resolution|--- |WAITINGFORINFO Status|UNCONFIRMED |RESOLVED --- Comment #8 from caulier.gil...@gmail.com --- digiKam 5.0.0 will be released soon. Please test with this version quickly and give us a fresh feedback. -- You are receiving this mail because: You are watching all bug changes.
