Bug#946141: [akonadi-backend-sqlite] Failed to commit transaction for database update
Start-Date: 2019-12-02 09:29:50 Commandline: /usr/bin/unattended-upgrade Upgrade: akonadi-backend-sqlite:amd64 (4:18.08.3-11, 4:19.08.3-1) End-Date: 2019-12-02 09:29:52 $ LANG=C akonadictl start org.kde.pim.akonadictl: Starting Akonadi Server... qt.qpa.xcb: Has MIT-SHM : true qt.qpa.xcb: Has MIT-SHM FD : true qt.qpa.xcb: Using XInput version 2.2 qt.qpa.screen: Output DisplayPort-0 is not connected qt.qpa.screen: EDID data for output "HDMI-A-0": identifier '', manufacturer 'Philips Consumer Electronics Company',model 'PHL 276E8V-', serial '245', physical size: 600.00x340.00 qt.qpa.screen: Output DVI-D-0 is not connected qt.qpa.screen: adding QXcbScreen(0x5587963346c0, name="HDMI-A-0", geometry=2560x1440+0+0, availableGeometry=2560x1380+0+0, devicePixelRatio=1.0, logicalDpi=QPair(134.0,134.0), physicalSize=597.0x336.0mm, screenNumber=0, virtualSize=2560x1440 (2560.0x1440.0mm), orientation=Qt::LandscapeOrientation, depth=24, refreshRate=59.0, root=6cd, windowManagerName="KWin") (Primary: true ) qt.qpa.screen: primary output is "HDMI-A-0" qt.qpa.input.devices: input device Virtual core XTEST pointer ID 4 qt.qpa.input.devices: has 10 buttons qt.qpa.input.devices: has valuator "Rel X" recognized? true qt.qpa.input.devices: has valuator "Rel Y" recognized? true qt.qpa.input.devices: it's a scrolling device qt.qpa.input.devices: input device USB USB Keyboard Consumer Control ID 9 qt.qpa.input.devices: has 7 buttons qt.qpa.input.devices: has valuator "Rel X" recognized? true qt.qpa.input.devices: has valuator "Rel Y" recognized? true qt.qpa.input.devices: has valuator "Rel Horiz Scroll" recognized? true qt.qpa.input.devices: has valuator "Rel Vert Scroll" recognized? true qt.qpa.input.devices: it's a scrolling device qt.qpa.input.devices: input device Logitech USB Optical Mouse ID 11 qt.qpa.input.devices: has 7 buttons qt.qpa.input.devices: has valuator "Rel X" recognized? true qt.qpa.input.devices: has valuator "Rel Y" recognized? true qt.qpa.input.devices: has valuator "Rel Horiz Scroll" recognized? true qt.qpa.input.devices: has valuator "Rel Vert Scroll" recognized? true qt.qpa.input.devices: it's a scrolling device qt.qpa.input.devices: input device lircd-uinput ID 12 qt.qpa.input.devices: has 20 buttons qt.qpa.input.devices: has valuator "Rel X" recognized? true qt.qpa.input.devices: has valuator "Rel Y" recognized? true qt.qpa.input.devices: has valuator "Rel Horiz Scroll" recognized? true qt.qpa.input.devices: has valuator "Rel Vert Scroll" recognized? true qt.qpa.input.devices: it's a scrolling device qt.qpa.xcb: using glib dispatcher org.kde.pim.akonadictl: done. Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) alexs@alexs:~/.config/QtProject$ qt.qpa.events: Event | XCB_PROPERTY_NOTIFY(28) | sequence: 193 qt.qpa.events: Event | XCB_PROPERTY_NOTIFY(28) | sequence: 194 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: Success 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: skipp
Bug#946141: [akonadi-backend-sqlite] Failed to commit transaction for database update
Hey, so youupgrading Akonadi, what version you had before? To use akonadiserver directly is not recommended. Please use akonadictl and enable debugging via .config/QtProject/qtlogging.ini. And one line is not in English: > org.kde.pim.akonadiserver: Creating socket directory with name "" > failed: Выполнено can you please translate this, or un with LANG=C [cmd], so everthing is in English. hefee -- > 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
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
