TOFU db corruption detected

[Daniel Villarreal]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 08/05/17 11:30, Teemu Likonen wrote:
> MFPA [2017-08-05 15:56:02+01] wrote:
> 
>> ... "rebuild" the TOFU database to get rid of the corruption?
> 
> ... tofu [db] is a regular Sqlite [db] file. So you can do:
> 
> $ sqlite3 ~/.gnupg/tofu.db
> 
> and ... SQL commands. Interesting SQL command could be "vacuum". 
> [Backup] tofu.db file first. Then start Sqlite ...
> 
> sqlite> vacuum; https://www.sqlite.org/lang_vacuum.html



Thanks to Jason L. Froebe...

"... run sqlite3 with vacuum, reindex and analyze on each of the
*.sqlite databases."

I use this script with sqlite2 also.

http://froebe.net/blog/2013/01/27/optimizing-the-firefox-sqlite-database
s/

and then for all my different Firefox profiles, I change
	for profile in *.default; do
to
	# for profile in *; do

- -- 
Daniel Villarreal
http://www.youcanlinux.org
youcanlinux at gmail.com
PGP key 2F6E 0DC3 85E2 5EC0 DA03  3F5B F251 8938 A83E 7B49
https://pgp.mit.edu/pks/lookup?op=get&search=0xF2518938A83E7B49
-----BEGIN PGP SIGNATURE-----

iQEcBAEBCAAGBQJZhmOBAAoJEPJRiTioPntJxy4H/1SQBA9SyyBXc95XB75xKJGE
7cz1kHjIjplTOn2z3WLK9z41/qZuQVdo8nfefUtowLXegEozgK5kt00Qfmd8yf85
qN53eea9dZfZLe6dYZMtRlgRPY+kkuJoZY4uMylzHG6i8DRjrUU+nTlYy3BxYvFH
pOZHzmeoIdFYrRIcYaJKQTzjf6eZJYSEEOKdxf7bTAtDs6h+kg7t8Bm2NDxtBg+/
+K2Dxg/Zq7PulEcxPeBinU4eWKXf0Xkmdm0yfBpKlE5y6y/c+px9EVwGpE/pr/l/
nFjnK5vknc+/MAqzbnrkEiAY0/y3QnJRVoS1B/NSSBL/I/UnL+Bi0dfL1XVv+pg=
=QfmK
-----END PGP SIGNATURE-----