[Akonadi] [Bug 436550] Sporadic error when moving messages to trash.

2021-05-03 Thread David C. Bryant
https://bugs.kde.org/show_bug.cgi?id=436550

--- Comment #3 from David C. Bryant  ---
I guess I have a work around. I copied all the contents of
./local/share/local-mail/inbox to a new location. Then I closed KMail, stopped
Akonadi, and deleted all the messages in ./local/share/local-mail/inbox. When I
restarted KMail and ran "akonadictl fsck" I saw that 236 "dirty" items had been
eliminated. Here is some terminal output.

david@localhost ~ $ akonadictl stop
david@localhost ~ $ akonadictl fsck 2>&1|grep ^Found
Found 13 external files.
Found 13 external parts.
Found no unreferenced external files.
Found 0 parts to be moved to external files
Found 0 parts to be moved to database
Found 5 collections without RID.
Found 0 items without RID.
Found 2765 dirty items.

Notice the last line ... that used to say 3,001. 3,001 - 2,765 = 236. So there
were 236 "dirty" items in my inbox folder.

I killed KMail again, then stopped akonadi and copied the messages from the
backup copy back where they had come from. I then restarted KMail, and all the
inbox messages re-appeared. And when I reran akonadictl fsck, things were stil
(partially) copacetic:

david@localhost ~ $ akonadictl fsck 2>&1|grep ^Found
Found 398 external files.
Found 398 external parts.
Found no unreferenced external files.
Found 0 parts to be moved to external files
Found 0 parts to be moved to database
Found 5 collections without RID.
Found 0 items without RID.
Found 2765 dirty items.

So I guess I can cure my KMail error messages by repeating this procedure for
all the destinations in my folder tree. But I'd like to understand what created
the "dirty" items in the first place. And it would also be nice to have a less
labor-intensive method to correct this problem if and when it does arise.

(I'm not real hot with "C++". But I used to write database driver software in
assembly language on IBM mainframes. It's pretty clear to me that a bunch of
the pointers in Akonadi's relational database were corrupted somehow, leading
to a lot of "dirty" items. When I removed all the data from one -- well,
actually, two -- folders, a whole slew of pointers were cleared from the
relational database. Then, when I put the data back and restarted Akonadi, the
previously corrupted pointers were rebuilt correctly. So now a bunch of "dirty"
items are gone. If some clever C++ programmer could figure out how to make
Akonadi reconstruct all its relational database pointers without actually
moving a lot of data around, he could at least construct a recovery tool that
would probably be useful. Reading a bunch of forum posts, it's obvious a lot of
people are unhappy with Akonadi.)

-- 
You are receiving this mail because:
You are watching all bug changes.

[Akonadi] [Bug 436550] Sporadic error when moving messages to trash.

2021-05-03 Thread David C. Bryant
https://bugs.kde.org/show_bug.cgi?id=436550

--- Comment #2 from David C. Bryant  ---
Sam James (s...@gentoo.org) asked me to post the output from "emerge --info" as
part of this bug report. Here it is.

david@localhost ~ $ emerge --info
Portage 3.0.18 (python 3.8.8-final-0, default/linux/amd64/17.1/desktop/plasma,
gcc-10.2.0, glibc-2.32-r7, 5.10.27-gentoo-x86_64 x86_64)
=
System uname:
Linux-5.10.27-gentoo-x86_64-x86_64-Intel-R-_Core-TM-_i7-9700_CPU_@_3.00GHz-with-glibc2.2.5
KiB Mem:16087792 total,  10926892 free
KiB Swap:7999484 total,   7999484 free
Timestamp of repository gentoo: Mon, 03 May 2021 12:00:01 +
Head commit of repository gentoo: ebccfebd1e9a5999357933ffda08b3e11fce375a
sh bash 5.0_p18
ld GNU ld (Gentoo 2.35.2 p1) 2.35.2
app-shells/bash:  5.0_p18::gentoo
dev-lang/perl:5.30.3::gentoo
dev-lang/python:  2.7.18_p8::gentoo, 3.8.8_p1::gentoo, 3.9.2_p1::gentoo
dev-lang/rust:1.51.0-r2::gentoo
dev-util/cmake:   3.18.5::gentoo
sys-apps/baselayout:  2.7::gentoo
sys-apps/openrc:  0.42.1-r1::gentoo
sys-apps/sandbox: 2.21::gentoo
sys-devel/autoconf:   2.13-r1::gentoo, 2.69-r5::gentoo
sys-devel/automake:   1.13.4-r2::gentoo, 1.16.2-r1::gentoo
sys-devel/binutils:   2.35.2::gentoo
sys-devel/gcc:10.2.0-r5::gentoo
sys-devel/gcc-config: 2.4::gentoo
sys-devel/libtool:2.4.6-r6::gentoo
sys-devel/make:   4.3::gentoo
sys-kernel/linux-headers: 5.10::gentoo (virtual/os-headers)
sys-libs/glibc:   2.32-r7::gentoo
Repositories:

