Bug#960194: akonadi-server: Adding a new resource in korganizer or kaddressbook ends up in 2 resources
Package: akonadi-server
Version: 4:19.08.3-1
Severity: normal
Dear Maintainer,
When I add or create a new resource in korganizer or kaddressbook the new resource is not
shown with the given name (e.g. 'New-Addressbook') but as akonadi_vcard_resource_<X>. When
I restart akonadi-server the new resource is shown twice: As akonadi_vcard_resource_<X> and
as 'New-Addressbook', which seem to be identical: if i delete one I also delete the other.
This is really annoying: When you have 4 resources as in my case there are shown 8.
This should not happen.
So I had a look in the akonadi mysql-database with akonadi-console and in the in the
collectiontable I found two entries for my resources which beside the id only differ
in the fields name and remoteId: one has remoteId <NULL> and name 'akonadi_vcard_resource_<X>'
one has remoteId <PathToVcard-file> and name 'New-Adressbook'.
So I opened the akonadi-Database directly with mysql:
mysql --socket=/home/klaumi/.local/share/akonadi/db_misc/mysql.socket
MariaDB [(none)]> use akonadi;
and had (of cource) the same result with:
MariaDB [akonadi]> SELECT * FROM collectiontable
Next I deleted the entry with the empty remoteId-field, which in my case had the id 19:
DELETE FROM collectiontable WHERE id = 19;
restarted akonadi-server and voilá: In kaddressbook the resource is only shown once and all
works like expected.
I had to do the same for new ical-resources in korganizer.
This should not happen. It should not be necessary to access the akonadi-
database with mysql directly everytime add or create a new vcard- or ical-resource.
Klaumi
-- System Information:
Debian Release: bullseye/sid
APT prefers testing
APT policy: (900, 'testing'), (200, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 5.6.0-1-amd64 (SMP w/4 CPU cores)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE=de_DE:de:en_US:en (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages akonadi-server depends on:
ii akonadi-backend-mysql 4:19.08.3-1
ii akonadi-backend-sqlite 4:19.08.3-1
ii libc6 2.30-4
ii libgcc-s1 [libgcc1] 10-20200418-1
ii libgcc1 1:10-20200418-1
ii libkf5akonadiprivate5abi2 [libkf5akonadiprivate5-19.08] 4:19.08.3-1
ii libkf5akonadiwidgets5abi1 [libkf5akonadiwidgets5-19.08] 4:19.08.3-1
ii libkf5configcore5 5.62.0-1+b1
ii libkf5coreaddons5 5.62.0-1
ii libkf5crash5 5.62.0-1+b1
ii libkf5i18n5 5.62.0-1
ii libqt5core5a 5.12.5+dfsg-10
ii libqt5dbus5 5.12.5+dfsg-10
ii libqt5gui5 5.12.5+dfsg-10
ii libqt5network5 5.12.5+dfsg-10
ii libqt5sql5 5.12.5+dfsg-10
ii libqt5widgets5 5.12.5+dfsg-10
ii libqt5xml5 5.12.5+dfsg-10
ii libstdc++6 10-20200418-1
akonadi-server recommends no packages.
Versions of packages akonadi-server suggests:
ii akonadi-backend-mysql 4:19.08.3-1
pn akonadi-backend-postgresql <none>
ii akonadi-backend-sqlite 4:19.08.3-1
-- no debconf information
Reply to: