Custom query (1090 matches)

r105556:

maybe related to version upgrade, maybe related to new larger CBD osm file extract (should I shrink the area now that there is more detail?)

Setting up osm2pgrouting (2.0.0-beta-ppa4) ...
create pgrouting database with PostGIS and pgRouting
CREATE EXTENSION
CREATE EXTENSION
unpack sample data
Run osm2pgrouting converter (this may take a while)
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes"
2create ways failed: 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "types_pkey" for table "types"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "classes_pkey" for table "classes"
ERROR:  value "45028" is out of range for type smallint
CONTEXT:  COPY nodes, line 115830, column numofuse: "45028"
NOTICE:  table "vertices_tmp" does not exist, skipping
CONTEXT:  SQL statement "DROP TABLE IF EXISTS vertices_tmp"
PL/pgSQL function "pgr_createtopology" line 44 at SQL statement
NOTICE:  CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id"
CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id bigserial)"
PL/pgSQL function "pgr_createtopology" line 45 at SQL statement
NOTICE:  0 out of 21142 edges processed
NOTICE:  10000 out of 21142 edges processed
NOTICE:  20000 out of 21142 edges processed
VACUUM

Hamish

Hi,

a number of errors come back for cartaro and geonode in the build logs, apparently connected to geoserver.

86295:ERROR:  database "cartaro" does not exist
86296:ERROR:  role "cartaro" does not exist
86585:31 Jul 20:23:12 ERROR [geoserver.rest] - No such workspace: cartaro
86586:31 Jul 20:23:12 ERROR [geoserver.rest] - 
86670:31 Jul 20:23:12 ERROR [geoserver.rest] - No such datastore: cartaro,cartaro
86671:31 Jul 20:23:12 ERROR [geoserver.rest] - 
86757:31 Jul 20:23:27 ERROR [geoserver.rest] - No such feature type: cartaro,cartaro,capitals
86758:31 Jul 20:23:27 ERROR [geoserver.rest] - 
86843:org.postgresql.util.PSQLException: ERROR: permission denied for relation geography_columns
86946:WD mail: Error sending e-mail (from admin@example.com to             ESC[31;40mESC[1m[error]ESC[0m
86949:Unable to send e-mail. Contact the site administrator if the problem ESC[31;40mESC[1m[error]ESC[0m
86974:31 Jul 20:23:51 WARN [support.DisposableBeanAdapter] - Invocation of destroy method failed on bean with name 'geoServerLoader': org.springframework.beans.factory.BeanCreationNotAllowed
Exception: Error creating bean with name 'GWCLifeCycleHandler': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a Bean
Factory in a destroy method implementation!)
87663:checking if bus error on unaligned pointers... no
93059:Copying '/usr/lib/python2.7/dist-packages/geoexplorer/static/geoexplorer/externals/ext/resources/images/default/window/icon-error.gif'
93196:Copying '/usr/lib/python2.7/dist-packages/geoexplorer/static/geoexplorer/externals/ext/resources/images/default/form/error-tip-corners.gif'
93261:Copying '/usr/lib/python2.7/dist-packages/geoexplorer/static/geoexplorer/externals/ext/resources/images/gray/window/icon-error.gif'
93766:org.postgresql.util.PSQLException: ERROR: permission denied for relation geography_columns
95424:31 Jul 20:39:48 ERROR [geoserver.ows] - 
95500:31 Jul 20:39:49 ERROR [geoserver.ows] - 
95576:31 Jul 20:39:49 ERROR [geoserver.ows] - 
95652:31 Jul 20:39:49 ERROR [geoserver.ows] - 
96469:31 Jul 20:40:25 ERROR [geoserver.ows] - 
96545:31 Jul 20:40:25 ERROR [geoserver.ows] - 
96868:31 Jul 20:40:41 ERROR [geoserver.ows] - 
96944:31 Jul 20:40:41 ERROR [geoserver.ows] - 
97267:31 Jul 20:40:57 ERROR [geoserver.ows] - 
97343:31 Jul 20:40:57 ERROR [geoserver.ows] - 
97666:31 Jul 20:41:14 ERROR [geoserver.ows] - 
97742:31 Jul 20:41:14 ERROR [geoserver.ows] - 
98065:31 Jul 20:41:32 ERROR [geoserver.ows] - 
98141:31 Jul 20:41:32 ERROR [geoserver.ows] - 
org.geoserver.platform.ServiceException: No service: ( WPS )
98726:31 Jul 20:41:53 ERROR [geoserver.ows] - 
98848:31 Jul 20:41:55 ERROR [geoserver.ows] - 
98948:31 Jul 20:41:55 ERROR [geoserver.ows] - 
99122:31 Jul 20:42:00 ERROR [geoserver.ows] - 
99244:31 Jul 20:42:00 ERROR [geoserver.ows] - 
99344:31 Jul 20:42:00 ERROR [geoserver.ows] - 
99518:31 Jul 20:42:04 ERROR [geoserver.ows] - 
99640:31 Jul 20:42:05 ERROR [geoserver.ows] - 
99740:31 Jul 20:42:05 ERROR [geoserver.ows] - 
99914:31 Jul 20:42:10 ERROR [geoserver.ows] - 
100036:31 Jul 20:42:10 ERROR [geoserver.ows] - 
100136:31 Jul 20:42:10 ERROR [geoserver.ows] - 
100800:31 Jul 20:42:48 ERROR [gce.arcgrid] - 
100951:31 Jul 20:42:49 ERROR [geoserver.ows] - 
101051:31 Jul 20:42:49 ERROR [geoserver.ows] - 
101234:31 Jul 20:43:04 ERROR [gce.arcgrid] - 
101385:31 Jul 20:43:04 ERROR [geoserver.ows] - 
101485:31 Jul 20:43:05 ERROR [geoserver.ows] - 
101668:31 Jul 20:43:13 ERROR [gce.arcgrid] - 
101819:31 Jul 20:43:13 ERROR [geoserver.ows] - 
101919:31 Jul 20:43:14 ERROR [geoserver.ows] - 
102102:31 Jul 20:43:24 ERROR [gce.arcgrid] - 
org.geoserver.ows.ClientStreamAbortedException
102253:31 Jul 20:43:25 ERROR [geoserver.ows] - 
102353:31 Jul 20:43:25 ERROR [geoserver.ows] - 
102525:31 Jul 20:43:28 ERROR [geoserver.ows] - 
102625:31 Jul 20:43:28 ERROR [geoserver.ows] - 
102821:31 Jul 20:43:33 ERROR [geoserver.ows] - 
102921:31 Jul 20:43:33 ERROR [geoserver.ows] - 
103117:31 Jul 20:43:37 ERROR [geoserver.ows] - 
103217:31 Jul 20:43:37 ERROR [geoserver.ows] - 
103413:31 Jul 20:43:41 ERROR [geoserver.ows] - 
103513:31 Jul 20:43:41 ERROR [geoserver.ows] - 
103626:org.postgresql.util.PSQLException: ERROR: permission denied for relation geography_columns
103799:org.postgresql.util.PSQLException: ERROR: permission denied for relation geography_columns
103905:31 Jul 20:43:46 ERROR [geoserver.rest] - No such style: capital
103906:31 Jul 20:43:46 ERROR [geoserver.rest] - 
104032:31 Jul 20:43:47 WARN [support.DisposableBeanAdapter] - Invocation of destroy method failed on bean with name 'geoServerLoader': org.springframework.beans.factory.BeanCreationNotAllowedException: Error creating bean with name 'GWCLifeCycleHandler': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!)

see the full build log for details.

​http://aiolos.survey.ntua.gr/gisvm/dev/

Group icons for Web Clients and Crisis Management are missing since we removed KDE libs.