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

XMLWordPrintable

    • 7.02
    • 13
    • Severity 2 - Major
    • 3

      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

            Assignee:
            Unassigned
            Reporter:
            Ignat (Inactive)
            Votes:
            7 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated: