Dear Maintainer,

*** Reporter, please consider answering these questions, where appropriate ***

   * What led up to the situation?
   * What exactly did you do (or not do) that was effective (or
     ineffective)?
   * What was the outcome of this action?
   * What outcome did you expect instead?

*** End of the template - remove these template lines ***

Those lines I quoted above are meant to remind a bug reporter, ie you, to
provide some information which allows the maintainer (and others) to find the
actual problem which in turn can lead to a solution.

It's fine to ask for help *how* to provide more detailed/technical information,
but those questions above can be answered without any technical knowledge.
For example:
    * What led up to the situation?
I upgraded from version 4:18.08.3-1 to version 4:19.08.3-1 and where it did
work before, it no longer does.

Other pieces which may prove to be useful is share the output of running the
following commands from a terminal:
$ kmail
and
$ akonadictl restart

It's not a problem at all if you didn't know those commands and that they
could prove useful. See bug reporting as starting a dialog.

HTH

Hi,
sorry it's the same bug as 946141 Failed to commit transaction for database update
 
What led up to the situation?
 last update yesturday
What exactly did you do (or not do) that was effective (or
 
Just start kmail
 
What was the outcome of this action?
 
le service des gestions des information personelles n'est pas operationnel
the service of management of the personal information is not operational
 
What outcome did you expect instead?
using kmail
 
$ kmail do and say nothing return $
 
$ akonadictl restart Akonadi is not running.
 
$ akonadictl start Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) pitcat@pitcat:~$ org.kde.pim.akonadiserver: Starting up the Akonadi Server... QSqlDatabasePrivate::addDatabase: duplicate connection name 'initConnection', old connection removed. org.kde.pim.akonadiprivate: StandardDirs::saveDir: failed to create directory ' "/run/user/1000/akonadi" ' QDir::mkpath: Empty or null file name org.kde.pim.akonadiserver: Creating socket directory with name "" failed: Succès org.kde.pim.akonadiserver: Could not create socket directory for Akonadi. org.kde.pim.akonadiserver: Running DB initializer org.kde.pim.akonadiserver: DB initializer done org.kde.pim.akonadiserver: Updating index failed:   Sql error: table CollectionTable has 19 columns but 20 values were supplied Unable to execute statement Query: INSERT INTO CollectionTable SELECT * FROM CollectionTable_old org.kde.pim.akonadiserver: "" org.kde.pim.akonadiserver: Unable to initialize database. org.kde.pim.akonadiserver: Shutting down AkonadiServer... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
 
akonadiserver --start-without-control --verbose 
org.kde.pim.akonadiserver: Starting up the Akonadi Server... QSqlDatabasePrivate::addDatabase: duplicate connection name 'initConnection', old connection removed. org.kde.pim.akonadiserver: sqlite version is  "3.30.1" org.kde.pim.akonadiserver: sqlite journal mode is  "wal" org.kde.pim.akonadiprivate: StandardDirs::saveDir: failed to create directory ' "/run/user/1000/akonadi" ' QDir::mkpath: Empty or null file name org.kde.pim.akonadiserver: Creating socket directory with name "" failed: Succès org.kde.pim.akonadiserver: Could not create socket directory for Akonadi. org.kde.pim.akonadiserver: Database "/home/pitcat/.local/share/akonadi/akonadi.db" opened using driver "QSQLITE3" org.kde.pim.akonadiserver: Running DB initializer org.kde.pim.akonadiserver: checking table  "SchemaVersionTable" org.kde.pim.akonadiserver: checking table  "ResourceTable" org.kde.pim.akonadiserver: checking table  "CollectionTable" org.kde.pim.akonadiserver: checking table  "MimeTypeTable" org.kde.pim.akonadiserver: checking table  "PimItemTable" org.kde.pim.akonadiserver: checking table  "FlagTable" org.kde.pim.akonadiserver: checking table  "PartTypeTable" org.kde.pim.akonadiserver: checking table  "PartTable" org.kde.pim.akonadiserver: checking table  "CollectionAttributeTable" org.kde.pim.akonadiserver: checking table  "TagTypeTable" org.kde.pim.akonadiserver: checking table  "TagTable" org.kde.pim.akonadiserver: checking table  "TagAttributeTable" org.kde.pim.akonadiserver: checking table  "TagRemoteIdResourceRelationTable" org.kde.pim.akonadiserver: checking table  "RelationTypeTable" org.kde.pim.akonadiserver: checking table  "RelationTable" org.kde.pim.akonadiserver: checking table  "PimItemFlagRelation" org.kde.pim.akonadiserver: checking table  "PimItemTagRelation" org.kde.pim.akonadiserver: checking table  "CollectionMimeTypeRelation" org.kde.pim.akonadiserver: checking table  "CollectionPimItemRelation" 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: Adding new foreign key constraints org.kde.pim.akonadiserver: "PRAGMA defer_foreign_keys=ON" org.kde.pim.akonadiserver: "BEGIN TRANSACTION" org.kde.pim.akonadiserver: "ALTER TABLE CollectionTable RENAME TO CollectionTable_old" org.kde.pim.akonadiserver: "CREATE TABLE CollectionTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, remoteId TEXT, remoteRevision TEXT, name TEXT NOT NULL, parentId BIGINT, resourceId BIGINT NOT NULL, enabled BOOL NOT NULL DEFAULT 1, syncPref TINYINT DEFAULT 2, displayPref TINYINT DEFAULT 2, indexPref TINYINT DEFAULT 2, cachePolicyInherit BOOL NOT NULL DEFAULT 1, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT 0, cachePolicyLocalParts TEXT, queryString TEXT, queryAttributes TEXT, queryCollections TEXT, isVirtual BOOL DEFAULT 0, CONSTRAINT CollectionTableparentId_Collectionid_fk FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, CONSTRAINT CollectionTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)" org.kde.pim.akonadiserver: "INSERT INTO CollectionTable SELECT * FROM CollectionTable_old" org.kde.pim.akonadiserver: Updating index failed:   Sql error: table CollectionTable has 19 columns but 20 values were supplied Unable to execute statement Query: INSERT INTO CollectionTable SELECT * FROM CollectionTable_old org.kde.pim.akonadiserver: "" 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.akonadiserver: Shutting down AkonadiServer...