[Akonadi] [Bug 409853] New: akonadiserver runs dbinitializer even when db is already filled with data and dies

[Mathias Homann]

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

            Bug ID: 409853
           Summary: akonadiserver runs dbinitializer even when db is
                    already filled with data and dies
           Product: Akonadi
           Version: 5.11.3
          Platform: openSUSE RPMs
                OS: Linux
            Status: REPORTED
          Severity: critical
          Priority: NOR
         Component: general
          Assignee: kdepim-bugs at kde.org
          Reporter: Mathias.Homann at opensuse.org
  Target Milestone: ---

on my desktop workstation, akonadi is configured to use a central mysql
database on a database server (~ is on NFS, 'nuff said). Since 5.11.3 akonadi
dies after 
the first setup, due to dbinitializer in this configuration not realizng that
the DB is already initialized.

STEPS TO REPRODUCE
1. do a fresh akonadi configuration using a mysql database on a different
machine via tcp/ip, set up some akonadi agents as usual - imap, webdav
calendar, google, etc
2. wait for akonadi to fill with data
3. log out (and maybe restart your desktop workstation to make sure all akonadi
processes are stopped)
4. log back in


OBSERVED RESULT
akonadiserver is not running

EXPECTED RESULT
akonadiserver should be running


SOFTWARE/OS VERSIONS

Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 5.16.3
KDE Frameworks Version: 5.59.0
Qt Version: 5.13.0

ADDITIONAL INFORMATION
when running "akonadiserver --verbose" on a commandline:
lemmy at kumiko:~> akonadiserver --verbose
org.kde.pim.akonadiserver: Akonadi control process not found - aborting.
org.kde.pim.akonadiserver: If you started akonadiserver manually, try
'akonadictl start' instead.
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Found mysql_install_db:  "/usr/bin/mysql_install_db"
org.kde.pim.akonadiserver: Found mysqlcheck:  "/usr/bin/mysqlcheck"
org.kde.pim.akonadiserver: Using mysqld: "/usr/sbin/mysqld"
org.kde.pim.akonadiserver: Database "lemmy_akonadi" opened using driver
"QMYSQL"
org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: checking table  "SchemaVersionTable"
org.kde.pim.akonadiserver: "ALTER TABLE SchemaVersionTable ADD COLUMN version
INTEGER NOT NULL DEFAULT 0"
org.kde.pim.akonadiserver: "\nSql error: Duplicate column name 'version'
QMYSQL: Unable to execute query\nQuery: ALTER TABLE SchemaVersionTable ADD
COLUMN version INTEGER NOT NULL DEFAULT 0"
org.kde.pim.akonadiserver: Unable to initialize database.
org.kde.pim.akonadiserver: terminating connection threads
org.kde.pim.akonadiserver: terminating service threads
org.kde.pim.akonadiserver: Shutting down "NotificationManager" ...
org.kde.pim.akonadiserver: stopping db process
lemmy at kumiko:~> akonadiserver --version
akonadiserver 5.11.3
lemmy at kumiko:~>


Observe the dbinitializer trying to add a column to a table where that column
already exists.

-- 
You are receiving this mail because:
You are the assignee for the bug.