1.1 --- a/doc/notes/zrq/20190508-01-vmdown-debug.txt	Thu May 09 05:34:15 2019 +0100
     1.2 +++ b/doc/notes/zrq/20190508-01-vmdown-debug.txt	Thu May 09 05:51:40 2019 +0100
     1.3 @@ -1399,12 +1399,12 @@
     1.4  
     1.5  
     1.6  
     1.7 -# -----------------------------------------------------
     1.8 -# Service is working and responding to simple queries ...
     1.9 -#[user@virtual]
    1.10 +    #
    1.11 +    # Service is working and responding to simple queries ...
    1.12 +    #
    1.13  
    1.14      #
    1.15 -    # Requesting list of queries for the main resource causes an Exception.
    1.16 +    # Requesting the large (171,174) list of queries for the main resource causes an Exception.
    1.17      # http://tap.roe.ac.uk/firethorn/adql/resource/54/queries/select
    1.18  
    1.19  --START--
    1.20 @@ -1443,3 +1443,41 @@
    1.21  	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
    1.22  --END--
    1.23  
    1.24 +
    1.25 +    #
    1.26 +    # Login to the postgresql tapschema database didn't seem to find anything.
    1.27 +    #
    1.28 +
    1.29 +    \dt
    1.30 +
    1.31 +--START--
    1.32 +Did not find any relations.
    1.33 +--END--
    1.34 +
    1.35 +    #
    1.36 +    # But these resources all work.
    1.37 +    #
    1.38 +
    1.39 +    http://tap.roe.ac.uk/firethorn/jdbc/column/65220
    1.40 +
    1.41 +        {"type":"http://data.metagrid.co.uk/wfau/firethorn/types/entity/jdbc-column-1.0.json","meta":{"jdbc":{"type":"INTEGER","size":0},"adql":{"ucd":null,"utype":null,"arraySize":0,"units":null,"type":"INTEGER"}},"base":"http://tap.roe.ac.uk/firethorn/jdbc/column/65220","fullname":"postgres.TAP_SCHEMA_54.columns.ts_column_id","depth":"FULL","parent":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378","root":"http://tap.roe.ac.uk/firethorn/jdbc/column/65220","table":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378","text":null,"name":"ts_column_id","owner":"http://tap.roe.ac.uk/firethorn/community-member/163","ident":"65220","created":"2018-12-12T19:16:03.468","modified":"2018-12-12T19:16:03.469","url":"http://tap.roe.ac.uk/firethorn/jdbc/column/65220","self":"http://tap.roe.ac.uk/firethorn/jdbc/column/65220"}
    1.42 +
    1.43 +    http://tap.roe.ac.uk/firethorn/jdbc/table/58378
    1.44 +
    1.45 +        {"type":"http://data.metagrid.co.uk/wfau/firethorn/types/entity/jdbc-table-1.0.json","formats":{"datatable":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378/datatable","votable":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378/votable"},"metadata":{"jdbc":{"count":-1,"status":"CREATED","type":"TABLE"},"adql":{"count":-1,"status":"CREATED"}},"query":null,"schema":"http://tap.roe.ac.uk/firethorn/jdbc/schema/546","base":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378","fullname":"postgres.TAP_SCHEMA_54.columns","depth":"FULL","columns":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378/columns/select","resource":"http://tap.roe.ac.uk/firethorn/jdbc/resource/55","parent":"http://tap.roe.ac.uk/firethorn/jdbc/schema/546","root":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378","text":null,"name":"columns","owner":"http://tap.roe.ac.uk/firethorn/community-member/163","ident":"58378","created":"2018-12-12T19:16:03.129","modified":"2018-12-12T19:16:03.129","url":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378","self":"http://tap.roe.ac.uk/firethorn/jdbc/table/58378"}
    1.46 +
    1.47 +    http://tap.roe.ac.uk/firethorn/jdbc/schema/546
    1.48 +
    1.49 +        {"type":"http://data.metagrid.co.uk/wfau/firethorn/types/entity/jdbc-schema-1.0.json","tables":"http://tap.roe.ac.uk/firethorn/jdbc/schema/546/tables/select","base":"http://tap.roe.ac.uk/firethorn/jdbc/schema/546","fullname":"postgres.TAP_SCHEMA_54","depth":"FULL","resource":"http://tap.roe.ac.uk/firethorn/jdbc/resource/55","parent":"http://tap.roe.ac.uk/firethorn/jdbc/resource/55","root":"http://tap.roe.ac.uk/firethorn/jdbc/schema/546","text":null,"name":"postgres.TAP_SCHEMA_54","owner":"http://tap.roe.ac.uk/firethorn/community-member/163","ident":"546","created":"2018-12-12T19:16:02.756","modified":"2018-12-12T19:16:02.756","url":"http://tap.roe.ac.uk/firethorn/jdbc/schema/546","self":"http://tap.roe.ac.uk/firethorn/jdbc/schema/546"}
    1.50 +
    1.51 +    http://tap.roe.ac.uk/firethorn/jdbc/resource/55
    1.52 +
    1.53 +        {"type":"http://data.metagrid.co.uk/wfau/firethorn/types/entity/jdbc-resource-1.0.json","connection":{"pass":"########","uri":"jdbc:postgresql://carolina:5432/postgres","user":"ieW7oomei7Laebuu9Ax7"},"schemas":"http://tap.roe.ac.uk/firethorn/jdbc/resource/55/schemas/select","fullname":"TAP_RESOURCE_54","queries":"http://tap.roe.ac.uk/firethorn/jdbc/resource/55/queries/select","text":null,"name":"TAP_RESOURCE_54","owner":"http://tap.roe.ac.uk/firethorn/community-member/163","ident":"55","created":"2018-12-12T19:16:02.316","modified":"2018-12-12T19:16:02.317","url":"http://tap.roe.ac.uk/firethorn/jdbc/resource/55","self":"http://tap.roe.ac.uk/firethorn/jdbc/resource/55"}
    1.54 +
    1.55 +    #
    1.56 +    # Including votable of the JdbcTable.
    1.57 +    # ** takes time for FireFox to render, but curl is instant.
    1.58 +
    1.59 +    http://tap.roe.ac.uk/firethorn/jdbc/table/58378/votable
    1.60 +
    1.61 +