PostgreSQL database back-end for JBoss ON includes orphan BLOB entries in its pg_largeobject table after content backed resources are removed from inventory
Issue
- Uninventory of resource leaves behind binary large object (BLOB) entries in PostgreSQL database
- Number of rows in
pg_largeobject
table does not decrease when resource is removed from inventory using Uninventory operation
Environment
- Red Hat JBoss Operations Network (ON) 3.3
- PostgreSQL 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5
- Remove existing resource backed by content or its parent or grandparent resource using the Uninventory child inventory operation
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.