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

vacuumlo deletes active large objects of jBPM CLOB data

    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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  swiderski.maciej Maciej Swiderski
                  Reporter:
                  tkobayashi Toshiya Kobayashi
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: