Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-2743

Error during migration, MS SQL -> Oracle

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Fixed
    • None
    • None
    • None
    • We collect Bitbucket feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      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

      Attachments

        Activity

          People

            Unassigned Unassigned
            tbright ThomasA
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: