com.atlassian.stash.internal.migration.MigrationException: One or more database connections were not closed within the allotted timeout. To prevent corruption due to inconsistent state, the migration has been aborted. Please try your migration again when the system is under less load.

Atlassian JIRA | Thomas Bright [Atlassian] | 4 years ago
  1. 0

    I did a test connection to the new db and then hit migrate the resulting error was: 2012-10-05 13:37:52,928 WARN [threadpool:thread-1] admin 816x99x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.h.ExtendedBoneCPDataSource The connection pool did not drain in 1 MINUTES; 1 connections are still leased 2012-10-05 13:37:52,928 WARN [threadpool:thread-1] admin 816x99x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.m.DefaultMigrationService The DataSource could not be drained; some database connections are still open. Aborting migration... 2012-10-05 13:37:52,930 ERROR [threadpool:thread-1] admin 816x99x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.m.DefaultMigrationService Reverting database configuration after a failed migration attempt com.atlassian.stash.internal.migration.MigrationException: One or more database connections were not closed within the allotted timeout. To prevent corruption due to inconsistent state, the migration has been aborted. Please try your migration again when the system is under less load. at com.atlassian.stash.internal.migration.DefaultMigrationService.drainDataSource(DefaultMigrationService.java:603) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService.writeBackup(DefaultMigrationService.java:388) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.backup.AbstractBackupSupport.backup(AbstractBackupSupport.java:92) ~[stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService.performMigration(DefaultMigrationService.java:714) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService.access$100(DefaultMigrationService.java:63) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService$1.run(DefaultMigrationService.java:166) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_33] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_33] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_33] at com.atlassian.stash.internal.concurrent.StateTransferringExecutor$StateTransferringRunnable.run(StateTransferringExecutor.java:68) [stash-platform-1.3.0-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_33] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_33] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_33] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) [na:1.6.0_33] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) [na:1.6.0_33] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_33] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_33] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33] 2012-10-05 13:38:54,601 INFO [http-7990-3] admin 818x224x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.b.l.DefaultLiquibaseSession Examining structure of source database 2012-10-05 13:44:01,338 INFO [main] c.a.s.i.server.ApplicationInfoLogger Shutting down Stash 1.3.0-SNAPSHOT 2012-10-05 13:44:02,260 INFO [Timer-2] c.a.stash.ssh.server.SshServer Stopping SSH server... 2012-10-05 13:44:02,262 INFO [Timer-2] c.a.stash.ssh.server.SshServer Stopped SSH server successfully. 2012-10-05 13:44:02,661 INFO [main] c.a.s.internal.home.HomeLockAcquirer Releasing lock on C:\currentDot\home

    Atlassian JIRA | 4 years ago | Thomas Bright [Atlassian]
    com.atlassian.stash.internal.migration.MigrationException: One or more database connections were not closed within the allotted timeout. To prevent corruption due to inconsistent state, the migration has been aborted. Please try your migration again when the system is under less load.
  2. 0

    I did a test connection to the new db and then hit migrate the resulting error was: 2012-10-05 13:37:52,928 WARN [threadpool:thread-1] admin 816x99x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.h.ExtendedBoneCPDataSource The connection pool did not drain in 1 MINUTES; 1 connections are still leased 2012-10-05 13:37:52,928 WARN [threadpool:thread-1] admin 816x99x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.m.DefaultMigrationService The DataSource could not be drained; some database connections are still open. Aborting migration... 2012-10-05 13:37:52,930 ERROR [threadpool:thread-1] admin 816x99x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.m.DefaultMigrationService Reverting database configuration after a failed migration attempt com.atlassian.stash.internal.migration.MigrationException: One or more database connections were not closed within the allotted timeout. To prevent corruption due to inconsistent state, the migration has been aborted. Please try your migration again when the system is under less load. at com.atlassian.stash.internal.migration.DefaultMigrationService.drainDataSource(DefaultMigrationService.java:603) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService.writeBackup(DefaultMigrationService.java:388) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.backup.AbstractBackupSupport.backup(AbstractBackupSupport.java:92) ~[stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService.performMigration(DefaultMigrationService.java:714) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService.access$100(DefaultMigrationService.java:63) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at com.atlassian.stash.internal.migration.DefaultMigrationService$1.run(DefaultMigrationService.java:166) [stash-service-impl-1.3.0-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_33] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_33] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_33] at com.atlassian.stash.internal.concurrent.StateTransferringExecutor$StateTransferringRunnable.run(StateTransferringExecutor.java:68) [stash-platform-1.3.0-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_33] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_33] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_33] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) [na:1.6.0_33] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) [na:1.6.0_33] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_33] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_33] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_33] 2012-10-05 13:38:54,601 INFO [http-7990-3] admin 818x224x1 7mtejf 0:0:0:0:0:0:0:1 "POST /admin/db/edit HTTP/1.1" c.a.s.i.b.l.DefaultLiquibaseSession Examining structure of source database 2012-10-05 13:44:01,338 INFO [main] c.a.s.i.server.ApplicationInfoLogger Shutting down Stash 1.3.0-SNAPSHOT 2012-10-05 13:44:02,260 INFO [Timer-2] c.a.stash.ssh.server.SshServer Stopping SSH server... 2012-10-05 13:44:02,262 INFO [Timer-2] c.a.stash.ssh.server.SshServer Stopped SSH server successfully. 2012-10-05 13:44:02,661 INFO [main] c.a.s.internal.home.HomeLockAcquirer Releasing lock on C:\currentDot\home

    Atlassian JIRA | 4 years ago | Thomas Bright [Atlassian]
    com.atlassian.stash.internal.migration.MigrationException: One or more database connections were not closed within the allotted timeout. To prevent corruption due to inconsistent state, the migration has been aborted. Please try your migration again when the system is under less load.

    Root Cause Analysis

    1. com.atlassian.stash.internal.migration.MigrationException

      One or more database connections were not closed within the allotted timeout. To prevent corruption due to inconsistent state, the migration has been aborted. Please try your migration again when the system is under less load.

      at com.atlassian.stash.internal.migration.DefaultMigrationService.drainDataSource()
    2. com.atlassian.stash
      DefaultMigrationService$1.run
      1. com.atlassian.stash.internal.migration.DefaultMigrationService.drainDataSource(DefaultMigrationService.java:603)[stash-service-impl-1.3.0-SNAPSHOT.jar:na]
      2. com.atlassian.stash.internal.migration.DefaultMigrationService.writeBackup(DefaultMigrationService.java:388)[stash-service-impl-1.3.0-SNAPSHOT.jar:na]
      3. com.atlassian.stash.internal.backup.AbstractBackupSupport.backup(AbstractBackupSupport.java:92)[stash-service-impl-1.3.0-SNAPSHOT.jar:na]
      4. com.atlassian.stash.internal.migration.DefaultMigrationService.performMigration(DefaultMigrationService.java:714)[stash-service-impl-1.3.0-SNAPSHOT.jar:na]
      5. com.atlassian.stash.internal.migration.DefaultMigrationService.access$100(DefaultMigrationService.java:63)[stash-service-impl-1.3.0-SNAPSHOT.jar:na]
      6. com.atlassian.stash.internal.migration.DefaultMigrationService$1.run(DefaultMigrationService.java:166)[stash-service-impl-1.3.0-SNAPSHOT.jar:na]
      6 frames
    3. Java RT
      FutureTask.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)[na:1.6.0_33]
      2. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[na:1.6.0_33]
      3. java.util.concurrent.FutureTask.run(FutureTask.java:138)[na:1.6.0_33]
      3 frames
    4. com.atlassian.stash
      StateTransferringExecutor$StateTransferringRunnable.run
      1. com.atlassian.stash.internal.concurrent.StateTransferringExecutor$StateTransferringRunnable.run(StateTransferringExecutor.java:68)[stash-platform-1.3.0-SNAPSHOT.jar:na]
      1 frame
    5. Java RT
      Thread.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)[na:1.6.0_33]
      2. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)[na:1.6.0_33]
      3. java.util.concurrent.FutureTask.run(FutureTask.java:138)[na:1.6.0_33]
      4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)[na:1.6.0_33]
      5. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)[na:1.6.0_33]
      6. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)[na:1.6.0_33]
      7. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)[na:1.6.0_33]
      8. java.lang.Thread.run(Thread.java:662)[na:1.6.0_33]
      8 frames