[opensuse-support] Akonadi fails to start after latest Tumbleweed update (snapshot 20190721)
Hi all, Sending this from Thunderbird because my KMail/Akonadi install is non-functional after updating to Tumbleweed snapshot 20190721). Running akonadictl start --verbose produces the following output: 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 "akonadidb" 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 org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally... I've tried dropping the column in question so akonadi can recreate it, but then it generates the same error for the second column in SchemaVersionTable. If I drop SchemaVersionTable from the database, it fails on the next table. It seems as though akonadi is now trying to initialise the database from scratch, when it should simply be using the existing database as-is. I have no idea what's caused this - nothing has changed apart from zypper dup to the latest snapshot. It was working prior to the upgrade, and stopped working after the reboot. Yes, I can login to MariaDB using the configured akonadi user/password, I can use the configured database, I can view the schema and the tables and I can select data from the tables. I can't find a configuration option anywhere that could be forcing akonadi to initialise the database from scratch, but I may be looking in the wrong places. Any suggestions welcome. If there's no quick fix, looks like a bug report on the way. Regards, Rodney. -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
On 25/07/2019 0:47, Rodney Baker wrote:
Hi all,
Sending this from Thunderbird because my KMail/Akonadi install is non-functional after updating to Tumbleweed snapshot 20190721).
Running akonadictl start --verbose produces the following output: [...]
Bugzilla ID 1142680. -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
* Rodney Baker <rodney.baker@iinet.net.au> [07-24-19 11:19]:
Hi all,
Sending this from Thunderbird because my KMail/Akonadi install is non-functional after updating to Tumbleweed snapshot 20190721).
Running akonadictl start --verbose produces the following output:
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"
try: akonadictl restart -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
On 25/07/2019 1:36, Patrick Shanahan wrote:
Hi all,
Sending this from Thunderbird because my KMail/Akonadi install is non-functional after updating to Tumbleweed snapshot 20190721).
Running akonadictl start --verbose produces the following output:
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"
* Rodney Baker <rodney.baker@iinet.net.au> [07-24-19 11:19]: try: akonadictl restart
Restart doesn't work when it isn't running first. Already tried that. It is a known bug with a fix waiting, but the fix has been blocked by other updates. Apparently the version in KDE:Applications already has the fix, but I haven't had time to test that yet. -- ============================================================================== Rodney Baker VK5ZTV rodney.baker@iinet.net.au ============================================================================== -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
On 25/07/2019 1:36, Patrick Shanahan wrote:
Hi all,
Sending this from Thunderbird because my KMail/Akonadi install is non-functional after updating to Tumbleweed snapshot 20190721).
Running akonadictl start --verbose produces the following output:
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"
* Rodney Baker <rodney.baker@iinet.net.au> [07-24-19 11:19]: try: akonadictl restart
Installing akonadi-server from KDE:Applications fixes the issue. Hopefully the fix will make it into the main OSS repo eventually. -- ============================================================================== Rodney Baker VK5ZTV rodney.baker@iinet.net.au ============================================================================== -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
participants (2)
-
Patrick Shanahan
-
Rodney Baker