-
Fabien Viale authored
- discontinue support of pa.scheduler.job.removeFromDataBase=false, which implied executing joined tables queries constantly (decreases performance and disallow some indexing) - add 3 indexes in JobData (submit_time, scheduled_time_for_removal, and job_id_status : composite index used to optimize scheduler portal default list jobs query) - getTaskCounts : avoid joined table query by considering only task statuses. - getFinishedTaskCount : fix incomplete list of finished task statuses - getPendingTaskCount : add in-error status (similar to pause) - adapt db tests - add owner column in TaskData to avoid join - initialize TaskData.owner using JobData.owner when recovering an existing database - TaskData : replace task.jobData.id by task.id.jobId to avoid implicit cross join - TaskDBUtils : supress removeTime usage and replace jobData.owner by taskData.owner - BaseServiceTest : add SQL debug info - MockSchedulingInfrastructure : print unexpected exceptions
4acab84c