PostgreSQL: Dalibo released temBoard Version 7.6 which fixed the ERROR: Request failed: 500 column “key” does not exist

  • Post author:
  • Post category:PostgreSQL

Dalibo released temBoard Version 7.6 at the 10th of February 2021, which came with an important bug fix.

temboard-7.6-1.el7.noarch.rpm 10-Feb-2021
temboard-agent-7.6-1.el7.noarch.rpm 10-Feb-2021

This release fixes the ERROR: column “key” does not exist at character 262

2021-01-21 08:04:37.812 CET [24672] ERROR:  column "key" does not exist at character 262
2021-01-21 08:04:37.812 CET [24672] STATEMENT:  COPY(
        SELECT
            datetime AS date,
            SUM((record).n_rollback) AS rollback
        FROM metric_xacts_30m_current
        WHERE instance_id = 21 AND datetime >= '2021-01-19T07:04:37.736000+00:00'::timestamptz AND datetime <= '2021-01-21T07:04:37.736000+00:00'::timestamptz AND key = 'repmgr'
        GROUP BY datetime, instance_id ORDER BY datetime
                ) TO STDOUT WITH CSV HEADER

In case you want to see more about the issue, check out the following link.

https://github.com/dalibo/temboard/issues/888

To upgrade to the new version, simply follow the instructions from the blog:

https://ptdb.ch/2021/01/03/postgresql-how-to-upgrade-temboard-7-3-to-7-4/

Conclusion

Check out https://github.com/dalibo/temboard/ because cool new stuff is released regularly. 🙂