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

vacuumlo deletes active large objects of jBPM CLOB data

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: