× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
joefromct reported 2017-09-05T18:08:30Z  · tomconrad last modified 2017-09-11T15:08:47Z

postgres9.6 - dba tools -> session manager has invalid sql; no column "waiting" anymore


customer request
Priority Low
Complexity Trivial
Component DB - PostgreSQL
Version 18.0

Versions:  ADS v 18.0.17
Postgresql:  9.6

 

How to reproduce:

Connect to a postgres version 9.6 database.

Right click on the database, select DBA Tools  then Session Manager.  (Nothing happens)

If you open the sql log while opening the session manager, you can see the exception issued by the ADS generated sql.  It looks for a column called waiting which no longer exists in the pg_stat_activity view in PG 9.6.  See here .

SELECT pid, datid, datname, usesysid, usename , query, client_addr, client_port, query_start, backend_start, waiting, xact_start, state FROM pg_catalog.pg_stat_activity

 

org.postgresql.util.PSQLException: ERROR: column "waiting" does not exist
  Position: 110
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2153)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:286)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305)
    at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:269)
    at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:236)
 
    at java.lang.Thread.run(Thread.java:748)
 

 

 

Issue #15460

Closed
Fixed
Resolved 2017-09-06T17:12:11Z
 
 
Completion
No due date
Fixed Build ADS 18.0.18-10
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017