dbi login spams log with dbi_result_next_row failed

[Stefan Voelkel]

I am seeing these log messages every $Interval:

collectd[579]: dbi plugin: cdbi_read_database_query (mariadb, threads_d): dbi_result_next_row failed: dbi_conn_error failed with status -6.
collectd[579]: dbi plugin: cdbi_read_database_query (mariadb, aria_status): dbi_result_next_row failed: dbi_conn_error failed with status -6.
collectd[579]: dbi plugin: cdbi_read_database_query (mariadb, threads_g): dbi_result_next_row failed: dbi_conn_error failed with status -6.

Upstream issue: https://github.com/collectd/collectd/issues/2894

The fix is part of 5.9.1

https://github.com/collectd/collectd/commit/6b29f39c2213e209f0996105c78b77f034b983f9

Plugin configuration:

<Plugin dbi>
   <Query "aria_status">
     Statement "SHOW GLOBAL STATUS WHERE Variable_name LIKE '%aria%';"
     <Result>
       Type "gauge"
       InstancesFrom "Variable_name"
       ValuesFrom "Value"
     </Result>
   </Query>
   <Query "threads_g">
     Statement "SHOW GLOBAL STATUS WHERE Variable_name in ('Threads_cached', 'Threads_connected', 'Threads_running');"
     <Result>
       Type "gauge"
       InstancesFrom "Variable_name"
       ValuesFrom "Value"
     </Result>
   </Query>
   <Query "threads_d">
     Statement "SHOW GLOBAL STATUS WHERE Variable_name in ('Threads_created');"
     <Result>
       Type "derive"
       InstancesFrom "Variable_name"
       ValuesFrom "Value"
     </Result>
   </Query>
   <Database "mariadb">
     Driver "mysql"
     DriverOption "host" "127.0.0.1"
     DriverOption "username" "***"
     DriverOption "password" "***"
     DriverOption "dbname" "information_schema"
     Query "aria_status"
     Query "threads_g"
     Query "threads_d"
   </Database>
</Plugin>

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.