[Dutch] Geoserver vraag ..

[Richard de Bruin]

Hoi allemaal,

Misschien is dit niet de lijst om deze vraag te stellen, maar ik weet dat
een
aantal van jullie ervaring hebben met Geoserver.

We zitten met een 'probleem' (of meer een rarigheid).
We maken gebruik van Geoserver 2.1.4 en op het moment dat we vanuit
Flamingo MC
(en waarschijnlijk ook een ander WFS request doen) gaat Geoserver alle
layers checken
op geometrie.
We maken gebruik van Oracle spatial en hier treed dit dan eenmalig op?
(cache??). Dan gaat
het een tijdje goed totdat je bijv. Geoserver reload of Tomcat herstart.
Op zich is het niet zo erg, alleen het duurt ongeveer een half uur tot drie
kwartier (bijna 1200 layers). En dan reageert Geoserver bijna niet meer.

Iemand hier ervaring mee gehad? Of weet iemand een oplossing?

Bij Geoserver 2.2.2 gebeurt dit gelijk al bij het opstarten van Geoserver.
En duurt het dus een half uur voordat Geoserver in de lucht is.

Wat we zelf al geprobeert hebben is gebruik te maken van een Geometry
metadata table.
Heeft de feature type cache size nog invloed hierop?

Zie bijlage voor een stukje log.

Alvast bedankt :)

Grt,

