Corrupt database caused by server crash without saving data properly about mail HOT 6 OPEN

That might be the 1 second storage update. @Bastrabun noticed an equivalent bug in #122 , with some different initial conditions. Thanks for giving a lot of information. I consider both issue as not the same, however my upcoming fix will probably fix both.

from mail.

Maybe I could spend some time studying my database and separating what information could be relevant or not

someone else did the work for you:

# extract the json-value for the mail-entry in the modstorage
sqlite3 mod_storage.sqlite "select value from entries where modname = 'mail' and key = cast('mail/BuckarooBanzai' as blob);"

# (optional, but looks prettier) parse the output with `jq`
sqlite3 mod_storage.sqlite "select value from entries where modname = 'mail' and key = cast('mail/BuckarooBanzai' as blob);" | jq

from mail.

nice! how can I do for postgresql?

right, i forgot this is possible now, here you go:

select convert_from(value, 'utf-8') from mod_storage where modname = 'mail' and key = 'mail/BuckarooBanzai';

from mail.

I suspect this is because the database (pgsql mod storage) is corrupt

somehow i doubt that 🤔 can you extract the relevant data from the database and post it here if possible?

from mail.

can you extract the relevant data from the database and post it here if possible?

I could spend some time studying my database and separating what information could be relevant or not, I would have to learn to do that and how this mod stores the information in the database to know where and how to locate it.

I think it would take a lot of time

from mail.

sqlite3 mod_storage.sqlite "select value from entries where modname = 'mail' and key = cast('mail/BuckarooBanzai' as blob);"

nice! how can I do for postgresql?

from mail.