Re: ERROR: column "current_query" does not exist
Could you please create a bug in our bugzilla
(https://bugzilla.redhat.com/enter_bug.cgi?product=RHQ%20Project)?
It seems like our plugin doesn't support postgres 9.2...
Something very similar was discussed yesterday on our IRC channel. Do you think the
conversation describes the same problem as you are having?
<rav1ne> hello
<rav1ne> we are new to rhq
<rav1ne> and have a small problem atm
<rav1ne> with psql 9.2
<rav1ne> in the logs:
<rav1ne> CEST STATEMENT: SELECT (SELECT COUNT(*) FROM pg_stat_activity where
usename = $1 AND current_query != '<IDLE>') AS active, (SELECT
COUNT(*) FROM pg_stat_activity WHERE usename = $2) AS total
<rav1ne> there is no current_query column in psql 9.2
<rav1ne> so probably it's a compatibility problem
<rav1ne> is it known?
<rav1ne> can we fix it somehow?
<jkremser> rav1ne, it looks like it was changed in Postgres 9.2
(http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#pg_stat_...),
We currently support Postgres 9.1 (feel free to raise a bug for it
https://bugzilla.redhat.com/enter_bug.cgi?product=RHQ%20Project)
<jkremser> fast fix would be downgrade to Postgres 9.1
<rav1ne> hm i see
<rav1ne> i thought 4.8 is compatible with 9.2
<-- crobson (~crobson@redhat/jboss/crobson) has quit (Quit: Computer has gone to
sleep.)
<rav1ne> one other thing: on postgres Monitoring tab
<pilhuhn> jkremser we support 9.2 as backend database
<rav1ne> the "postgres - CPU percentage" graph shows 1119% usage
<pilhuhn> that query most likely comes from monitoring postgres and the postgres
plugin
<jkremser> oh
<rav1ne> yep, monitoring
<pilhuhn> rav1ne as jkremser said, please open BZ issue(s) for that ( and if
possible, supply a patch :-> )
----- Original Message -----
From: "Attila Heidrich" <attila.heidrich(a)gmail.com>
To: rhq-users(a)lists.fedorahosted.org
Sent: Friday, July 26, 2013 11:06:59 AM
Subject: ERROR: column "current_query" does not exist
It's me again... :)
When trying to manage Pg 9.2, we constantly have the above message.
Is there
any easy way to get rid oh these?
There's also another problem with the postgres plugin (I guess).
After a Pg crash (log filesystem full) and recovery, the Pg process
data is
not collected at all. Database metrics are OK, but process metrics gone mad.
CPU percentage and Virtual memory shows some theoretical maximum, the
others
shows "no data".
Regards,
Attila
_______________________________________________
rhq-users mailing list
rhq-users(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/rhq-users