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: 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
====
On Sat, 07 Dec 2019 17:01:21 +0100 Sandro =?ISO-8859-1?Q?Knau=DF?=
<hefee@debian.org> wrote:
> 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
Reply to: