Metricbeat postgresql module missing field errors

I have setup and am running metricbeats 6.2.4 with the postgresql module. It seems to be collecting but have 2 issues.

  1. I do not see a metricbeat dashboard for the module postgres. Where is it?

  2. I am getting the following errors in the metricbeats log file despite it collecting data. How can I fix this?

2018-05-16T19:12:59.083Z ERROR schema/schema.go:41 Error on field 'port': Missing field: port, Error: Error converting param to int: client_port
2018-05-16T19:12:59.083Z ERROR schema/schema.go:41 Error on field 'oid': Missing field: oid, Error: Error converting param to int: datid
2018-05-16T19:12:59.083Z ERROR schema/schema.go:41 Error on field 'id': Missing field: id, Error: Error converting param to int: usesysid
2018-05-16T19:12:59.083Z ERROR schema/schema.go:41 Error on field 'oid': Missing field: oid, Error: Error converting param to int: datid
2018-05-16T19:12:59.083Z ERROR schema/schema.go:41 Error on field 'port': Missing field: port, Error: Error converting param to int: client_port
2018-05-16T19:12:59.083Z ERROR schema/schema.go:41 Error on field 'oid': Missing field: oid, Error: Error converting param to int: datid
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'oid': Missing field: oid, Error: Error converting param to int: datid
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'port': Missing field: port, Error: Error converting param to int: client_port
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'oid': Missing field: oid, Error: Error converting param to int: datid
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'id': Missing field: id, Error: Error converting param to int: usesysid
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'port': Missing field: port, Error: Error converting param to int: client_port
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'oid': Missing field: oid, Error: Error converting param to int: datid
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'id': Missing field: id, Error: Error converting param to int: usesysid
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'port': Missing field: port, Error: Error converting param to int: client_port
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'oid': Missing field: oid, Error: Error converting param to int: datid
2018-05-16T19:12:59.084Z ERROR schema/schema.go:41 Error on field 'id': Missing field: id, Error: Error converting param to int: usesysid

Hello @kyle_che

  1. Metricbeat currently doesn't ship with a dashboard, but you can create your own and maybe contribute it back.

  2. This is a problem, in some circumstances, these fields are missing, and we log at error level, in the upcoming version 6.3 we made a change to only log these errors at debug level.

The host overview seems to not be working very well. The disk usage says 0 sometimes and then will display correctly other times. Also it only shows these 5 mount points and not all of them. How can this be fixed?

I have now installed metricbeats and packetbeats. The dashboards have visualizations that work and don't work. I would think that the out of the box dashboard would be all working but not so. Especially the packetbeats, only a couple of the many visualizations even work and I get errors continuously when clicking on the different tabs. Will elasticsearch eventually put full time developers on creating kibana dashboards so that we can actually use these out of the box dashboards?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.