Submitter: Robert Lyon (robe...@catalyst.net.nz)
Author: Cecilia Vela Gurovic <cecili...@catalyst.net.nz>
Date: Thu Mar 8 09:14:09 2018 +1300
Bug 1731067: drop elasticsearch triggers for some cron jobs
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!
Some cron jobs cause elasticsearch queue to populate when it doesn't
Status in Mahara:
We only record certain information in elasticsearch but we queue
things even if unrecorded information changes because we use
triggers/procedures on the tables
Example, when the recalculate_quota cron runs it works out what the
user quota should be and then updates all the users in usr table that
need fixing. This table has a trigger on it so all users needing
updating are added to queue to be indexed.
On a big site that can mean thousands of users being indexed. But we
don't record quota in elasticsearch so we don't need to index this
It would be good to be able to drop/add elasticsearch triggers during
cron process for certain cron jobs like we do in upgrade.php script
... do cron job ...
To manage notifications about this bug go to:
Mailing list: https://launchpad.net/~mahara-contributors
Post to : firstname.lastname@example.org
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp