[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Bug Janitor Service]

https://bugs.kde.org/show_bug.cgi?id=384359

Bug Janitor Service  changed:

   What|Removed |Added

 Resolution|WAITINGFORINFO  |WORKSFORME
 Status|NEEDSINFO   |RESOLVED

--- Comment #14 from Bug Janitor Service  ---
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Bug Janitor Service]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #13 from Bug Janitor Service  ---
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Justin Zobel]

https://bugs.kde.org/show_bug.cgi?id=384359

Justin Zobel  changed:

   What|Removed |Added

 Resolution|--- |WAITINGFORINFO
 Status|REPORTED|NEEDSINFO

--- Comment #12 from Justin Zobel  ---
Thank you for reporting this issue in KDE software. As it has been a while
since this issue was reported, can we please ask you to see if you can
reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when
replying. Thank you!

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Daniel Roschka]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #11 from Daniel Roschka  ---
I might have figured out what caused the issue.

The search folder in KMail showed 10 results and when I opened the search
window it showed the search folder itself as destination for the search. I then
did a search in a different folder and the problem immediately went away.

So my guess is that it's somehow an odd default which results in a recursive
search, as the search searches in the search results.

I haven't been able to reproduce it once it was gone, but luckily the problem
is gone for me now.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Daniel Roschka]

https://bugs.kde.org/show_bug.cgi?id=384359

Daniel Roschka  changed:

   What|Removed |Added

 CC||danielroschka@phoenitydawn.
   ||de

--- Comment #10 from Daniel Roschka  ---
I got the exactly the same problem after updating to KDE PIM 17.08 and haven't
been able to solve it yet.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #9 from mat...@gmail.com ---
apologies for the many comments... I made a mistake, it was not a google
calendar but a remote ics file, imported from office365.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #8 from mat...@gmail.com ---
ok, I found out that my problem is with google calendars. I had a google
calendar displayed in korganizer and korgc was using 3.5 GB of memory, and
running queries like there was no tomorrow. I removed the calendar and it seems
to be ok. So maybe these are two different issues... not sure.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #7 from mat...@gmail.com ---
Created attachment 108214
  --> https://bugs.kde.org/attachment.cgi?id=108214=edit
akonadiconsole showing the queries to the db

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=384359

mat...@gmail.com changed:

   What|Removed |Added

 CC||mat...@gmail.com

--- Comment #6 from mat...@gmail.com ---
I get mysqld, kontact, akonadiserver, korgac, and akonadi_ical_resource that
run like crazy and whose memory footprint grows indefinitely.

kmail seems to be fine, the madness starts when I run korganizer, or open the
calendar within kontact.

By looking at akonadiconsole the db is queried pretty much continuously, I'm
attaching a screen shot after a few seconds. I am running 17.04.2, Kde
Frameworks 5.32, qt 5.6.2, on OpenSUSE 42.3.

Let me know if there's anything I can do to get more info. Thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Gunter Ohrner]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #5 from Gunter Ohrner  ---
Is anyone else seeing this problem? Otherwise I'll probably close the bug.

Or does one of the developers fear / see a problem here and want to keep this
issue open to have a reminder for having a look at it?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Gunter Ohrner]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #4 from Gunter Ohrner  ---
For whatever reason, the query storm stopped on my system.

Now kMail is still as slow as ever, but more or less usable again.

Meanwhile I also upgraded to 5.6.1 - no idea if it's related to this
improvement or if both are independent events.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Olivier Goffart]

https://bugs.kde.org/show_bug.cgi?id=384359

Olivier Goffart  changed:

   What|Removed |Added

 CC||ogoff...@kde.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[EGD]

https://bugs.kde.org/show_bug.cgi?id=384359

EGD  changed:

   What|Removed |Added

 CC||egdf...@opensuse.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Gunter Ohrner]

https://bugs.kde.org/show_bug.cgi?id=384359

--- Comment #3 from Gunter Ohrner  ---
Not quite sure if really IMAP ressource is the culprit, but I think so.

How can I find out who or what is triggering all those (slow) queries?

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.

[Akonadi] [Bug 384359] Regression in 5.6.0 / 17.08 compared to 17.04.3: MySQL load always 100%, constant queries, extremely sluggisch behaviour

[Gunter Ohrner]

https://bugs.kde.org/show_bug.cgi?id=384359

Gunter Ohrner  changed:

   What|Removed |Added

Product|kmail2  |Akonadi
  Component|general |IMAP resource
 CC||kdepim-bugs@kde.org

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.