mahara-contributors team mailing list archive

[Kristina Hoeppner <1778889@xxxxxxxxxxxxxxxxxx>]

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

See https://reviews.mahara.org/#/c/9401/ for the work in progress.

** This bug has been marked a duplicate of bug 1785985
   Remove triggers from Mahara database

-- 
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/1778889

Title:
  Dropping and re-adding elasticsearch triggers will prevent other
  triggers from executing if some action is made during this period.

Status in Mahara:
  Confirmed

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 other triggers cannot be executed during the period
  of disabling triggers and re-enabling them.

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

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