Calendar failure

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Calendar failure

Gnome Evolution - General mailing list
Was importing an ICS file with multiple entries into my Outlook (EWS)
calendar and got this error. What is the best way to repair/recover?

Thanks.

   The calendar backend servicing “Calendar” encountered an error.

   The reported error was “SQLite error code '11': database disk image
   is malformed (statement:SELECT ECacheOBJ FROM ECacheObjects WHERE
   ECacheUID='040000008200E00074C5B7101A82E00800000000F0A5532741FDD1010
   000000000000000100000001D433CF2A855704680B4529641359835' OR
   ECacheUID LIKE
   '040000008200E00074C5B7101A82E00800000000F0A5532741FDD10100000000000
   00000100000001D433CF2A855704680B4529641359835
   %' ORDER BY ECacheUID)”.
--
Matthew Saltzman
School of Mathematical and Statistical Sciences
Clemson University
mjs AT clemson DOT edu
_______________________________________________
evolution-list mailing list
[hidden email]
To change your list options or unsubscribe, visit ...
https://mail.gnome.org/mailman/listinfo/evolution-list
Reply | Threaded
Open this post in threaded view
|

Re: Calendar failure

Gnome Evolution - General mailing list
On Tue, 2020-09-29 at 15:58 +0200, Matthew Saltzman via evolution-list
wrote:
> SQLite error code '11': database disk image is malformed

        Hi,
unfortunately delete ~/.cache/evolution/calendar/<calendar-uid>/, then
restart the background processes (evolution --force-shutdown), then
start evolution and let it re-download the server events to the local
cache.
        Bye,
        Milan

_______________________________________________
evolution-list mailing list
[hidden email]
To change your list options or unsubscribe, visit ...
https://mail.gnome.org/mailman/listinfo/evolution-list
Reply | Threaded
Open this post in threaded view
|

Re: Calendar failure

Gnome Evolution - General mailing list
On Tue, 2020-09-29 at 16:20 +0200, Milan Crha via evolution-list wrote:

> On Tue, 2020-09-29 at 15:58 +0200, Matthew Saltzman via evolution-
> list
> wrote:
> > SQLite error code '11': database disk image is malformed
>
> Hi,
> unfortunately delete ~/.cache/evolution/calendar/<calendar-uid>/,
> then
> restart the background processes (evolution --force-shutdown), then
> start evolution and let it re-download the server events to the local
> cache.

Thanks. How do I know which UID is the one I need to remove?

> Bye,
> Milan
>
> _______________________________________________
> evolution-list mailing list
> [hidden email]
> To change your list options or unsubscribe, visit ...
> https://mail.gnome.org/mailman/listinfo/evolution-list
--
Matthew Saltzman
School of Mathematical and Statistical Sciences
Clemson University
mjs AT clemson DOT edu
_______________________________________________
evolution-list mailing list
[hidden email]
To change your list options or unsubscribe, visit ...
https://mail.gnome.org/mailman/listinfo/evolution-list
Reply | Threaded
Open this post in threaded view
|

Re: Calendar failure

Gnome Evolution - General mailing list
On Tue, 2020-09-29 at 16:33 +0200, Matthew Saltzman via evolution-list
wrote:
> Thanks. How do I know which UID is the one I need to remove?

        Hi,
right, it's harder to find out.

The EWS calendar definitions are stored in
~/.cache/evolution/sources/<account-UID>/*.source
You search the files for something unique and then the file name
(without the .source extension) is the UID you are looking for.

Or you can search the files under ~/.cache/evolution/calendar/ for an
existing event, again with something unique you see from the affected
calendar, and that will tell you which directory is the right one.

You can also traverse the calendar directories and check with sqlite3
command which of the cache.db file(s) is (are) broken (and remove all
the affected). I do not have a good SQL command handy, the one from the
error message may work too.

In case you have no problem with the bandwidth, you can simply delete
all the calendar caches and let the factory re-download all of them.
        Bye,
        Milan


_______________________________________________
evolution-list mailing list
[hidden email]
To change your list options or unsubscribe, visit ...
https://mail.gnome.org/mailman/listinfo/evolution-list
Reply | Threaded
Open this post in threaded view
|

Re: Calendar failure

Gnome Evolution - General mailing list
Got it, thanks!

On Tue, 2020-09-29 at 16:57 +0200, Milan Crha via evolution-list wrote:

> On Tue, 2020-09-29 at 16:33 +0200, Matthew Saltzman via evolution-
> list
> wrote:
> > Thanks. How do I know which UID is the one I need to remove?
>
>         Hi,
> right, it's harder to find out.
>
> The EWS calendar definitions are stored in
> ~/.cache/evolution/sources/<account-UID>/*.source
> You search the files for something unique and then the file name
> (without the .source extension) is the UID you are looking for.
>
> Or you can search the files under ~/.cache/evolution/calendar/ for an
> existing event, again with something unique you see from the affected
> calendar, and that will tell you which directory is the right one.
>
> You can also traverse the calendar directories and check with sqlite3
> command which of the cache.db file(s) is (are) broken (and remove all
> the affected). I do not have a good SQL command handy, the one from
> the
> error message may work too.
>
> In case you have no problem with the bandwidth, you can simply delete
> all the calendar caches and let the factory re-download all of them.
>         Bye,
>         Milan
>
>
> _______________________________________________
> evolution-list mailing list
> [hidden email]
> To change your list options or unsubscribe, visit ...
> https://mail.gnome.org/mailman/listinfo/evolution-list
--
Matthew Saltzman
School of Mathematical and Statistical Sciences
Clemson University
mjs AT clemson DOT edu
_______________________________________________
evolution-list mailing list
[hidden email]
To change your list options or unsubscribe, visit ...
https://mail.gnome.org/mailman/listinfo/evolution-list