Public bug reported:

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>

** Affects: collectd (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1843687

Title:
  dbi login spams log with dbi_result_next_row failed

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/collectd/+bug/1843687/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to