*** 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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
