On 12/8/2016 11:59 PM, Johann Spies
wrote:
Now, when running the 9.6 server the following error message
shows up regularly in the log:
postgres@template1 ERROR: column "waiting" does not exist at
character 217
As far as I understand the following remark in the release notes,
the column 'waiting' should not exist:
-
Improve the pg_stat_activity
view's information about what a process is waiting for
(Amit Kapila, Ildus Kurbangaliev)
Historically a process has only been shown as waiting if
it was waiting for a heavyweight lock. Now waits for
lightweight locks and buffer pins are also shown in pg_stat_activity. Also,
the type of lock being waited for is now visible. These
changes replace the waiting
column with wait_event_type
and wait_event.
How do I correct this?
are you running some sort of monitoring software thats
periodically looking at pg_stat_activity ? whatever query its
doing needs to be rewritten to take into account the
pg_stat_activity changes in 9.6
--
john r pierce, recycling bits in santa cruz
