-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
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