Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 661856 - kde-apps/akonadi loses connection with IMAP server after suspend
Summary: kde-apps/akonadi loses connection with IMAP server after suspend
Status: RESOLVED UPSTREAM
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: x86 Linux
: Normal normal (vote)
Assignee: Gentoo KDE team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-23 07:13 UTC by yves.caniou
Modified: 2018-11-01 08:54 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
emerge --info (emerge--info.txt,6.05 KB, text/plain)
2018-07-23 07:13 UTC, yves.caniou
Details

Note You need to log in before you can comment on or make changes to this bug.
Description yves.caniou 2018-07-23 07:13:54 UTC
Created attachment 540556 [details]
emerge --info

Hi,

Akonadi is v17.12.3
dev-db/mariadb is v10.1.34

1) At nearly all KDE startup, akonadi terminates quickly with something like the following (not new but I never reported).
It seems that it is relaunched automatically (by korganizer, kmail, ... ?)
If needed/requested, I can compile with some debug mode to help debugging.

Application: akonadi_control (akonadi_control), signal: Aborted
Using host libthread_db library "/lib64/libthread_db.so.1".
[Current thread is 1 (Thread 0x7f2b76f6b780 (LWP 6452))]

Thread 3 (Thread 0x7f2b5ce09700 (LWP 6455)):
#0  0x00007f2b7202edf3 in g_main_context_prepare () from /usr/lib64/libglib-2.0.so.0
#1  0x00007f2b7202f88b in g_main_context_iterate.isra () from /usr/lib64/libglib-2.0.so.0
#2  0x00007f2b7202fa7c in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0
#3  0x00007f2b756f542b in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5
#4  0x00007f2b756a441a in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5
#5  0x00007f2b755026d3 in QThread::exec() () from /usr/lib64/libQt5Core.so.5
#6  0x00007f2b7664eec5 in QDBusConnectionManager::run() () from /usr/lib64/libQt5DBus.so.5
#7  0x00007f2b75506b91 in QThreadPrivate::start(void*) () from /usr/lib64/libQt5Core.so.5
#8  0x00007f2b7486f97a in start_thread () from /lib64/libpthread.so.0
#9  0x00007f2b74b893ef in clone () from /lib64/libc.so.6

Thread 2 (Thread 0x7f2b69c12700 (LWP 6453)):
#0  0x00007f2b74b7dad4 in poll () from /lib64/libc.so.6
#1  0x00007f2b7157d860 in _xcb_conn_wait () from /usr/lib64/libxcb.so.1
#2  0x00007f2b7157f419 in xcb_wait_for_event () from /usr/lib64/libxcb.so.1
#3  0x00007f2b6bf72299 in QXcbEventReader::run() () from /usr/lib64/libQt5XcbQpa.so.5
#4  0x00007f2b75506b91 in QThreadPrivate::start(void*) () from /usr/lib64/libQt5Core.so.5
#5  0x00007f2b7486f97a in start_thread () from /lib64/libpthread.so.0
#6  0x00007f2b74b893ef in clone () from /lib64/libc.so.6

Thread 1 (Thread 0x7f2b76f6b780 (LWP 6452)):
[KCrash Handler]
#6  0x00007f2b74abe020 in raise () from /lib64/libc.so.6
#7  0x00007f2b74abfc0d in abort () from /lib64/libc.so.6
#8  0x00007f2b754f3a67 in QMessageLogger::fatal(char const*, ...) const () from /usr/lib64/libQt5Core.so.5
#9  0x0000559780775b5d in akInit(QString const&) ()
#10 0x0000559780773942 in AkApplicationBase::init() ()
#11 0x00005597807505bb in main ()

2) Akonadi looses connection with IMAPS server (M$).
To get it back, I restart akonadi, and possibly have to make a fsck because a mail doesn't show (blank page in the frame instead of the mail).

3) akonadi fsck gives many errors like the following, "record with id" number being different in each:
DATABASE ERROR:
  Error code: "1205"
  DB error:  "Lock wait timeout exceeded; try restarting transaction"
  Error text: "Lock wait timeout exceeded; try restarting transaction QMYSQL3:  Unable to execute statement"
  Query: "UPDATE PimItemTable SET atime = ? WHERE ( ( PimItemTable.id = ? ) )"
