Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4715

Source timestamp timezone differs between snapshot and streaming records

    XMLWordPrintable

Details

    Description

      Hi Team,

           We using debezium with log minor on oracle. during CDC we getting different epoch values under source.ts_ms

      • In initial snapshot - source.ts_ms is in UTC 
      • during streaming - source.ts_ms is in IST

      there is no problem with debezium time format but as oracle is configured in IST we getting these kind of in consistency.

      Use case: To produce custom metrics in grefana we using these info to do the calculation of latency.

      Note: there is no issue on the ts_ms which is in root level, that is always in UTC

      please help us on this.

      Thanks

      Arun M

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            marun790 Arun M (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: