Skip to content

[BUG][Postgis] max phenomenonTime throw exception #192

@mdhsl

Description

@mdhsl

While executing this kind of query: <..>./observations?f=json&phenomenonTime=2026-03-30Z/..

The ending '..' throw an exception:

│ Caused by: org.postgresql.util.PSQLException: ERROR: time zone displacement out of range: "+1000000000-12-31T23:59:59.999999999Z" │ │ Position: 127 │ │ at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2734) │ │ at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2421) │ │ at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372) │ │ at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:518) │ │ at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:435) │ │ at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:357) │ │ at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:342) │ │ at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:318) │ │ at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:267) │ │ at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111) │ │ at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java) │ │ at org.sensorhub.impl.datastore.postgis.builder.ObsIteratorResultSet.makeRequest(ObsIteratorResultSet.java:113) │ │ ... 22 common frames omitted

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions