i have the following problem: i serve raster tiles (jpg / png), loaded into PostgreSQL/PostGIS with raster2pgsql, with Geoserver imagemosaic-jdbc plug-in. Which is working, but from the 25 GB file size the database size is growing to about 383 GB. Mostly the "pg_toast" table, the created table "raster" is only about 60 MB great.
So i read that it is possible to just register the rasters with using the -R flag when importing with raster2pgsql. So i loaded the rasters and published them with Geoserver. But i got the following errors in the log file:
...24 Aug 13:47:08 WARN [imagemosaic.jdbc] - Could not read from stream, switch to JAIException in thread "pool-6-thread-1" java.lang.NullPointerException24 Aug 13:47:08 WARN [imagemosaic.jdbc] - Could not read from stream, switch to JAI at com.sun.media.jai.codec.ImageCodec.getCodec(ImageCodec.java:96) at com.sun.media.jai.codec.ImageCodec.createImageDecoder(ImageCodec.java:208) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.readImage2(ImageDecoderThread.java:187) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.run(ImageDecoderThread.java:121) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)Exception in thread "pool-6-thread-3" Exception in thread "pool-6-thread-2" java.lang.NullPointerException at com.sun.media.jai.codec.ImageCodec.getCodec(ImageCodec.java:96) at com.sun.media.jai.codec.ImageCodec.createImageDecoder(ImageCodec.java:208) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.readImage2(ImageDecoderThread.java:187) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.run(ImageDecoderThread.java:121) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)java.lang.NullPointerException at com.sun.media.jai.codec.ImageCodec.getCodec(ImageCodec.java:96) at com.sun.media.jai.codec.ImageCodec.createImageDecoder(ImageCodec.java:208) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.readImage2(ImageDecoderThread.java:187) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.run(ImageDecoderThread.java:121) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)...My system configuration is:
Either how to minimize the "pg_toast" table or how to fix the geoserver output error?
Kind regards, Christoph
أكثر...
So i read that it is possible to just register the rasters with using the -R flag when importing with raster2pgsql. So i loaded the rasters and published them with Geoserver. But i got the following errors in the log file:
...24 Aug 13:47:08 WARN [imagemosaic.jdbc] - Could not read from stream, switch to JAIException in thread "pool-6-thread-1" java.lang.NullPointerException24 Aug 13:47:08 WARN [imagemosaic.jdbc] - Could not read from stream, switch to JAI at com.sun.media.jai.codec.ImageCodec.getCodec(ImageCodec.java:96) at com.sun.media.jai.codec.ImageCodec.createImageDecoder(ImageCodec.java:208) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.readImage2(ImageDecoderThread.java:187) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.run(ImageDecoderThread.java:121) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)Exception in thread "pool-6-thread-3" Exception in thread "pool-6-thread-2" java.lang.NullPointerException at com.sun.media.jai.codec.ImageCodec.getCodec(ImageCodec.java:96) at com.sun.media.jai.codec.ImageCodec.createImageDecoder(ImageCodec.java:208) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.readImage2(ImageDecoderThread.java:187) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.run(ImageDecoderThread.java:121) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)java.lang.NullPointerException at com.sun.media.jai.codec.ImageCodec.getCodec(ImageCodec.java:96) at com.sun.media.jai.codec.ImageCodec.createImageDecoder(ImageCodec.java:208) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.readImage2(ImageDecoderThread.java:187) at org.geotools.gce.imagemosaic.jdbc.ImageDecoderThread.run(ImageDecoderThread.java:121) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)...My system configuration is:
- Windows 7 Pro
- "PostgreSQL 9.3.5, compiled by Visual C++ build 1600, 64-bit"
- "POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3924" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24 GDAL_DATA not found" LIBXML="2.7.8" LIBJSON="UNKNOWN" TOPOLOGY RASTER"
- Geoserver 2.7.1.1 Standalone.
Either how to minimize the "pg_toast" table or how to fix the geoserver output error?
Kind regards, Christoph
أكثر...