Re: [Evolution] “cannot VACUUM from within a transaction”

[Joakim Tjernlund <Joakim Tjernlund infinera com>]

On Tue, 2022-08-30 at 15:19 +0200, Milan Crha via evolution-list wrote:
> On Tue, 2022-08-30 at 12:47 +0200, Joakim Tjernlund via evolution-list
> wrote:
> > Failed to expunge folder “Infinera : Deleted Items”.
> > The reported error was “cannot VACUUM from within a transaction”.
> >
> > Seems like the operation is successful though, Deleted Items is empty
>
>       Hi,
> the vacuum is ran on the database level, to make the corresponding
> folders.db file smaller.
>
> I tried it here, but it did not trigger the condition, maybe my
> folders.db file doesn't need the vacuum call. Just in case, do you know
> the version of the sqlite in your system please? I do not think they
> changed anything relevant, I only want to make sure I'll use a similar
> version as you.

dev-db/sqlite-3.39.2 but I have seen this on and off for quite a while.
I usually have hundreds of mail in Deleted Items(even 1000-2000 sometimes),
maybe it depends on number of emails to purge?

> Maybe open a bug against the evolution-data-server [1] (these things
> are done in the libcamel, which is there), to not have this lost in the
> mailing list. I can move it elsewhere, if it'll turn out to not be in
> the evolution-data-server code base.
>
>       Thanks and bye,
>       Milan
>
> [1] 
> https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.gnome.org%2FGNOME%2Fevolution-data-server%2F-%2Fissues&data=05%7C01%7Cjoakim.tjernlund%40infinera.com%7C33bbf5471427459f116108da8a8a659c%7C285643de5f5b4b03a1530ae2dc8aaf77%7C1%7C0%7C637974624280261209%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PBQnwTKSWZzh7gG3TcupiqDWqlHcRe3eoVqFsIzxDPc%3D&reserved=0
>
> _______________________________________________
> evolution-list mailing list
> evolution-list gnome org
> To change your list options or unsubscribe, visit ...
> https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmail.gnome.org%2Fmailman%2Flistinfo%2Fevolution-list&data=05%7C01%7Cjoakim.tjernlund%40infinera.com%7C33bbf5471427459f116108da8a8a659c%7C285643de5f5b4b03a1530ae2dc8aaf77%7C1%7C0%7C637974624280417430%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=TJJBBc00Md5zxb%2FisIhlldHsTj7ems1DfUCLkc1Pdx8%3D&reserved=0