Hi ,
Your monitoring program is trying to use pg_stat_activity's old version. In 9.6 pg_stat_activity has new columns named wait_event , wait_event_type . Which monitoring programme? Neslişah Demirci | Veritabanı Yöneticisi Ayazağa cad. No:4 Uniq İstanbul Plaza B2 /Kat:3 34396 Ayazağa-SARIYER-İstanbul T. (+90) 212 453 16 00 – 5516 F. (+90) 212 453 16 16 www.markafoni.com<http://www.markafoni.com/> www.facebook.com/markafoni<http://www.facebook.com/markafoni> blog.markafoni.com ________________________________ Gönderen: Johann Spies <johann.sp...@gmail.com> adına pgsql-general-ow...@postgresql.org <pgsql-general-ow...@postgresql.org> Gönderildi: 2 Mart 2017 Perşembe 11:27 Kime: pgsql-general@postgresql.org Konu: [GENERAL] column "waiting" does not exist I have no idea what is causing this message in the logs (PostgreSQL 9.6+177.pgdg80+1 on Debian): 2017-03-02 10:20:25 SAST [5196-1] [unknown] postgres postgres@template1 ERROR: column "waiting" does not exist at character 217 2017-03-02 10:20:25 SAST [5196-2] [unknown] postgres postgres@template1 STATEMENT: SELECT tmp.mstate AS state,COALESCE(count,0) FROM (VALUES ('active'),('waiting'),('idle'),('idletransaction'),('unknown')) AS tmp(mstate) LEFT JOIN (SELECT CASE WHEN waiting THEN 'waiting' WHEN state='idle' THEN 'idle' WHEN state LIKE 'idle in transaction%' THEN 'idle$ count(*) AS count FROM pg_stat_activity WHERE pid != pg_backend_pid() AND datname='data_portal' GROUP BY CASE WHEN waiting THEN 'waiting' WHEN state='idle' THEN 'idle' WHEN state LIKE 'idle in transaction%' THEN 'idl$ ) AS tmp2 ON tmp.mstate=tmp2.mstate ORDER BY 1; I do not know whether it is related but we recently get warnings about bloat in our system tables from the monitoring program. How do I fix the cause of this error message? Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)
