Stress test failed with Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException`

[chandrams]

Stress test failed with the below error on minikube with Kruize 0.0.20.2_mvp image

Waiting for experiments ... 
2024-02-1515:28:51.860 ERROR [qtp1245065720-40][ExperimentDAOImpl.java(166)]-Exception occurred while adding the partition: Converting `org.hibernate.exception.SQLGrammarException` to JPA `PersistenceException` : JDBC exception executing SQL [CREATE TABLE IF NOT EXISTS kruize_results_20240131 PARTITION OF kruize_results FOR VALUES FROM ('2024-01-31 00:00:00.000') TO ('2024-01-31 23:59:59');]
2024-02-1515:28:54.455 ERROR [qtp1245065720-47][ExperimentDAOImpl.java(166)]-Exception occurred while adding the partition: Converting `org.hibernate.exception.SQLGrammarException` to JPA `PersistenceException` : JDBC exception executing SQL [CREATE TABLE IF NOT EXISTS kruize_results_20240201 PARTITION OF kruize_results FOR VALUES FROM ('2024-02-01 00:00:00.000') TO ('2024-02-01 23:59:59');]
2024-02-1515:28:55.083 ERROR [qtp1245065720-47][ExperimentDAOImpl.java(166)]-Exception occurred while adding the partition: Converting `org.hibernate.exception.SQLGrammarException` to JPA `PersistenceException` : JDBC exception executing SQL [CREATE TABLE IF NOT EXISTS kruize_recommendations_20240201 PARTITION OF kruize_recommendations FOR VALUES FROM ('2024-02-01 00:00:00.000') TO ('2024-02-01 23:59:59');]
2024-02-1515:30:13.261 ERROR [qtp1245065720-45][ExperimentDAOImpl.java(248)]-Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement
2024-02-1515:30:15.355 ERROR [qtp1245065720-45][KruizeErrorHandler.java(76)]-{"message":"Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement","httpcode":400,"documentationLink":"","status":"ERROR"}
2024-02-1515:39:07.860 ERROR [qtp1245065720-53][KruizeErrorHandler.java(68)]-{"message":"Not Found: interval_end_time does not exist: 2024-02-17T23:08:05.867Z","httpcode":400,"documentationLink":"","status":"ERROR"}
2024-02-1515:39:07.864 ERROR [qtp1245065720-53][KruizeErrorHandler.java(68)]-{"message":"Not Found: interval_end_time does not exist: 2024-02-17T23:07:43.067Z","httpcode":400,"documentationLink":"","status":"ERROR"}
2024-02-1515:39:07.966 ERROR [qtp1245065720-53][KruizeErrorHandler.java(68)]-{"message":"Not Found: interval_end_time does not exist: 2024-02-17T23:07:43.864Z","httpcode":400,"documentationLink":"","status":"ERROR"}
2024-02-1515:39:12.263 ERROR [qtp1245065720-53][KruizeErrorHandler.java(68)]-{"message":"Not Found: interval_end_time does not exist: 2024-02-17T23:08:09.259Z","httpcode"

[chandrams]

On openshift cluster, out of 2 runs it failed once with the below error with kruize 0.0.20.2_mvp image :

2024-02-1606:14:59.325 ERROR [qtp1245065720-30][ExperimentDAOImpl.java(248)]-Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement
2024-02-1606:14:59.348 ERROR [qtp1245065720-30][KruizeErrorHandler.java(76)]-{"message":"Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement","httpcode":400,"documentationLink":"","status":"ERROR"}
2024-02-1606:14:59.367 ERROR [qtp1245065720-36][ExperimentDAOImpl.java(248)]-Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement
2024-02-1606:14:59.386 ERROR [qtp1245065720-36][KruizeErrorHandler.java(76)]-{"message":"Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement","httpcode":400,"documentationLink":"","status":"ERROR"}
2024-02-1606:14:59.580 ERROR [qtp1245065720-35][ExperimentDAOImpl.java(248)]-Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement
2024-02-1606:14:59.609 ERROR [qtp1245065720-35][KruizeErrorHandler.java(76)]-{"message":"Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement","httpcode":400,"documentationLink":"","status":"ERROR"}
2024-02-1606:14:59.937 ERROR [qtp1245065720-36][ExperimentDAOImpl.java(248)]-Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement

[chandrams]

Stress test failed intermittently on openshift with the below error with 0.0.21_mvp image: Tested with 50 users

2024-04-2510:00:01.002 ERROR [qtp62343880-42][ExperimentDAOImpl.java(244)]-Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement
2024-04-2510:00:01.124 ERROR [qtp62343880-42][UpdateResults.java(123)]-updateResults API request payload for requestID 1213 failed
2024-04-2510:00:01.128 ERROR [qtp62343880-42][KruizeErrorHandler.java(76)]-{"message":"Converting `org.hibernate.exception.ConstraintViolationException` to JPA `PersistenceException` : could not execute statement","httpcode":400,"documentationLink":"","status":"ERROR"}