https://bugs.kde.org/show_bug.cgi?id=435179
--- Comment #23 from gessel <ges...@blackrosetech.com> ---
Initial setup log:
gessel@dg-dl:~/.config$ digikam | tee
/home/gessel/projects/digikam-7.2.0/log.txt
digikam.widgets: Use installed icons
digikam.general: "/home/gessel"
digikam.general: Testing "mysql_install_db" ...
digikam.general: Found "mysql_install_db"
digikam.general: Testing "mysqld" ...
digikam.general: Found "mysqld"
Empty filename passed to function
digikam.general: Root album is : "/media/gessel/datas/pictures/David/Sorted"
digikam.general: AlbumWatch is disabled
digikam.database: Testing DB connection ( "ConnectionTest" ) with these
settings:
digikam.database: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam"
DB Face Name: "digikam"
DB Similarity Name: "digikam"
Connect Options: "UNIX_SOCKET=/var/run/mysqld/mysqld.sock"
Host Name: "localhost"
Host port: 3306
Internal Server: false
Internal Server Path: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "gessel"
Password: "XXXXXXXX"
digikam.database: Testing DB connection ( "ConnectionTest" ) with these
settings:
digikam.database: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam"
DB Face Name: "digikam"
DB Similarity Name: "digikam"
Connect Options: "UNIX_SOCKET=/var/run/mysqld/mysqld.sock"
Host Name: "localhost"
Host port: 3306
Internal Server: false
Internal Server Path: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "gessel"
Password: "XXXXXXXX"
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "digikam"
DB Thumbs Name: "digikam"
DB Face Name: "digikam"
DB Similarity Name: "digikam"
Connect Options: "UNIX_SOCKET=/var/run/mysqld/mysqld.sock"
Host Name: "localhost"
Host port: 3306
Internal Server: false
Internal Server Path: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "gessel"
Password: "XXXXXXXX"
digikam.dbengine: Loading SQL code from config file
"/usr/share/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
digikam.general: KMemoryInfo: Platform identified : "LINUX"
digikam.general: KMemoryInfo: TotalRam: 33417322496
digikam.general: Allowing a cache size of 200 MB
digikam.general: No locale found in database
digikam.general: No locale found in config file
digikam.database: addLocation
QUrl("file:///media/gessel/datas/pictures/David/Sorted")
digikam.database: Creating new Location "/pictures/David/Sorted" uuid
"volumeid:?uuid=0d772d10-716f-43e4-b5d6-a974df395a0e"
digikam.database: location for "/media/gessel/datas/pictures/David/Sorted" is
available true
digikam.thumbsdb: Thumbs database: no database file available
digikam.general: Thumbnails database ready for use
digikam.similaritydb: Similarity database: no database file available
digikam.similaritydb: Similarity database ready for use
Brand new database looks like this as we get into parsing the root album:
MariaDB [(none)]> show table status from digikam;
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free | Auto_increment |
Create_time | Update_time | Check_time | Collation |
Checksum | Create_options | Comment | Max_index_length | Temporary |
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
| AlbumRoots | InnoDB | 10 | Dynamic | 1 | 16384 |
16384 | 0 | 16384 | 0 | 2 |
2021-04-02 22:21:32 | 2021-04-02 22:21:36 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| Albums | InnoDB | 10 | Dynamic | 4645 | 63 |
294912 | 0 | 278528 | 0 | 4646 |
2021-04-02 22:21:32 | 2021-04-02 22:23:29 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| CustomIdentifiers | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 49152 | 0 | NULL |
2021-04-02 22:21:37 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| DownloadHistory | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 16384 | 0 | 1 |
2021-04-02 22:21:33 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| FaceMatrices | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 16384 | 0 | 1 |
2021-04-02 22:23:21 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| FaceSettings | InnoDB | 10 | Dynamic | 2 | 8192 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:23:20 | 2021-04-02 22:23:21 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| FilePaths | InnoDB | 10 | Dynamic | 22 | 744 |
16384 | 0 | 32768 | 0 | NULL |
2021-04-02 22:21:37 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| Identities | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 0 | 0 | 1 |
2021-04-02 22:23:20 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| IdentityAttributes | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 32768 | 0 | NULL |
2021-04-02 22:23:21 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageComments | InnoDB | 10 | Dynamic | 2 | 8192 |
16384 | 0 | 32768 | 0 | 3 |
2021-04-02 22:21:35 | 2021-04-02 22:23:29 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageCopyright | InnoDB | 10 | Dynamic | 70 | 234 |
16384 | 0 | 32768 | 0 | 71 |
2021-04-02 22:21:35 | 2021-04-02 22:23:29 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageHaarMatrix | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 0 | 0 | NULL |
2021-04-02 22:21:37 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageHistory | InnoDB | 10 | Dynamic | 5 | 3276 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:35 | 2021-04-02 22:23:29 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageInformation | InnoDB | 10 | Dynamic | 49 | 334 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:34 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageMetadata | InnoDB | 10 | Dynamic | 44 | 372 |
16384 | 0 | 0 | 0 | NULL |
2021-04-02 22:21:32 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImagePositions | InnoDB | 10 | Dynamic | 5 | 3276 |
16384 | 0 | 0 | 0 | NULL |
2021-04-02 22:21:33 | 2021-04-02 22:23:29 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageProperties | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:33 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageRelations | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 65536 | 0 | NULL |
2021-04-02 22:21:35 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageSimilarity | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:37 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageTagProperties | InnoDB | 10 | Dynamic | 4 | 4096 |
16384 | 0 | 81920 | 0 | NULL |
2021-04-02 22:21:36 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ImageTags | InnoDB | 10 | Dynamic | 24 | 682 |
16384 | 0 | 32768 | 0 | NULL |
2021-04-02 22:21:34 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| Images | InnoDB | 10 | Dynamic | 49 | 334 |
16384 | 0 | 65536 | 0 | 50 |
2021-04-02 22:21:34 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| KDTree | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 65536 | 0 | 1 |
2021-04-02 22:23:21 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| Searches | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 0 | 0 | 1 |
2021-04-02 22:21:33 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| Settings | InnoDB | 10 | Dynamic | 16 | 1024 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:34 | 2021-04-02 22:21:36 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| SimilaritySettings | InnoDB | 10 | Dynamic | 2 | 8192 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:37 | 2021-04-02 22:21:37 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| TagProperties | InnoDB | 10 | Dynamic | 23 | 712 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:35 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| Tags | InnoDB | 10 | Dynamic | 24 | 682 |
16384 | 0 | 32768 | 0 | 24 |
2021-04-02 22:21:33 | 2021-04-02 22:23:32 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| TagsTree | InnoDB | 10 | Dynamic | 41 | 399 |
16384 | 0 | 0 | 0 | NULL |
2021-04-02 22:21:33 | 2021-04-02 22:23:32 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| ThumbSettings | InnoDB | 10 | Dynamic | 2 | 8192 |
16384 | 0 | 16384 | 0 | NULL |
2021-04-02 22:21:37 | 2021-04-02 22:21:37 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| Thumbnails | InnoDB | 10 | Dynamic | 22 | 4468 |
98304 | 0 | 0 | 0 | 23 |
2021-04-02 22:21:36 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| UniqueHashes | InnoDB | 10 | Dynamic | 22 | 744 |
16384 | 0 | 32768 | 0 | NULL |
2021-04-02 22:21:37 | 2021-04-02 22:23:33 | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
| VideoMetadata | InnoDB | 10 | Dynamic | 0 | 0 |
16384 | 0 | 0 | 0 | NULL |
2021-04-02 22:21:33 | NULL | NULL | utf8mb4_general_ci |
NULL | | | 0 | N |
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
33 rows in set (0.010 sec)
--
You are receiving this mail because:
You are watching all bug changes.
