https://bugs.kde.org/show_bug.cgi?id=467766

--- Comment #18 from Petr Schonmann <pschonm...@gmail.com> ---
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.

Reply via email to