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

Duplicate key violation on "definitions" table [data_index]

    XMLWordPrintable

Details

    Description

      Environment: using platform artifacts from main branch, with embedded postgres, data index and job services.

      While running SWF instances that contain a callback state, the framework attempts to insert more than once the SWF entry in the definitions table of the `data_index` database.

      DB status before running another instanceof ticket-escalation SWF:

      data_index=# select id from definitions;
         id         
--------------------
 ticket-escalation2
 hello
 ticket-escalation

      Log messages after the new instance is triggered:

      2023-10-23 09:08:19,779 dmartino-mac INFO  [org.kie.kogito.serverless.workflow.devservices.DevModeServerlessWorkflowLogger:64] (executor-thread-16) Triggered node 'approvalEvent' for process 'ticket-escalation' (fa669882-13e5-41c5-a3c2-6f50cb013294)
2023-10-23 09:08:19,780 dmartino-mac INFO  [org.kie.kogito.serverless.workflow.devservices.DevModeServerlessWorkflowLogger:50] (executor-thread-16) Workflow 'ticket-escalation' (fa669882-13e5-41c5-a3c2-6f50cb013294) was started, now 'Active'
2023-10-23 09:08:19,821 dmartino-mac WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:137] (executor-thread-16) SQL Error: 0, SQLState: 23505
2023-10-23 09:08:19,821 dmartino-mac ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:142] (executor-thread-16) ERROR: duplicate key value violates unique constraint "definitions_pkey"
  Detail: Key (id, version)=(ticket-escalation, 0.0.1) already exists.

      As a result, the client invoking the POST request receives 500 error:

      < HTTP/1.1 500 Internal Server Error
< Content-Type: application/json
< Content-Length: 44
< 
* Connection #0 to host localhost left intact
{"message":"Error invoking subclass method"}

      Example SWF attached.

      Snippet of log attached.

       

      Attachments

        Issue Links

          is depended on by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. FLPATH-634 Generalize escalation mechanism

          • Undefined - Priority not specified.
          • Closed
          is incorporated by

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. KOGITO-9674 Workflow definitions on Data-Index

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved
          relates to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. KOGITO-9920 Runtimes to Data Index eventing concurrency issues

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. KOGITO-9921 Concurrent events consumption and indexing to a given Process Instance

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              tdolphin-1 Tiago Dolphine
              dmartino@redhat.com Daniele Martinoli
              Marian Macik Marian Macik
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: