|Pathologically Eclectic Rubbish Lister|
Re^3: Message Inbox: Retain Deleted messages longer (more)by tye (Sage)
|on Feb 08, 2014 at 04:34 UTC||Need Help??|
++jdporter for the sarcasm. And thanks for the prod that quite a while has passed but nothing else has happened on this thread.
I quickly gave the one answer that I had handy at the time. After posting, it eventually occurred to me what some of the other answers likely were. But I wasn't where I could post when any of these potential answers finally came to me.
And, of course, I'm not the only person who has knowledge of or access to the code in question. It was my hope that somebody else (maybe even jdporter) might find the motivation to find (or reveal) some of the answers. And I expected I'd have to not completely answer for quite a while if there was going to be a chance of somebody jumping in.
But, as often happens, me volunteering to do some small thing leads to little credit for what I did and more blame for what I didn't volunteer to do. I doubt jdporter sent a personal message to Corion or demerphq or even chromatic "thank"ing them for not answering any of his question.
Part of the reason I do so relatively little at PerlMonks now is, in part, due to trying to avoid that much more blame for what I don't manage to do (and other reasons). But I actually manage to still hang out here and rarely do some tiny bit of maintenance or administration, and I still get the lion's share of the blame (it seems to me). I don't mind getting blamed for doing something badly. But getting blamed for not doing enough simply because almost nobody else has stuck around as long or nobody else did anything on that topic... is discouraging. Oh well.
There are people who do more maintenance/administration at PerlMonks than I do. I'll let them step forward if/when they decide they'd like to start getting blamed more. ;)
One of the nightly cron jobs runs a query like:
and then deletes rows where folder has reached -3 (roughly).
So I think it is actually between 2 and 3 days before a "deleted" message is irretrievable, depending on the time of day when it is "deleted".
You can find -3 hard-coded quite a few places in the other bits of code that deal with "message folders". So we could lengthen the grace period by updating all of those (as well as, I think, just the one instance of "-3" in one cron job).