firethorn
changeset 4216:57acf41bcc1c
....
author | Dave Morris <dmr@roe.ac.uk> |
---|---|
date | Thu May 09 05:51:40 2019 +0100 (2019-05-09) |
parents | 373d1a1f0078 |
children | 9e5d4e98967f |
files | doc/notes/zrq/20190508-01-vmdown-debug.txt |
line diff
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 +