https://bugs.kde.org/show_bug.cgi?id=394434
--- Comment #34 from caulier.gil...@gmail.com ---
I cleaned again all DK data files (config, DB), and startup again :
macbook-pro-de-gilles:~ gilles$
/opt/digikam/Applications/KF5/digikam.app/Contents/MacOS/digikam
digikam.widgets: Breeze icons resource file found
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam"
DB Face Name: "digikam"
DB Similyritiy Name: "digikam"
Connect Options: "UNIX_SOCKET=/Users/gilles/Library/Application
Support/digikam/digikam/db_misc/mysql.socket"
Host Name: ""
Host port: -1
Internal Server: true
Internal Server Path: "/Users/gilles/Pictures/"
Internal Server Serv Cmd: "/opt/digikam/lib/mariadb/bin/mysqld"
Internal Server Init Cmd: "/opt/digikam/lib/mariadb/bin/mysql_install_db"
Username: "root"
Password: ""
digikam.databaseserver: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam"
DB Face Name: "digikam"
DB Similyritiy Name: "digikam"
Connect Options: "UNIX_SOCKET=/Users/gilles/Library/Application
Support/digikam/digikam/db_misc/mysql.socket"
Host Name: ""
Host port: -1
Internal Server: true
Internal Server Path: "/Users/gilles/Pictures/"
Internal Server Serv Cmd: "/opt/digikam/lib/mariadb/bin/mysqld"
Internal Server Init Cmd: "/opt/digikam/lib/mariadb/bin/mysql_install_db"
Username: "root"
Password: ""
digikam.databaseserver: Internal Server data path:
"/Users/gilles/Pictures/.mysql.digikam/db_data"
digikam.databaseserver: The mysql configuration is outdated,
"/Users/gilles/Library/Application Support/digikam/digikam/mysql.conf" will be
updated.
digikam.databaseserver: Updated mysql configuration with
"/opt/digikam/Applications/KF5/digikam.app/Contents/Resources//digikam/database/mysql-global.conf"
digikam.databaseserver: Fixed permissions of mysql configuration file.
digikam.databaseserver: Database initializer:
"/opt/digikam/lib/mariadb/bin/mysql_install_db"
("--datadir=/Users/gilles/Pictures/.mysql.digikam/db_data",
"--defaults-file=/opt/digikam/Applications/KF5/digikam.app/Contents/Resources//digikam/database/mysql-global.conf")
digikam.databaseserver: Database server: "/opt/digikam/lib/mariadb/bin/mysqld"
("--defaults-file=/Users/gilles/Library/Application
Support/digikam/digikam/mysql.conf",
"--datadir=/Users/gilles/Pictures/.mysql.digikam/db_data",
"--socket=/Users/gilles/Library/Application
Support/digikam/digikam/db_misc/mysql.socket")
digikam.databaseserver: Failed to use database "digikam"
digikam.databaseserver: Query error: "Unknown database 'digikam' QMYSQL: Unable
to execute query"
digikam.databaseserver: Database error: "Can't connect to local MySQL server
through socket '/Users/gilles/Library/Application
Support/digikam/digikam/db_misc/mysql.socket' (2) QMYSQL: Unable to connect"
digikam.databaseserver: Trying to create database now
digikam.databaseserver: Database was successfully created
digikam.databaseserver: Internal database server started
digikam.databaseserver: Running 0 seconds...
digikam.dbengine: Loading SQL code from config file
"/opt/digikam/Applications/KF5/digikam.app/Contents/Resources//digikam/database/dbconfig.xml"
digikam.dbengine: Checking XML version ID => expected: 3 found: 3
digikam.coredb: Core database: running schema update
digikam.coredb: Core database: no database file available
KMemoryInfo: Platform identified : "Unknown"
KMemoryInfo: TotalRam: -1
digikam.general: Allowing a cache size of 60 MB
digikam.general: No locale found in database
digikam.general: No locale found in config file
digikam.general: Testing "mysql_install_db" ...
digikam.general: Testing "mysqld" ...
digikam.general: Testing "mysql_install_db" ...
digikam.general: Testing "mysqld" ...
digikam.general: Testing "/opt/local/bin/mysql_install_db" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/local/bin/mysqld" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/local/sbin/mysql_install_db" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/local/sbin/mysqld" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/local/lib/mariadb/bin/mysql_install_db" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/local/lib/mariadb/bin/mysqld" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/digikam/bin/mysql_install_db" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/digikam/bin/mysqld" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/digikam/sbin/mysql_install_db" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/digikam/sbin/mysqld" ...
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/digikam/lib/mariadb/bin/mysql_install_db" ...
digikam.general: Found "/opt/digikam/lib/mariadb/bin/mysql_install_db"
digikam.general: All Binaries Found : false
digikam.general: Testing "/opt/digikam/lib/mariadb/bin/mysqld" ...
digikam.general: Found "/opt/digikam/lib/mariadb/bin/mysqld"
digikam.general: All Binaries Found : true
digikam.general: Switch to widget style: "Fusion"
digikam.general: Testing
"/opt/digikam/lib/mariadb/bin/mysql_install_db/mysql_install_db" ...
digikam.general: All Binaries Found : true
digikam.general: Testing "/opt/digikam/lib/mariadb/bin/mysqld/mysqld" ...
digikam.general: All Binaries Found : true
digikam.dimg:
"/opt/digikam/Applications/KF5/digikam.app/Contents/Resources//digikam/data/sample-aix.png"
: PNG file identified
digikam.dimg: ("/System/Library/ColorSync/Profiles",
"/Library/ColorSync/Profiles")
digikam.dimg: The original Adobe RGB (1998) profile has been found at
"/System/Library/ColorSync/Profiles/AdobeRGB1998.icc"
digikam.general: new search text settings: "" : hasResult = false , validRows
= 0
digikam.databaseserver: Running 30 seconds...
The collection config dialog appear.
The DB files are re-created from scratch :
bash-3.2$ pwd
/Users/gilles/Pictures/.mysql.digikam
bash-3.2$ ls -alR
total 0
drwxr-xr-x 3 gilles staff 96 21 mai 20:43 .
drwx------+ 13 gilles staff 416 21 mai 20:43 ..
drwxr-xr-x 16 gilles staff 512 21 mai 20:44 db_data
./db_data:
total 301240
drwxr-xr-x 16 gilles staff 512 21 mai 20:44 .
drwxr-xr-x 3 gilles staff 96 21 mai 20:43 ..
-rw-rw---- 1 gilles staff 16384 21 mai 20:44 aria_log.00000001
-rw-rw---- 1 gilles staff 52 21 mai 20:44 aria_log_control
drwx------ 70 gilles staff 2240 21 mai 20:44 digikam
-rw-rw---- 1 gilles staff 67108864 21 mai 20:44 ib_logfile0
-rw-rw---- 1 gilles staff 67108864 21 mai 20:43 ib_logfile1
-rw-rw---- 1 gilles staff 18874368 21 mai 20:44 ibdata1
drwx------ 74 gilles staff 2368 21 mai 20:43 mysql
-rw-rw---- 1 gilles staff 30394 21 mai 20:43 mysql-bin.000001
-rw-rw---- 1 gilles staff 1038814 21 mai 20:43 mysql-bin.000002
-rw-rw---- 1 gilles staff 37625 21 mai 20:44 mysql-bin.000003
-rw-rw---- 1 gilles staff 57 21 mai 20:43 mysql-bin.index
-rw-rw---- 1 gilles staff 1892 21 mai 20:44 mysql.err
drwx------ 20 gilles staff 640 21 mai 20:43 performance_schema
drwx------ 2 gilles staff 64 21 mai 20:43 test
./db_data/digikam:
total 8584
drwx------ 70 gilles staff 2240 21 mai 20:44 .
drwxr-xr-x 16 gilles staff 512 21 mai 20:44 ..
-rw-rw---- 1 gilles staff 8740 21 mai 20:43 AlbumRoots.frm
-rw-rw---- 1 gilles staff 8780 21 mai 20:43 Albums.frm
-rw-rw---- 1 gilles staff 8608 21 mai 20:44 CustomIdentifiers.frm
-rw-rw---- 1 gilles staff 8712 21 mai 20:43 DownloadHistory.frm
-rw-rw---- 1 gilles staff 8786 21 mai 20:44 FaceMatrices.frm
-rw-rw---- 1 gilles staff 8598 21 mai 20:44 FaceSettings.frm
-rw-rw---- 1 gilles staff 8596 21 mai 20:44 FilePaths.frm
-rw-rw---- 1 gilles staff 8586 21 mai 20:44 Identities.frm
-rw-rw---- 1 gilles staff 8658 21 mai 20:44 IdentityAttributes.frm
-rw-rw---- 1 gilles staff 8760 21 mai 20:43 ImageComments.frm
-rw-rw---- 1 gilles staff 8704 21 mai 20:43 ImageCopyright.frm
-rw-rw---- 1 gilles staff 8696 21 mai 20:44 ImageHaarMatrix.frm
-rw-rw---- 1 gilles staff 8632 21 mai 20:43 ImageHistory.frm
-rw-rw---- 1 gilles staff 8928 21 mai 20:43 ImageInformation.frm
-rw-rw---- 1 gilles staff 9298 21 mai 20:43 ImageMetadata.frm
-rw-rw---- 1 gilles staff 8970 21 mai 20:43 ImagePositions.frm
-rw-rw---- 1 gilles staff 8636 21 mai 20:43 ImageProperties.frm
-rw-rw---- 1 gilles staff 8630 21 mai 20:43 ImageRelations.frm
-rw-rw---- 1 gilles staff 8678 21 mai 20:44 ImageSimilarity.frm
-rw-rw---- 1 gilles staff 8668 21 mai 20:43 ImageTagProperties.frm
-rw-rw---- 1 gilles staff 8598 21 mai 20:43 ImageTags.frm
-rw-rw---- 1 gilles staff 8824 21 mai 20:43 Images.frm
-rw-rw---- 1 gilles staff 8734 21 mai 20:44 OpenCVLBPHRecognizer.frm
-rw-rw---- 1 gilles staff 8796 21 mai 20:44 OpenCVLBPHistograms.frm
-rw-rw---- 1 gilles staff 8648 21 mai 20:43 Searches.frm
-rw-rw---- 1 gilles staff 8598 21 mai 20:43 Settings.frm
-rw-rw---- 1 gilles staff 8598 21 mai 20:44 SimilaritySettings.frm
-rw-rw---- 1 gilles staff 8632 21 mai 20:43 TagProperties.frm
-rw-rw---- 1 gilles staff 8736 21 mai 20:43 Tags.frm
-rw-rw---- 1 gilles staff 8598 21 mai 20:44 ThumbSettings.frm
-rw-rw---- 1 gilles staff 8722 21 mai 20:44 Thumbnails.frm
-rw-rw---- 1 gilles staff 8646 21 mai 20:44 UniqueHashes.frm
-rw-rw---- 1 gilles staff 8934 21 mai 20:43 VideoMetadata.frm
-rw-rw---- 1 gilles staff 114688 21 mai 20:43 albumroots.ibd
-rw-rw---- 1 gilles staff 131072 21 mai 20:43 albums.ibd
-rw-rw---- 1 gilles staff 147456 21 mai 20:44 customidentifiers.ibd
-rw-rw---- 1 gilles staff 61 21 mai 20:43 db.opt
-rw-rw---- 1 gilles staff 114688 21 mai 20:43 downloadhistory.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:44 facematrices.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:44 facesettings.ibd
-rw-rw---- 1 gilles staff 147456 21 mai 20:44 filepaths.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:44 identities.ibd
-rw-rw---- 1 gilles staff 131072 21 mai 20:44 identityattributes.ibd
-rw-rw---- 1 gilles staff 131072 21 mai 20:43 imagecomments.ibd
-rw-rw---- 1 gilles staff 131072 21 mai 20:43 imagecopyright.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:44 imagehaarmatrix.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:43 imagehistory.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:43 imageinformation.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:43 imagemetadata.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:43 imagepositions.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:43 imageproperties.ibd
-rw-rw---- 1 gilles staff 163840 21 mai 20:43 imagerelations.ibd
-rw-rw---- 1 gilles staff 163840 21 mai 20:43 images.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:44 imagesimilarity.ibd
-rw-rw---- 1 gilles staff 163840 21 mai 20:43 imagetagproperties.ibd
-rw-rw---- 1 gilles staff 131072 21 mai 20:43 imagetags.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:44 opencvlbphistograms.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:44 opencvlbphrecognizer.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:43 searches.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:44 settings.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:44 similaritysettings.ibd
-rw-rw---- 1 gilles staff 131072 21 mai 20:44 tagproperties.ibd
-rw-rw---- 1 gilles staff 131072 21 mai 20:44 tags.ibd
-rw-rw---- 1 gilles staff 516 21 mai 20:43 tagstree.frm
-rw-rw---- 1 gilles staff 98304 21 mai 20:44 thumbnails.ibd
-rw-rw---- 1 gilles staff 114688 21 mai 20:44 thumbsettings.ibd
-rw-rw---- 1 gilles staff 147456 21 mai 20:44 uniquehashes.ibd
-rw-rw---- 1 gilles staff 98304 21 mai 20:43 videometadata.ibd
./db_data/mysql:
total 2000
drwx------ 74 gilles staff 2368 21 mai 20:43 .
drwxr-xr-x 16 gilles staff 512 21 mai 20:44 ..
-rw-rw---- 1 gilles staff 0 21 mai 20:43 columns_priv.MYD
-rw-rw---- 1 gilles staff 4096 21 mai 20:43 columns_priv.MYI
-rw-rw---- 1 gilles staff 8820 21 mai 20:43 columns_priv.frm
-rw-rw---- 1 gilles staff 880 21 mai 20:43 db.MYD
-rw-rw---- 1 gilles staff 5120 21 mai 20:43 db.MYI
-rw-rw---- 1 gilles staff 9582 21 mai 20:43 db.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 event.MYD
-rw-rw---- 1 gilles staff 2048 21 mai 20:43 event.MYI
-rw-rw---- 1 gilles staff 10239 21 mai 20:43 event.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 func.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 func.MYI
-rw-rw---- 1 gilles staff 8665 21 mai 20:43 func.frm
-rw-rw---- 1 gilles staff 35 21 mai 20:43 general_log.CSM
-rw-rw---- 1 gilles staff 0 21 mai 20:43 general_log.CSV
-rw-rw---- 1 gilles staff 8776 21 mai 20:43 general_log.frm
-rw-rw---- 1 gilles staff 1092 21 mai 20:43 help_category.MYD
-rw-rw---- 1 gilles staff 3072 21 mai 20:43 help_category.MYI
-rw-rw---- 1 gilles staff 8700 21 mai 20:43 help_category.frm
-rw-rw---- 1 gilles staff 91408 21 mai 20:43 help_keyword.MYD
-rw-rw---- 1 gilles staff 16384 21 mai 20:43 help_keyword.MYI
-rw-rw---- 1 gilles staff 8612 21 mai 20:43 help_keyword.frm
-rw-rw---- 1 gilles staff 9252 21 mai 20:43 help_relation.MYD
-rw-rw---- 1 gilles staff 19456 21 mai 20:43 help_relation.MYI
-rw-rw---- 1 gilles staff 8630 21 mai 20:43 help_relation.frm
-rw-rw---- 1 gilles staff 450388 21 mai 20:43 help_topic.MYD
-rw-rw---- 1 gilles staff 20480 21 mai 20:43 help_topic.MYI
-rw-rw---- 1 gilles staff 8770 21 mai 20:43 help_topic.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 host.MYD
-rw-rw---- 1 gilles staff 2048 21 mai 20:43 host.MYI
-rw-rw---- 1 gilles staff 9510 21 mai 20:43 host.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 ndb_binlog_index.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 ndb_binlog_index.MYI
-rw-rw---- 1 gilles staff 8778 21 mai 20:43 ndb_binlog_index.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 plugin.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 plugin.MYI
-rw-rw---- 1 gilles staff 8586 21 mai 20:43 plugin.frm
-rw-rw---- 1 gilles staff 2712 21 mai 20:44 proc.MYD
-rw-rw---- 1 gilles staff 4096 21 mai 20:44 proc.MYI
-rw-rw---- 1 gilles staff 10012 21 mai 20:43 proc.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 procs_priv.MYD
-rw-rw---- 1 gilles staff 4096 21 mai 20:43 procs_priv.MYI
-rw-rw---- 1 gilles staff 8875 21 mai 20:43 procs_priv.frm
-rw-rw---- 1 gilles staff 1386 21 mai 20:43 proxies_priv.MYD
-rw-rw---- 1 gilles staff 5120 21 mai 20:43 proxies_priv.MYI
-rw-rw---- 1 gilles staff 8800 21 mai 20:43 proxies_priv.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 servers.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 servers.MYI
-rw-rw---- 1 gilles staff 8838 21 mai 20:43 servers.frm
-rw-rw---- 1 gilles staff 35 21 mai 20:43 slow_log.CSM
-rw-rw---- 1 gilles staff 0 21 mai 20:43 slow_log.CSV
-rw-rw---- 1 gilles staff 8976 21 mai 20:43 slow_log.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 tables_priv.MYD
-rw-rw---- 1 gilles staff 4096 21 mai 20:43 tables_priv.MYI
-rw-rw---- 1 gilles staff 8955 21 mai 20:43 tables_priv.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 time_zone.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 time_zone.MYI
-rw-rw---- 1 gilles staff 8636 21 mai 20:43 time_zone.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 time_zone_leap_second.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 time_zone_leap_second.MYI
-rw-rw---- 1 gilles staff 8624 21 mai 20:43 time_zone_leap_second.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 time_zone_name.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 time_zone_name.MYI
-rw-rw---- 1 gilles staff 8606 21 mai 20:43 time_zone_name.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 time_zone_transition.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 time_zone_transition.MYI
-rw-rw---- 1 gilles staff 8686 21 mai 20:43 time_zone_transition.frm
-rw-rw---- 1 gilles staff 0 21 mai 20:43 time_zone_transition_type.MYD
-rw-rw---- 1 gilles staff 1024 21 mai 20:43 time_zone_transition_type.MYI
-rw-rw---- 1 gilles staff 8748 21 mai 20:43 time_zone_transition_type.frm
-rw-rw---- 1 gilles staff 340 21 mai 20:43 user.MYD
-rw-rw---- 1 gilles staff 2048 21 mai 20:43 user.MYI
-rw-rw---- 1 gilles staff 10630 21 mai 20:43 user.frm
./db_data/performance_schema:
total 416
drwx------ 20 gilles staff 640 21 mai 20:43 .
drwxr-xr-x 16 gilles staff 512 21 mai 20:44 ..
-rw-rw---- 1 gilles staff 8624 21 mai 20:43 cond_instances.frm
-rw-rw---- 1 gilles staff 61 21 mai 20:43 db.opt
-rw-rw---- 1 gilles staff 9220 21 mai 20:43 events_waits_current.frm
-rw-rw---- 1 gilles staff 9220 21 mai 20:43 events_waits_history.frm
-rw-rw---- 1 gilles staff 9220 21 mai 20:43 events_waits_history_long.frm
-rw-rw---- 1 gilles staff 8878 21 mai 20:43
events_waits_summary_by_instance.frm
-rw-rw---- 1 gilles staff 8854 21 mai 20:43
events_waits_summary_by_thread_by_event_name.frm
-rw-rw---- 1 gilles staff 8814 21 mai 20:43
events_waits_summary_global_by_event_name.frm
-rw-rw---- 1 gilles staff 8654 21 mai 20:43 file_instances.frm
-rw-rw---- 1 gilles staff 8800 21 mai 20:43 file_summary_by_event_name.frm
-rw-rw---- 1 gilles staff 8840 21 mai 20:43 file_summary_by_instance.frm
-rw-rw---- 1 gilles staff 8684 21 mai 20:43 mutex_instances.frm
-rw-rw---- 1 gilles staff 8776 21 mai 20:43 performance_timers.frm
-rw-rw---- 1 gilles staff 8758 21 mai 20:43 rwlock_instances.frm
-rw-rw---- 1 gilles staff 8605 21 mai 20:43 setup_consumers.frm
-rw-rw---- 1 gilles staff 8637 21 mai 20:43 setup_instruments.frm
-rw-rw---- 1 gilles staff 8650 21 mai 20:43 setup_timers.frm
-rw-rw---- 1 gilles staff 8650 21 mai 20:43 threads.frm
./db_data/test:
total 0
drwx------ 2 gilles staff 64 21 mai 20:43 .
drwxr-xr-x 16 gilles staff 512 21 mai 20:44 ..
bash-3.2$
Gilles
--
You are receiving this mail because:
You are watching all bug changes.
