PostgreSQL pg_largeobject table still contains deleted objects in BPMS/RHPAM

Solution Unverified - Updated -


  • PostgreSQL data keeps increasing. pg_largeobject table is not cleaned up even if process instances are completed.
  • I get the following error after executing vacuumlo.
Caused by: org.hibernate.HibernateException: Unable to access lob stream
    at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(
    at org.hibernate.type.descriptor.sql.BasicExtractor.extract(
Caused by: org.postgresql.util.PSQLException: ERROR: large object 41565 does not exist
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
    at org.postgresql.core.v3.QueryExecutorImpl.receiveFastpathResult(
    at org.postgresql.core.v3.QueryExecutorImpl.fastpathCall(
    at org.postgresql.fastpath.Fastpath.fastpath(


  • Red Hat JBoss BPM Suite (BPMS)
    • 6.3.0
    • 6.4.0
  • Red Hat Process Automation Manager (RHPAM)
    • 7
  • PostgreSQL

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In