Uploaded image for project: 'Kogito'
  1. Kogito
  2. KOGITO-5310

BPMN persistence broken on PostgreSQL

    XMLWordPrintable

Details

    • False
    • False
    • Undefined

    Description

      During my test run of PostgreSQL persistence I've noticed that it's broken. Problem exists when there is an update of process payload during instance life.

      Insertion of process instance seems to work fine:

      2021-06-11 14:01:16 UTC [183] LOG: duration: 1.043 ms execute <unnamed>: INSERT INTO process_instances (id, payload, process_id) VALUES ($1, $2, $3)
      2021-06-11 14:01:16 UTC [183] DETAIL: parameters: $1 = 'b0ac44e3-efab-45fa-b29d-de7610ab2e25', $2 = '\xSOMEHEXCONTENTHERE', $3 = 'SubProcessId'

      Then while trying to update payload an error is generated due to unexpected "end bracket" sign at the end:

      2021-06-11 14:01:16 UTC [184] ERROR: syntax error at or near ")" at character 56
      2021-06-11 14:01:16 UTC [184] STATEMENT: UPDATE process_instances SET payload = $1 WHERE id = $2)

      Attachments

        Issue Links

          Activity

            People

              cnicolai@redhat.com Cristiano Nicolai
              jakubgrabowski Jakub Grabowski (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: