PostgreSQL pg_largeobject table still contains deleted objects in BPMS/RHPAM

Solution Unverified - Updated -

Issue

  • 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.java.DataHelper.extractString(DataHelper.java:285)
    at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:89)
    at org.hibernate.type.descriptor.java.StringTypeDescriptor.wrap(StringTypeDescriptor.java:39)
    at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60)
    at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
        ...
Caused by: org.postgresql.util.PSQLException: ERROR: large object 41565 does not exist
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
    at org.postgresql.core.v3.QueryExecutorImpl.receiveFastpathResult(QueryExecutorImpl.java:672)
    at org.postgresql.core.v3.QueryExecutorImpl.fastpathCall(QueryExecutorImpl.java:501)
    at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:109)

Environment

  • 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