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
> ineffective)?
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...
