Bug 988800 - cannot access postgres 9.2 internal statistics
Summary: cannot access postgres 9.2 internal statistics
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Plugins
Version: 4.8
Hardware: x86_64
OS: Linux
unspecified
high
Target Milestone: ---
: RHQ 4.11
Assignee: Thomas Segismont
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On:
Blocks: 1073990
TreeView+ depends on / blocked
 
Reported: 2013-07-26 12:37 UTC by Heidrich Attila
Modified: 2014-07-21 10:13 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
: 1073990 (view as bug list)
Environment:
Last Closed: 2014-07-21 10:13:29 UTC
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1079361 0 unspecified CLOSED Postgres Plugin - Scheduling A New List Process Statistics Operation Fails 2021-02-22 00:41:40 UTC

Internal Links: 1079361

Description Heidrich Attila 2013-07-26 12:37:31 UTC
Description of problem:
postgres statistics cannot be retrieved from 9.2 server.

Version-Release number of selected component (if applicable):
RHQ is 4.8 "factory" version, no elements has been changed over the distribution

How reproducible:
just use the postgresql server plugin

Steps to Reproduce:
1. inventory a postgres server (server version should be 9.2)
2. look at the metrics
3. say "wow!"

Actual results:
any data but "active backend" results "no-data" or something unusable (1119% for the CPU usage and 99GB for Virtual memory usage)

Expected results:
pls look at the attached screenshot

Additional info:

http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.2#pg_stat_activity_and_pg_stat_replication.27s_definitions_have_changed

org.postgresql.util.PSQLException: ERROR: column "current_query" does not exist
  Position: 41
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
	at org.rhq.plugins.postgres.PostgresServerComponent.invokeOperation(PostgresServerComponent.java:361)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocationThread.call(ResourceContainer.java:634)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:724)

Comment 1 Thomas Segismont 2014-04-04 08:19:39 UTC
(In reply to Heidrich Attila from comment #0)

> pls look at the attached screenshot

Can you actually attach the screenshot?

> org.postgresql.util.PSQLException: ERROR: column "current_query" does not
> exist
>   Position: 41
> 	at
> org.postgresql.core.v3.QueryExecutorImpl.
> receiveErrorResponse(QueryExecutorImpl.java:2157)
> 	at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.
> java:1886)
> 	at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> 	at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.
> java:555)
> 	at
> org.postgresql.jdbc2.AbstractJdbc2Statement.
> executeWithFlags(AbstractJdbc2Statement.java:403)
> 	at
> org.postgresql.jdbc2.AbstractJdbc2Statement.
> executeQuery(AbstractJdbc2Statement.java:283)
> 	at
> org.rhq.plugins.postgres.PostgresServerComponent.
> invokeOperation(PostgresServerComponent.java:361)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.
> java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at
> org.rhq.core.pc.inventory.ResourceContainer$ComponentInvocationThread.
> call(ResourceContainer.java:634)
> 	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> 	at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:
> 1145)
> 	at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:
> 615)
> 	at java.lang.Thread.run(Thread.java:724)


This stacktrace is the result of the "List Process Statistics" operation invocation. This problem is tracked by Bug 1079361 and is fixed in master (see https://bugzilla.redhat.com/show_bug.cgi?id=1079361#c1)

Comment 2 Thomas Segismont 2014-05-07 14:31:07 UTC
Fixed in master master (see Bug 1079361 Comment 1)

Comment 3 Heiko W. Rupp 2014-07-21 10:13:29 UTC
Bulk closing of RHQ 4.11 issues, now that RHQ 4.12 is out.

If you find an issue with those, please open a new BZ, linking to the old one.


Note You need to log in before you can comment on or make changes to this bug.