Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-65978

On Oracle JIRA executes unnecessary ALTER TABLE operation for certain tables upon restart

    XMLWordPrintable

Details

    Description

      Summary

      JIRA executes unnecessary ALTER TABLE operation for certain tables upon restart when using Oracle DB

      Steps to reproduce

      • Start Jira with Oracle db 12c
      • Check logs

       

      Actual results

      Tables Core JIRA tables (ofbiz): projectversionjiraworkflows are altered.
       

      Expected Results

      There are no alter tables statement executed.

      Notes

      Logs

      2017-08-31 15:34:18,614 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "VNAME" of type "VARCHAR2" of table "projectversion" of entity "Version" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,619 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "RELEASED" of type "VARCHAR2" of table "projectversion" of entity "Version" has different type definition and has been changed from VARCHAR2(10) to VARCHAR2(10 CHAR).
      2017-08-31 15:34:18,624 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "ARCHIVED" of type "VARCHAR2" of table "projectversion" of entity "Version" has different type definition and has been changed from VARCHAR2(10) to VARCHAR2(10 CHAR).
      2017-08-31 15:34:18,637 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "URL" of type "VARCHAR2" of table "projectversion" of entity "Version" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,643 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "VCSNAME" of type "VARCHAR2" of table "versioncontrol" of entity "VersionControl" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,647 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "VCSDESCRIPTION" of type "VARCHAR2" of table "versioncontrol" of entity "VersionControl" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,652 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "VCSTYPE" of type "VARCHAR2" of table "versioncontrol" of entity "VersionControl" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,657 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "WORKFLOWNAME" of type "VARCHAR2" of table "jiraworkflows" of entity "Workflow" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,662 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "CREATORNAME" of type "VARCHAR2" of table "jiraworkflows" of entity "Workflow" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,667 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "ISLOCKED" of type "VARCHAR2" of table "jiraworkflows" of entity "Workflow" has different type definition and has been changed from VARCHAR2(60) to VARCHAR2(60 CHAR).
      2017-08-31 15:34:18,672 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "NAME" of type "VARCHAR2" of table "workflowscheme" of entity "WorkflowScheme" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,678 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "WORKFLOW" of type "VARCHAR2" of table "workflowschemeentity" of entity "WorkflowSchemeEntity" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,682 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "ISSUETYPE" of type "VARCHAR2" of table "workflowschemeentity" of entity "WorkflowSchemeEntity" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,688 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "STATUS" of type "VARCHAR2" of table "jiraworkflowstatuses" of entity "WorkflowStatuses" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,693 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "PARENTNAME" of type "VARCHAR2" of table "jiraworkflowstatuses" of entity "WorkflowStatuses" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,697 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "AUTHOR" of type "VARCHAR2" of table "worklog" of entity "Worklog" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,703 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "GROUPLEVEL" of type "VARCHAR2" of table "worklog" of entity "Worklog" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      2017-08-31 15:34:18,715 localhost-startStop-1 INFO      [o.o.c.entity.jdbc.DatabaseUtil] Column "UPDATEAUTHOR" of type "VARCHAR2" of table "worklog" of entity "Worklog" has different type definition and has been changed from VARCHAR2(255) to VARCHAR2(255 CHAR).
      

       

      Workaround

      None

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ialexeyenko Ignat (Inactive)
              Votes:
              7 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated: