nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

we did not change the php version

Egor Dorofeev

but when opening an address https://jira.hata.sale/secure/errors.jsp, it gives this error

Database: We've found an error in MySQL supported version!

The database type in your dbconfig.xml is set up to MySQl 5.7+ and your MySQL version is 5.6 or lower. Consider using MySQL 5.6 database type instead
See our documentation for more information on changing database type.

Accepted answers

Daniel Ebers

Hi Egor,

from what it seems Jira is either not recognizing the used MySQL version correctly or there is a mismatch in configuration like

being connected to the wrong database
using a wrong JDBC driver

Did you upgrade Jira and or the MySQL version lately or did this come out of the blue?
At least I assume the error pops up after a restart, is that correct?

Could you please show an anonymized excerpt of your dbconfig.xml?

Regards,
Daniel

All comments

Egor Dorofeev

now we use mysql-5.7.32

Daniel Ebers

Hi Egor,

from what it seems Jira is either not recognizing the used MySQL version correctly or there is a mismatch in configuration like

being connected to the wrong database
using a wrong JDBC driver

Regards,
Daniel

Egor Dorofeev

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mysql57</database-type>
  <jdbc-datasource>
    <url>jdbc:mysql://address=(protocol=tcp)(host=localhost)(port=3306)/jira?sessionVariables=default_storage_engine=InnoDB</url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <username>jira</username>
    <password>8S6p9V9z</password>
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <validation-query>select 1</validation-query>
    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
    <pool-test-on-borrow>false</pool-test-on-borrow>
    <pool-test-while-idle>true</pool-test-while-idle>
    <validation-query-timeout>3</validation-query-timeout>
  </jdbc-datasource>
</jira-database-config>

Daniel Ebers

Could you please also confirm on the specific JDBC driver version you are using?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server