MariaDB database elements fail during monitoring with HCO 2024.1

This article describes a solution for an issue with elements failing on HCO 2024.1. This version of HCO contains MariaDB version 3.1.19. MariaDB database elements fail with the following error: ERROR [HY000] [ma-3.1.19][10.0.38-MariaDB]Unknown system variable 'STATEMENT'

First published date

2/5/2024 1:50 PM

Last published date

2/20/2025 12:15 AM

Overview

The most recent version of MariaDB ODBC driver 3.1.19 that was available at the time HCO 2024.1 was built uses a “SET STATEMENT” command available in MariaDB 10.1.2. Users may encounter the following error: 
ERROR [HY000] [ma-3.1.19][10.0.38-MariaDB]Unknown system variable 'STATEMENT' 

Cause

MariaDB ODBC driver 3.1.19 needs to be updated to avoid this error. 

Resolution

To resolve this issue, take the following steps: 

  1. Download the most recent Windows 32-bit version of the ODBC driver from MariaDB (© 2023 MariaDB, available at https://mariadb.com/downloads/connectors/connectors-data-access/odbc-connector/, obtained on December 13, 2023).  
    Note: You must download version 3.1.x, as the bug was fixed in version 3.1.20. 

  1. Stop the SolarWinds Job Engine v2 service on the poller. 

  1. Install the new version of MariaDB 3.1.x. 

  1. Open the Control Panel > Programs and Features and verify that the MariaDB ODBC driver has been installed. 

  1. Start the SolarWinds Job Engine v2 service. 

  1. Wait 5 to 10 minutes for the next polling and verify that SCM elements are polled with no errors. 

If this solution does not resolve your issue, contact Support for assistance.