Tech Tips: Linux MySQL is not working with Linux DevTest 10.2

Document created by MarcyNunns Employee on Jan 23, 2018Last modified by MarcyNunns Employee on Jan 24, 2018
Version 2Show Document
  • View in full screen mode

Having an issue where MySQL for Linux is not working properly with DevTest 10.2 on Linux.

 

When starting either the Enterprise Dashboard or Registry when configured for MySQL on Linux, you will get and error similar to the one below:

 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dashboard_10_2.METRIC' doesn't exist

 

and

 

Failed to execute: select COMP_UUID,METRIC_TM,METRIC_VALUE from METRIC where METRIC_TM > ? and METRIC_TM < ? and METRIC_CLASS = ? order by METRIC_TM because: Table 'dashboard_10_2.METRIC' doesn't exist

 

When inspecting the Database, there is a table named "metric" in all lowercase.

 

The query is failing because table names in MySQL on Linux are case sensitive.

 

This will be fixed in the next release of DevTest, but for now the workaround is:


In the /etc/my.cnf file can you add the below lines and restart MySQL.


lower_case_table_names = 1

 

If the workaround is not acceptable until fixed in a future release, please feel free to open a new Support case and we will provide a patch.

Attachments

    Outcomes