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

    • Bug
    • Resolution: Fixed
    • High
    • None
    • 3.0.3
    • None
    • Redhat ES 3.0 running Redhat Postgres RPM (rh-postgresql-server-7.3.8-2)

    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

            Unassigned Unassigned
            4d5476093c7d Eric Molitor
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: