Hi all, I didn't hear back from anyone as to why this should be the case, so have filed it as a bug:
https://opencast.jira.com/browse/MH-9031 Also is there any reason why completed jobs could not be removed manually from the table? e.g. delete from job where date_completed is not null; delete from job_arguments where id not in (select id from job); Regards Stephen Stephen Marquard, Learning Technologies Co-ordinator Centre for Educational Technology, University of Cape Town http://www.cet.uct.ac.za Email/IM/XMPP: [email protected] Phone: +27-21-650-5037 Cell: +27-83-500-5290 >>> Stephen Marquard <[email protected]> 8/13/2012 9:12 AM >>> Hi all, In our production db (running for about 9 months), the job and job_arguments tables seem to grow continuously: mysql> select count(*) from job; +----------+ | count(*) | +----------+ | 62371 | +----------+ 1 row in set (0.16 sec) mysql> select count(*) from job_arguments; +----------+ | count(*) | +----------+ | 109887 | +----------+ 1 row in set (2.87 sec) Should some maintenance task be taking clear of cleaning out old records? Should we run SQL daily to delete old records? Regards Stephen Stephen Marquard, Learning Technologies Co-ordinator Centre for Educational Technology, University of Cape Town http://www.cet.uct.ac.za Email/IM/XMPP: [email protected] Phone: +27-21-650-5037 Cell: +27-83-500-5290 ### UNIVERSITY OF CAPE TOWN This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity. ### _______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________ ### UNIVERSITY OF CAPE TOWN This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity. ### _______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