Richard
------------- volgend deel ------------
Een HTML-bijlage is gescrubt...
URL: <http://lists.osgeo.org/pipermail/dutch/attachments/20121214/03bed624/attachment.html>
------------- volgend deel ------------
2012-12-11 11:18:57,387 DEBUG [org.geotools.jdbc] - Getting information about primary keys of OGV_K10_GRONDWONTTR_P
2012-12-11 11:18:57,387 DEBUG [org.geotools.jdbc] - Grabbing table pk metadata: SELECT OBJECTID FROM GBI.OGV_K10_GRONDWONTTR_P WHERE 0=1
2012-12-11 11:18:57,434 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:18:57,434 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:18:57,434 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.USER_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K10_GRONDWONTTR_P'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' 
2012-12-11 11:18:58,105 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.ALL_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K10_GRONDWONTTR_P'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' AND META.SDO_INDEX_OWNER = 'GBI' 
2012-12-11 11:18:58,651 WARN [org.geotools.jdbc] - Unrecognized geometry type DEFAULT falling back on generic 'GEOMETRY'
2012-12-11 11:18:58,651 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.USER_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K10_GRONDWONTTR_P' AND COLUMN_NAME='SHAPE' 
2012-12-11 11:18:58,651 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K10_GRONDWONTTR_P' AND COLUMN_NAME='SHAPE' AND OWNER='GBI' 
2012-12-11 11:18:58,744 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:18:58,744 INFO [org.geoserver.catalog] - Disposing feature type 'GBI.NAT_HIST_NATDOEL_2002_V'
2012-12-11 11:18:58,744 INFO [org.geoserver.catalog] - Disposing feature type 'GBI.NAT_HIST_NATELEMENTAGGEB_100_V'
2012-12-11 11:18:58,744 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:18:59,025 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:18:59,025 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:18:59,025 DEBUG [org.geotools.jdbc] - Getting information about primary keys of OGV_K10_OPPWATER_MEREN_V
2012-12-11 11:18:59,025 DEBUG [org.geotools.jdbc] - Grabbing table pk metadata: SELECT OBJECTID FROM GBI.OGV_K10_OPPWATER_MEREN_V WHERE 0=1
2012-12-11 11:18:59,041 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:18:59,041 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:18:59,041 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.USER_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K10_OPPWATER_MEREN_V'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' 
2012-12-11 11:18:59,618 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.ALL_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K10_OPPWATER_MEREN_V'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' AND META.SDO_INDEX_OWNER = 'GBI' 
2012-12-11 11:19:00,148 WARN [org.geotools.jdbc] - Unrecognized geometry type DEFAULT falling back on generic 'GEOMETRY'
2012-12-11 11:19:00,148 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.USER_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K10_OPPWATER_MEREN_V' AND COLUMN_NAME='SHAPE' 
2012-12-11 11:19:00,164 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K10_OPPWATER_MEREN_V' AND COLUMN_NAME='SHAPE' AND OWNER='GBI' 
2012-12-11 11:19:00,257 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:00,257 INFO [org.geoserver.catalog] - Disposing feature type 'GBI.NAT_HIST_NATUURBEHPLAN_2011_V'
2012-12-11 11:19:00,257 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:00,523 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:00,538 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:00,538 DEBUG [org.geotools.jdbc] - Getting information about primary keys of OGV_K10_OPPWATER_WATERLOOP_L
2012-12-11 11:19:00,538 DEBUG [org.geotools.jdbc] - Grabbing table pk metadata: SELECT OBJECTID FROM GBI.OGV_K10_OPPWATER_WATERLOOP_L WHERE 0=1
2012-12-11 11:19:00,554 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:00,554 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:00,569 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.USER_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K10_OPPWATER_WATERLOOP_L'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' 
2012-12-11 11:19:01,131 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.ALL_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K10_OPPWATER_WATERLOOP_L'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' AND META.SDO_INDEX_OWNER = 'GBI' 
2012-12-11 11:19:01,646 WARN [org.geotools.jdbc] - Unrecognized geometry type DEFAULT falling back on generic 'GEOMETRY'
2012-12-11 11:19:01,646 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.USER_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K10_OPPWATER_WATERLOOP_L' AND COLUMN_NAME='SHAPE' 
2012-12-11 11:19:01,646 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K10_OPPWATER_WATERLOOP_L' AND COLUMN_NAME='SHAPE' AND OWNER='GBI' 
2012-12-11 11:19:01,786 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:01,786 INFO [org.geoserver.catalog] - Disposing feature type 'GBI.NAT_HIST_NATUURGEBPLAN02_V'
2012-12-11 11:19:01,786 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:02,067 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:02,067 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:02,067 DEBUG [org.geotools.jdbc] - Getting information about primary keys of OGV_K11_GEBGERICHT_GWBEHEER_V
2012-12-11 11:19:02,067 DEBUG [org.geotools.jdbc] - Grabbing table pk metadata: SELECT OBJECTID FROM GBI.OGV_K11_GEBGERICHT_GWBEHEER_V WHERE 0=1
2012-12-11 11:19:02,083 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:02,083 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:02,098 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.USER_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K11_GEBGERICHT_GWBEHEER_V'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' 
2012-12-11 11:19:02,941 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.ALL_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K11_GEBGERICHT_GWBEHEER_V'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' AND META.SDO_INDEX_OWNER = 'GBI' 
2012-12-11 11:19:03,471 WARN [org.geotools.jdbc] - Unrecognized geometry type DEFAULT falling back on generic 'GEOMETRY'
2012-12-11 11:19:03,487 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.USER_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K11_GEBGERICHT_GWBEHEER_V' AND COLUMN_NAME='SHAPE' 
2012-12-11 11:19:03,518 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K11_GEBGERICHT_GWBEHEER_V' AND COLUMN_NAME='SHAPE' AND OWNER='GBI' 
2012-12-11 11:19:03,767 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:03,767 INFO [org.geoserver.catalog] - Disposing feature type 'GBI.NAT_HIST_NATUURGEBPLAN03_V'
2012-12-11 11:19:03,767 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:05,530 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:05,530 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:05,546 DEBUG [org.geotools.jdbc] - Getting information about primary keys of OGV_K11_GRONDW_BESCH_DRAA_L
2012-12-11 11:19:05,608 DEBUG [org.geotools.jdbc] - Grabbing table pk metadata: SELECT OBJECTID FROM GBI.OGV_K11_GRONDW_BESCH_DRAA_L WHERE 0=1
2012-12-11 11:19:05,733 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:05,733 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:05,749 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.USER_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K11_GRONDW_BESCH_DRAA_L'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' 
2012-12-11 11:19:07,699 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.ALL_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K11_GRONDW_BESCH_DRAA_L'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' AND META.SDO_INDEX_OWNER = 'GBI' 
2012-12-11 11:19:09,056 WARN [org.geotools.jdbc] - Unrecognized geometry type DEFAULT falling back on generic 'GEOMETRY'
2012-12-11 11:19:09,056 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.USER_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K11_GRONDW_BESCH_DRAA_L' AND COLUMN_NAME='SHAPE' 
2012-12-11 11:19:09,056 DEBUG [org.geotools.jdbc] - SRID check; SELECT SRID FROM MDSYS.ALL_SDO_GEOM_METADATA WHERE TABLE_NAME='OGV_K11_GRONDW_BESCH_DRAA_L' AND COLUMN_NAME='SHAPE' AND OWNER='GBI' 
2012-12-11 11:19:09,259 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:09,259 INFO [org.geoserver.catalog] - Disposing feature type 'GBI.NAT_HIST_NATUURGEBPLAN05_V'
2012-12-11 11:19:09,259 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:09,633 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:09,633 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:09,633 DEBUG [org.geotools.jdbc] - Getting information about primary keys of OGV_K11_GRONDW_BESCH_V
2012-12-11 11:19:09,649 DEBUG [org.geotools.jdbc] - Grabbing table pk metadata: SELECT OBJECTID FROM GBI.OGV_K11_GRONDW_BESCH_V WHERE 0=1
2012-12-11 11:19:09,664 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2012-12-11 11:19:09,664 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2012-12-11 11:19:09,664 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO
INNER JOIN MDSYS.USER_SDO_INDEX_METADATA META
ON INFO.INDEX_NAME = META.SDO_INDEX_NAME
WHERE INFO.TABLE_NAME = 'OGV_K11_GRONDW_BESCH_V'
AND REPLACE(meta.sdo_column_name, '"') = 'SHAPE'
 AND INFO.TABLE_OWNER = 'GBI' 
2012-12-11 11:19:10,226 DEBUG [org.geotools.jdbc] - Geometry type check; SELECT META.SDO_LAYER_GTYPE
FROM ALL_INDEXES INFO