com.atlassian.stash.repository.RepositoryDeletionCanceledException: Repository deletion was canceled.

Atlassian JIRA | Bryan Turner | 3 years ago
  1. 0

    [STASH-4518] SQL Server: Deleting repositories with many comments fails - Atlassian JIRA

    atlassian.com | 2 years ago
    com.atlassian.stash.repository.RepositoryDeletionCanceledException: Repository deletion was canceled.
  2. 0

    Deleting repositories with a large number of comments _can_ fail on SQL Server with an error like: {noformat} 2014-03-14 16:06:03,744 DEBUG [http-bio-7990-exec-10634] jdoe 966x1670694x3 2tmzqw1 54.240.197.225,127.0.0.1 "DELETE /projects/KEY/repos/slug HTTP/1.1" c.a.s.r.e.ServiceExceptionMapper Mapping ServiceException to REST response 400 com.atlassian.stash.repository.RepositoryDeletionCanceledException: Repository deletion was canceled. at com.atlassian.stash.internal.repository.RepositoryServiceImpl.fireRepositoryDeletionRequested(RepositoryServiceImpl.java:562) ~[stash-service-impl-2.5.0.jar:na] at com.atlassian.stash.internal.repository.RepositoryServiceImpl.access$000(RepositoryServiceImpl.java:56) ~[stash-service-impl-2.5.0.jar:na] at com.atlassian.stash.internal.repository.RepositoryServiceImpl$1.doInTransaction(RepositoryServiceImpl.java:168) ~[stash-service-impl-2.5.0.jar:na] at com.atlassian.stash.internal.repository.RepositoryServiceImpl$1.doInTransaction(RepositoryServiceImpl.java:164) ~[stash-service-impl-2.5.0.jar:na] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131) ~[spring-tx-3.2.2.RELEASE.jar:3.2.2.RELEASE] at com.atlassian.stash.internal.repository.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:164) ~[stash-service-impl-2.5.0.jar:na] at sun.reflect.GeneratedMethodAccessor21510.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_27] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "fk_sta_comment_parent". The conflict occurred in database "stashlhr10", table "dbo.sta_comment", column 'parent_id'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc-4.0.2206.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133) ~[hibernate-core-4.2.1.Final.jar:4.2.1.Final] ... 308 common frames omitted {noformat} This is unique to SQL Server, due to how {{ON DELETE CASCADE}} clauses are processed for foreign keys, and cannot affect any other database.

    Atlassian JIRA | 3 years ago | Bryan Turner
    com.atlassian.stash.repository.RepositoryDeletionCanceledException: Repository deletion was canceled.
  3. 0

    Deleting repositories with a large number of comments _can_ fail on SQL Server with an error like: {noformat} 2014-03-14 16:06:03,744 DEBUG [http-bio-7990-exec-10634] jdoe 966x1670694x3 2tmzqw1 54.240.197.225,127.0.0.1 "DELETE /projects/KEY/repos/slug HTTP/1.1" c.a.s.r.e.ServiceExceptionMapper Mapping ServiceException to REST response 400 com.atlassian.stash.repository.RepositoryDeletionCanceledException: Repository deletion was canceled. at com.atlassian.stash.internal.repository.RepositoryServiceImpl.fireRepositoryDeletionRequested(RepositoryServiceImpl.java:562) ~[stash-service-impl-2.5.0.jar:na] at com.atlassian.stash.internal.repository.RepositoryServiceImpl.access$000(RepositoryServiceImpl.java:56) ~[stash-service-impl-2.5.0.jar:na] at com.atlassian.stash.internal.repository.RepositoryServiceImpl$1.doInTransaction(RepositoryServiceImpl.java:168) ~[stash-service-impl-2.5.0.jar:na] at com.atlassian.stash.internal.repository.RepositoryServiceImpl$1.doInTransaction(RepositoryServiceImpl.java:164) ~[stash-service-impl-2.5.0.jar:na] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131) ~[spring-tx-3.2.2.RELEASE.jar:3.2.2.RELEASE] at com.atlassian.stash.internal.repository.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:164) ~[stash-service-impl-2.5.0.jar:na] at sun.reflect.GeneratedMethodAccessor21510.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_27] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "fk_sta_comment_parent". The conflict occurred in database "stashlhr10", table "dbo.sta_comment", column 'parent_id'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc-4.0.2206.jar:na] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc-4.0.2206.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133) ~[hibernate-core-4.2.1.Final.jar:4.2.1.Final] ... 308 common frames omitted {noformat} This is unique to SQL Server, due to how {{ON DELETE CASCADE}} clauses are processed for foreign keys, and cannot affect any other database.

    Atlassian JIRA | 3 years ago | Bryan Turner
    com.atlassian.stash.repository.RepositoryDeletionCanceledException: Repository deletion was canceled.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    support for other db types in nextRow method

    GitHub | 4 years ago | androtan
    java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'my_jdbc_river'.
  6. 0

    TestJPQLBasic#testBulkDelete fail

    GitHub | 4 years ago | ilgrosso
    com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'PObject'.

  1. abrazeneb 2 times, last 3 months ago
19 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "fk_sta_comment_parent". The conflict occurred in database "stashlhr10", table "dbo.sta_comment", column 'parent_id'.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
  2. com.microsoft.sqlserver
    SQLServerPreparedStatement.executeUpdate
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)[sqljdbc-4.0.2206.jar:na]
    2. com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)[sqljdbc-4.0.2206.jar:na]
    3. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)[sqljdbc-4.0.2206.jar:na]
    4. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)[sqljdbc-4.0.2206.jar:na]
    5. com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)[sqljdbc-4.0.2206.jar:na]
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)[sqljdbc-4.0.2206.jar:na]
    7. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)[sqljdbc-4.0.2206.jar:na]
    8. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)[sqljdbc-4.0.2206.jar:na]
    9. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)[sqljdbc-4.0.2206.jar:na]
    9 frames
  3. BoneCP :: Core Library
    PreparedStatementHandle.executeUpdate
    1. com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203)[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
    1 frame
  4. Hibernate
    ResultSetReturnImpl.executeUpdate
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)[hibernate-core-4.2.1.Final.jar:4.2.1.Final]
    1 frame
  5. com.atlassian.stash
    RepositoryServiceImpl$1.doInTransaction
    1. com.atlassian.stash.internal.repository.RepositoryServiceImpl.fireRepositoryDeletionRequested(RepositoryServiceImpl.java:562)[stash-service-impl-2.5.0.jar:na]
    2. com.atlassian.stash.internal.repository.RepositoryServiceImpl.access$000(RepositoryServiceImpl.java:56)[stash-service-impl-2.5.0.jar:na]
    3. com.atlassian.stash.internal.repository.RepositoryServiceImpl$1.doInTransaction(RepositoryServiceImpl.java:168)[stash-service-impl-2.5.0.jar:na]
    4. com.atlassian.stash.internal.repository.RepositoryServiceImpl$1.doInTransaction(RepositoryServiceImpl.java:164)[stash-service-impl-2.5.0.jar:na]
    4 frames
  6. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)[spring-tx-3.2.2.RELEASE.jar:3.2.2.RELEASE]
    1 frame
  7. com.atlassian.stash
    RepositoryServiceImpl.delete
    1. com.atlassian.stash.internal.repository.RepositoryServiceImpl.delete(RepositoryServiceImpl.java:164)[stash-service-impl-2.5.0.jar:na]
    1 frame
  8. Java RT
    DelegatingMethodAccessorImpl.invoke
    1. sun.reflect.GeneratedMethodAccessor21510.invoke(Unknown Source)[na:na]
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.6.0_27]
    2 frames