[kontact] [Bug 352701] Kontact forgets how to download messages

[Bug Janitor Service]

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

Bug Janitor Service  changed:

   What|Removed |Added

 Status|NEEDSINFO   |RESOLVED
 Resolution|WAITINGFORINFO  |WORKSFORME

--- Comment #13 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.

[kontact] [Bug 352701] Kontact forgets how to download messages

[Bug Janitor Service]

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

--- Comment #12 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 the assignee for the bug.

[kontact] [Bug 352701] Kontact forgets how to download messages

[Justin Zobel]

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

Justin Zobel  changed:

   What|Removed |Added

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

--- Comment #11 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.

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

--- Comment #10 from Nick  ---
And if you have rebuild your database but find new mail isn't showing up in the
inbox then this is the fix.

You will need to correct the destination folders in any filters you created in
kmail as they are now probably pointing to the wrong folders. In kmail
[Settings]>[Configure Filters] and if the filter uses a 'move into folder'
action, check it's moving to the correct folder.

This also applies to any account destination folders, ie my gmail pop3 account
was saving into a zoneminder folder I'd created. In kmail,
[Settings]>[Configure Kmail]>[Accounts]>[Receiving Tab] click on your account,
check destination folder.

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

--- Comment #9 from Nick  ---
BTW I'm running KDE Neon LTS 5.8
KDE Plasma Version 5.8.7
KDE Frameworks Version 5.38.0
QT Version 5.7.1
Kernel Version 4.10.0-33-generic
OS Type 64-bit

Processors 8x Intel Core I7 @ 2.2GHz
Memory 16GB

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

--- Comment #8 from Nick  ---
Interesting

Quote
You should execute mysql_upgrade each time you upgrade MySQL.

https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

--- Comment #7 from Nick  ---
Doing a more /var/log/apt/history.log | grep mysql I can see that
akonadi-backend-mysql was updated just before I started getting this problem.
I'm almost certain that's what messed up the mysql database and was the answer
to run mysql_upgrade as described here ?
https://dev.mysql.com/doc/refman/5.5/en/performance-schema-build-configuration.html

At least I'm feeling a little more confident about the akonadi-backend-mysql
update having triggered this problem.

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

--- Comment #6 from Nick  ---
Interesting regarding the mysql performance schema issue. I do remember doing a
very large update prior to this problem that maybe includeded a mysql update.
Could the fix have been as simple as running mysql_upgrade as described below ?

If you install MySQL over a previous installation that was configured without
the Performance Schema (or with an older version of the Performance Schema that
may not have all the current tables), run mysql_upgrade after starting the
server to ensure that the performance_schema database exists with all current
tables. Then restart the server. One indication that you need to do this is the
presence of messages such as the following in the error log:

[ERROR] Native table 'performance_schema'.'events_waits_history'
has the wrong structure
[ERROR] Native table 'performance_schema'.'events_waits_history_long'
has the wrong structure
...

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

--- Comment #5 from Nick  ---
Regarding the native table has the wrong structure error. Here's a link that
references this mysql error here
https://dev.mysql.com/doc/refman/5.5/en/performance-schema-build-configuration.html

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

--- Comment #4 from Nick  ---
This fixed it for me .. (until the next time the akonadi database gets
corrupted)

This involves removing the old akonadi database and letting akonadi construct
and reindex a new one.

First exit kmail
then as normal user
akonadi stop

mv /home/jbloggs/.local/share/akonadi /home/jbloggs/.local/share/akonadi.orig
(This is where akonadi stores it's mysql database)

akonadi start

You may get the following messages, but then nothing while it's reindexing.
akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
nick@nick-X681X:~/.local/share$ /usr/bin/mysqlcheck: Got error: 1049: Unknown
database 'akonadi' when selecting the database
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
"No file selected."
org.kde.pim.akonadicore: Failed SpecialCollectionsRequestJob::slotResult
"Failed to fetch the resource collection."
org.kde.pim.maildispatcher: Failed to get outbox folder. Retrying in:  5000
org.kde.pim.akonadicore: Failed to request resource
"akonadi_maildir_resource_0" : "Failed to fetch the resource collection."
org.kde.pim.akonadicore: Failed SpecialCollectionsRequestJob::slotResult
"Failed to fetch the resource collection."
org.kde.pim.akonadicore: Failed to request resource
"akonadi_maildir_resource_0" : "Failed to fetch the resource collection."
org.kde.akonadi.ETM: GEN true false false
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: 
org.kde.akonadi.ETM: Fetch job took  31 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 0
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: Fetch job took  39 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 2
org.kde.akonadi.ETM: first fetched collection: "Search"
org.kde.akonadi.ETM: Fetch job took  2 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 0
org.kde.akonadi.ETM: GEN true false false
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: 
org.kde.akonadi.ETM: Fetch job took  39 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 0
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: Fetch job took  42 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 2
org.kde.akonadi.ETM: first fetched collection: "Search"
org.kde.akonadi.ETM: Fetch job took  1 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 0
Pass a valid window to KWallet::Wallet::openWallet().
"Unable to fetch item from backend (collection -1) : Unable to retrieve item
from resource: Did not receive a reply. Possible causes include: the remote
application did not send a reply, the message bus security policy blocked the
reply, the reply timeout expired, or the network connection was broken."

To completely reindex akonadi may take a considerable time especially if you
have tens of thousands of emails. In my case it's still indexing after an hour.
However I can access my emails during this time.

looking at the process list with 'top' mysqld shows at 70-95% on my system
during this reindexing period.

If it all goes ok then remove the backup you made.
rm /home/jbloggs/.local/share/akonadi.orig

I don't use kontact or any Calendar so can't comment on what will happen to any
data you've entered in those apps however if like me you just use kmail then
this worked fine. In kmail it retained the various folders and filters I'd
created. And it now works without getting the annoying please wait retrieving
folder contents.

Because I made a backup of the original database I noticed that there were a
few mysql errors in the log, reproduced below. In particular the error that
stands out is this one (with lots of variations.. but basically native table
has the wrong structure.

[ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong
structure

more mysql.err
170915  0:46:57 [Note] InnoDB: innodb_empty_free_list_algorithm has been
changed to legacy because of small buffer pool size. In order to use backoff,
increase buffer pool at least up to 20MB.

170915  0:46:57 [Note] InnoDB: Using mutexes to ref count buffer pool pages
170915  0:46:57 [Note] InnoDB: The InnoDB memory heap is disabled
170915  0:46:57 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
170915  0:46:57 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for
memory barrier
170915  0:46:57 [Note] InnoDB: Compressed tables use zlib 1.2.8
170915  0:46:57 [Note] InnoDB: Using Linux native AIO
170915  0:46:57 [Note] InnoDB: Using CPU crc32 instructions
170915  0:46:57 [Note] InnoDB: Initializing buffer pool, size = 128.0M
170915  0:46:57 [Note] InnoDB: Completed initialization of buffer pool
170915  0:46:57 [Note] InnoDB: Highest supported file format is Barracuda.
170915  0:46:57 [Note] InnoDB: 128 rollback segment(s) are active.
170915  0:46:57 [Note] InnoDB: Waiting 

[kontact] [Bug 352701] Kontact forgets how to download messages

[Nick]

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

Nick  changed:

   What|Removed |Added

 CC||nick.craig@gmail.com

--- Comment #3 from Nick  ---
And me, I get this same error. Retrieving folder contents please wait. This bug
has been around for years. Kmail/akonadi has been working for me ok for a
couple of months but now I just get this inability to read a email. Perhaps
it's related to quantity of emails stored that makes it more likely to trigger
this bug ? Who knows :-/ In the past I think I've deleted the akonadi database
file and configs and started again but it's such a pain to keep doing that.
Looking at the logs this seems to be the problem "Cannot connect to agent
instance with identifier 'akonadi_maildir_resource_0', error message: ''"

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Oliver Kurz]

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

Oliver Kurz  changed:

   What|Removed |Added

 CC||ok...@suse.de

--- Comment #2 from Oliver Kurz  ---
I seem to have same or similar symptoms some times but not as often as reported
in comment 0. kmail stops to show emails but instead shows the background
window where the message preview should appear with the text "Retrieving folder
contents" shown.

~/.xsession-errors-:0 shows me

```
Connection broken with state 4 and error: "Unknown error"
```

multiple times during that time.

Version tested is KMail 5.3.0 on openSUSE Leap 42.2. Package version
16.08.2-1.1.

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

[kontact] [Bug 352701] Kontact forgets how to download messages

[Orion]

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

Orion  changed:

   What|Removed |Added

 CC||orion200...@yahoo.co.uk

--- Comment #1 from Orion  ---
using Kubuntu 15.10 Beta, latest Plasma 5 release
KMail says version 4.81 Beta 1

configured IMAP access to office365.com resulting in folders being created and
KMail (and akonadi) reports mail fetching starts. Gets stuck and no mail is
being fetched.

expected result: mail being fetched for offline (or non offline) use

Note: it works as expected in KMail 4.14.2 on Kubuntu 14.10 (KDE same version)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs