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

Excessive Calendar Event Creation During Google Calendar Import

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.1.12
    • Calendar, Performance
    • None
    • MOODLE_401_STABLE

      We experienced performance issues in Moodle due to excessive database activity caused by a user's Google Calendar import. The logs indicate that during each import, Moodle creates a large number of calendar event records within a very short period, leading to high memory usage and "too many database connections" errors.

      Steps to Reproduce:

      1. Set up a Google Calendar import in Moodle.
      2. Schedule it to sync hourly.
      3. Monitor the database activity during import.
      4. Observe if multiple event records are created excessively.

      Expected Behavior:
      Moodle should efficiently sync events without overloading the database.

      Actual Behavior:
      The import process creates a high number of event records rapidly, consuming system resources and leading to performance degradation.

      Temporary Workaround:
      We have reduced the calendar sync frequency to once per day for the affected user.

            Unassigned Unassigned
            rkaur Rajmale Kaur
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.