-
Type:
Bug
-
Resolution: Fixed
-
Priority:
High
-
Component/s: Issue - Backend
-
23
-
Severity 3 - Minor
-
17
Issue Summary
Unable to change the project Key in a project that has a huge number of tickets, it is timing out.
Steps to Reproduce
- Create a Project with more than 40k tickets (as seen in customer environment).
- Change the Project Key.
Expected Results
Project Key changes successfully.
Actual Results
Results in a 500 Error.
The below exception is thrown in the xxxxxxx.log file:
message: [Limited to 100 per PT1M] Encountered exception while executing OLD code behind Rollout Flag [monolith.crud.take.issue.locks.in.order]. Exception will be propagated up the stack. err.msg: Caught PSQLException for update "public"."jiraissue" "ISSUE" set "pkey" = ? where "ISSUE"."project" = ? err.stack: com.querydsl.core.QueryException: Caught PSQLException for update "public"."jiraissue" "ISSUE" set "pkey" = ? where "ISSUE"."project" = ? at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50) at com.querydsl.sql.Configuration.translate(Configuration.java:508) at com.querydsl.sql.dml.AbstractSQLUpdateClause.execute(AbstractSQLUpdateClause.java:221) .... Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to statement timeout at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
Workaround
Currently, there is no known workaround for this behavior. A workaround will be added here when available
