[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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 (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

Attachment: signature.asc
Description: This is a digitally signed message part.


Reply to: