[opensuse-factory] Re: How to reindex akonadi database without having to reconfigure?
On Thursday, 2 February 2017 09:45:59 GMT Martin Steigerwald wrote:
Am Donnerstag, 2. Februar 2017, 07:56:16 CET schrieb ianseeks:
Hi
I'm having the "Retrieving folder..." error message on every folder that contains an unread item. Akonadi fsck/vacuum/top/start no longer fixes the problem. I have in the past followed the how to fix akonadi when there was a failed migration and that did all the work but it seemed like a hammer to crack a nut as you have to reconfigure kmail etc.
Is there a way to just delete the data and any related indexes to force a reindexing process?
I'm running out of ideas hence i hope this idea may help
Did you try "Clear Akonadi Cache" on one of the folders in question in Akonadiconsole. As far as I understand this is a partial clearing of the cache which forces Akonadi to redo the cache for the particular folder.
I bet I´d do it in the following order:
1) make sure you have backup 2) stop Kmail 3) stop Akonadi 4) make sure database process is gone 5) start Akonadiconsole 6) clear cache of one folder 7) start kmail and test result
As far as I understand you maybe could loose data with doing that, just as you can loose data with removing the complete database, cause while Akonadi is mostly a cache, there can be circumstances where it contains more than only cached items, i.e. when an IMAP server is not reachable to add a newly written mail into the sent folder… (but on that I also found that the sent mail was stored into the local sent mail folder instead).
I do not know exactly whether the data loss risk is only when you wipe the whole database, or also when you clear only the cache of one folder, but I warned you :)
Also I believe there was a recent bug which caused Retrieving folder contents displayed forever… you could research that. I am still using KDEPIM 16.04 as Debian has nothing newer packaged due to challenges and difficulties packaging Qt Webengine with Debian quality standards. I've been suffereing that for quite a while and it got to the point where every folder i opened gave me that message, its taken about 12 hours for
Also what I believed helped timeouts a lot is raising InnoDB buffer pool size *a lot*. I raised it to 1 GiB. Mysqltuner.pl recommended even more. But keep the amount of free memory on your system in mind. Whether that helps you or not mostly depends on whether Akonadi is waiting on mysqld to complete the queries it floods it with. That might help, i'll try that. I've deleted a lot of emails prior to 2016 and
That made no difference trying things to be able to reply to your email that seems to have made it possible for me to do some work again.
Thanks,
Thanks for the reply -- opensuse:tumbleweed:20170131 Qt: 5.7.1 KDE Frameworks: 5.30.0 KDE Plasma: 5.9.0 kwin5-5.9.0-1.1.x86_64 kmail2 5.4.1 Kernel: 4.9.6-1-default Nouveau: 1.0.13_2.2 -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Op donderdag 2 februari 2017 22:13:29 CET schreef ianseeks:
On Thursday, 2 February 2017 09:45:59 GMT Martin Steigerwald wrote:
Am Donnerstag, 2. Februar 2017, 07:56:16 CET schrieb ianseeks:
Hi
I'm having the "Retrieving folder..." error message on every folder that contains an unread item. Akonadi fsck/vacuum/top/start no longer fixes the problem. I have in the past followed the how to fix akonadi when there was a failed migration and that did all the work but it seemed like a hammer to crack a nut as you have to reconfigure kmail etc.
Is there a way to just delete the data and any related indexes to force a reindexing process?
I'm running out of ideas hence i hope this idea may help
I removed the directory .local/share/akonadi/ after closing kontact and stopping akonadi using "akonadict stop" by giving it another name; just for safety. After that I just started kontact, which starts akonadi and all of its processes. This builds a new directory like the above with a new mysql database and after some patience almost all is back to normal, except pointers to Trash folders which used to point to trash folders of an account, but I found these folders pointing to what seems to be a random folder in an account. You need to be patient and observe that all folders are filled again from the local folders and from folders on an IMAP server, before you direct the trash folder to the proper trash folder. I needed this to do a few times and never lost a single message. -- fr.gr. member openSUSE Freek de Kruijf -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Op donderdag 2 februari 2017 22:13:29 CET schreef ianseeks:
On Thursday, 2 February 2017 09:45:59 GMT Martin Steigerwald wrote:
Am Donnerstag, 2. Februar 2017, 07:56:16 CET schrieb ianseeks:
Hi
I'm having the "Retrieving folder..." error message on every folder that contains an unread item. Akonadi fsck/vacuum/top/start no longer fixes the problem. I have in the past followed the how to fix akonadi when there was a failed migration and that did all the work but it seemed like a hammer to crack a nut as you have to reconfigure kmail etc.
Is there a way to just delete the data and any related indexes to force a reindexing process?
I'm running out of ideas hence i hope this idea may help
I removed the directory .local/share/akonadi/ after closing kontact and stopping akonadi using "akonadict stop" by giving it another name; just for safety. After that I just started kontact, which starts akonadi and all of its processes. This builds a new directory like the above with a new mysql database and after some patience almost all is back to normal, except pointers to Trash folders which used to point to trash folders of an account, but I found these folders pointing to what seems to be a random folder in an account. You need to be patient and observe that all folders are filled again from the local folders and from folders on an IMAP server, before you direct the trash folder to the proper trash folder.
I needed this to do a few times and never lost a single message.
On Friday, 3 February 2017 00:29:53 GMT Freek de Kruijf wrote: thanks. i tried that and it all seemed to work ok. But it didn't improve my "Retrieving Folders...." problem at all. I gave up on it and i created a new user in the end and started with a fresh empty mail system. -- opensuse:tumbleweed:20170201 Qt: 5.7.1 KDE Frameworks: 5.30.0 KDE Plasma: 5.9.0 kwin5-5.9.0-1.1.x86_64 kmail2 5.4.1 Kernel: 4.9.6-1-default Nouveau: 1.0.13_2.2 -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
participants (2)
-
Freek de Kruijf
-
ianseeks