Hello,
After a bit of driver updating and connection string mangling we got our MySQL Service monitor up and running. On one of the queries for Opened Connections we appear to be getting the wrong results, it seems to give us either a 1 or 2. When we execute the same query on the server, select count(*) from processlist, we are getting what we expected which is a wide range of numbers.
The debug is below and we would be grateful if anyone could shed any light on the matter
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.OdbcQAProbe - SQL query to execute: 'select count(*) from processlist'
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.OdbcQAProbe - Start SQL query execution
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.SQL.DbClient - Executed reader. 1st column value = '1' (System.Int64).
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.SQL.DbClient - Result reader.GetValue(0) converted to string type: '1'
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.OdbcQAProbe - SqlQuery returned Statistics: '1'
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.OdbcQAProbe - SqlQuery returned Message: 'NULL'
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.OdbcQAProbe - Adding results to the result writer.
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.Utility.DataTransformHelper - Expression is null or empty, returning the original value: '1'
2012-10-09 14:12:14,448 [STP SmartThreadPool Thread #2] [C2113] DEBUG SolarWinds.APM.Probes.OdbcQAProbe - Outcome changed from Pass to Available based on thresholds. Response Time Value: 5, StatisticData: 1
Regards
Jim
