search

wizkid057 / wizstats

Optimized Bitcoin Mining Pool Web Stats
GNU Affero General Public License v3.0
80 stars 56 forks source link

Warning: pg_exec(): Query failed: ERROR: column "current_query" does not exist LINE 1: ...ect count(*) as check from pg_stat_activity where current_qu... ^ in instant_livedata.php on line 126 #65

Open encorehu opened 10 years ago

encorehu commented 10 years ago

Warning: pg_exec(): Query failed: ERROR: column "current_query" does not exist LINE 1: ...ect count(*) as check from pg_stat_activity where current_qu... ^ in instant_livedata.php on line 126

this is because current_query changed from postgresql 9.2, now i use postgresql 9.3, this appeared.

https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2

pg_stat_activity and pg_stat_replication's definitions have changed

The view pg_stat_activity has changed. It's not backward compatible, but let's see what this new definition brings us:

current_query disappears and is replaced by two columns:
state: is the session running a query, waiting
query: what is the last run (or still running if stat is "active") query