Details
-
Bug
-
Resolution: Cannot Reproduce
-
Blocker
-
None
-
Pipelines 1.14.3
-
None
-
False
-
None
-
False
Description
Description of problem:
Results are broken even though neither TektonConfig nor installer set is reporting any issues.
Cluster: https://console-openshift-console.apps.cicd.ospqa.com
Prerequisites (if any, like setup, operators/versions):
- OpenShift Pipelines 1.14.3
- OpenShift cluster updated from 4.14.18 to 4.14.20
Steps to Reproduce
# install OpenShift 4.14 and install OpenShift Pipelines
- update to latest bugfix release of OpenShift
Actual results:
- New pipeline runs don't have Results annotations.
- There is huge amount of following errors in tekton-results-api pod
{"level":"error","ts":1713519708.8786728,"caller":"zap/options.go:212","msg":"finished unary call with code Unknown","grpc.auth_disabled":true,"grpc.start_time":"2024-04-19T09:41:48Z","system":"grpc","span.kind":"server","grpc.service":"tekton.results.v1alpha2.Results","grpc.method":"GetResult","peer.address":"10.129.2.39:53582","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/logging/zap/server_interceptors.go:39\ngithub.com/grpc-ecosystem/go-grpc-middleware.ChainUnaryServer.func1.1.1\n\t/go/src/github.com/tektoncd/results/vendor/github.com/grpc-ecosystem/go-grpc-middleware/chain.go:25\ngithub.com/grpc-ecosystem/go-grpc-middleware/tags.UnaryServerInterceptor.func1\n\t/go/src/github.com/tektoncd/results/vendor/github.com/grpc-ecosystem/go-grpc-middleware/tags/interceptors.go:23\ngithub.com/grpc-ecosystem/go-grpc-middleware.ChainUnaryServer.func1.1.1\n\t/go/src/github.com/tektoncd/results/vendor/github.com/grpc-ecosystem/go-grpc-middleware/chain.go:25\ngithub.com/grpc-ecosystem/go-grpc-middleware.ChainUnaryServer.func1\n\t/go/src/github.com/tektoncd/results/vendor/github.com/grpc-ecosystem/go-grpc-middleware/chain.go:34\ngithub.com/tektoncd/results/proto/v1alpha2/results_go_proto._Results_GetResult_Handler\n\t/go/src/github.com/tektoncd/results/proto/v1alpha2/results_go_proto/api_grpc.pb.go:294\ngoogle.golang.org/grpc.(*Server).processUnaryRPC\n\t/go/src/github.com/tektoncd/results/vendor/google.golang.org/grpc/server.go:1372\ngoogle.golang.org/grpc.(*Server).handleStream\n\t/go/src/github.com/tektoncd/results/vendor/google.golang.org/grpc/server.go:1783\ngoogle.golang.org/grpc.(*Server).serveStreams.func2.1\n\t/go/src/github.com/tektoncd/results/vendor/google.golang.org/grpc/server.go:1016"}
Similar error appears when I try to get logs of older pipeline run
opc results logs get pipelines-ci/results/8dac54ac-a2fc-42b9-a730-89e7cb34bce9/logs/e0d773f8-3ec6-3f24-9693-d2b6a03eded6 | jq -r '.data' | base64 -d Error: rpc error: code = Unknown desc = ERROR: relation "records" does not exist (SQLSTATE 42P01) parse error: Invalid numeric literal at line 1, column 4
Expected results:
New pipeline runs have results annotations
Reproducibility (Always/Intermittent/Only Once):
Unknown
