Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and 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

              Assignee:
              Unassigned
              Reporter:
              ialexeyenko Ignat Alexeyenko
              Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: