[Geoserver-devel] [JIRA] (GEOS-7287) ImageMosaic + PostGIS query returns wrong file names

[Maciej Filocha (JIRA)]

Title: Message Title

Maciej Filocha created an issue   GeoServer / GEOS-7287 ImageMosaic + PostGIS query returns wrong file names Issue Type: Bug Affects Versions: 2.8.0 Assignee: Unassigned Components: PostGIS Created: 29/Oct/15 4:03 PM Environment: Centos 6.7, Ubuntu 14.04, tomcat 6, tomcat 7, oracle java 7, oracle java8 Priority: Medium Reporter: Maciej Filocha My set-up consists of several ImageMosaic stores with PostGIS data store. Two dimensions are defined - a "time" and a "forecast". All stores are updated every hour with many new geotiffs. After about two days of runtime Geoserver starts to show wrong pictures instead of expected "forecast" value, it uses value taken about 15-20 steps (hours) earlier. Moreover, all next requests are shifted the same amount of hours (offset) back. I found that something happens after the ImageMosaic queries PostGIS about a file name. In the following example, the query itself looks correct, but file name reported in log is obviously wrong - "0100" (forecast "100") instead of "1900". I believe that PostGIS table is correct. The same query asked manually returns proper name. The only workaround I know is to clear resource cache in Geoserver - from that on everything works perfectly (since next failure after one or two days). That looks like Geoserver starts to use some old (cached) responses or old connections to the database? 2015-09-03 07:13:24,891 DEBUG [geotools.jdbc] - SELECT "fid",encode(ST_AsEWKB("the_geom"),'base64') as "the_geom","location","time","forecast" FROM "public"."UM1_HIGH_CLOUD_AMOUNT" WHERE ("the_geom" && ST_GeomFromWKB(?, 100101 ) AND "time" <= ? AND "time" IS NOT NULL AND "time" >= ? AND "forecast" = ? AND "forecast" IS NOT NULL ) 2015-09-03 07:13:24,891 DEBUG [geotools.jdbc] - 1 = POLYGON ((-1.7600189734073737 -3.7571876107040336, -1.7600189734073737 0.1875907849611185, 2.287338214041183 0.1875907849611185, 2.287338214041183 -3.7571876107040336, -1.7600 189734073737 -3.7571876107040336)) 2015-09-03 07:13:24,891 DEBUG [geotools.jdbc] - 2 = 2015-09-03 00:00:00.999 2015-09-03 07:13:24,891 DEBUG [geotools.jdbc] - 3 = 2015-09-03 00:00:00.0 2015-09-03 07:13:24,891 DEBUG [geotools.jdbc] - 4 = 1900 2015-09-03 07:13:24,892 DEBUG [gce.imagemosaic] - Trying to resolve path: type:RELATIVE parentLocation:file:some_directory location:some_field_2015090300+0100.tiff ***should be: "some_field_2015090300+1900.tiff" Add Comment   This message was sent by Atlassian JIRA (v7.0.0-OD-08-002#70107-sha1:3f098e8)

------------------------------------------------------------------------------

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel