ImageMosaic out of sync with PostGIS index requiring resource cache clear

Description

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?

***should be: "some_field_2015090300+1900.tiff"

Environment

Centos 6.7, Ubuntu 14.04, tomcat 6, tomcat 7, oracle java 7, oracle java8

Assignee

Unassigned

Reporter

Maciej Filocha

Triage

None

Fix versions

None

Affects versions

Components

Priority

Medium
Configure