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

      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): projectversion, jiraworkflows 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

          Form Name

            [JRASERVER-65978] On Oracle JIRA executes unnecessary ALTER TABLE operation for certain tables upon restart

            Ramanand Ravi added a comment -

            Jira 8.5.4 as well

            Ramanand Ravi added a comment - Jira 8.5.4 as well

            Jack Nolddor [Sweet Bananas] added a comment -

            Affects Jira 8.2.3 as well

            Jack Nolddor [Sweet Bananas] added a comment - Affects Jira 8.2.3 as well

              Unassigned Unassigned
              ialexeyenko Ignat (Inactive)
              Affected customers:
              7 This affects my team
              Watchers:
              10 Start watching this issue

                Created:
                Updated: