Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-373

Duplicate key value violates unique constraint "records_lb_pkey"

    XMLWordPrintable

    Details

    • Template:
    • Story Points:
      3
    • Development Team:
      Folijet

      Description

      When execute data-import-flow via "Create job profile (for instance+holdings+item)", there can be some logs from mod-source-record-storage:

      "22:30:10.344 [vert.x-worker-thread-2] WARN RecordDaoImpl [434312432eqId] Error occurred on batch execution: ERROR: duplicate key value violates unique constraint "records_lb_pkey"
      22:30:58.844 [vert.x-kafka-consumer-thread-0] ERROR KafkaConsumerWrapper [434360932eqId] Error while KafkaConsumerWrapper is working:
      22:30:58.845 [vert.x-worker-thread-8] ERROR KafkaConsumerWrapper [434360933eqId] Consumer - id: 13 subscriptionPattern: SubscriptionDefinition(eventType=DI_RAW_RECORDS_CHUNK_PARSED, subscriptionPattern=jint\.Default\.\w{1,}\.DI_RAW_RECORDS_CHUNK_PARSED) Error while commit offset: 6"

       

      The main goal is to investigate the root cause of this log and fix it.

      Note: this error message can be revealed after the same chunk of messages were reached to srs. 

      Might relate to duplicated events

       

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                VRohach Volodymyr Rohach
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    TestRail: Runs

                      TestRail: Cases