Postgres ERRORS. Filling up disk

Hi!

We noticed that our /db folder was filled up with a lot of 1GB files. folder name: /db/postgresql/10/main/base/16386

I looked at the opennms table and i didn’t see anything strange with table size. Looked ok.
So i wonder where did all those files come from?

I can see a lot of theese errors in our postgres-log.

2021-06-27 03:11:39.498 CEST [19784] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"
2021-06-27 03:11:39.528 CEST [19818] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"
2021-06-27 03:11:39.714 CEST [19789] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"
2021-06-27 03:11:43.985 CEST [19787] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"
2021-06-27 03:11:44.058 CEST [19848] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"
2021-06-27 03:11:44.430 CEST [19790] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"
2021-06-27 03:50:08.735 CEST [20917] opennms@opennms ERROR:  value too long for type character varying(16)
2021-06-27 04:11:39.086 CEST [21551] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"
2021-06-27 04:11:39.171 CEST [21546] opennms@opennms ERROR:  duplicate key value violates unique constraint "ifservices_ipinterfaceid_svc_unique"

OpenNMS 26.1.0
Postgres 10.11-1

That’s over a year old. You should upgrade; this may already be fixed in a newer version.

Hi! We tried to upgrade our test-env > 27.0.0. But we didn’t get it up and running, remember that we had problems with “jetty”. That’s why we don’t do it. And we don’t have any support for it.“Best effort” -_-.

But thanks. Then i know that it would probably be solved by doing an bump.