Small glitches upgrading from 42.3 to 15.0

bearymore · May 29, 2018, 12:15am

I just upgraded from 42.3 to 15.0. Things seem to have gone well. There were only a few odd glitches:

KMail stopped working. When I opened it in a konsole I found that libva.so.2 was missing. I went into Yast and found the libva 2.0 package was not installed. After installing the package, Kmail worked fine. It had been working in 42.3 without this fix.

My disk based calendar file, main_calendar.ics was missing all recurring and the most recent events. I restored a backup and they reappeared without a problem. Somehow, the file must have been truncated or corrupted during the update.

An error message appears on boot: SP5100_TCO: IO address 060cd6 in use. This did not appear under 42.3. I’ve seen this reported as a kernel regression in Tumbleweed and some discussion of it maybe having to do with a Radeon video card. I do have Radeon on my motherboard, but I have disabled it and use a faster NVidia card and the NVidia drivers instead. I don’t detect any symptoms after the system boots, however.

The application widgets on my panel were there, but the icons were missing. I had to erase them and re-attach the applications to the panel. On the newly reattached applications, the proper icons do appear.

There is a lot of constant disk activity since rebooting. I would hope this will stop.

That’s it. Otherwise the process was pretty painless for a major system upgrade.

Fraser_Bell · May 29, 2018, 1:41am

Yes, but … where is the question, here? What are you asking? Or, are you asking something, or just reporting your experience?

I need to know in order to proceed.

arvidjaar · May 29, 2018, 6:19am

This needs bug report to be fixed.

bearymore · May 29, 2018, 8:13pm

I was primarily reporting my experience. I was mostly hoping to help others who encounter the kmail issue.

I did want some help on the disk activity issue. It seems to be related to an akonadi pop3 resource that is constantly accessing the disk and an akonadi server instance that is constantly using 25% of the cpu or more. I terminated both processes and things calmed down. Kmail and korganizer still work after I did that. Is this a known issue?

Fraser_Bell · May 29, 2018, 11:53pm

Okay, thanks.

For anyone following this thread, if primarily reporting your experience, please post such things in a Chit-Chat or similar Forum, as the “Get Technical Help Here” Forums are for asking questions and seeking solutions.

@bearymore: Now some questions have been asked and answered, I will leave this thread here.

Thanks for your input.

wolfi323 · May 30, 2018, 1:39pm

Well, TBH I don’t see a bug there though.

kmail does not require or use libva2.
ffmpeg’s libavcodec does (which is needed by QtWebEngine, that’s used by kmail for the mail display) as it is linked against libva.so.2, but it does require it on a package level.

I have no idea how one would end up with libavcodec installed, but not libva2.
Except maybe by choosing “Break xxx by ignoring some of its dependencies…” in a conflict resolution dialog/message.

I don’t really think a bug report makes sense here without finding out first what actually happened. /var/log/zypp/history may have a clue, depending on how the upgrade was performed.

wolfi323 · May 30, 2018, 1:46pm

The only known “issue” is that Akonadi’s database will have to be upgraded on first start, as the table schemas have changed.
This can take a while (and also use some CPU I suppose), but that’s done before any resources are started.

Maybe that was caused by mail indexing? Or the pop3 resource just synchronized the mails/cache with the actual storage location (which can take a while too if there are many mails).

karlmistelberger · May 30, 2018, 2:47pm

Akonadi works normal for weeks, but suddenly there is heavy activity (cpu+disk) with typical error messages:

1867 Command: FetchItems scope: UID 23778 scopeContext:ScopeContext(empty) fetchScope:FetchScope( Fetch Flags:QFlags(0x1|0x10|0x40|0x100|0x200) Tag Fetch Scope:QSet() Changed Since:QDateTime(Invalid) Ancestor Depth:No ancestor Requested Parts:QVector())

wolfi323 · May 30, 2018, 3:02pm

After upgrading from 42.3 to 15.0?
That’s the topic here.

Or what version exactly are you using anyway?

That’s not an error message though, AFAICT.

wolfi323 · May 30, 2018, 3:15pm

But again, it might just be syncing a folder.
You can check the status of all resources in akonadiconsole e.g.

You might try to run “akonadictl fsck” (as user! not root!) to see whether there is a problem with the database and hopefully fix it.

karlmistelberger · May 30, 2018, 11:11pm

It occurs with Tumbleweed. There is definitely corruption of the local storage. Lots of empty folders are created, such as .local/share/local-mail/sent-mail/cur/new, .local/share/local-mail/sent-mail/new/new, .local/share/local-mail/sent-mail/cur/tmp … . Recovery is through removing .local/share/akonadi* and deleting empty folders.

dcurtisfra · June 1, 2018, 11:46am

Yes, there’s something in Akonadi which occasionally creates empty “cur/”, “new/” and “tmp/” directories in various Kontact (PIM) directories located in “~/.local/share/”.

I haven’t stumbled across what’s doing it – I simply remove those empty directories occasionally.
[HR][/HR]BTW: “akonadictl vacuum” is also needed after “akonadictl fsck”.
[HR][/HR]To find those empty “cur/”, “new/” and “tmp/” directories, for each “cur” or “new” or “tmp” you need to execute something like the following CLI commands from you login directory:


find .local/share/local-mail/ -type d -name 'new' -exec ls '{}' \;
find .local/share/.local-mail.directory/ -type d -name 'new' -exec ls '{}' \;

find .local/share/local-mail/ -type d -name 'new' -print -exec ls '{}' \; | less
find .local/share/.local-mail.directory/ -type d -name 'new' -print -exec ls '{}' \; | less

Be aware that, for the case of ‘new’ directories, you’ll find all your unread e-Mails or, those e-Mails you have read and then moved to another Mail Folder – there is a KDE Bug reported but, no action to date …

