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

Atlassian JIRA | Bryan Turner | 3 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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

    Storing Java Double Infinity and NaN values to MS SQL 2008 database

    Stack Overflow | 5 years ago | Spaideri
    com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 6 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
  6. 0

    support for other db types in nextRow method

    GitHub | 5 years ago | androtan
    java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'my_jdbc_river'.
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