1389118 - Please update Windows stylo job priorities

Status: RESOLVED FIXED

(Tree Management :: Treeherder: Infrastructure, enhancement, P1)

Description

[Armen [:armenzg]]

Please set the priority of these jobs to 5.

JobPriority.objects.filter(platform='windows7-32-stylo', priority=1)

Thank you!

Same request as with bug 1386668.

Comment 1

[Ed Morley [:emorley]]

So something like this?

heroku run --app treeherder-prod -- ./manage.py shell -c 'from treeherder.seta.models import JobPriority; JobPriority.objects.filter(platform="windows7-32-stylo", priority=1).update(priority=1)'

Or alternatively if we just use SQL:

UPDATE treeherder.seta_jobpriority SET priority = 5 WHERE platform = 'windows7-32-stylo' and priority = 1;

Comment 2

[Armen [:armenzg]]

Correct. The priority has to be 5.
> priority=1).update(priority=5)'

Thank you so much!

Comment 3

[Ed Morley [:emorley]]

Done :-)

treeherder $ thp run -- ./manage.py shell -c 'from treeherder.seta.models import JobPriority; JobPr iority.objects.filter(platform="windows7-32-stylo", priority=1).update(priority=5)'
Running ./manage.py shell -c "from treeherder.seta.models import JobPriority; JobPriority.objects.filter(platform=\"windows7-32-stylo\", priority=1).update(priority=5)" on treeherder-prod... up, run.3460 (Standard-1X)
/tmp/memcachier-stunnel.conf
treeherder $

Comment 4

[Armen [:armenzg]]

Thank you Ed!

Comment 5

[Armen [:armenzg]]

*sigh*

My apologies. I forgot about the expiration date needing to be set to null as well as win10 jobs.


* windows7-32-stylo
** set expiration date to null
* windows10-64-stylo
** set expiration date to null
** set priority to 5

jmaher and I will be talking next week on how to reduce this unnecessary maintenance and disruptions.

Thanks in advance and my apologies for the distraction.

Comment 6

[Armen [:armenzg]]

I've confirmed that the stylo jobs now show up in here:
https://treeherder.mozilla.org/api/project/autoland/seta/job-priorities/?build_system_type=taskcluster&priority=5


>>> JobPriority.objects.filter(platform="windows10-64-stylo", priority=1).update(priority=5)
83L
>>> JobPriority.objects.filter(platform="windows10-64-stylo", expiration_date__isnull=False).update(expiration_date=None)
84L
>>> JobPriority.objects.filter(platform="windows10-64-stylo", expiration_date__isnull=False)
<QuerySet []>
>>> JobPriority.objects.filter(platform="windows7-32-stylo", expiration_date__isnull=False).update(expiration_date=None)
84L
>>> JobPriority.objects.filter(platform="windows7-32-stylo", expiration_date__isnull=False)
<QuerySet []>