[Kde-pim] Akonadi on Ubuntu Trusty

Patrick Ohly patrick.ohly at gmx.de
Thu Mar 20 21:42:42 GMT 2014


Hello!

On Ubuntu Trusty akonadictl and Akonadi::ServerManager::isRunning()
disagree about whether Akonadi is running:

$ /tmp/akonadi-multithreading 
Akonadi is not running
$ akonadictl status
Akonadi Control: running
Akonadi Server: running
search paths:  ("/usr/lib", "/usr/lib/qt4/plugins/", "/usr/lib/kde4/", "/usr/lib/kde4/plugins/", "/usr/lib/qt4/plugins/", "/usr/lib/x86_64-linux-gnu/qt4/plugins", "/usr/lib/qt4/plugins", "/usr/bin", "/data/runtests/work/prebuilt-trusty-amd64/home/evolution/.kde/lib/kde4/") 
Akonadi Server Search Support: available (Remote Search)
$ cat /tmp/akonadi-multithreading.cpp 
#include <glib.h>

#include <Akonadi/ServerManager>
#include <Akonadi/CollectionFetchJob>
#include <KUrl>
#include <KApplication>
#include <KCmdLineArgs>
#include <KAboutData>

#include <iostream>
#include <memory>

#include <unistd.h>

int main(int argc, char **argv)
{
    KAboutData aboutData(// The program name used internally.
                         "syncevolution",
                         // The message catalog name
                         // If null, program name is used instead.
                         0,
                         // A displayable program name string.
                         ki18n("SyncEvolution"),
                         // The program version string.
                         "1.0",
                         // Short description of what the app does.
                         ki18n("Lets Akonadi synchronize with a SyncML Peer"),
                         // The license this code is released under
                         KAboutData::License_GPL,
                         // Copyright Statement
                         ki18n("(c) 2010-12"),
                         // Optional text shown in the About box.
                         // Can contain any information desired.
                         ki18n(""),
                         // The program homepage string.
                         "http://www.syncevolution.org/",
                         // The bug report email address
                         "syncevolution at syncevolution.org");
    KCmdLineArgs::init(argc, argv, &aboutData);
    KApplication app(false);

    std::cout << "Akonadi is " <<
        (Akonadi::ServerManager::isRunning() ? "running" : "not running") <<
        std::endl;

    return 0;
}
$ g++ -o /tmp/akonadi-multithreading `pkg-config --cflags glib-2.0 QtCore` -I/usr/include/KDE /tmp/akonadi-multithreading.cpp -lakonadi-kde -lkdecore -lkdeui `pkg-config --libs  glib-2.0 QtCore`

Here's a D-Bus log:

$ dbus-monitor &
...

$ /tmp/akonadi-multithreading
signal sender=org.freedesktop.DBus -> dest=(null destination) serial=27 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=NameOwnerChanged
   string ":1.16"
   string ""
   string ":1.16"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=1 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=Hello
signal sender=org.freedesktop.DBus -> dest=(null destination) serial=28 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=NameOwnerChanged
   string "org.syncevolution.syncevolution-27075"
   string ""
   string ":1.16"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=2 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=RequestName
   string "org.syncevolution.syncevolution-27075"
   uint32 4
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=3 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=NameHasOwner
   string "org.freedesktop.Akonadi.upgrading"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=4 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=NameHasOwner
   string "org.freedesktop.Akonadi.Control"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=5 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=NameHasOwner
   string "org.freedesktop.Akonadi"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=6 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=GetNameOwner
   string "org.freedesktop.Akonadi.Control"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=7 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.DBus',interface='org.freedesktop.DBus',member='NameOwnerChanged',arg0='org.freedesktop.Akonadi.Control'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=8 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentTypeAdded'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=9 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=GetNameOwner
   string "org.freedesktop.Akonadi.Control"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=10 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentTypeRemoved'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=11 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceAdded'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=12 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceRemoved'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=13 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceStatusChanged'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=14 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceProgressChanged'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=15 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceNameChanged'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=16 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceWarning'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=17 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceError'"
method call sender=:1.16 -> dest=org.freedesktop.DBus serial=18 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=AddMatch
   string "type='signal',sender='org.freedesktop.Akonadi.Control',path='/AgentManager',interface='org.freedesktop.Akonadi.AgentManager',member='agentInstanceOnlineChanged'"
method call sender=:1.16 -> dest=org.freedesktop.Akonadi.Control serial=19 path=/AgentManager; interface=org.freedesktop.Akonadi.AgentManager; member=agentTypes
method return sender=:1.3 -> dest=:1.16 reply_serial=19
   array [
   ]