karlmistelberger · June 1, 2018, 2:02pm

dcurtisfra:

Yes, there’s something in Akonadi which occasionally creates empty “cur/”, “new/” and “tmp/” directories in various Kontact (PIM) directories located in “~/.local/share/”.

I haven’t stumbled across what’s doing it – I simply remove those empty directories occasionally.
[HR][/HR]BTW: “akonadictl vacuum” is also needed after “akonadictl fsck”.
[HR][/HR]To find those empty “cur/”, “new/” and “tmp/” directories, for each “cur” or “new” or “tmp” you need to execute something like the following CLI commands from you login directory:
find .local/share/local-mail/ -type d -name 'new' -exec ls '{}' \;
find .local/share/.local-mail.directory/ -type d -name 'new' -exec ls '{}' \;

find .local/share/local-mail/ -type d -name 'new' -print -exec ls '{}' \; | less
find .local/share/.local-mail.directory/ -type d -name 'new' -print -exec ls '{}' \; | less
Be aware that, for the case of ‘new’ directories, you’ll find all your unread e-Mails or, those e-Mails you have read and then moved to another Mail Folder – there is a KDE Bug reported but, no action to date …

I am using:

for j in cur tmp new ; do 
    for i in cur tmp new ; do 
        find ~/.local/share/local-mail/ -type d -path '*'$i/$j  # -exec rmdir {} \;
    done
done

I think using rmdir is pretty safe.

Stopping kmail and akonadi, then removing .local/share/akonadi* and deleting empty folders and restarting would not work. What finally fixed the issue: https://mail.kde.org/pipermail/kdepim-users/2017-February/000546.html

karlmistelberger · June 6, 2018, 8:52pm

Typical assortion of messages:

karl@erlangen:~> akonadiconsole          
Found only the dummy module in speech-dispatcher. No text to speech possible. Install a tts module (e.g. espeak).
[0606/203446.905714:WARNING:stack_trace_posix.cc(648)] Failed to open file: /home/karl/#2230222 (deleted)
  Error: Datei oder Verzeichnis nicht gefunden
[5921:5956:0606/203447.135322:ERROR:nss_util.cc(750)] After loading Root Certs, loaded==false: NSS error code: -8018
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673180" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673183" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673190" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673201" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673214" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673350" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673359" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673360" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673363" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673380" "No such file or directory"
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
org.kde.pim.akonadi_indexer_agent: Failed to fetch items:  "Collection does not exist"
org.kde.pim.akonadi_indexer_agent: Indexing failed:  ""
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673571" "No such file or directory"
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
org.kde.pim.akonadi_indexer_agent: Failed to fetch items:  "Collection does not exist"
org.kde.pim.akonadi_indexer_agent: Indexing failed:  ""
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673640" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673658" "No such file or directory"
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
org.kde.pim.akonadi_indexer_agent: Failed to fetch items:  "Collection does not exist"
org.kde.pim.akonadi_indexer_agent: Indexing failed:  ""
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
org.kde.pim.akonadi_indexer_agent: Failed to fetch items:  "Collection does not exist"
org.kde.pim.akonadi_indexer_agent: Indexing failed:  ""
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
org.kde.pim.akonadi_indexer_agent: Failed to fetch items:  "Collection does not exist"
org.kde.pim.akonadi_indexer_agent: Indexing failed:  ""
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
org.kde.pim.akonadi_indexer_agent: Failed to fetch items:  "Collection does not exist"
org.kde.pim.akonadi_indexer_agent: Indexing failed:  ""
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Restarting application '/usr/bin/akonadi_indexing_agent'.
org.kde.pim.akonadi_indexer_agent: Failed to fetch items:  "Collection does not exist"
org.kde.pim.akonadi_indexer_agent: Indexing failed:  ""
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673725" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673777" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673834" "No such file or directory"
org.kde.pim.akonadicore: Failed to open external payload: "/home/karl/.local/share/akonadi/file_db_data/43/56343_r673892" "No such file or directory"
org.kde.pim.akonadicore: Got a stale 'changed' notification for an item which was already removed. 18617 "1510808117.R89.erlangen:2,S"
org.kde.pim.akonadicore: Got a stale 'changed' notification for an item which was already removed. 18587 "1454857304.R315.erlangen.home:2,S"

hundreds of similar to the above ommitted ...

org.kde.pim.akonadiserver:   Error code: "1452"
org.kde.pim.akonadiserver:   DB error:  "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
org.kde.pim.akonadiserver:   Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Der Befehl konnte nicht ausgeführt werden"
org.kde.pim.akonadiserver:   Query: "INSERT INTO PartTable (pimItemId, partTypeId, data, datasize, version) VALUES (:0, :1, :2, :3, :4)"
org.kde.pim.akonadiserver: Error during insertion into table "PartTable" "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Der Befehl konnte nicht ausgeführt werden"
"Unable to fetch item from backend (collection -1) : Unable to retrieve item from resource: Failed to insert part to database"
"Item query returned empty result set"
"Item query returned empty result set"
"Item query returned empty result set"
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
karl@erlangen:~> 
karl@erlangen:~> 
karl@erlangen:~> 
karl@erlangen:~> 
karl@erlangen:~> 
karl@erlangen:~> akonadictl stop         
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
karl@erlangen:~> QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_akonotes_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_mailfilter_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_birthdays_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildispatcher_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_migration_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_contacts_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_notes_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_newmailnotifier_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_sendlater_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_archivemail_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_followupreminder_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_indexing_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildir_resource' exited normally...
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...

karl@erlangen:~>

Clearing the cache of the collection where the indexer is hanging would fix the problem of ***turbating akonadi.