Service Virtualization

 View Only

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

Jan 23, 2018 04:03 PM

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




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.

0 Favorited
0 Files

Tags and Keywords

Related Entries and Links

No Related Resource entered.