Refreshing materialized view fails with "ERROR: value out of range: underflow"

aodn / nrmn-application

A web application for collation, validation, and storage of all data obtained during surveys conducted by the NRMN

GNU General Public License v3.0

4 stars 3 forks source link

Refreshing materialized view fails with "ERROR: value out of range: underflow" #1313

Open craigrose opened 1 year ago

craigrose commented 1 year ago

When trying to restore backup from s3://imos-backups/backups/db1-prod-aws-syd.emii.org.au/pgsql/2023.08.30.00.07.35/nrmn_prod/nrmn.dump the materialized view nrmn.ep_rarity_range fails to create (and refresh) with ERROR: value out of range: underflow.

As a result materialized views that depend on this one will also fail.

This will be a problem if we need to restore the backup.