Bulk cache upload is not working for Maria DB (Adapter: MySQL 5.5) as cache target data source even after enabling "Enable Native Loading"

Bulk cache upload is not working for Maria DB (Adapter: MySQL 5.5) as cache target data source even after enabling "Enable Native Loading"

book

Article ID: KB0081683

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.5, 7.0.6

Description

  • Please enable the cache debug logging using the below debug properties.
    • Open <<CIS Installation Dir>>/conf/server/log4j.properties, add these 2 lines at the end of the file and restart CIS server:
                              log4j.logger.com.compositesw.server.cache.CacheRefreshThread=DEBUG
                              log4j.logger.com.compositesw.cdms.ds.jdbc.cache.BulkLoadableCache=DEBUG
  • Open cache resource and click "Refresh Now" button in caching tab
  • Verify cs_server.log file and you should be able to find the actual error which is causing the issue.

Environment

TEST

Resolution

  • In this case, we have found the below error in the logs
    • Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: The used command is not allowed with this MariaDB version
  • After researching the above error, we have found that its related 'local_infile' configuration. The 'local_infile' conf was set to 'OFF" and after changing it to 'ON', the cache refresh is working fine. 
  • Please refer the below forum for more details about the solution: 
                   https://bugs.mysql.com/bug.php?id=72220

Issue/Introduction

Bulk cache upload is not working for Maria DB (Adapter: MySQL 5.5) as cache target data source even after enabling "Enable Native Loading"
Powered by Wolken Software