Using PostgreSQL with dockerimage: library/postgres:9.5-alpine my metricbeat container (5.5.0) spits out the following errors:
2017/09/11 16:41:56.911310 schema.go:38: ERR Error on field 'query_start': Error converting param to time.Time: query_start. Original:
2017/09/11 16:41:56.911327 schema.go:38: ERR Error on field 'waiting': Key waiting not found
My metricbeat.yml looks like the following (omitted sending to ES etc)
Yup exactly if you run a similar query to what metric beat does (select usename, query_start from pg_stat_activity;) you will get something like the following (i am using postgres 9.5 and metricbeat 9.5 so column names can vary but general idea should hold)
And as you can see one of the service3 rows has no query_start since only a connection has been established no query has actually be run yet. I think metricbeat acted as expected but perhaps making that field optional could be a good idea?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.