topic Major problem with smtp and reindexing in Alfresco Archive

Major problem with smtp and reindexing

ebogaard — Fri, 07 Jan 2011 08:16:24 GMT

Yesterday Alfresco crashed on us. When investigating why, the logfile appeared to be enormous: >10GB. Checking the contents revealed that Alfresco was trying to send an email to a non-existing user (user was removed from the AD):10:39:34,686 User:eripo ERROR [action.executer.MailActionExecuter] F

Re: Major problem with smtp and reindexing

muralie39 — Wed, 12 Jan 2011 09:30:59 GMT

catch (Throwable e)
      {
          // don't stop the action but let admins know email is not getting sent
logger.error("Failed to send email to " + (String JavaDoc)ruleAction.getParameterValue(PARAM_TO), e);
      }

Re: Major problem with smtp and reindexing

ebogaard — Sat, 15 Jan 2011 15:37:09 GMT

Update: Several days ago I posted a bug in Jira (https://issues.alfresco.com/jira/browse/ALF-6550) and Alfresco is going to fix the SMTP bug (where the bug is: "no limit on number of retries") in 3.4d and 3.4.1. So that shouldn't be a problem anymore.

But because of this bug, I'm having a bigger problem. The database has grown from ~200MB to almost 500MB. The number of transactions has gone up from about 150K to 3,6M, increasing the time to reindex from ~15 minutes to 38 hours!
Anybody knows a way to safely (!) clean the databse of unnecessary transactions? I suspect the enormous number of retries on sending the mail (which was triggered by a rule in a Space) has impacted the DB, so if anyone knows where to find these transactions and how to clean it up, it would be greatly appreciated.

Re: Major problem with smtp and reindexing

ebogaard — Wed, 26 Jan 2011 11:01:26 GMT

Last week, the automatic cleaning jobs reduced te db size to ~360MB (1,9M transactions), which is a good thing. Hoped the cleaning jobs this week would reduce the size and useless transactions even more, but no cigar. Just the ususal few MB's. Anyone a suggestion?