Akonadi closed unexpectedly

Board index

Page 1 of 1 (6 posts)

Tags:

metcalsr Registered Member Posts 3 Karma 0	Akonadi closed unexpectedly Mon Jan 27, 2020 4:01 am Hi guys, I installed Manjaro ARM KDE on my pinebook pro. It's fast and works great, but unfortunately, I'm completely unable to use most KDE software. The problem is that I can't get Akonadi to work properly. Anyone have an idea of what's going on? akonadictl start output: org.kde.pim.akonadicontrol: Service org.freedesktop.Akonadi.Control.lock already registered, terminating now. Error: akonadi_control was started but didn't register at D-Bus session bus. Make sure your system is set up correctly! akonaditest output: Creating test environment in "/tmp/aktestrunner-20140/" Copying "/xdgconfig" to "/tmp/aktestrunner-20140/config" Copying "" to "/tmp/aktestrunner-20140/data" Invalid backend name Started akonadi daemon with pid: 20143 "/tmp/aktestrunner-20140/testenvironment.sh" Icon theme "gnome" not found. Icon theme "gnome" not found. Icon theme "gnome" not found. Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadicontrol: Service ":1.190" owner changed from "" to ":1.190" org.kde.pim.akonadicontrol: Service ":1.191" owner changed from "" to ":1.191" 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/bin/mysqld" org.kde.pim.akonadiserver: mysqld reports version 10.4.11 (MariaDB) org.kde.pim.akonadiserver: Executing: "/usr/bin/mysql_install_db" "--defaults-file= --force --basedir=/usr --datadir=/tmp/aktestrunner-20140/data/akonadi/instance/testrunner-20140/db_data/" Installing MariaDB/MySQL system tables in '/tmp/aktestrunner-20140/data/akonadi/instance/testrunner-20140/db_data/' ... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system Two all-privilege accounts were created. One is root@localhost, it has no password, but you need to be system 'root' user to connect. Use, for example, sudo mysql The second is steve@localhost, it has no password either, but you need to be the system 'steve' user to connect. After connecting you can set the password, if you would need to be able to connect as any of these users with a password and without sudo See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions. You can start the MariaDB daemon with: cd '/usr' ; /usr/bin/mysqld_safe --datadir='/tmp/aktestrunner-20140/data/akonadi/instance/testrunner-20140/db_data/' You can test the MariaDB daemon with mysql-test-run.pl cd '/usr/mysql-test' ; perl mysql-test-run.pl Please report any problems at http://mariadb.org/jira The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/ org.kde.pim.akonadiserver: Executing: "/usr/bin/mysqld" "--defaults-file=/tmp/aktestrunner-20140/data/akonadi/instance/testrunner-20140/mysql.conf --datadir=/tmp/aktestrunner-20140/data/akonadi/instance/testrunner-20140/db_data/ --socket=/run/user/1000/akonadi/instance/testrunner-20140/mysql.socket --pid-file=/run/user/1000/akonadi/instance/testrunner-20140/mysql.pid" org.kde.pim.akonadiserver: Executing: "/usr/bin/mysqlcheck" "--defaults-file=/tmp/aktestrunner-20140/data/akonadi/instance/testrunner-20140/mysql.conf --check-upgrade --auto-repair --socket=/run/user/1000/akonadi/instance/testrunner-20140/mysql.socket akonadi" /usr/bin/mysqlcheck: Got error: 1049: Unknown database 'akonadi' when selecting the database org.kde.pim.akonadiserver: MySQL version OK (required "5.1" , available "10.4" ) org.kde.pim.akonadiserver: Failed to use database "akonadi" org.kde.pim.akonadiserver: Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query" org.kde.pim.akonadiserver: Database error: "" org.kde.pim.akonadiserver: Trying to create database now... org.kde.pim.akonadiserver: Database "akonadi" opened using driver "QMYSQL" org.kde.pim.akonadiserver: Running DB initializer org.kde.pim.akonadiserver: checking table "SchemaVersionTable" org.kde.pim.akonadiserver: "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL DEFAULT 0, generation INTEGER NOT NULL DEFAULT 0) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: "INSERT INTO SchemaVersionTable (version) VALUES (41)" org.kde.pim.akonadiserver: checking table "ResourceTable" org.kde.pim.akonadiserver: "CREATE TABLE ResourceTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE, isVirtual BOOL DEFAULT false) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: "INSERT INTO ResourceTable (isVirtual,name) VALUES (true,'akonadi_search_resource')" org.kde.pim.akonadiserver: checking table "CollectionTable" org.kde.pim.akonadiserver: "CREATE TABLE CollectionTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, remoteId VARBINARY(255), remoteRevision VARBINARY(255), name VARBINARY(255) NOT NULL, parentId BIGINT, resourceId BIGINT NOT NULL, enabled BOOL NOT NULL DEFAULT true, syncPref TINYINT DEFAULT 2, displayPref TINYINT DEFAULT 2, indexPref TINYINT DEFAULT 2, cachePolicyInherit BOOL NOT NULL DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false, cachePolicyLocalParts VARBINARY(255), queryString VARBINARY(32768), queryAttributes VARBINARY(255), queryCollections VARBINARY(255), isVirtual BOOL DEFAULT false, FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC" org.kde.pim.akonadiserver: "INSERT INTO CollectionTable (isVirtual,name,parentId,resourceId) VALUES (true,'Search',NULL,1)" org.kde.pim.akonadiserver: checking table "MimeTypeTable" org.kde.pim.akonadiserver: "CREATE TABLE MimeTypeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "PimItemTable" org.kde.pim.akonadiserver: "CREATE TABLE PimItemTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, rev INTEGER NOT NULL DEFAULT 0, remoteId VARBINARY(1024), remoteRevision VARBINARY(255), gid VARBINARY(255), collectionId BIGINT, mimeTypeId BIGINT, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, dirty BOOL, size BIGINT NOT NULL DEFAULT 0, FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC" org.kde.pim.akonadiserver: checking table "FlagTable" org.kde.pim.akonadiserver: "CREATE TABLE FlagTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "PartTypeTable" org.kde.pim.akonadiserver: "CREATE TABLE PartTypeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL, ns VARBINARY(255) NOT NULL) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "PartTable" org.kde.pim.akonadiserver: "CREATE TABLE PartTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, pimItemId BIGINT NOT NULL, partTypeId BIGINT NOT NULL, data LONGBLOB, datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, storage TINYINT DEFAULT 0, FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "CollectionAttributeTable" org.kde.pim.akonadiserver: "CREATE TABLE CollectionAttributeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, collectionId BIGINT NOT NULL, type LONGBLOB NOT NULL, value LONGBLOB, FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "TagTypeTable" org.kde.pim.akonadiserver: "CREATE TABLE TagTypeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: "INSERT INTO TagTypeTable (name) VALUES ('PLAIN')" org.kde.pim.akonadiserver: checking table "TagTable" org.kde.pim.akonadiserver: "CREATE TABLE TagTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, gid VARBINARY(255) NOT NULL, parentId BIGINT, typeId BIGINT DEFAULT 1, FOREIGN KEY (parentId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (typeId) REFERENCES TagTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "TagAttributeTable" org.kde.pim.akonadiserver: "CREATE TABLE TagAttributeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, tagId BIGINT NOT NULL, type LONGBLOB NOT NULL, value LONGBLOB, FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "TagRemoteIdResourceRelationTable" org.kde.pim.akonadiserver: "CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL, resourceId BIGINT NOT NULL, remoteId VARBINARY(255) NOT NULL, FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "RelationTypeTable" org.kde.pim.akonadiserver: "CREATE TABLE RelationTypeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: "INSERT INTO RelationTypeTable (name) VALUES ('GENERIC')" org.kde.pim.akonadiserver: checking table "RelationTable" org.kde.pim.akonadiserver: "CREATE TABLE RelationTable (leftId BIGINT NOT NULL, rightId BIGINT NOT NULL, typeId BIGINT DEFAULT 1, remoteId VARBINARY(255), FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "PimItemFlagRelation" org.kde.pim.akonadiserver: "CREATE TABLE PimItemFlagRelation (PimItem_id BIGINT NOT NULL, Flag_id BIGINT NOT NULL, PRIMARY KEY (PimItem_id, Flag_id), FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Flag_id) REFERENCES FlagTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "PimItemTagRelation" org.kde.pim.akonadiserver: "CREATE TABLE PimItemTagRelation (PimItem_id BIGINT NOT NULL, Tag_id BIGINT NOT NULL, PRIMARY KEY (PimItem_id, Tag_id), FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Tag_id) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "CollectionMimeTypeRelation" org.kde.pim.akonadiserver: "CREATE TABLE CollectionMimeTypeRelation (Collection_id BIGINT NOT NULL, MimeType_id BIGINT NOT NULL, PRIMARY KEY (Collection_id, MimeType_id), FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (MimeType_id) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: checking table "CollectionPimItemRelation" org.kde.pim.akonadiserver: "CREATE TABLE CollectionPimItemRelation (Collection_id BIGINT NOT NULL, PimItem_id BIGINT NOT NULL, PRIMARY KEY (Collection_id, PimItem_id), FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" org.kde.pim.akonadiserver: Generation: 1580097598 org.kde.pim.akonadiserver: DB initializer done org.kde.pim.akonadiserver: skipping update 2 org.kde.pim.akonadiserver: skipping update 3 org.kde.pim.akonadiserver: skipping update 4 org.kde.pim.akonadiserver: skipping update 8 org.kde.pim.akonadiserver: skipping update 10 org.kde.pim.akonadiserver: skipping update 12 org.kde.pim.akonadiserver: skipping update 13 org.kde.pim.akonadiserver: skipping update 14 org.kde.pim.akonadiserver: skipping update 15 org.kde.pim.akonadiserver: skipping update 16 org.kde.pim.akonadiserver: skipping update 17 org.kde.pim.akonadiserver: skipping update 18 org.kde.pim.akonadiserver: skipping update 19 org.kde.pim.akonadiserver: skipping update 20 org.kde.pim.akonadiserver: skipping update 21 org.kde.pim.akonadiserver: skipping update 22 org.kde.pim.akonadiserver: skipping update 23 org.kde.pim.akonadiserver: skipping update 24 org.kde.pim.akonadiserver: skipping update 25 org.kde.pim.akonadiserver: skipping update 26 org.kde.pim.akonadiserver: skipping update 28 org.kde.pim.akonadiserver: skipping update 30 org.kde.pim.akonadiserver: skipping update 31 org.kde.pim.akonadiserver: skipping update 33 org.kde.pim.akonadiserver: skipping update 35 org.kde.pim.akonadiserver: skipping update 36 org.kde.pim.akonadiserver: skipping update 37 org.kde.pim.akonadiserver: skipping update 39 org.kde.pim.akonadiserver: skipping update 41 org.kde.pim.akonadiserver: Updating indexes org.kde.pim.akonadiserver: "CREATE UNIQUE INDEX CollectionTable_parentAndNameIndex ON CollectionTable (parentId,name)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionTable_parentIndex ON CollectionTable (parentId)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionTable_resourceIndex ON CollectionTable (resourceId)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionTable_enabledIndex ON CollectionTable (enabled)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionTable_syncPrefIndex ON CollectionTable (syncPref)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionTable_displayPrefIndex ON CollectionTable (displayPref)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionTable_indexPrefIndex ON CollectionTable (indexPref)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemTable_collectionIndex ON PimItemTable (collectionId)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemTable_mimeTypeIndex ON PimItemTable (mimeTypeId)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemTable_gidIndex ON PimItemTable (gid)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemTable_ridIndex ON PimItemTable (remoteId)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemTable_idSortIndex ON PimItemTable (id DESC)" org.kde.pim.akonadiserver: "CREATE UNIQUE INDEX PartTypeTable_partTypeNameIndex ON PartTypeTable (ns,name)" org.kde.pim.akonadiserver: "CREATE UNIQUE INDEX PartTable_pimItemIdTypeIndex ON PartTable (pimItemId,partTypeId)" org.kde.pim.akonadiserver: "CREATE INDEX PartTable_pimItemIdSortIndex ON PartTable (pimItemId DESC)" org.kde.pim.akonadiserver: "CREATE INDEX PartTable_partTypeIndex ON PartTable (partTypeId)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionAttributeTable_collectionIndex ON CollectionAttributeTable (collectionId)" org.kde.pim.akonadiserver: "CREATE INDEX TagTable_parentIndex ON TagTable (parentId)" org.kde.pim.akonadiserver: "CREATE INDEX TagTable_typeIndex ON TagTable (typeId)" org.kde.pim.akonadiserver: "CREATE INDEX TagAttributeTable_tagIndex ON TagAttributeTable (tagId)" org.kde.pim.akonadiserver: "CREATE UNIQUE INDEX TagRemoteIdResourceRelationTable_TagAndResourceIndex ON TagRemoteIdResourceRelationTable (tagId,resourceId)" org.kde.pim.akonadiserver: "CREATE INDEX TagRemoteIdResourceRelationTable_tagIndex ON TagRemoteIdResourceRelationTable (tagId)" org.kde.pim.akonadiserver: "CREATE INDEX TagRemoteIdResourceRelationTable_resourceIndex ON TagRemoteIdResourceRelationTable (resourceId)" org.kde.pim.akonadiserver: "CREATE UNIQUE INDEX RelationTable_RelationIndex ON RelationTable (leftId,rightId,typeId)" org.kde.pim.akonadiserver: "CREATE INDEX RelationTable_leftIndex ON RelationTable (leftId)" org.kde.pim.akonadiserver: "CREATE INDEX RelationTable_rightIndex ON RelationTable (rightId)" org.kde.pim.akonadiserver: "CREATE INDEX RelationTable_typeIndex ON RelationTable (typeId)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemFlagRelation_PimItem_idIndex ON PimItemFlagRelation (PimItem_id)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemFlagRelation_Flag_idIndex ON PimItemFlagRelation (Flag_id)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemFlagRelation_pimItemIdSortIndex ON PimItemFlagRelation (pimitem_id DESC)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemTagRelation_PimItem_idIndex ON PimItemTagRelation (PimItem_id)" org.kde.pim.akonadiserver: "CREATE INDEX PimItemTagRelation_Tag_idIndex ON PimItemTagRelation (Tag_id)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionMimeTypeRelation_Collection_idIndex ON CollectionMimeTypeRelation (Collection_id)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionMimeTypeRelation_MimeType_idIndex ON CollectionMimeTypeRelation (MimeType_id)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionPimItemRelation_Collection_idIndex ON CollectionPimItemRelation (Collection_id)" org.kde.pim.akonadiserver: "CREATE INDEX CollectionPimItemRelation_PimItem_idIndex ON CollectionPimItemRelation (PimItem_id)" org.kde.pim.akonadiserver: Indexes successfully created org.kde.pim.akonadiserver.search: SEARCH MANAGER: searching in "/usr/lib/qt/plugins/akonadi" : ("akonadi_search_plugin.so", "akonadi_test_searchplugin.so", "calendarsearchstore.so", "contactsearchstore.so", "emailsearchstore.so", "notesearchstore.so") org.kde.pim.akonadiserver: Database "akonadi" opened using driver "QMYSQL" org.kde.pim.akonadicontrol: Service ":1.192" owner changed from "" to ":1.192" Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadiserver: Database "akonadi" opened using driver "QMYSQL" org.kde.pim.akonadiserver.search: Search loop is waiting, will wake again in -1 ms org.kde.pim.akonadicontrol: Service ":1.193" owner changed from "" to ":1.193" KCrash: crashing... crashRecursionCounter = 2 KCrash: Application Name = akonadiserver path = /usr/bin pid = 20146 KCrash: Arguments: /usr/bin/akonadiserver --instance testrunner-20140 KCrash: Attempting to start /usr/lib/drkonqi from kdeinit sock_file=/run/user/1000/kdeinit5__0 QSocketNotifier: Invalid socket 7 and type 'Read', disabling... QSocketNotifier: Invalid socket 20 and type 'Read', disabling... QSocketNotifier: Invalid socket 25 and type 'Read', disabling... org.kde.pim.akonadicontrol: Service "org.freedesktop.Akonadi.Janitor.testrunner-20140" owner changed from "" to ":1.193" org.kde.pim.akonadicontrol: Service "org.freedesktop.Akonadi.Janitor.testrunner-20140" owner changed from ":1.193" to "" org.kde.pim.akonadicontrol: Service ":1.193" owner changed from ":1.193" to "" org.kde.pim.akonadicontrol: Service ":1.191" owner changed from ":1.191" to "" org.kde.pim.akonadicontrol: Service ":1.192" owner changed from ":1.192" to "" org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY: org.kde.pim.akonadiserver: Error code: "2006" org.kde.pim.akonadiserver: DB error: "MySQL server has gone away" org.kde.pim.akonadiserver: Error text: "MySQL server has gone away QMYSQL3: Unable to prepare statement" org.kde.pim.akonadiserver: Query: "SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.remoteRevision, CollectionTable.name, CollectionTable.parentId, CollectionTable.resourceId, CollectionTable.enabled, CollectionTable.syncPref, CollectionTable.displayPref, CollectionTable.indexPref, CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval, CollectionTable.cachePolicyCacheTimeout, CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts, CollectionTable.queryString, CollectionTable.queryAttributes, CollectionTable.queryCollections, CollectionTable.isVirtual FROM CollectionTable" org.kde.pim.akonadiserver: Failed to query initial collections for scheduler! org.kde.pim.akonadiserver: Not a fatal error, no collections will be scheduled for sync or cache expiration! org.kde.pim.akonadiserver.search: SEARCH MANAGER: searching in "/usr/bin/akonadi" : () org.kde.pim.akonadiserver: DataStore::unhideAllPimItems() org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY: org.kde.pim.akonadiserver: Error code: "2006" org.kde.pim.akonadiserver: DB error: "MySQL server has gone away" org.kde.pim.akonadiserver: Error text: "MySQL server has gone away QMYSQL3: Unable to prepare statement" org.kde.pim.akonadiserver: Query: "SELECT id, name FROM PartTypeTable WHERE ( ns = :0 AND name = :1 )" org.kde.pim.akonadiserver: Error during selection of record with ns "ATR" from table "PartTypeTable" "MySQL server has gone away QMYSQL3: Unable to prepare statement" org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY: org.kde.pim.akonadiserver: Error code: "2006" org.kde.pim.akonadiserver: DB error: "MySQL server has gone away" org.kde.pim.akonadiserver: Error text: "MySQL server has gone away QMYSQL3: Unable to prepare statement" org.kde.pim.akonadiserver: Query: "INSERT INTO PartTypeTable (name, ns) VALUES (:0, :1)" org.kde.pim.akonadiserver: Error during insertion into table "PartTypeTable" "MySQL server has gone away QMYSQL3: Unable to prepare statement" org.kde.pim.akonadiserver: Unable to connect to dbus service: "Not connected to D-Bus server" org.kde.pim.akonadiserver: terminating connection threads org.kde.pim.akonadiserver: terminating service threads org.kde.pim.akonadiserver: Shutting down "CacheCleaner" ... org.kde.pim.akonadiserver: Shutting down "IntervalCheck" ... org.kde.pim.akonadicontrol: Service ":1.194" owner changed from "" to ":1.194" org.kde.pim.akonadicontrol: Service "org.kde.drkonqi-20146" owner changed from "" to ":1.194" org.kde.pim.akonadicontrol: Service ":1.195" owner changed from "" to ":1.195" Last edited by metcalsr on Mon Jan 27, 2020 1:15 pm, edited 1 time in total.
raphaelra Registered Member Posts 209 Karma 0 OS	Re: Akonadi closed unexpectedly Mon Jan 27, 2020 9:20 am Would you please edit your post and use the BBCode so that we can see, what is the akonadi output and what is your text. Do you start your MariaDB server at the boot time ?
metcalsr Registered Member Posts 3 Karma 0	Re: Akonadi closed unexpectedly Mon Jan 27, 2020 1:18 pm raphaelra wrote:Would you please edit your post and use the BBCode so that we can see, what is the akonadi output and what is your text. Do you start your MariaDB server at the boot time ? I put them in a quote block, if you'd prefer different tags just tell me. I haven't touched the processes or any config files. I'm still new to KDE and haven't had to use mariaDB on other DEs. I just installed Korganizer off the Manjaro extras repo.
raphaelra Registered Member Posts 209 Karma 0 OS	Re: Akonadi closed unexpectedly Mon Jan 27, 2020 2:16 pm It looks like the SQL Server crashes while akonadi tries to run a SQL query: Code: Select all `org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY: org.kde.pim.akonadiserver: Error code: "2006" org.kde.pim.akonadiserver: DB error: "MySQL server has gone away" org.kde.pim.akonadiserver: Error text: "MySQL server has gone away QMYSQL3: Unable to prepare statement" org.kde.pim.akonadiserver: Query: "SELECT ...` Do you have a file mysql.err in folder ~/.local/share/akonadi/db_data ?
metcalsr Registered Member Posts 3 Karma 0	Re: Akonadi closed unexpectedly Tue Jan 28, 2020 3:25 am Sorry, I thought I sent this after work, but checking back, I realized I only previewed it. output of cat mysql.err 2020-01-27 16:29:59 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address. 2020-01-27 16:29:59 0 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address. 2020-01-27 16:29:59 0 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly. 2020-01-27 16:29:59 0 [Note] WSREP: Node addr: 2020-01-27 16:29:59 0 [Note] InnoDB: Using Linux native AIO 2020-01-27 16:29:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-01-27 16:29:59 0 [Note] InnoDB: Uses event mutexes 2020-01-27 16:29:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-01-27 16:29:59 0 [Note] InnoDB: Number of pools: 1 2020-01-27 16:29:59 0 [Note] InnoDB: Using generic crc32 instructions 2020-01-27 16:29:59 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2020-01-27 16:29:59 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-01-27 16:29:59 0 [Note] InnoDB: Completed initialization of buffer pool 2020-01-27 16:29:59 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-01-27 16:29:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=398580 2020-01-27 16:30:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-01-27 16:30:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-01-27 16:30:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-01-27 16:30:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-01-27 16:30:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-01-27 16:30:00 0 [Note] InnoDB: 10.4.11 started; log sequence number 398589; transaction id 618 2020-01-27 16:30:00 0 [Note] InnoDB: Loading buffer pool(s) from /home/steve/.local/share/akonadi/db_data/ib_buffer_pool 2020-01-27 16:30:00 0 [Note] InnoDB: Buffer pool(s) load completed at 200127 16:30:00 2020-01-27 16:30:00 0 [Note] Reading of all Master_info entries succeeded 2020-01-27 16:30:00 0 [Note] Added new Master_info '' to hash table 2020-01-27 16:30:00 0 [Note] /usr/bin/mysqld: ready for connections. Version: '10.4.11-MariaDB' socket: '/run/user/1000/akonadi/mysql.socket' port: 0 Arch Linux 2020-01-27 16:30:00 12 [Warning] Aborted connection 12 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets) 2020-01-27 16:30:00 11 [Warning] Aborted connection 11 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets) 2020-01-27 16:30:00 10 [Warning] Aborted connection 10 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets) 2020-01-27 16:30:08 15 [Warning] Aborted connection 15 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets) 2020-01-27 16:33:01 20 [Warning] Aborted connection 20 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets) 2020-01-27 16:33:01 22 [Warning] Aborted connection 22 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets) 2020-01-27 16:33:01 21 [Warning] Aborted connection 21 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets)
raphaelra Registered Member Posts 209 Karma 0 OS	Re: Akonadi closed unexpectedly Tue Jan 28, 2020 8:49 am I think this is the important message: Code: Select all `2020-01-27 16:30:00 12 [Warning] Aborted connection 12 to db: 'akonadi' user: 'steve' host: '' (Got an error reading communication packets) ...` I can't tell you how to fix it, but google find many articles about it ... Did you try to start stand alone MySQL/MariaDB server ? I mean not as a local server for akonadi ... To check if MySQL/MariaDB is broken or is it akonadi.