Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-2412

Investigate billable_usage kafka messages sending when DB fails

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Undefined Undefined
    • 2024-04-17 - API
    • None
    • None
    • None

      While deploying an update to liquibase to add a PK UUID to billable_usage_remittance, there were code failures where billable_usage_remittances failed to insert because they did not have the UUID from the old deployment. When this happened the kafka billable usage message still sent even though the database transaction failed. We need to investigate why this is happening and have the messages send only when the db records are inserted successfully.

      https://docs.spring.io/spring-kafka/reference/kafka/transactions.html#transaction-synchronization

      Splunk query to see the column contraint violation at 27 March:

      index=rh_rhsm namespace=rhsm-prod "ERROR: null value in column "uuid" violates not-null constraint"
      

              jcarvaja@redhat.com Jose Carvajal Hilario
              kflahert@redhat.com Kevin Flaherty
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: