New issue
Advanced search Search tips

Issue 920747 link

Starred by 1 user

Issue metadata

Status: Fixed
Owner:
Closed: Jan 11
Cc:
Components:
EstimatedDays: ----
NextAction: ----
OS: ----
Pri: 3
Type: Bug



Sign in to add a comment

BuildBucket BigQuery has bad step start and end times for old builds

Project Member Reported by garymm@google.com, Jan 10

Issue description

When I run this query, the first few records returned have a build_step_duration of 0: 

SELECT FORMAT("https://luci-milo.appspot.com/p/%s/builders/luci.fuchsia.%s/%s/b%d", builder.project, builder.bucket, builder.builder, id) AS build_url,
       builder.builder AS builder_name,
       FORMAT_TIMESTAMP("%F %X", create_time) AS create_time,
       TIMESTAMP_DIFF(step.end_time, step.start_time, SECOND) AS build_step_duration,
       step.start_time, step.end_time
FROM `cr-buildbucket.fuchsia.completed_builds_BETA` b
  CROSS JOIN UNNEST(b.steps) AS step
WHERE builder.bucket = "ci" AND
      step.name = "build" AND step.status = "SUCCESS"
      AND builder.builder = "garnet-host-linux"
ORDER BY create_Time


However, when i click on the URL, I see the step named "build" took much longer than 1 second.

This seems to be fixed for more recent builds.

Example of build with bad data:
https://luci-milo.appspot.com/p/fuchsia/builders/luci.fuchsia.ci/garnet-host-linux/b8935390485444994656

Example of build with good data:
https://luci-milo.appspot.com/p/fuchsia/builders/luci.fuchsia.ci/garnet-host-linux/b8935387024340448512


 
Status: Fixed (was: Unconfirmed)
this was fixed by 
https://chromium-review.googlesource.com/c/infra/infra/+/1226114/
in Sept

Sign in to add a comment