Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-34

Plans are stuck in RUNNING state when Confluence restarts or has an error

    XMLWordPrintable

Details

    • 1

    Description

      Issue Summary

      Plans can be stuck in a RUNNING state and do not progress.

      Environment

      • Confluence 5.10. or above
      • Latest CMAC

      Steps to Reproduce

      1. Create a Plan for a large Space
      2. Start the Plan
      3. Kill Confluence with kill -9 (do not do this in production)
      4. Restart Confluence

      Expected Results

      Plans should re-start

      Actual Results

      Plans say RUNNING, however there is no progression of the Plan and it stays in the same state.

      Notes

      This is caused by the running thread being killed and CMAC not cleaning up invalid Plans on restart.

      Workaround

      See also the Restore the Cloud Migration Assistant for Confluence to the default version guide.

      IMPORTANT

      Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

      1. Stop Confluence
      2. Remove CMAC completely (this will remove all the current Plans and associated data)
        For PostgreSQL
        DELETE FROM public.plugindata WHERE plugindata.pluginkey = 'com.atlassian.migration.agent';
        DROP TABLE "public"."mig_analytics_event" CASCADE;
        DROP TABLE "public"."mig_attachment" CASCADE;
        DROP TABLE "public"."mig_cloud_site" CASCADE;
        DROP TABLE "public"."mig_db_changelog" CASCADE;
        DROP TABLE "public"."mig_db_changelog_lock" CASCADE;
        DROP TABLE "public"."mig_plan" CASCADE;
        DROP TABLE "public"."mig_sequences" CASCADE;
        DROP TABLE "public"."mig_stats" CASCADE;
        DROP TABLE "public"."mig_step" CASCADE;
        DROP TABLE "public"."mig_task" CASCADE;
        DROP TABLE "public"."mig_work_item" CASCADE;
        
      1. Restart Confluence

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jrichards@atlassian.com James Richards
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: