1159863 - Add a "last_build_name" field to runner stats

Status: RESOLVED FIXED

(Release Engineering :: General, defect)

Description

[Morgan Phillips [:mrrrgn]]

We can find the last build name by scraping twistd logs and surface it in runner's task hook. This will help us understand the behavior of machines before/after running various job types. It will also help us understand the performance of various jobs by machine type.

Comment 1

[Morgan Phillips [:mrrrgn]]

Attachment: last-build-name.diff

Tested via ansible deploy to all tst-linux64 hosts.

Comment 2

[Morgan Phillips [:mrrrgn]]

Attachment: last-build-name.diff

The last patch had a comparison for determining if an array had elements which had a bug (< 0). This has been fixed (changed to < 1).

Comment 3

[Morgan Phillips [:mrrrgn]]

~/projects/UTILS/INFLUXDB_QUERY.sh "select * from runner_tasks where hostname = 'bld-linux64-spot-1000.build.releng.use1.mozilla.com' limit 1"
[
    {
        "name": "runner_tasks",
        "columns": [
            "time",
            "sequence_number",
            "result",
            "hostname",
            "aws_instance_id",
            "task",
            "aws_instance_type",
            "placement/availability_zone",
            "foo",
            "last_build_name",
            "aws_ami_id",
            "platform",
            "max_retries",
            "try_num"
        ],
        "points": [
            [
                1430751221822,
                1000733040001,
                "RUNNING",
                "bld-linux64-spot-1000.build.releng.use1.mozilla.com",
                "i-d44ef202",
                "4-buildbot.py",
                "m3.xlarge",
                "us-east-1c",
                null,
                "Linux mozilla-inbound build",
                "ami-a85358c0",
                "linux2",
                5,
                1
            ]
        ]
    }
]