Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-4929

Database errors with Postgres 7.1: POSITION is a reserved word

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • 3.2
    • 3.0 Standard Beta
    • Dashboard & Gadgets
    • Postgres 7.1

    Description

      If the field-type-name is set to "postgres", and JIRA is pointed to a clean Postgres database, there is an error creating the 'portletconfiguration' table:

      i:Exit -:PrevPg <Space>:NextPg ?:Help
      [INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 9090
      Starting service Tomcat-Standalone
      Apache Tomcat/4.1.29
      [INFO] jotm - -JOTM started with a local transaction factory which is not bound.
      [INFO] jotm - -CAROL initialization
      2004-10-14 12:40:30,406 WARN [core.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database
      2004-10-14 12:40:30,522 WARN [core.entity.jdbc.DatabaseUtil] Entity "ChangeGroup" has no table in the database
      2004-10-14 12:40:30,561 WARN [core.entity.jdbc.DatabaseUtil] Entity "ChangeItem" has no table in the database
      2004-10-14 12:40:30,681 WARN [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayout" has no table in the database
      2004-10-14 12:40:30,722 WARN [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayoutItem" has no table in the database
      2004-10-14 12:40:30,781 WARN [core.entity.jdbc.DatabaseUtil] Entity "Component" has no table in the database
      2004-10-14 12:40:30,874 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomField" has no table in the database
      2004-10-14 12:40:30,971 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomFieldOption" has no table in the database
      2004-10-14 12:40:31,021 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomFieldValue" has no table in the database
      2004-10-14 12:40:31,121 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayout" has no table in the database
      2004-10-14 12:40:31,152 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutItem" has no table in the database
      2004-10-14 12:40:31,201 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutScheme" has no table in the database
      2004-10-14 12:40:31,305 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutSchemeAssociation" has no table in the
      database
      2004-10-14 12:40:31,329 WARN [core.entity.jdbc.DatabaseUtil] Entity "FileAttachment" has no table in the database
      2004-10-14 12:40:31,381 WARN [core.entity.jdbc.DatabaseUtil] Entity "FilterSubscription" has no table in the database
      2004-10-14 12:40:31,421 WARN [core.entity.jdbc.DatabaseUtil] Entity "Issue" has no table in the database
      2004-10-14 12:40:31,501 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueLink" has no table in the database
      2004-10-14 12:40:31,561 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueLinkType" has no table in the database
      2004-10-14 12:40:31,591 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueSecurityScheme" has no table in the database
      2004-10-14 12:40:31,681 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueType" has no table in the database
      2004-10-14 12:40:31,751 WARN [core.entity.jdbc.DatabaseUtil] Entity "ListenerConfig" has no table in the database
      2004-10-14 12:40:31,781 WARN [core.entity.jdbc.DatabaseUtil] Entity "MailServer" has no table in the database
      2004-10-14 12:40:31,871 WARN [core.entity.jdbc.DatabaseUtil] Entity "NodeAssociation" has no table in the database
      2004-10-14 12:40:31,921 WARN [core.entity.jdbc.DatabaseUtil] Entity "Notification" has no table in the database
      2004-10-14 12:40:31,951 WARN [core.entity.jdbc.DatabaseUtil] Entity "NotificationInstance" has no table in the database
      2004-10-14 12:40:32,001 WARN [core.entity.jdbc.DatabaseUtil] Entity "NotificationScheme" has no table in the database
      2004-10-14 12:40:32,082 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSCurrentStep" has no table in the database
      2004-10-14 12:40:32,121 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSCurrentStepPrev" has no table in the database
      2004-10-14 12:40:32,184 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSGroup" has no table in the database
      2004-10-14 12:40:32,221 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSHistoryStep" has no table in the database
      2004-10-14 12:40:32,251 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSHistoryStepPrev" has no table in the database
      2004-10-14 12:40:32,301 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSMembership" has no table in the database
      2004-10-14 12:40:32,371 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyData" has no table in the database
      2004-10-14 12:40:32,421 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyDate" has no table in the database
      2004-10-14 12:40:32,461 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyDecimal" has no table in the database
      2004-10-14 12:40:32,501 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyEntry" has no table in the database
      2004-10-14 12:40:32,542 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyNumber" has no table in the database
      2004-10-14 12:40:32,581 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyString" has no table in the database
      2004-10-14 12:40:32,682 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSPropertyText" has no table in the database
      2004-10-14 12:40:32,782 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSUser" has no table in the database
      2004-10-14 12:40:32,882 WARN [core.entity.jdbc.DatabaseUtil] Entity "Permission" has no table in the database
      2004-10-14 12:40:32,922 WARN [core.entity.jdbc.DatabaseUtil] Entity "PermissionScheme" has no table in the database
      2004-10-14 12:40:33,002 WARN [core.entity.jdbc.DatabaseUtil] Entity "PortalPage" has no table in the database
      2004-10-14 12:40:33,041 WARN [core.entity.jdbc.DatabaseUtil] Entity "PortletConfiguration" has no table in the database
      2004-10-14 12:40:33,043 ERROR [core.entity.jdbc.DatabaseUtil] Could not create table "portletconfiguration"
      2004-10-14 12:40:33,043 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE TABLE portletconfiguration (ID NUMERIC(18,0) NOT NULL, PORTALPAGE NUMERIC(18,0), PORTLET_ID VARCHAR(255),
      COLUMN_NUMBER NUMERIC(9,0), POSITION NUMERIC(9,0), CONSTRAINT PK_portletconfiguration PRIMARY KEY (ID))
      Error was: java.sql.SQLException: ERROR: parser: parse error at or near "POSITION"

      2004-10-14 12:40:33,043 WARN [core.entity.jdbc.DatabaseUtil] Entity "Priority" has no table in the database
      2004-10-14 12:40:33,101 WARN [core.entity.jdbc.DatabaseUtil] Entity "Project" has no table in the database
      2004-10-14 12:40:33,221 WARN [core.entity.jdbc.DatabaseUtil] Entity "ProjectCategory" has no table in the database
      2004-10-14 12:40:33,321 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZCalendars" has no table in the database
      2004-10-14 12:40:33,421 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZCronTriggers" has no table in the database
      2004-10-14 12:40:33,461 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZFiredTriggers" has no table in the database
      2004-10-14 12:40:33,492 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZJobDetails" has no table in the database
      2004-10-14 12:40:33,541 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZJobListeners" has no table in the database
      2004-10-14 12:40:33,591 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZSimpleTriggers" has no table in the database
      2004-10-14 12:40:33,622 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZTriggerListeners" has no table in the database
      2004-10-14 12:40:33,681 WARN [core.entity.jdbc.DatabaseUtil] Entity "QRTZTriggers" has no table in the database
      2004-10-14 12:40:33,721 WARN [core.entity.jdbc.DatabaseUtil] Entity "Resolution" has no table in the database
      2004-10-14 12:40:33,792 WARN [core.entity.jdbc.DatabaseUtil] Entity "SchemeIssueSecurities" has no table in the database
      2004-10-14 12:40:33,827 WARN [core.entity.jdbc.DatabaseUtil] Entity "SchemeIssueSecurityLevels" has no table in the database
      2004-10-14 12:40:33,901 WARN [core.entity.jdbc.DatabaseUtil] Entity "SchemePermissions" has no table in the database
      2004-10-14 12:40:33,941 WARN [core.entity.jdbc.DatabaseUtil] Entity "SearchRequest" has no table in the database
      2004-10-14 12:40:34,064 WARN [core.entity.jdbc.DatabaseUtil] Entity "SequenceValueItem" has no table in the database
      2004-10-14 12:40:34,122 WARN [core.entity.jdbc.DatabaseUtil] Entity "ServiceConfig" has no table in the database
      2004-10-14 12:40:34,161 WARN [core.entity.jdbc.DatabaseUtil] Entity "Status" has no table in the database
      2004-10-14 12:40:34,261 WARN [core.entity.jdbc.DatabaseUtil] Entity "TrackbackPing" has no table in the database
      2004-10-14 12:40:34,321 WARN [core.entity.jdbc.DatabaseUtil] Entity "UpgradeHistory" has no table in the database
      2004-10-14 12:40:34,361 WARN [core.entity.jdbc.DatabaseUtil] Entity "UserAssociation" has no table in the database
      2004-10-14 12:40:34,422 WARN [core.entity.jdbc.DatabaseUtil] Entity "Version" has no table in the database
      2004-10-14 12:40:34,501 WARN [core.entity.jdbc.DatabaseUtil] Entity "VersionControl" has no table in the database
      2004-10-14 12:40:34,541 WARN [core.entity.jdbc.DatabaseUtil] Entity "Workflow" has no table in the database
      2004-10-14 12:40:34,621 WARN [core.entity.jdbc.DatabaseUtil] Entity "WorkflowScheme" has no table in the database
      2004-10-14 12:40:34,721 WARN [core.entity.jdbc.DatabaseUtil] Entity "WorkflowSchemeEntity" has no table in the database
      [INFO] StdSchedulerFactory - -Quartz scheduler 'JiraQuartzScheduler' initialized from default resource file in Quartz
      package: 'quartz.properties'

      This is because POSITION is a SQL92 reserved word.

      Attachments

        Activity

          People

            7ee5c68a815f Jeff Turner
            7ee5c68a815f Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: