#946141 [akonadi-backend-sqlite] Failed to commit transaction for database update

Package:
akonadi-backend-sqlite
Source:
akonadi
Description:
SQLite storage backend for Akonadi
Submitter:
alexs
Date:
2019-12-07 16:54:03 UTC
Severity:
important
#946141#5
Date:
2019-12-04 08:19:08 UTC
From:
To:
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...

#946141#10
Date:
2019-12-07 16:01:21 UTC
From:
To:
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:

can you please translate this, or un with LANG=C [cmd], so everthing is in
English.

hefee

#946141#15
Date:
2019-12-07 16:49:06 UTC
From:
To:
====

$ 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: 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...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally... qt.qpa.events.reader: nodes on heap: 0

====

 
akonadictl and
is in
Akonadi.

"QSQLITE3"