Task #10089
closed
- After a small brainstorming it appears that ...
- Caution when using trigger, mainly in case of foreign key.
- I don't want provide the feature at application level (due to status of current code)
- The solution must be 'simple'
- We decided to limit to jrequests table, using a trigger
Trigger will be fired when request is done (status 140, 150 or 160 and tries >=3)
archived_jrequests will be the same jrequest + a field to store the activation_time from jqueue.
(Obviously php monitoring tool should be adapted to archived_jrequests table)
- Status changed from New to Closed
Done.
A new table 'archived_jrequests' has been created + a trigger wired to jrequests.
- Priority changed from Normal to High
Also available in: Atom
PDF
Updated by