Hello GIS-Experts,
i am not able to add a store and following create a raster layer with geoserver
using the ImageMosaicJDBC. The caracteristic of my Problem is maybe something
like a time out of my geoserver application. Previously i have to say that the
Problem only occurs if i use the plugin ImageMosaicJDBC.
*My Specifications:*
Windows Server 2012 (64 Bit) - 2,8 Ghz (2 Processors), 64 GB RAM PostgreSQL
9.3.5 (64 Bit) / PostGIS 2.1.4 (64 Bit) Tomcat 8.0.21 (64 Bit)/ Java 7 (64 Bit)
GeoServer 2.7.0 + Image Mosaic JDBC 13.0 Rasterdataset GeoTIFF: 592 Files á 290
MB (sum 165 GB) ...(10. 000 x 10.000
Pixels) 0.2 m x 0.2 pixelsize for every dataset.
I have used gdal_retile and the Import function of Image mosaic jdbc like the
tutorials of this plugin.
Adding a store in the geoserver application with the Special XML-File i wait
nearly one hour. Then the geoserver applications stops reloading/waiting for
the new Formular "add raster layer". In log-files there are NO visible entry
according to this error. Geoserver still abort but not shut down - i can
navigate in the gui. Looking in my postgresql/postgis using pgadmin i see a
Server Status that shows me postgres is not finished selecting the Information
for the Image mosaic jdbc plugin...
*I think the Problem could be the big size of my dataset and the fact that
geoserver can´t wait until the postgres response the Information to this
plugin.*
The postgres working until now using this command, but the geoserver don´t wait
for the response:
select s.location,st_asbinary(st_envelope(s.geom)),s.data from
tile_dop2014rgb_0 s
Has anybody a good idea what i should do know?
By the way - i tested it also on a 32 Bit Server using JAI with only 1 GB of
RAM for the Tomcat.
The 64 Bit Tomcat Server got up to 54 GB because the postgres only need up to
2-4 GB for working.
Here are some other questions for better understanding:
1) Why Image mosaic jdbc calls the full dataset in database using select "all"?
Why not call dataset after dataset - maybe it will solve my Problem for big
datasets?
2) JAI is a nativ Extension for Geoserver: Are there any Relations between
Image mosaic jdbc and JAI? Are there Advantages use JAI with 32 Bit Java 7
counterpart 64 Bit Java 7 without JAI in Geoserver?
Best regards and thanks!!
André Mende
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
