[Pkg-kde-extras] Bug#895937: digikam: database upgrade from schema 8 to 9 fails

[tv.debian at googlemail.com]

Package: digikam
Version: 4:5.9.0-1
Severity: important

Dear Digikam Maintainer,


    * What led up to the situation?

Upgrading to latest Unstable Digikam version

    * What exactly did you do (or not do) that was effective (or
      ineffective)?

No workaround tried as Digikam exits immediately after database 
migration fails.

Error messages is as follow:

"
digikam.general: AlbumWatch use QFileSystemWatcher
digikam.general: Database Parameters:
    Type:                     "QMYSQL"
    DB Core Name:             "digikamdb"
    DB Thumbs Name:           "digikam_thumbsdb"
    DB Face Name:             "digikam_faces"
    Connect Options:          ""
    Host Name:                "localhost"
    Host port:                3306
    Internal Server:          false
    Internal Server Path:     ""
    Internal Server Serv Cmd: ""
    Internal Server Init Cmd: ""
    Username:                 "digikam"
    Password:                 ""

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: have a structure version  8
digikam.coredb: Core database: makeUpdates  8  to  9
digikam.dbengine: Failure executing query:
  ""
Error messages: "QMYSQL: Unable to execute query" "Illegal mix of 
collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for 
operation '='" 1267 2
Bound values:  ()
digikam.dbengine: Error while executing DBAction [ 
"UpdateSchemaFromV7ToV9" ] Statement [ "CALL 
drop_index_if_exists('AlbumRoots', 'identifier');" ]
digikam.coredb: Core database: schema update to V 9 failed!
digikam.coredb: Core database: cannot process schema initialization
KMemoryInfo: Platform identified :  "LINUX"
KMemoryInfo: TotalRam:  16826564608
digikam.general: Allowing a cache size of 200 MB
QThreadStorage: Thread 0x7f10cf629bc0 exited after QThreadStorage 11 
destroyed
"
Connecting to Mariadb Digikam databases as user "digikam" works, 
checking databases (mysqlcheck) reports no error.

Thank you for your time.

-- System Information:
Debian Release: buster/sid
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.17.0-rc1-deb64 (SMP w/16 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), 
LANGUAGE=fr:en_US (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages digikam depends on:
ii  digikam-data          4:5.9.0-1
ii  digikam-private-libs  4:5.9.0-1
ii  kipi-plugins          4:5.9.0-1
ii  libc6                 2.27-3
ii  libgcc1               1:8-20180414-1
ii  libkf5configcore5     5.44.0-1
ii  libkf5coreaddons5     5.44.0-1
ii  libkf5filemetadata3   5.44.0-1
ii  libkf5i18n5           5.44.0-1
ii  libqt5core5a          5.10.1+dfsg-5
ii  libqt5gui5            5.10.1+dfsg-5
ii  libqt5sql5            5.10.1+dfsg-5
ii  libqt5sql5-mysql      5.10.1+dfsg-5
ii  libqt5sql5-sqlite     5.10.1+dfsg-5
ii  libqt5widgets5        5.10.1+dfsg-5
ii  libstdc++6            8-20180414-1
ii  perl                  5.26.1-6

Versions of packages digikam recommends:
ii  chromium [www-browser]              66.0.3359.26-2
ii  ffmpegthumbs                        4:17.08.3-1
ii  firefox [www-browser]               59.0.2-1
ii  google-chrome-stable [www-browser]  65.0.3325.181-1
ii  konqueror [www-browser]             4:17.08.3-2
ii  lynx [www-browser]                  2.8.9dev17-1

Versions of packages digikam suggests:
pn  digikam-doc     <none>
ii  systemsettings  4:5.12.4-1

-- no debconf information