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

Timezone difference not considered in `LagFromSourceInMilliseconds` calculation

    XMLWordPrintable

Details

    Description

      We are getting our changes captured and appended to kafka topics within milliseconds since the transactions are commited in the database. However, the metric LagFromSourceInMilliseconds shows 7198710, which is ~2 hours.

      Could it be a timezone related bug? We are running our connector in UTC+2 (CEST).

      We are using LogMiner strategy.

      ccranfor@redhat.com on https://gitter.im/debezium/dev:

      I just looked at the code and yes the database time should be returned in UTC but the lag calculation against Instant would not shift the connector host's timezone to be the same, leading to this unsual but consistent variance in lag.

       

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            didiez Diego Ricondo (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: