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)
-
3
-
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