Jira database checklist launcher errors

[Matthew Paulsen]

Hi all,

I am doing a test migration and upgrade of Jira. I started by migrating a 4.3.3 server to another 4.3.3 server and it worked flawlessly. I have now upgraded the migrated server to 4.4 and I get this string of errors when I start jira. Any insites and fixes would be greatly apprecated

2011-10-19 21:25:08,478 main INFO [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2011-10-19 21:25:08,505 main INFO [atlassian.jira.startup.JiraHomeStartupCheck] The jira.home directory '/usr/local/jira-home' is validated and locked for exclusive use by this instance.
2011-10-19 21:25:08,505 main INFO [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2011-10-19 21:25:08,624 main INFO [jira.config.database.SystemTenantDatabaseConfigurationLoader] Reading database configuration from /usr/local/jira-home/dbconfig.xml
2011-10-19 21:25:08,691 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher
2011-10-19 21:25:09,924 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "GroupAttribute"
2011-10-19 21:25:09,924 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE INDEX idx_group_attr_dir_name_lval ON cwd_group_attributes (directory_id, attribute_name, lower_attribute_value)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
SQL Exception while executing the following:
CREATE UNIQUE INDEX uk_group_attr_name_lval ON cwd_group_attributes (group_id, attribute_name, lower_attribute_value)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
2011-10-19 21:25:09,925 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "Membership"
2011-10-19 21:25:09,925 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX idx_mem_dir_parent_child ON cwd_membership (lower_parent_name, lower_child_name, membership_type, directory_id)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
2011-10-19 21:25:09,925 main ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "UserAttribute"
2011-10-19 21:25:09,925 main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX idx_user_attr_dir_name_lval ON cwd_user_attributes (directory_id, attribute_name, lower_attribute_value)
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
2011-10-19 21:25:10,402 main INFO [atlassian.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.
2011-10-19 21:25:10,403 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Post database-configuration launchers
2011-10-19 21:25:11,119 main INFO [jira.config.database.SystemTenantDatabaseConfigurationLoader] Reading database configuration from /usr/local/jira-home/dbconfig.xml
2011-10-19 21:25:11,627 main INFO [atlassian.jira.startup.JiraStartupLogger]

[Harry Chan]

Hi, which version of MySQL are you using? Are you using myISAM? Best to switch to InnoDB for this.

Refer to https://jira.atlassian.com/browse/JRA-24124 for more information.

Also, make sure you are going to 4.4.5 to receive all the bug fixes.

[John Chin]

Hi Matthew,

I assume you are following the documentation of how to migrating Jira to another server. Could you confirm the following information?

1. Try shut down jira.
2. Remove file .bundled-plugins/ folder and the .osgi-plugins/ folder from JIRA_HOME.
3. Remove indexes file in cache folder from JIRA_HOME.
4. Start Jira

I hope its help, good luck.

Regards,

John Chin