Uploaded image for project: 'OpenShift Pipelines'
  1. OpenShift Pipelines
  2. SRVKP-6642

Results broken after cluster upgrade from 4.15 to 4.16

XMLWordPrintable

    • False
    • None
    • False

      Description of problem:

      Results from operator 1.15.2 don't work after cluster is upgraded from 4.15 to 4.16

      Workaround

      Prerequisites (if any, like setup, operators/versions):

      Pipelines 1.15.2
      OpenShift 4.15.29 -> 4.16.17

      Steps to Reproduce

       # install OpenShift 4.15.29

      1. install Pipelines 1.15.2
      2. update cluster to 4.16.17
      3. create a taskrun/pipelinerun and check that it has Results annotations and logs are stored
      4. alternatively, run release-tests using "gauge run --log-level=debug --verbose --tags e2e specs/results/"

       

      Actual results:

      Test fails, tekton-results-api pod shows a lot of errors like this

      2024/10/17 19:06:14 /go/src/github.com/tektoncd/results/pkg/api/server/v1alpha2/results.go:208 ERROR: relation "results" does not exist (SQLSTATE 42P01)
[0.944ms] [rows:0] SELECT * FROM "results" WHERE "results"."parent" = 'releasetest-ww8sk' AND "results"."name" = '88b29464-966a-4cd7-8dfa-fc61816a3c68' ORDER BY "results"."id" LIMIT 1
{"level":"error","ts":1729191974.7472188,"caller":"zap/options.go:212","msg":"finished unary call with code Unknown","grpc.auth_disabled":true,"grpc.start_time":"2024-10-17T19:06:14Z","grpc.request.deadline":"2024-10-17T19:06:44Z","system":"grpc","span.kind":"server","grpc.service":"tekton.results.v1alpha2.Results","grpc.method":"GetResult","peer.address":"10.128.2.21:33770","grpc.user":"system:serviceaccount:openshift-pipelines:tekton-results-watcher","grpc.issuer":"https://kubernetes.default.svc","error":"ERROR: relation \"results\" does not exist (SQLSTATE 42P01)","grpc.code":"Unknown","grpc.time_duration_in_ms":1,"stacktrace":"github.com/grpc-ecosystem/go-grpc-middleware/logging/zap.DefaultMessageProducer\n\t/go/src/github.com/tektoncd/results/vendor/github.com/grpc-ecosystem/go-grpc-middleware/logging/zap/options.go:212\ngithub.com/grpc-ecosystem/go-grpc-middleware/logging/zap.UnaryServerInterceptor.func1\n\t/go/src/github.com/tektoncd/results/vendor/github.com/grpc-ecosystem/go-grpc-middleware/loggin...

      tekton-results-watcher pod shows errors like this

      {"level":"error","time":"2024-10-17T19:05:30.678Z","logger":"watcher","caller":"controller/controller.go:566","msg":"Reconcile error","commit":"067091e","knative.dev/traceid":"04f18fbb-e4b5-440f-91b2-bf8fc99fdd96","knative.dev/key":"releasetest-f6vhd/results-task","duration":"1.749166ms","error":"error upserting record: rpc error: code = Unknown desc = GetResult(releasetest-f6vhd/results/3b94a2d0-8b0a-4861-a456-3630b8df9d2b): rpc error: code = Unknown desc = ERROR: relation \"results\" does not exist (SQLSTATE 42P01)","stacktrace":"knative.dev/pkg/controller.(*Impl).handleErr\n\t/go/src/github.com/tektoncd/results/vendor/knative.dev/pkg/controller/controller.go:566\nknative.dev/pkg/controller.(*Impl).processNextWorkItem\n\t/go/src/github.com/tektoncd/results/vendor/knative.dev/pkg/controller/controller.go:543\nknative.dev/pkg/controller.(*Impl).RunContext.func3\n\t/go/src/github.com/tektoncd/results/vendor/knative.dev/pkg/controller/controller.go:491"}

      Expected results:

      Taskruns/pipelineruns have Results annotations and logs are successfully stored

      Reproducibility (Always/Intermittent/Only Once):

      Always (reproduced twice so far)

      Acceptance criteria: 

       

      Definition of Done:

      Build Details:

      Additional info (Such as Logs, Screenshots, etc):

       

       *

              Unassigned Unassigned
              ppitonak Pavol Pitoňák
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: