https://bugs.kde.org/show_bug.cgi?id=406276
--- Comment #3 from m...@griewel.de --- (In reply to caulier.gilles from comment #1) > Under Windows, please install DebugView program from Microsoft to capture > all debug trace from the console while digiKam is running. > > https://www.digikam.org/contribute/ > > Try again all the step listed and copy and paste the debug view in this file > > Gilles Caulier Thanks for your quick response! Here comes the DebugView data: - #122 digiKam start - #146 call menu topic Migration - #149 enter server data - #166 call "Verbindung prüfen" - #175 call "Migration" 00000001 0.00000000 [5468] digikam.general: Loading DrMinGw run-time... 00000002 0.00151498 [5468] digikam.general: DrMinGw run-time loaded. 00000003 0.00154109 [5468] digikam.general: DrMinGw crash-file will be located at: "C:\\Users\\Martin\\AppData\\Local\\digikam_crash.log" 00000004 0.02299094 [5468] digikam.widgets: Breeze icons resource file found 00000005 0.02930433 [5468] digikam.general: AlbumWatch use QFileSystemWatcher 00000006 0.05838195 [5468] digikam.general: Database Parameters: 00000007 0.05838195 [5468] Type: "QSQLITE" 00000008 0.05838195 [5468] DB Core Name: "C:/Users/Public/Documents/digikam/digikam4.db" 00000009 0.05838195 [5468] DB Thumbs Name: "C:/Users/Public/Documents/digikam/thumbnails-digikam.db" 00000010 0.05838195 [5468] DB Face Name: "C:/Users/Public/Documents/digikam/recognition.db" 00000011 0.05838195 [5468] DB Similarity Name: "C:/Users/Public/Documents/digikam/similarity.db" 00000012 0.05838195 [5468] Connect Options: "" 00000013 0.05838195 [5468] Host Name: "" 00000014 0.05838195 [5468] Host port: -1 00000015 0.05838195 [5468] Internal Server: false 00000016 0.05838195 [5468] Internal Server Path: "" 00000017 0.05838195 [5468] Internal Server Serv Cmd: "" 00000018 0.05838195 [5468] Internal Server Init Cmd: "" 00000019 0.05838195 [5468] Username: "" 00000020 0.05838195 [5468] Password: "" 00000021 0.05838195 [5468] 00000022 0.54014355 [5468] digikam.dbengine: Loading SQL code from config file "C:/Program Files/digiKam/data/digikam/database/dbconfig.xml" 00000023 0.54478085 [5468] digikam.dbengine: Checking XML version ID => expected: 3 found: 3 00000024 0.54705364 [5468] digikam.coredb: Core database: running schema update 00000025 0.54797959 [5468] digikam.coredb: Core database: have a structure version 10 00000026 0.54800439 [5468] digikam.coredb: Core database: makeUpdates 10 to 10 00000027 0.57018977 [5468] digikam.database: Creating new Location "/Users/Martin/Pictures" uuid "volumeid:?uuid=620de046" 00000028 0.57021332 [5468] digikam.database: location for "C:/Users/Martin/Pictures" is available true 00000029 0.57040119 [5468] KMemoryInfo: Platform identified : "WINDOWS" 00000030 0.57049865 [5468] KMemoryInfo: TotalRam: 8464744448 00000031 0.57057190 [5468] digikam.general: Allowing a cache size of 200 MB 00000032 0.57319427 [5468] digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret = 0 00000033 0.57330000 [5468] digikam.thumbsdb: ThumbDB SelectThumbnailSetting val ret = 0 00000034 0.57336688 [5468] digikam.thumbsdb: Thumbs database: have a structure version "3" 00000035 0.58326423 [5468] digikam.general: Thumbnails database ready for use 00000036 0.58432454 [5468] digikam.similaritydb: SimilarityDb SelectSimilaritySetting val ret = 0 00000037 0.58447099 [5468] digikam.similaritydb: SimilarityDb SelectSimilaritySetting val ret = 0 00000038 0.58453721 [5468] digikam.similaritydb: Similarity database: have a structure version "1" 00000039 0.59383154 [5468] digikam.similaritydb: Similarity database ready for use 00000040 0.59517711 [5468] digikam.general: Switch to widget style: "Fusion" 00000041 0.70593971 [5468] digikam.dimg: () 00000042 0.71828371 [5468] digikam.general: Camera XML data: "C:/Users/Martin/AppData/Local/digikam/cameras.xml" 00000043 0.74626666 [5468] digikam.facedb: FaceDB SelectFaceSetting val ret = 0 00000044 0.74666148 [5468] digikam.facedb: FaceDB SelectFaceSetting val ret = 0 00000045 0.74671626 [5468] digikam.facedb: Face database: have a structure version "3" 00000046 0.76070583 [5468] digikam.facesengine: Face database ready for use 00000047 0.76113504 [5468] digikam.general: Face PipeLine: add database writer 00000048 0.76127833 [5468] digikam.general: Face PipeLine: add faces trainer 00000049 0.79680049 [5468] digikam.facesengine: Face database ready for use 00000050 0.79700941 [5468] digikam.general: Face PipeLine: add database writer 00000051 0.79703295 [5468] digikam.general: Face PipeLine: add faces trainer 00000052 0.82373333 [5468] digikam.geoiface: "setting backend marble" 00000053 0.82943028 [5468] digikam.general: AudioOutput backends: ("XAudio2", "OpenAL", "DirectSound", "null") 00000054 0.82955319 [5468] digikam.general: Stacked View Mode : 0 00000055 0.88513762 [5468] digikam.geoiface: "setting backend marble" 00000056 0.99421328 [5468] digikam.geoiface: "setting backend marble" 00000057 1.01555681 [5468] digikam.general: "browse_album" 00000058 1.01569045 [5468] digikam.general: "browse_tag" 00000059 1.01580131 [5468] digikam.general: "browse_labels" 00000060 1.01590896 [5468] digikam.general: "browse_date" 00000061 1.01601720 [5468] digikam.general: "browse_timeline" 00000062 1.01619291 [5468] digikam.general: "browse_search" 00000063 1.01629615 [5468] digikam.general: "browse_fuzzysearch" 00000064 1.01639986 [5468] digikam.general: "browse_gpssearch" 00000065 1.01642025 [5468] digikam.general: "browse_people" 00000066 1.22758186 [5468] digikam.widgets: Paths to color scheme : ("C:/Program Files/digiKam/data/digikam/colorschemes") 00000067 1.24897695 [5468] digikam.widgets: "" :: "" 00000068 1.27103746 [5468] digikam.widgets: "" :: "" 00000069 1.30082715 [5468] QFSFileEngine::open: No file name specified 00000070 1.30880070 [5468] digikam.general: Using 4 CPU core to run threads 00000071 1.31282210 [5468] digikam.general: new search text settings: "" : hasResult = false , validRows = 0 00000072 1.40607548 [5468] QFSFileEngine::open: No file name specified 00000073 1.42330897 [5468] digikam.geoiface: ---- 00000074 1.42337525 [5468] digikam.geoiface: ---- 00000075 1.45335007 [5468] digikam.general: Added root album called: "Pictures" 00000076 1.46110773 [5468] digikam.general: Using 4 CPU core to run threads 00000077 1.46234381 [5468] digikam.general: Action Thread run 1 new jobs 00000078 1.48433244 [5468] digikam.geoiface: "ROADMAP" 00000079 1.56549966 [5468] digikam.geoiface: "ROADMAP" 00000080 1.57101381 [5468] digikam.geoiface: "ROADMAP" 00000081 1.57319808 [5468] digikam.geoiface: ---- 00000082 1.57977200 [5468] digikam.geoiface: ---- 00000083 1.57986939 [5468] digikam.general: Using 4 CPU core to run threads 00000084 1.58045530 [5468] digikam.general: Action Thread run 1 new jobs 00000085 1.58585417 [5468] digikam.geoiface: "ROADMAP" 00000086 1.58642602 [5468] digikam.geoiface: ---- 00000087 1.58888161 [5468] digikam.general: Cancel Main Thread 00000088 1.58901787 [5468] digikam.geoiface: ---- 00000089 1.58915353 [5468] digikam.general: Using 4 CPU core to run threads 00000090 1.58935916 [5468] digikam.general: Stacked View Mode : 2 00000091 1.58999729 [5468] digikam.general: Action Thread run 1 new jobs 00000092 1.59002399 [5468] digikam.geoiface: ---- 00000093 1.59645331 [5468] digikam.general: Stacked View Mode : 2 00000094 1.60172296 [5468] digikam.general: One job is done 00000095 1.60196364 [5468] digikam.general: One job is done 00000096 1.60209417 [5468] digikam.general: Data From DBJobsThread is null: true 00000097 1.60218275 [5468] digikam.general: Cancel Main Thread 00000098 1.60219932 [5468] digikam.general: One job is done 00000099 1.67406261 [5468] digikam.geoiface: "setting backend marble" 00000100 1.74720156 [5468] QFSFileEngine::open: No file name specified 00000101 1.78890085 [5468] digikam.geoiface: "ROADMAP" 00000102 1.88981497 [5468] digikam.geoiface: "setting backend marble" 00000103 1.98181760 [5468] digikam.facesengine: Face database ready for use 00000104 1.98202205 [5468] digikam.general: Face PipeLine: add database writer 00000105 1.98206031 [5468] digikam.general: Face PipeLine: add faces trainer 00000106 1.98811126 [5468] digikam.facesengine: Face database ready for use 00000107 1.98830175 [5468] digikam.general: Face PipeLine: add database writer 00000108 1.98834825 [5468] digikam.general: Face PipeLine: add faces trainer 00000109 2.03568387 [5468] digikam.geoiface: "setting backend marble" 00000110 2.08569121 [5468] QFSFileEngine::open: No file name specified 00000111 2.14910197 [5468] digikam.geoiface: "ROADMAP" 00000112 2.15103722 [5468] digikam.geoiface: "ROADMAP" 00000113 2.17386198 [5468] digikam.general: Cancel Main Thread 00000114 2.17448425 [5468] digikam.general: Cancel Main Thread 00000115 2.17490315 [5468] digikam.general: Cancel Main Thread 00000116 2.22130227 [5468] digikam.geoiface: ---- 00000117 4.29423046 [5468] digikam.general: scan mode: ScanDeferredFiles 00000118 4.30029678 [5468] digikam.database: items to tag () 00000119 4.30439329 [5468] digikam.general: total scan value : 7 00000120 4.30545425 [5468] digikam.database: Complete scan took: 11 msecs. 00000121 4.32057905 [5468] digikam.general: Event is dispatched through a passive pop-up 00000122 4.32072163 [5468] QLayout: Attempting to add QLayout "" to QWidget "", which already has a layout 00000123 11.72569847 [5468] digikam.general: Testing "mysql_install_db.exe" ... 00000124 11.72836494 [5468] digikam.general: Testing "mysqld.exe" ... 00000125 11.73361015 [5468] digikam.general: Testing "mysql_install_db.exe" ... 00000126 11.74524307 [5468] digikam.general: Testing "mysqld.exe" ... 00000127 11.75583744 [5468] digikam.general: Testing "C:/Program Files/MariaDB 10.3/bin/mysql_install_db.exe" ... 00000128 11.75646877 [5468] digikam.general: All Binaries Found : false 00000129 11.75653934 [5468] digikam.general: Testing "C:/Program Files/MariaDB 10.3/bin/mysqld.exe" ... 00000130 11.75705719 [5468] digikam.general: All Binaries Found : false 00000131 11.75713158 [5468] digikam.general: Testing "C:/Program Files (x86/MariaDB 10.3/bin/mysql_install_db.exe" ... 00000132 11.75765133 [5468] digikam.general: All Binaries Found : false 00000133 11.75775146 [5468] digikam.general: Testing "C:/Program Files (x86/MariaDB 10.3/bin/mysqld.exe" ... 00000134 11.75813198 [5468] digikam.general: All Binaries Found : false 00000135 11.77557087 [5468] digikam.general: Testing "mysql_install_db.exe" ... 00000136 11.77828407 [5468] digikam.general: Testing "mysqld.exe" ... 00000137 11.78296280 [5468] digikam.general: Testing "mysql_install_db.exe" ... 00000138 11.79111195 [5468] digikam.general: Testing "mysqld.exe" ... 00000139 11.79764557 [5468] digikam.general: Testing "C:/Program Files/MariaDB 10.3/bin/mysql_install_db.exe" ... 00000140 11.79794979 [5468] digikam.general: All Binaries Found : false 00000141 11.79801273 [5468] digikam.general: Testing "C:/Program Files/MariaDB 10.3/bin/mysqld.exe" ... 00000142 11.79824543 [5468] digikam.general: All Binaries Found : false 00000143 11.79830551 [5468] digikam.general: Testing "C:/Program Files (x86/MariaDB 10.3/bin/mysql_install_db.exe" ... 00000144 11.79849720 [5468] digikam.general: All Binaries Found : false 00000145 11.79855537 [5468] digikam.general: Testing "C:/Program Files (x86/MariaDB 10.3/bin/mysqld.exe" ... 00000146 11.79875278 [5468] digikam.general: All Binaries Found : false 00000147 58.63725662 [3784] AveSvc_EngineService2009_57 00000148 63.19165039 [5468] setGeometry: Unable to set geometry 1005x762+346+246 on QWidgetWindow/'Digikam::DatabaseMigrationDialogClassWindow'. Resulting geometry: 1005x950+346+246 (frame: 9, 38, 9, 9, custom margin: 0, 0, 0, 0, minimum size: 840x762, maximum size: 16777215x16777215). 00000149 64.67082977 [4020] InitEngine 00000150 98.33888245 [5468] digikam.database: Testing DB connection ( "ConnectionTest" ) with these settings: 00000151 98.33892822 [5468] digikam.database: Database Parameters: 00000152 98.33892822 [5468] Type: "QMYSQL" 00000153 98.33892822 [5468] DB Core Name: "digikam" 00000154 98.33892822 [5468] DB Thumbs Name: "digikam" 00000155 98.33892822 [5468] DB Face Name: "digikam" 00000156 98.33892822 [5468] DB Similarity Name: "digikam" 00000157 98.33892822 [5468] Connect Options: "" 00000158 98.33892822 [5468] Host Name: "NAS1" 00000159 98.33892822 [5468] Host port: 3306 00000160 98.33892822 [5468] Internal Server: false 00000161 98.33892822 [5468] Internal Server Path: "" 00000162 98.33892822 [5468] Internal Server Serv Cmd: "" 00000163 98.33892822 [5468] Internal Server Init Cmd: "" 00000164 98.33892822 [5468] Username: "Media" 00000165 98.33892822 [5468] Password: "XXXXX" 00000166 98.33892822 [5468] 00000167 132.79748535 [5468] digikam.dbengine: Failure executing query: 00000168 132.79748535 [5468] "" 00000169 132.79748535 [5468] Error messages: "QMYSQL: Unable to execute query" "Error on rename of './digikam/Albums' to './digikam/#sql2-2d23-96' (errno: 152)" 1025 2 00000170 132.79748535 [5468] Bound values: () 00000171 132.79769897 [5468] digikam.dbengine: Error while executing DBAction [ "Migrate_Cleanup_Prepare" ] Statement [ "ALTER TABLE Albums DROP FOREIGN KEY Albums_Images;" ] 00000172 132.98222351 [5468] digikam.coredb: Core database: running schema update 00000173 133.70201111 [5468] digikam.coredb: Core database: no database file available 00000174 134.23355103 [5468] digikam.dbengine: Failure executing query: 00000175 134.23355103 [5468] "" 00000176 134.23355103 [5468] Error messages: "QMYSQL: Unable to execute query" "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3),\n fileSize BIGINT,\n uniqueHash VARCHAR' at line 7" 1064 2 00000177 134.23355103 [5468] Bound values: () 00000178 134.23377991 [5468] digikam.dbengine: Error while executing DBAction [ "CreateDB" ] Statement [ "CREATE TABLE IF NOT EXISTS Images\n (id BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT,\n album INTEGER,\n name LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n status INTEGER NOT NULL,\n category INTEGER NOT NULL,\n modificationDate DATETIME(3),\n fileSize BIGINT,\n uniqueHash VARCHAR(128),\n manualOrder BIGINT,\n CONSTRAINT Images_Albums FOREIGN KEY (album) REFERENCES Albums (id) ON DELETE CASCADE ON UPDATE CASCADE,\n UNIQUE (album, name(255)))\n ENGINE InnoDB;\n " ] Martin -- You are receiving this mail because: You are watching all bug changes.
