-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
Component/s: Integrations - Confluence Questions
-
None
-
1
-
Severity 3 - Minor
Issue Summary
Purging a Questions for Confluence content would fail if the question has answers that have been either upvoted or downvoted.
Steps to Reproduce
- Delete the question.
- Then purge the content from trash.
Expected Results
Contents can be purged.
Actual Results
Purging would fail with FK constraint error.
The below exception is thrown in the xxxxxxx.log file:
java.sql.BatchUpdateException: Batch entry 1 <unknown> was aborted: ERROR: update or delete on table "content" violates foreign key constraint "fkpwgl85a266iie5i0adu8bdbcv" on table "usercontent_relation" Call getNextException to see other errors in the batch. org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2402) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:574) org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:896) org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:919) org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1685) com.atlassian.connpool.impl.util.StatementAdapter.executeBatch(StatementAdapter.java:145) org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:125)
Workaround
Reach out to support.
- mentioned in
-
Page Loading...