mahara-contributors team mailing list archive

[Kristina Hoeppner <1778888@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1778889 ***
    https://bugs.launchpad.net/bugs/1778889

** This bug has been marked a duplicate of bug 1778889
   Dropping and re-adding elasticsearch triggers will prevent other triggers from executing if some action is made during this period.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1778888

Title:
  Dropping and re-adding elasticsearch triggers requires SUPER privilege
  to work.

Status in Mahara:
  New

Bug description:
  On big sites there is an issue regarding the time it takes cron to run
  due to the use of triggers/procedures on the tables when processing
  information for elasticsearch.

  A solution was developed to drop triggers for this portion of the cron
  run and then re-enable triggers.

  The issue is that it requires SUPER privileges to do this.

  Relevant Bugs: 
  https://bugs.launchpad.net/mahara/+bug/1731067?comments=all
  https://bugs.launchpad.net/mahara/+bug/1778889

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1778888/+subscriptions