Re: A mess in KMail

--nextPartGkPlr5iAQWee_sxC_HXWlQ
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="utf-8"; protected-headers="v1"
From: Michael <[email protected]>
To: [email protected]
Reply-To: [email protected]
Subject: Re: [gentoo-user] A mess in KMail
Date: Sat, 20 Jun 2026 16:31:20 +0100
Message-ID: <[email protected]>
In-Reply-To: <[email protected]>
References: <[email protected]>
MIME-Version: 1.0

On Saturday, 20 June 2026 15:58:23 British Summer Time Peter Humphrey 
wrote:
> Greetings Users,
> 
> I've come a cropper with the switch from mysql to sqlite in akonadi. I
> followed the instructions to migrate, and ended up with large gaps in
> my collection of emails. Hah! I thought; I know what to do. For many
> years I've had a cron job running on my mail server, running rsync to
> copy my .maildir to backup. That directory is now 2.8GB. All I had to
> do was rsync back in the other direction and I'd have my mail back
> again. I did that once before, and once I'd pruned old stuff, sorted
> out expiry dates and so on, all was fine.
> 
> 'Fortune favours the bold,' we're told, but Murphy's Law also applies.
> Now I have 11000 messages in gentoo-user, down from 30000 after
> expiring at 400 days. Manageable, you may suppose, but I have large
> numbers of messages greyed out in the message list. Other folders
> have similar problems.
> 
> Any idea how I can get out of this mess? I've tried migrating back to
> mysql, but it seems to make no difference. I've also run akonadictl
> fsck and vacuum a few times, also making no difference.

You could try 'clear cache' from within akonadiconsole, after you shut 
down kmail.  Best you try this ONLY on ONE folder/subfolder, then check 
the situation within Kmail to make sure it worked.  Large folders may 
take some time.

If the above does not work, you can have a look at this process to 
recreate everything from scratch:

https://userbase.kde.org/KMail/
FAQs_Hints_and_Tips#Clean_start_after_a_failed_migration

--nextPartGkPlr5iAQWee_sxC_HXWlQ
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part.
Content-Transfer-Encoding: 7Bit

-----BEGIN PGP SIGNATURE-----

iQJPBAABCAA5FiEEXqhvaVh2ERicA8Ceseqq9sKVZxkFAmo2skgbFIAAAAAABAAO
bWFudTIsMi41KzEuMTIsMiwyAAoJELHqqvbClWcZB5wP+wfTg4t1U4T0J7yKhyp+
io4iJdBVpJpcpO5/W1TbTRVvJd2X9+qamz1+FrtVE71FgE/lxTFDGNynVIL0yZ3y
gkEdz8V8xVrIYEupjYFaoUcCbEp2qOTD5w00USTcIViICxC70WWoK9bLmlwv2ldb
VEz8KejbHX0vnqkpJX45ua9yJeBDbhkpsRnvWVKvBsE8x3RdkE0mmxkExLIyoU+C
TKZdREIEj5hoajC3Qjn0lsb6MqpkOnbQce7knIweXYB5/negE6gtG6uYapOMEfBu
dNCm4NjvZ+gSvrDMX54AVZttcdvqEO4f3f4oNiDTAYe7ehN/nQbUGvtQe/rUUOqr
7J/NU5AU20Uc7g38euGaBHs1oeh1N7C6es30EgpUora+iBMJPhldOszeuPo6SZuD
jRONYKwYhsTnEHf0CkSWag+8euG82YGtE9KIOfzPihtFxGOf5b1a+Evj3QKiYVKD
BQ9zmzJVh2J1hBvq4gn9/sqa3XVDG3joWy7Ea/2Zb84wFUIyEQS7fFaUpoCeUCVl
wf508xVivhG3OMCAhdwsU6jc1wSJ7SjvQIak0G1dfDo6FF0PUoE+BDNQWZbCwhh+
2qI0fdqhs50M+uVei/Zl0Fl76jUdFs7cOvtqrXQLNLF0mp9LYwAD/UICmxQVKIVJ
UjZRUceId70yv1NM25yHEZyd
=dwvN
-----END PGP SIGNATURE-----

--nextPartGkPlr5iAQWee_sxC_HXWlQ--