Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-48003

Incoming email processing seems relatively expenseive

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.8
    • Fix Version/s: FRONTEND
    • Component/s: Libraries
    • Labels:
    • Affected Branches:
      MOODLE_28_STABLE

      Description

      It struck me that 40 db queries to reject these meessages semed like a lot - should investigate if it scales:

      Scheduled task: Incoming email pickup
      Connecting to mail.moodle.com as posts@moodle.org...
      Connection established.
      Searching for Unseen, Unflagged email in the folder 'INBOX'
      Found 2 messages to parse. Parsing...
      - Parsing message 4
      -- Subject:	im evil
      -- From:	t.j.hunt@open.ac.uk
      -- Recipient:	posts+AAAAAAAAAAIAAAAAAAAAAgAAAAAAAAAK6JGVs7QiTMf/8XOs@moodle.org
      -- Processing the message as user 2 (admin).
      -- Message did not meet validation but is possibly recoverable. Fail code 256
      --> Sending a message to the user to report an verification failure.
      --- Original message retained on mail server and confirmation message sent to user.
      -- Returning to the original user.
      - Parsing message 5
      -- Subject:	Dan is evil
      -- From:	mary@moodle.com
      -- Recipient:	posts+AAAAAAAAAAIAAAAAAAAAAgAAAAAAAAAK6JGVs7QiTMf/8XOs@moodle.org
      -- Processing the message as user 2 (admin).
      -- Message did not meet validation but is possibly recoverable. Fail code 256
      --> Sending a message to the user to report an verification failure.
      --- Original message retained on mail server and confirmation message sent to user.
      -- Returning to the original user.
      ... used 40 dbqueries
      ... used 2.8588440418243 seconds
      Task completed.
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                poltawski Dan Poltawski
                Participants:
                Component watchers:
                Amaia Anabitarte, Bas Brands, Carlos Escobedo, Sara Arjona (@sarjona), Víctor Déniz Falcón
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated: