JIRA fails to create some tables in Firebird

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Medium
    • 3.2 Beta
    • Affects Version/s: 3.0.3
    • Component/s: Installation
    • None
    • Environment:

      Firebird 1.5.2

    • 3

      A user reports that JIRA fails to create some tables in Firebird, breaking with these errors:

      CREATE TABLE mailserver (ID NUMERIC(18,0) NOT NULL, NAME VARCHAR(255), DESCRIPTION BLOB SUB_TYPE TEXT, mailfrom VARCHAR(255), PREFIX VARCHAR(60), _TYPE VARCHAR(60), SERVERNAME VARCHAR(255), JNDILOCATION VARCHAR(255), mailusername VARCHAR(255), mailpassword VARCHAR(255), CONSTRAINT PK_mailserver PRIMARY KEY (ID))
      Error was: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
      335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 147 _TYPE
      CREATE TABLE notification (ID NUMERIC(18,0) NOT NULL, SCHEME NUMERIC(18,0), EVENT VARCHAR(60), _TYPE VARCHAR(60), PARAMETER VARCHAR(60), CONSTRAINT PK_notification PRIMARY KEY (ID)) Error was: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 96 _TYPE

      CREATE TABLE qrtz_calendars (ID NUMERIC(18,0), CALENDAR_NAME
      VARCHAR(255) NOT NULL, CALENDAR BLOB SUB_TYPE TEXT, CONSTRAINT PK_qrtz_calendars PRIMARY
      KEY (CALENDAR_NAME))
      Error was: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
      335544351. unsuccessful metadata update
      key size too big for index PK_QRTZ_CALENDARS

      CREATE TABLE qrtz_fired_triggers (ID NUMERIC(18,0), ENTRY_ID
      VARCHAR(255) NOT NULL, trigger_id NUMERIC(18,0), TRIGGER_LISTENER VARCHAR(255), FIRED_TIME
      TIMESTAMP, TRIGGER_STATE VARCHAR(255), CONSTRAINT PK_qrtz_fired_triggers PRIMARY
      KEY (ENTRY_ID))
      Error was: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544351. unsuccessful metadata updatekey size too big for index PK_QRTZ_FIRED_TRIGGERS

            Assignee:
            Jeff Turner
            Reporter:
            Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 4h
                4h
                Remaining:
                Remaining Estimate - 4h
                4h
                Logged:
                Time Spent - Not Specified
                Not Specified