Jira 8.8.0 setup fails during database creation

[Daniel_Hlebanovschi]

Hi guys,

Installed Jira 8.8.0 on Centos on 7.2 with MariaDB / MySQL (mysql  Ver 15.1 Distrib 10.1.44-MariaDB )and started configuring it from the browser, choosing my own database.

Test connection works fine, but it dies immediately after, although the database seems to be be populated.

This is the log file: INSTALLATION LOG 

Database misses the table that seems to generate the error, screenshot here: 

SCREENSHOT 

SQL Exception while executing the following:SELECT pluginkey, pluginenabled FROM pluginstate (Table 'jirmc3db.pluginstate' doesn't exist)

Thanks a lot!

[Earl McCutcheon · Accepted solution]

Hello @Daniel_Hlebanovschi ,

Thanks for reaching out and on this one I can see that your using MiraDB as the DB type, While it is not impossible to use MiraDB it is not currently supported for use with Jira and more than likely requires some customizations to make it work with the system.  For support reasons, and verified compatibility, I'd suggest that you do not use MiraDB.

I would recomend via the time table your looking at per the comment " Desperately need to get this working" to select a supported DB from the "Supported Platforms" page to use to get this running ASAP.

If you need to circle back to MiraDB I would recomend reaching out to the MiraDB support channel to ask for advice as I know they are have put out blogs in the past about working on Jira compatibility with MiraDB, exe:

• https://mariadb.org/eating-dog-food-running-jira-mariadb/

Regards,
Earl

[Earl McCutcheon]

Also an Additional Follow up item, Support for MiraDB as a compatible DB is being tracked here:

• https://jira.atlassian.com/browse/JRASERVER-32347

This is not currently on our short term roadmap but is flagged for future consideration so make sure to add a vote to this one to help us track continued interest and influence a priority bump.

Regards,
Earl

[Daniel_Hlebanovschi]

Hi, anyone else please? Desperately need to get this working. 

[Matt Doar]

Googling the error in the install log I found

https://confluence.atlassian.com/jirakb/mysql-table-creation-fails-with-error-specified-key-was-too-long-235668644.html

[Daniel_Hlebanovschi]

[root@ufo logs]# cat /etc/my.cnf | grep storage

default-storage-engine=INNODB

[root@ufo logs]# 

Already set, so it's not that.