Details
-
Bug
-
Resolution: Won't Fix
-
Low
-
None
-
3.12.2
-
db2 v 9.5
-
3.12
-
Description
When configuring jira to use a DB2 database as described at http://www.atlassian.com/software/jira/docs/latest/databases/db2.html the schema initialization fails. The tables are created correctly, but index creation fails with errors like these:
2008-04-09 11:49:59,791 main [core.entity.jdbc.DatabaseUtil] Could not create declared indices for entity "OSGroup" 2008-04-09 11:49:59,791 main [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE INDEX osgroup_name ON JIRALAB.groupbase (groupname) Error was: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-552, SQLSTATE=42502, SQLERRMC=JIRATEST;IMPLICIT CREATE SCHEMA, DRIVER=3.50.152 2008-04-09 11:49:59,794 main [core.entity.jdbc.DatabaseUtil] Could not create declared indices for entity "OSMembership" 2008-04-09 11:49:59,794 main [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE INDEX mshipbase_user ON JIRALAB.membershipbase (USER_NAME) Error was: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-552, SQLSTATE=42502, SQLERRMC=JIRATEST;IMPLICIT CREATE SCHEMA, DRIVER=3.50.152 SQL Exception while executing the following: CREATE INDEX mshipbase_group ON JIRALAB.membershipbase (GROUP_NAME)
Error: SQLCODE=-552, SQLSTATE=42502 is returned when a database user DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION as per http://www.rikipedia.co.za/index.php/DB2_SQL_Error_Codes.
JIRA specifies the schema name from enitityengine.xml when creating the tables, but it does not seem to specify the schema name when creating the indexes.
If the database user doesn't have default schema associated with it, JIRA fails to create indexes.
If the default Schema property is specified on the data source definition the default one is specified when JIRA does not do provide it. So, that is why in some/most cases JIRA is able to create the db correctly.
This problem was reported as a feedback by one of customers and successfully replicated in a testing instance.
Attachments
Issue Links
- is related to
-
JRASERVER-14825 Extra note about installing JIRA on DB2 is needed.
- Closed