Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-5640

On startup the entity engine reports that tables do not exist and attempts to add them even though they do exist.

    XMLWordPrintable

    Details

      Description

      Everytime we attempt to startup JIRA 3.0.3 it states that entity mappings are missing tables (even though they exist) and attempts to add them resulting in a SQL error (since they already exist.) Here is a snippet of the logs, but it appears that all the entity mappings do this.

      2005-01-12 08:34:10,915 [core.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database
      2005-01-12 08:34:10,961 [core.entity.jdbc.DatabaseUtil] Could not create table "jiraaction"
      2005-01-12 08:34:10,961 [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE TABLE jiraaction (ID NUMERIC(18,0) NOT NULL, issueid NUMERIC(18,0), AUTHOR VARCHAR(255), actiontype VARCHAR(255), actionlevel VARCHAR(255), actionbody TEXT, CREATED TIMESTAMPTZ, actionnum NUMERIC(18,0), CONSTRAINT PK_jiraaction PRIMARY KEY (ID))
      Error was: java.sql.SQLException: ERROR: Relation 'jiraaction' already exists

      2005-01-12 08:34:10,961 [core.entity.jdbc.DatabaseUtil] Entity "ChangeGroup" has no table in the database
      2005-01-12 08:34:10,963 [core.entity.jdbc.DatabaseUtil] Could not create table "changegroup"
      2005-01-12 08:34:10,963 [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE TABLE changegroup (ID NUMERIC(18,0) NOT NULL, issueid NUMERIC(18,0), AUTHOR VARCHAR(255), CREATED TIMESTAMPTZ, CONSTRAINT PK_changegroup PRIMARY KEY (ID))
      Error was: java.sql.SQLException: ERROR: Relation 'changegroup' already exists

      2005-01-12 08:34:10,963 [core.entity.jdbc.DatabaseUtil] Entity "ChangeItem" has no table in the database
      2005-01-12 08:34:10,965 [core.entity.jdbc.DatabaseUtil] Could not create table "changeitem"
      2005-01-12 08:34:10,965 [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE TABLE changeitem (ID NUMERIC(18,0) NOT NULL, groupid NUMERIC(18,0), FIELDTYPE VARCHAR(255), FIELD VARCHAR(255), OLDVALUE TEXT, OLDSTRING TEXT, NEWVALUE TEXT, NEWSTRING TEXT, CONSTRAINT PK_changeitem PRIMARY KEY (ID))
      Error was: java.sql.SQLException: ERROR: Relation 'changeitem' already exists

      2005-01-12 08:34:10,965 [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayout" has no table in the database
      2005-01-12 08:34:10,967 [core.entity.jdbc.DatabaseUtil] Could not create table "columnlayout"
      2005-01-12 08:34:10,967 [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE TABLE columnlayout (ID NUMERIC(18,0) NOT NULL, USERNAME VARCHAR(255), SEARCHREQUEST NUMERIC(18,0), CONSTRAINT PK_columnlayout PRIMARY KEY (ID))
      Error was: java.sql.SQLException: ERROR: Relation 'columnlayout' already exists

      2005-01-12 08:34:10,967 [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayoutItem" has no table in the database
      2005-01-12 08:34:10,968 [core.entity.jdbc.DatabaseUtil] Could not create table "columnlayoutitem"
      2005-01-12 08:34:10,969 [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE TABLE columnlayoutitem (ID NUMERIC(18,0) NOT NULL, COLUMNLAYOUT NUMERIC(18,0), FIELDIDENTIFIER VARCHAR(255), HORIZONTALPOSITION NUMERIC(18,0), CONSTRAINT PK_columnlayoutitem PRIMARY KEY (ID))
      Error was: java.sql.SQLException: ERROR: Relation 'columnlayoutitem' already exists

      2005-01-12 08:34:10,969 [core.entity.jdbc.DatabaseUtil] Entity "Component" has no table in the database
      2005-01-12 08:34:10,970 [core.entity.jdbc.DatabaseUtil] Could not create table "component"
      2005-01-12 08:34:10,970 [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE TABLE component (ID NUMERIC(18,0) NOT NULL, PROJECT NUMERIC(18,0), cname VARCHAR(255), description TEXT, URL VARCHAR(255), LEAD VARCHAR(255), ASSIGNEETYPE NUMERIC(18,0), CONSTRAINT PK_component PRIMARY KEY (ID))
      Error was: java.sql.SQLException: ERROR: Relation 'component' already exists

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              emolitor Eric Molitor
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: