Bug#946141: [akonadi-backend-sqlite] Failed to commit transaction for database update
Package: akonadi-backend-sqlite
Version: 4:19.08.3-1
Severity: important
Dear Maintainer,
Akonadi failed to start:
$ 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: Выполнено
org.kde.pim.akonadiserver: Could not create socket directory for Akonadi.
org.kde.pim.akonadiserver: Database
"/home/alexs/.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: DbUpdater: update to version: 36 mandatory: true
org.kde.pim.akonadiserver: Starting database update to version 36
org.kde.pim.akonadiserver: Updating foreign keys in table "CollectionTable"
org.kde.pim.akonadiserver: Creating table CollectionTable_new with
foreign keys
org.kde.pim.akonadiserver: Copying values from CollectionTable to
CollectionTable_new (this may take a very long of time...)
org.kde.pim.akonadiserver: SQL error when updating table CollectionTable
org.kde.pim.akonadiserver: Query: CREATE TABLE CollectionTable_new (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
CollectionTable_newparentId_Collectionid_fk FOREIGN KEY (parentId)
REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE
DEFERRABLE INITIALLY DEFERRED, CONSTRAINT
CollectionTable_newresourceId_Resourceid_fk FOREIGN KEY (resourceId)
REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE
DEFERRABLE INITIALLY DEFERRED)
org.kde.pim.akonadiserver: Error: table CollectionTable_new has 19
columns but 20 values were supplied Unable to execute statement
org.kde.pim.akonadiserver: Update failed
org.kde.pim.akonadiserver: Failed to commit transaction for database update
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...
-- System Information:
Debian Release: bullseye/sid
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 5.3.0-2-amd64 (SMP w/8 CPU cores)
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8),
LANGUAGE=ru (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages akonadi-backend-sqlite depends on:
ii libc6 2.29-3
ii libgcc1 1:9.2.1-21
ii libqt5core5a [qtbase-abi-5-12-5] 5.12.5+dfsg-2
ii libqt5sql5 5.12.5+dfsg-2
ii libqt5sql5-sqlite 5.12.5+dfsg-2
ii libsqlite3-0 3.30.1-1
ii libstdc++6 9.2.1-21
Versions of packages akonadi-backend-sqlite recommends:
ii akonadi-server 4:19.08.3-1
akonadi-backend-sqlite suggests no packages.
-- no debconf information
Reply to: