Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-5476

vacuumlo deletes active large objects of jBPM CLOB data

XMLWordPrintable

      If you use PostgreSQL with jBPM, pg_largeobject table keeps increasing even after process instances are completed. In order to delete orphaned (= unused) large objects, you need to run vacuumlo tool (https://www.postgresql.org/docs/9.4/static/vacuumlo.html).

      vacuumlo analyzes database to find orphaned large objects. But it only looks at 'oid' columns. In jBPM, there are 'text' columns which hold large objects. In Java codes, they are String @Lob fields which are considered as "CLOB". These 'text' columns are not analyzed so vacuumlo could delete non-orphaned (= active) large objects.

              swiderski.maciej Maciej Swiderski (Inactive)
              rhn-support-tkobayas Toshiya Kobayashi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: