#2170·clair

Clair Postgres database storage space issue

Author: Mkori1Created Nov 12, 2024Updated Nov 13, 2024

Description of Problem / Feature Request

Postgres Storage :1800 GiB Clair Postgres database storage space gets full in 1 week span and then suddenly storage space is freed around 1TB. This happens every week storage gets full and suddenly freed up at once. Screenshot 2024-11-12 at 12 49 46 PM

Garbage collection is running daily.

Need to understand why storage space is getting full and GC is not able to clean up the space.

Environment: clair:4.7.2 Combo Mode

config.yaml introspection_addr: :8089 http_listen_addr: :8080 log_level: debug indexer: connstring: XXX scanlock_retry: 10 layer_scan_concurrency: 5 migrations: true matcher: connstring: XXX migrations: true update_retention: 2 period: matchers: names:

  • alpine
  • aws
  • debian
  • oracle
  • photon
  • python
  • rhel
  • suse
  • ubuntu updaters: sets:
  • alpine
  • aws
  • debian
  • oracle
  • photon
  • pyupio
  • rhel
  • suse
  • ubuntu notifier: connstring: XXX delivery_interval: 1m poll_interval: 5m migrations: true auth: psk: key: XXX iss: ["quay"]

tracing and metrics

trace: name: "jaeger" probability: 1 jaeger: agent: endpoint: "localhost:6831" service_name: "clair" metrics: name: "prometheus"