Missing items in "Similar launches" secrtion in UI after uprgade to 24.1.0

[ifurs]

Missing items in "Similar launches" secrtion in UI after uprgade to 24.1.0

[ifurs]

For issue with service-api trying connect to OpenSearch is my bad, cause there is doubleEntry enabled and need to set env vars:

• RP_ELASTICSEARCH_USERNAME
• RP_ELASTICSEARCH_PASSWORD
  That is automaticly added to service jobs, but not api.

Also service-api trying connect to binded dns for service-jobs, using var

• RP_JOBS_BASEURL
  The problem is that this var has almost static value:

{{ ternary "https" "http" .Values.k8s.networking.ssl }}://{{ include "reportportal.fullname" . }}-jobs{{ printf ".%s.svc.cluster.local" .Release.Namespace }}:8686/jobs

But most production clusters use other domain than .svc.cluster.local
That could be fixed on Chart level, I will send PR.

After changes I got new errors from service-api:

2024-04-08 09:53:17.172 ERROR 1 --- [a.Spring.bean-9] c.e.t.r.w.rabbit.AsyncReportingListener  : exception : javax.persistence.PersistenceException, message : org.hibernate.exception.ConstraintViolationException: could not execute statement,  cause : could not execute statement
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "test_item_uuid_key"
2024-04-08 09:54:17.490 ERROR 1 --- [a.Spring.bean-9] c.e.t.r.w.rabbit.AsyncReportingListener  : Dropping on maximum retry limit request of type = START_TEST, for target id = jfud7re-5054-fvfm54-aaa4-38108cb11bc6
2024-04-08 10:02:50.612 ERROR 1 --- [nio-8585-exec-3] o.s.t.i.TransactionInterceptor           : Application exception overridden by rollback exception
2024-04-08 10:02:50.615 ERROR 1 --- [nio-8585-exec-3] c.e.t.r.c.e.rest.RestExceptionHandler    : Handled error:
2024-04-08 10:02:50.616 ERROR 1 --- [nio-8585-exec-3] .t.r.c.e.r.ReportPortalExceptionResolver : ReportPortalExceptionResolver > Could not roll back JPA transaction; nested exception is org.hibernate.TransactionException: Unable to rollback against JDBC Connection
2024-04-08 10:02:50.617 ERROR 1 --- [nio-8585-exec-3] c.e.t.r.c.e.rest.Default

and

2024-04-08 10:02:50.612 ERROR 1 --- [nio-8585-exec-3] o.s.t.i.TransactionInterceptor           : Application exception overridden by rollback exception
2024-04-08 10:02:50.615 ERROR 1 --- [nio-8585-exec-3] c.e.t.r.c.e.rest.RestExceptionHandler    : Handled error:
2024-04-08 10:02:50.616 ERROR 1 --- [nio-8585-exec-3] .t.r.c.e.r.ReportPortalExceptionResolver : ReportPortalExceptionResolver > Could not roll back JPA transaction; nested exception is org.hibernate.TransactionException: Unable to rollback against JDBC Connection
2024-04-08 10:02:50.617 ERROR 1 --- [nio-8585-exec-3] c.e.t.r.c.e.rest.DefaultErrorResolver    : Could not roll back JPA transaction; nested exception is org.hibernate.TransactionException: Unable to rollback against JDBC Connection

For service-jobs error remaining the same

[ifurs]

I've added PR that would fix issues with env variables, still problem need attention

[ifurs]

After recreating job migration, logs from service-api is normal now.

From my investigation, after adding env vars to service-api regards doubleEntry feature, it finally has access to OpenSearch with credentials, so after that move need to run migration job

[ifurs]

Waiting for review reportportal/kubernetes#375

[alena-babrova]

Hello @ifurs,

If I understood correctly, we are waiting for the PR updates according to the comments there in order to apply your changes.