Unable to update item access time
Error during updating record with id 790240  in table "PartTable" "Driver not loaded Driver not loaded"

4) fsck gives also things like "Found 844 items without RID."
I don't know what is a RID, but I'm a bit afraid about the integrity of my mails...

5) fsck gives also errors like:
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1064"
org.kde.pim.akonadiserver:   DB error:  "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1"
org.kde.pim.akonadiserver:   Error text: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1 QMYSQL: Unable to execute query"
org.kde.pim.akonadiserver:   Query: "SELECT PartTable.id, PartTable.pimItemId, PartTable.partTypeId, PartTable.data, PartTable.datasize, PartTable.version, PartTable.storage FROM PartTable WHERE ( PartTable.pimItemId IN (  ) AND PartTable.storage = :0 )"
Error while deleting duplicates Driver not loaded Driver not loaded
Comment 1 yves.caniou 2018-07-30 16:27:07 UTC
Since update to 18.04.3, no crash when KDE starts anymore, and for the moment, connections to imaps servers (linux and M$) are good, and resume well after a suspend.
-- had to akonadictl fsck and restart a couple of time, kmail was refusing to show some mails. Everything seems fine now.
Comment 2 yves.caniou 2018-07-31 06:23:58 UTC
Finally still losing connection with M$ server after a suspend to RAM.
Running "akonadictl restart" brings messages that some things don't seem to go as it should, but all connection seem to restart.

org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_newmailnotifier_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_imap_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource' crashed. No restart!
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_archivemail_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_notes_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_mixedmaildir_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_sendlater_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_followupreminder_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_mailfilter_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_ical_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' crashed. No restart!
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_ical_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_imap_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource' crashed. No restart!
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_contacts_resource' exited normally...

Plus that kind:
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Multiple merge candidates, aborting"
org.kde.pim.akonadicore: Error during ItemSync:  "Multiple merge candidates, aborting"
org.kde.pim.kimap: We asked for UID but the server didn't give it back, resultingFlags not stored.
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Multiple merge candidates, aborting"
org.kde.pim.akonadicore: Error during ItemSync:  "Multiple merge candidates, aborting"
org.kde.knotifications: Could not notify  "new-email" by taskbar, notification has no associated widget
log_mixedmaildir: Akonadi fetch got 24 items
log_mixedmaildir: of which 24 have remoteId
log_mixedmaildir: No index file "/home/ycaniou/.local/share/local-mail/.drafts.index" or not readable
log_mixedmaildirresource: storeList->error= 0
log_mixedmaildir: Store fetch got 24 items of which 0 are new and 0 are changed and 0 need to be removed
log_mixedmaildir: 0 items marked as Deleted
                                         (+ many more for local-mail dir)
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Multiple merge candidates, aborting"
org.kde.pim.akonadicore: Error during ItemSync:  "Multiple merge candidates, aborting"
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1205"
org.kde.pim.akonadiserver:   DB error:  "Lock wait timeout exceeded; try restarting transaction"
org.kde.pim.akonadiserver:   Error text: "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = ? WHERE ( ( PimItemTable.id = ? ) )"
org.kde.pim.akonadiserver: Unable to update item access time
"Item query returned empty result set"
"Item query returned empty result set"
org.kde.pim.kimap: We asked for UID but the server didn't give it back, resultingFlags not stored.
"Item query returned empty result set"
"Item query returned empty result set"
org.kde.pim.kimap: We asked for UID but the server didn't give it back, resultingFlags not stored.
org.kde.pim.kimap: We asked for UID but the server didn't give it back, resultingFlags not stored.
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: ""
Comment 3 Andreas Sturmlechner gentoo-dev 2018-08-04 23:41:33 UTC
Please go to upstream with this bug. bugs.kde.org will almost certainly already have one fitting bug recorded.
Comment 4 yves.caniou 2018-11-01 08:53:31 UTC
A report has been made here:
Comment 5 yves.caniou 2018-11-01 08:54:52 UTC
A report has been made here:
    https://bugs.kde.org/show_bug.cgi?id=397316