Обсуждение: [GENERAL] After upgrade to 9.6: waiting column does not exist
postgres@template1 ERROR: column "waiting" does not exist at character 217
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.
--
my lips will praise you. (Psalm 63:3)
Now, when running the 9.6 server the following error message shows up regularly in the log:As far as I understand the following remark in the release notes, the column 'waiting' should not exist:
postgres@template1 ERROR: column "waiting" does not exist at character 217
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
Also It would help to modify your log line prefix (log_line_prefix) to include client's address, PID, and application name.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:As far as I understand the following remark in the release notes, the column 'waiting' should not exist:
postgres@template1 ERROR: column "waiting" does not exist at character 217
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
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
On 09/12/2016 10:04, John R Pierce wrote: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
Also It would help to modify your log line prefix (log_line_prefix) to include client's address, PID, and application name.
my lips will praise you. (Psalm 63:3)