https://bugs.kde.org/show_bug.cgi?id=332781
Bug ID: 332781 Summary: Akonadi server fails to start right after upgrading to 1.12.0 Classification: Unclassified Product: Akonadi Version: 1.12.0 Platform: Archlinux Packages OS: Linux Status: UNCONFIRMED Severity: grave Priority: NOR Component: server Assignee: kdepim-bugs@kde.org Reporter: m...@aitorpazos.es Right after upgrading to 1.12.0, akonadi fails to start. I was using the internal MySQL (MariaDB) based setup. With this setup I received messages from akonadi than using the external DB configuration but mysqld complains about several instances running at the same time. Indeed, akonadi spawns many mysqld instances: ------------------------------------------------BEGIN---------------------------------------------------------------------- InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. -------------------------------------------------END--------------------------------------------------------------------- Changing it to a manually defined connection "akonadictl start" returns the following error: -------------------------------------------------BEGIN--------------------------------------------------------------------- Connecting to deprecated signal aitor@Apidell ~/.local/share/akonadi/db_data $QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) search paths: ("/opt/simili/tcl/bin", "/usr/lib/nx/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/bin", "/opt/android-sdk/platform-tools", "/usr/share/java/gradle/bin", "/opt/java/bin", "/opt/java/db/bin", "/opt/java/jre/bin", "/usr/bin/vendor_perl", "/usr/bin/core_perl", "/home/aitor/bin", "/home/aitor/src/androidSDK/adt-bundle-linux-x86_64-20130522/sdk/platform-tools/", "/home/aitor/src/androidSDK/adt-bundle-linux-x86_64-20130522/sdk/tools/", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work. "" Unable to initialize database. "[ 0: akonadiserver(_Z11akBacktracev+0x37) [0x463047] 1: akonadiserver() [0x46328d] 2: /usr/lib/libc.so.6(+0x35400) [0x7fe168d57400] 3: /usr/lib/libc.so.6(gsignal+0x39) [0x7fe168d57389] 4: /usr/lib/libc.so.6(abort+0x148) [0x7fe168d58788] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x5f) [0x7fe16a85d90f] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x4651bd] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7fe16a8f8500] 8: /usr/lib/libQtCore.so.4(+0x1188fd) [0x7fe16a9058fd] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7fe16a90e4e3] 10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5fa) [0x467faa] 11: /usr/lib/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fe16a97fefe] 12: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fe16a967ebd] 13: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7fe16a96af0f] 14: /usr/lib/libQtCore.so.4(+0x1a8263) [0x7fe16a995263] 15: /usr/lib/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7fe168433296] 16: /usr/lib/libglib-2.0.so.0(+0x485e8) [0x7fe1684335e8] 17: /usr/lib/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fe16843368c] 18: /usr/lib/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7fe16a994b25] 19: /usr/lib/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fe16a966b1f] 20: /usr/lib/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fe16a966e15] 21: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7fe16a96bf4b] 22: akonadiserver(main+0x1bf) [0x45ca9f] 23: /usr/lib/libc.so.6(__libc_start_main+0xf5) [0x7fe168d43b05] 24: akonadiserver() [0x45d1e8] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) ------------------------------------------END---------------------------------------------------------------------------- I'm able to connect to mysqld instance from any other client without any problem. This is my current akonadi DB schema (generated with MySQL workbench): ------------------------------------------BEGIN--------------------------------------------------------------------------- -- ----------------------------------------------------- -- Table `resourcetable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `resourcetable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `name` VARBINARY(255) NOT NULL, `isVirtual` TINYINT(1) NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE INDEX `name` (`name` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 30 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `collectiontable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `collectiontable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `remoteId` VARBINARY(255) NULL DEFAULT NULL, `remoteRevision` VARBINARY(255) NULL DEFAULT NULL, `name` VARBINARY(255) NOT NULL, `parentId` BIGINT(20) NULL DEFAULT NULL, `resourceId` BIGINT(20) NOT NULL, `subscribed` TINYINT(1) NOT NULL DEFAULT '1', `cachePolicyInherit` TINYINT(1) NOT NULL DEFAULT '1', `cachePolicyCheckInterval` INT(11) NOT NULL DEFAULT '-1', `cachePolicyCacheTimeout` INT(11) NOT NULL DEFAULT '-1', `cachePolicySyncOnDemand` TINYINT(1) NOT NULL DEFAULT '0', `cachePolicyLocalParts` VARBINARY(255) NULL DEFAULT NULL, `queryString` VARBINARY(32768) NULL DEFAULT NULL, `queryLanguage` VARBINARY(255) NULL DEFAULT NULL, `isVirtual` TINYINT(1) NULL DEFAULT '0', `queryAttributes` VARBINARY(255) NULL DEFAULT NULL, `queryCollections` VARBINARY(255) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 1184 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `collectionattributetable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `collectionattributetable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `collectionId` BIGINT(20) NOT NULL, `type` LONGBLOB NOT NULL, `value` LONGBLOB NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 6886 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `mimetypetable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mimetypetable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `name` VARBINARY(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `name` (`name` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 20 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `collectionmimetyperelation` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `collectionmimetyperelation` ( `Collection_id` BIGINT(20) NOT NULL, `MimeType_id` BIGINT(20) NOT NULL, PRIMARY KEY (`Collection_id`, `MimeType_id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `pimitemtable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `pimitemtable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `rev` INT(11) NOT NULL DEFAULT '0', `remoteId` VARBINARY(255) NULL DEFAULT NULL, `remoteRevision` VARBINARY(255) NULL DEFAULT NULL, `collectionId` BIGINT(20) NULL DEFAULT NULL, `mimeTypeId` BIGINT(20) NULL DEFAULT NULL, `datetime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `atime` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', `dirty` TINYINT(1) NULL DEFAULT NULL, `size` BIGINT(20) NOT NULL DEFAULT '0', `gid` VARBINARY(255) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `PimItemTable_gidIndex` (`gid` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 701423 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `collectionpimitemrelation` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `collectionpimitemrelation` ( `Collection_id` BIGINT(20) NOT NULL, `PimItem_id` BIGINT(20) NOT NULL, PRIMARY KEY (`Collection_id`, `PimItem_id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `flagtable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `flagtable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `name` VARBINARY(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `name` (`name` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 33 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `parttable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `parttable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `pimItemId` BIGINT(20) NOT NULL, `name` VARBINARY(255) NOT NULL, `data` LONGBLOB NULL DEFAULT NULL, `datasize` BIGINT(20) NOT NULL, `version` INT(11) NULL DEFAULT '0', `external` TINYINT(1) NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `PartTable_pimItemNameIndex` (`name` ASC)) ENGINE = InnoDB AUTO_INCREMENT = 1183423 DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `parttypetable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `parttypetable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `name` VARBINARY(255) NOT NULL, `ns` VARBINARY(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `PartTypeTable_partTypeNameIndex` (`ns` ASC, `name` ASC)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `pimitemflagrelation` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `pimitemflagrelation` ( `PimItem_id` BIGINT(20) NOT NULL, `Flag_id` BIGINT(20) NOT NULL, PRIMARY KEY (`PimItem_id`, `Flag_id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `tagtable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `tagtable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `gid` VARBINARY(255) NOT NULL, `parentId` BIGINT(20) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `pimitemtagrelation` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `pimitemtagrelation` ( `PimItem_id` BIGINT(20) NOT NULL, `Tag_id` BIGINT(20) NOT NULL, PRIMARY KEY (`PimItem_id`, `Tag_id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `schemaversiontable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `schemaversiontable` ( `version` INT(11) NOT NULL DEFAULT '0') ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `tagattributetable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `tagattributetable` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `tagId` BIGINT(20) NOT NULL, `type` LONGBLOB NOT NULL, `value` LONGBLOB NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; -- ----------------------------------------------------- -- Table `tagremoteidresourcerelationtable` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `tagremoteidresourcerelationtable` ( `tagId` BIGINT(20) NOT NULL, `resourceId` BIGINT(20) NOT NULL, `remoteId` VARBINARY(255) NOT NULL) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8; Reproducible: Always Steps to Reproduce: 1. run "akonadictl start" using either internal or external DB configuration 2. 3. Actual Results: using internal configuration akonadi spawns multiple mysqld instances but it fails to start in the same way as using the external configuration Expected Results: Akonadi should start correctly Distro: Archlinux Kernel: 3.13.7-1-ARCH KDE 4.12 Akonadi: 1.12.0 MariaDB: 5.5.34-MariaDB-31.1 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs