Uploaded image for project: 'OCP Technical Release Team'
  1. OCP Technical Release Team
  2. TRT-2049

operator-watch-requests generating empty autodl results

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • None
    • None
    • False
    • None
    • False

      Noted in slack thread the watch counts dashboard stopped showing data for 4.19.

      I see data on 2/9 but not 2/10

      SELECT * FROM `openshift-ci-data-analysis.ci_data_autodl.operator_watch_requests` AS Watches
      
      INNER JOIN openshift-gce-devel.ci_analysis_us.jobs AS JobRuns ON JobRuns.prowjob_build_id = Watches.JobRunName
      INNER JOIN openshift-ci-data-analysis.ci_data.JobsWithVariants AS Jobs on Jobs.JobName = JobRuns.prowjob_job_name
      
      WHERE Platform = "aws" 
      AND Release = "4.19"
      AND TIMESTAMP_TRUNC(PartitionTime, DAY) = TIMESTAMP("2025-02-10") LIMIT 1000
      

      Grafana view

              rh-ee-fbabcock Forrest Babcock
              rh-ee-fbabcock Forrest Babcock
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: