Aqua Data Studio: 19.0.0-alpha-14
Build #: 54482
Build Date: 2017-May-24 07:13:31 PM
Operating Environment: Linux (4.4.0-78-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_102-b14
Memory: Max=9,093,251,072; Total=1,865,416,704; Free=1,717,624,144; CPUs=8
Connect PostgreSQL9.6
PostgreSQL DBA Tool -> Session Manager gives column "waiting" does not exist exception.
1. Open PostgreSQL DBA Tool and select the Session Manager
2. You get the below exception.
In view log
org.postgresql.util.PSQLException: ERROR: column "waiting" does not exist
Position: 110
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:231)
at \\.\\.\\हिñçêČάй語简�?한\\.xᡯᠩꐗꂷcase.executeQuery(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.n7ꉬꋗͥ.executeQuery(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Nꄠꁽᡷꂔassert.k(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Nꄠꁽᡷꂔassert.aB(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.uꆿ⠷ꉱꑑintfinally.x(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.u⠺ꊌꅂꀙlongprotected.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)
Please refer screenshot session_mang.png
Observation:
-
Working fine for PostgreSQL9.5 and below versions.
-
This issue occurs in ADS v17 and ADS v18
Another scenario that ran into the same error is:
1. Expand a server node that connects to PostgreSQL v9.6 in the schema browser.
2. Expand the Management node.
3. Expand the Current Activity node.
4. Click "Detail" tab to open Detail view.
5. Click the Process Info node. The Detail view is empty and PSQLException is logged.
Both DBA Tool -> Session Manager and Process Info Detail View have been fixed.