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.

[Daniel Ebers · Accepted solution]

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

[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?

[Egor Dorofeev]

now we use mysql-5.7.32