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