gentoo
location: /var/db/repos/gentoo
sync-type: rsync
sync-uri: rsync://rsync.gentoo.org/gentoo-portage
priority: -1000
sync-rsync-verify-metamanifest: yes
sync-rsync-verify-jobs: 1
sync-rsync-extra-opts: 
sync-rsync-verify-max-age: 24

ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="* -@EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=native -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/lib64/libreoffice/program/sofficerc /usr/share/config
/usr/share/gnupg/qualified.txt"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d
/etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild
/etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d
/etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-march=native -O2 -pipe"
DISTDIR="/var/cache/distfiles"
ENV_UNSET="CARGO_HOME DBUS_SESSION_BUS_ADDRESS DISPLAY GOBIN GOPATH PERL5LIB
PERL5OPT PERLPREFIX PERL_CORE PERL_MB_OPT PERL_MM_OPT XAUTHORITY XDG_CACHE_HOME
XDG_CONFIG_HOME XDG_DATA_HOME XDG_RUNTIME_DIR"
FCFLAGS="-march=native -O2 -pipe"
FEATURES="assume-digests binpkg-docompress binpkg-dostrip binpkg-logs
config-protect-if-modified distlocks ebuild-locks fixlafiles ipc-sandbox
merge-sync multilib-strict network-sandbox news parallel-fetch pid-sandbox
preserve-libs protect-owned qa-unresolved-soname-deps sandbox sfperms strict
unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv
usersandbox usersync xattr"
FFLAGS="-march=native -O2 -pipe"
GENTOO_MIRRORS="https://gentoo.osuosl.org/ ftp://mirrors.rit.edu/gentoo/
https://mirror.sjc02.svwh.net/gentoo/";
LANG="en_US.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
MAKEOPTS="-j9"
PKGDIR="/var/cache/binpkgs"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times
--omit-dir-times --compress --force --whole-file --delete --stats
--human-readable --timeout=180 --exclude=/distfiles --exclude=/local
--exclude=/packages --exclude=/.git"
PORTAGE_TMPDIR="/var/tmp"
USE="X a52 aac acl acpi activities alsa amd64 berkdb bluetooth branding bzip2
cairo cdda cdr cli crypt cups dbus declarative dri dts dvd dvdr elogind emboss
encode exif flac fortran gdbm gif gpm gtk gui iconv icu ipv6 jpeg kde kdesu
kipi kwallet lcms libglvnd libnotify libtirpc mad mng mp3 mp4 mpeg multilib
ncurses nls nptl ogg opengl openmp pam pango pcre pdf pdfimport phonon plasma
png policykit ppds qml qt5 readline scanner sdl seccomp semantic-desktop spell
split-usr ssl startup-notification svg tcpd tiff truetype udev udisks uefi
unicode upower usb vorbis widgets wxwidgets x264 xattr xcb xml xv xvid zlib"
ABI_X86="64" ADA_TARGET="gnat_2018" ALSA_CARDS="ali5451 als4000 atiixp
atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801
hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem
ymfpci" APACHE2_MODULES="authn_core authz_core socache_shmcb unixd actions
alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file
authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user
autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires
ext_filter file_cache filter headers include info log_config logio mem_cache
mime mime_magic negotiation rewrite setenvif speling status unique_id userdir
usertrack vhost_alias" CALLIGRA_FEATURES="karbon 

[Akonadi] [Bug 436550] Sporadic error when moving messages to trash.

2021-05-03 Thread David C. Bryant
https://bugs.kde.org/show_bug.cgi?id=436550

--- Comment #1 from David C. Bryant  ---
I've done some more poking around. The messages that I can't access are
asociated with "dirty" items reported by akonadictl fsck. Here's some terminal
output.

david@localhost ~ $ akonadictl fsck 2>&1|grep ^Found
Found 13 external files.
Found 13 external parts.
Found no unreferenced external files.
Found 0 parts to be moved to external files
Found 0 parts to be moved to database
Found 5 collections without RID.
Found 0 items without RID.
Found 3001 dirty items.

I've posted inquiries in the KDE forum and in some chat rooms. I'll report back
here if I get a response. I did do some spot checking, and the "dirty" items
are definitely causing the problem. Every message that can't be accessed is on
the list of "dirty" items. 

For about a year, akonadictl routinely reported 0 dirty items. Then, a couple
of weeks ago, there were 3,003 of them. I have no idea how or why that
happened. I think I can probably fix it by backing up all my emails and
clearing all the data files out of .local/share/local-mail, then loading all
the data back in there. But that would be a lot of work. I'm hopeful there's an
easier way to clean the dirt out of Akonadi.

-- 
You are receiving this mail because:
You are watching all bug changes.

[Akonadi] [Bug 436550] Sporadic error when moving messages to trash.

2021-05-03 Thread David C. Bryant
https://bugs.kde.org/show_bug.cgi?id=436550

David C. Bryant  changed:

   What|Removed |Added

 CC||davidbry...@gvtc.com

-- 
You are receiving this mail because:
You are watching all bug changes.