method call sender=:1.16 -> dest=org.freedesktop.Akonadi.Control serial=20 path=/AgentManager; interface=org.freedesktop.Akonadi.AgentManager; member=agentInstances
method return sender=:1.3 -> dest=:1.16 reply_serial=20
   array [
   ]
Akonadi is not running
signal sender=org.freedesktop.DBus -> dest=(null destination) serial=29 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=NameOwnerChanged
   string "org.syncevolution.syncevolution-27075"
   string ":1.16"
   string ""
signal sender=org.freedesktop.DBus -> dest=(null destination) serial=30 path=/org/freedesktop/DBus; interface=org.freedesktop.DBus; member=NameOwnerChanged
   string ":1.16"
   string ":1.16"
   string ""

And here's the Akonadi setup:

$ cat $XDG_CONFIG_HOME/akonadi/akonadiserverrc 
[%General]
Driver=QSQLITE3

[QSQLITE3]
Name=/data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/akonadi.db

[Debug]
Tracer=null

$ sqlite3 /data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/akonadi.db .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL DEFAULT 0);
INSERT INTO "SchemaVersionTable" VALUES(26);
CREATE TABLE ResourceTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name TEXT UNIQUE NOT NULL, isVirtual BOOL DEFAULT false);
INSERT INTO "ResourceTable" VALUES(1,'akonadi_search_resource',1);
INSERT INTO "ResourceTable" VALUES(2,'akonadi_ical_resource_0','false');
INSERT INTO "ResourceTable" VALUES(3,'akonadi_ical_resource_1','false');
INSERT INTO "ResourceTable" VALUES(4,'akonadi_ical_resource_2','false');
INSERT INTO "ResourceTable" VALUES(5,'akonadi_contacts_resource_0','false');
INSERT INTO "ResourceTable" VALUES(6,'akonadi_contacts_resource_1','false');
INSERT INTO "ResourceTable" VALUES(7,'akonadi_contacts_resource_2','false');
INSERT INTO "ResourceTable" VALUES(8,'akonadi_notes_resource_0','false');
INSERT INTO "ResourceTable" VALUES(9,'akonadi_notes_resource_1','false');
INSERT INTO "ResourceTable" VALUES(10,'akonadi_notes_resource_2','false');
CREATE TABLE CollectionTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, remoteId TEXT, remoteRevision TEXT, name TEXT NOT NULL, parentId BIGINT, resourceId BIGINT NOT NULL, subscribed BOOL NOT NULL DEFAULT true, 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 TEXT, queryString TEXT, queryLanguage TEXT, queryAttributes TEXT, queryCollections TEXT, isVirtual BOOL DEFAULT false);
INSERT INTO "CollectionTable" VALUES(1,NULL,NULL,'Search',NULL,1,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,1);
INSERT INTO "CollectionTable" VALUES(2,'file:///data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/ical_resource_0.ics','','akonadi_ical_resource_0',NULL,2,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(3,'file:///data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/ical_resource_1.ics','','akonadi_ical_resource_1',NULL,3,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(4,'file:///data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/ical_resource_2.ics','','akonadi_ical_resource_2',NULL,4,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(5,'/data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/contacts_0','','Personal_Contacts_0',NULL,5,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(6,'/data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/contacts_1','','Personal_Contacts_1',NULL,6,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(8,'/data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/contacts_2','','Personal_Contacts_2',NULL,7,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(9,'file:///data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/notes_resource_0.ics','','akonadi_notes_resource_0',NULL,8,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(10,'file:///data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/notes_resource_0.ics','','akonadi_notes_resource_1',NULL,9,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
INSERT INTO "CollectionTable" VALUES(11,'file:///data/runtests/work/prebuilt-trusty-amd64/home/evolution/data/akonadi/notes_resource_1.ics','','akonadi_notes_resource_2',NULL,10,'true','true',-1,-1,'false',NULL,NULL,NULL,NULL,NULL,'false');
CREATE TABLE MimeTypeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name TEXT UNIQUE NOT NULL);
INSERT INTO "MimeTypeTable" VALUES(1,'application/octet-stream');
INSERT INTO "MimeTypeTable" VALUES(2,'message/rfc822');
INSERT INTO "MimeTypeTable" VALUES(3,'text/calendar');
INSERT INTO "MimeTypeTable" VALUES(4,'text/vcard');
INSERT INTO "MimeTypeTable" VALUES(5,'inode/directory');
INSERT INTO "MimeTypeTable" VALUES(6,'application/x-vnd.akonadi.calendar.event');
INSERT INTO "MimeTypeTable" VALUES(7,'application/x-vnd.akonadi.calendar.todo');
INSERT INTO "MimeTypeTable" VALUES(8,'application/x-vnd.akonadi.calendar.journal');
INSERT INTO "MimeTypeTable" VALUES(9,'application/x-vnd.akonadi.calendar.freebusy');
INSERT INTO "MimeTypeTable" VALUES(10,'text/directory');
INSERT INTO "MimeTypeTable" VALUES(11,'application/x-vnd.kde.contactgroup');
INSERT INTO "MimeTypeTable" VALUES(12,'application/x-vnd.kde.notes');
CREATE TABLE PimItemTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT, remoteRevision TEXT, collectionId BIGINT, mimeTypeId BIGINT, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP, dirty BOOL, size BIGINT NOT NULL DEFAULT 0, gid TEXT);
CREATE TABLE FlagTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name TEXT UNIQUE NOT NULL);
INSERT INTO "FlagTable" VALUES(1,'important');
INSERT INTO "FlagTable" VALUES(2,'has_attachment');
INSERT INTO "FlagTable" VALUES(3,'spam');
INSERT INTO "FlagTable" VALUES(4,'\ANSWERED');
INSERT INTO "FlagTable" VALUES(5,'\FLAGGED');
INSERT INTO "FlagTable" VALUES(6,'\DELETED');
INSERT INTO "FlagTable" VALUES(7,'\SEEN');
INSERT INTO "FlagTable" VALUES(8,'\DRAFT');
CREATE TABLE CollectionAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, collectionId BIGINT NOT NULL, type LONGBLOB NOT NULL, value LONGBLOB);
INSERT INTO "CollectionAttributeTable" VALUES(1,2,X'454E54495459444953504C4159',X'28226963616C5F7265736F757263655F302E6963732220226F66666963652D63616C656E6461722220222220282929');
INSERT INTO "CollectionAttributeTable" VALUES(2,2,X'416363657373526967687473',X'77636457');
INSERT INTO "CollectionAttributeTable" VALUES(3,3,X'454E54495459444953504C4159',X'28226963616C5F7265736F757263655F302E6963732028436C6F6E65292220226F66666963652D63616C656E6461722220222220282929');
INSERT INTO "CollectionAttributeTable" VALUES(4,3,X'416363657373526967687473',X'77636457');
INSERT INTO "CollectionAttributeTable" VALUES(5,4,X'454E54495459444953504C4159',X'28226963616C5F7265736F757263655F322E6963732220226F66666963652D63616C656E6461722220222220282929');
INSERT INTO "CollectionAttributeTable" VALUES(6,4,X'416363657373526967687473',X'77636457');
INSERT INTO "CollectionAttributeTable" VALUES(7,5,X'416363657373526967687473',X'61');
INSERT INTO "CollectionAttributeTable" VALUES(8,6,X'416363657373526967687473',X'61');
INSERT INTO "CollectionAttributeTable" VALUES(10,8,X'416363657373526967687473',X'61');
INSERT INTO "CollectionAttributeTable" VALUES(11,9,X'454E54495459444953504C4159',X'28226E6F7465735F7265736F757263655F302E6963732220226B6E6F7465732220222220282929');
INSERT INTO "CollectionAttributeTable" VALUES(12,9,X'416363657373526967687473',X'77636457');
INSERT INTO "CollectionAttributeTable" VALUES(13,10,X'454E54495459444953504C4159',X'28226E6F7465735F7265736F757263655F302E6963732028436C6F6E65292220226B6E6F7465732220222220282929');
INSERT INTO "CollectionAttributeTable" VALUES(14,10,X'416363657373526967687473',X'77636457');
INSERT INTO "CollectionAttributeTable" VALUES(15,11,X'454E54495459444953504C4159',X'28226E6F7465735F7265736F757263655F302E6963732028436C6F6E65292028436C6F6E65292220226B6E6F7465732220222220282929');
INSERT INTO "CollectionAttributeTable" VALUES(16,11,X'416363657373526967687473',X'77636457');
CREATE TABLE PimItemFlagRelation (PimItem_id INTEGER REFERENCES PimItemTable(id), Flag_id INTEGER REFERENCES FlagTable(id), PRIMARY KEY (PimItem_id, Flag_id));
CREATE TABLE CollectionMimeTypeRelation (Collection_id INTEGER REFERENCES CollectionTable(id), MimeType_id INTEGER REFERENCES MimeTypeTable(id), PRIMARY KEY (Collection_id, MimeType_id));
INSERT INTO "CollectionMimeTypeRelation" VALUES(2,3);
INSERT INTO "CollectionMimeTypeRelation" VALUES(2,6);
INSERT INTO "CollectionMimeTypeRelation" VALUES(2,7);
INSERT INTO "CollectionMimeTypeRelation" VALUES(2,8);
INSERT INTO "CollectionMimeTypeRelation" VALUES(2,9);
INSERT INTO "CollectionMimeTypeRelation" VALUES(3,6);
INSERT INTO "CollectionMimeTypeRelation" VALUES(3,9);
INSERT INTO "CollectionMimeTypeRelation" VALUES(3,8);
INSERT INTO "CollectionMimeTypeRelation" VALUES(3,7);
INSERT INTO "CollectionMimeTypeRelation" VALUES(3,3);
INSERT INTO "CollectionMimeTypeRelation" VALUES(4,6);
INSERT INTO "CollectionMimeTypeRelation" VALUES(4,9);
INSERT INTO "CollectionMimeTypeRelation" VALUES(4,8);
INSERT INTO "CollectionMimeTypeRelation" VALUES(4,7);
INSERT INTO "CollectionMimeTypeRelation" VALUES(4,3);
INSERT INTO "CollectionMimeTypeRelation" VALUES(5,5);
INSERT INTO "CollectionMimeTypeRelation" VALUES(5,10);
INSERT INTO "CollectionMimeTypeRelation" VALUES(5,11);
INSERT INTO "CollectionMimeTypeRelation" VALUES(6,11);
INSERT INTO "CollectionMimeTypeRelation" VALUES(6,5);
INSERT INTO "CollectionMimeTypeRelation" VALUES(6,10);
INSERT INTO "CollectionMimeTypeRelation" VALUES(8,11);
INSERT INTO "CollectionMimeTypeRelation" VALUES(8,5);
INSERT INTO "CollectionMimeTypeRelation" VALUES(8,10);
INSERT INTO "CollectionMimeTypeRelation" VALUES(9,12);
INSERT INTO "CollectionMimeTypeRelation" VALUES(10,12);
INSERT INTO "CollectionMimeTypeRelation" VALUES(11,12);
CREATE TABLE CollectionPimItemRelation (Collection_id INTEGER REFERENCES CollectionTable(id), PimItem_id INTEGER REFERENCES PimItemTable(id), PRIMARY KEY (Collection_id, PimItem_id));
CREATE TABLE PartTypeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name TEXT NOT NULL, ns TEXT NOT NULL);
INSERT INTO "PartTypeTable" VALUES(1,'HIDDEN','ATR');
CREATE TABLE TagTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, gid TEXT NOT NULL, parentId BIGINT);
CREATE TABLE TagAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, tagId BIGINT NOT NULL, type LONGBLOB NOT NULL, value LONGBLOB);
CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL, resourceId BIGINT NOT NULL, remoteId TEXT NOT NULL);
CREATE TABLE PimItemTagRelation (PimItem_id BIGINT NOT NULL, Tag_id BIGINT NOT NULL, PRIMARY KEY (PimItem_id, Tag_id));
CREATE TABLE "PartTable" (id INTEGER PRIMARY KEY AUTOINCREMENT, pimItemId BIGINT NOT NULL, partTypeId BIGINT NOT NULL, data LONGBLOB, datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, external BOOL DEFAULT false);
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('ResourceTable',10);
INSERT INTO "sqlite_sequence" VALUES('CollectionTable',11);
INSERT INTO "sqlite_sequence" VALUES('MimeTypeTable',12);
INSERT INTO "sqlite_sequence" VALUES('FlagTable',8);
INSERT INTO "sqlite_sequence" VALUES('CollectionAttributeTable',16);
INSERT INTO "sqlite_sequence" VALUES('PartTable',0);
INSERT INTO "sqlite_sequence" VALUES('PartTypeTable',1);
CREATE UNIQUE INDEX CollectionTable_parentAndNameIndex ON CollectionTable (parentId,name);
CREATE INDEX PimItemTable_collectionIndex ON PimItemTable (collectionId);
CREATE INDEX CollectionAttributeTable_collectionIndex ON CollectionAttributeTable (collectionId);
CREATE INDEX PimItemTable_gidIndex ON PimItemTable (gid);
CREATE UNIQUE INDEX PartTypeTable_partTypeNameIndex ON PartTypeTable (ns,name);
CREATE UNIQUE INDEX PartTable_pimItemIdTypeIndex ON PartTable (pimItemId,partTypeId);
CREATE INDEX TagAttributeTable_tagIndex ON TagAttributeTable (tagId);
CREATE UNIQUE INDEX TagRemoteIdResourceRelationTable_TagAndResourceIndex ON TagRemoteIdResourceRelationTable (tagId,resourceId);
COMMIT;

The akonadi.db was originally created on Debian Wheezy. The paths were
adjusted to match the actual location inside the Trusty test chroot.

Note that I am running without X. Akonadi agents were disabled with
AKONADI_DISABLE_AGENT_AUTOSTART=1 as discussed here on the list
recently.

Any idea? What other information do you need?

Bye, Patrick

_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/



More information about the kde-pim mailing list