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

Timestamp type column time zone problem

    XMLWordPrintable

Details

    • False
    • False
    • Hide

      This is initialization data ===》

      {"before":null,"after":\{"id":1,"name":"2","create_time":1638389872000,"update_time":"2021-12-01T20:17:54Z"}

      ,"source":{"version":"1.7.1.Final","connector":"mysql","name":"test-app-connector","ts_ms":1638433487055,"snapshot":"last","db":"a1","sequence":null,"table":"test2","server_id":0,"gtid":null,"file":"mysql-bin.000013","pos":435325864,"row":0,"thread":null,"query":null},"op":"r","ts_ms":1638433487070,"transaction":null}

       

       

      This is real-time data modification ===》

      {"before":\{"id":1,"name":"2","create_time":1638389872000,"update_time":"2021-12-01T12:17:54Z"}

      ,"after":{"id":1,"name":"1","create_time":1638389872000,"update_time":"2021-12-01T12:17:54Z"},"source":{"version":"1.7.1.Final","connector":"mysql","name":"test-app-connector","ts_ms":1638433506000,"snapshot":"false","db":"a1","sequence":null,"table":"test2","server_id":2,"gtid":null,"file":"mysql-bin.000013","pos":435358284,"row":0,"thread":null,"query":null},"op":"u","ts_ms":1638433505362,"transaction":null}

      Show
      This is initialization data ===》 {"before":null,"after":\{"id":1,"name":"2","create_time":1638389872000,"update_time":"2021-12-01T20:17:54Z"} ,"source":{"version":"1.7.1.Final","connector":"mysql","name":"test-app-connector","ts_ms":1638433487055,"snapshot":"last","db":"a1","sequence":null,"table":"test2","server_id":0,"gtid":null,"file":"mysql-bin.000013","pos":435325864,"row":0,"thread":null,"query":null},"op":"r","ts_ms":1638433487070,"transaction":null}     This is real-time data modification ===》 {"before":\{"id":1,"name":"2","create_time":1638389872000,"update_time":"2021-12-01T12:17:54Z"} ,"after":{"id":1,"name":"1","create_time":1638389872000,"update_time":"2021-12-01T12:17:54Z"},"source":{"version":"1.7.1.Final","connector":"mysql","name":"test-app-connector","ts_ms":1638433506000,"snapshot":"false","db":"a1","sequence":null,"table":"test2","server_id":2,"gtid":null,"file":"mysql-bin.000013","pos":435358284,"row":0,"thread":null,"query":null},"op":"u","ts_ms":1638433505362,"transaction":null}

    Description

      Timestamp type column, snapshot.mode=initial and database.serverTimezone = UTC data initialization update_time column time is correct
      But the real-time data modification update_time column is 8 hours less than in the table

      Attachments

        1. Testdebezium.java
          3 kB
        2. test2.sql
          0.3 kB
        3. pom.xml
          3 kB
        4. image-2021-12-10-09-46-06-799.png
          image-2021-12-10-09-46-06-799.png
          4 kB
        5. image-2021-12-10-09-45-20-724.png
          image-2021-12-10-09-45-20-724.png
          5 kB
        6. 20211210.java
          3 kB

        Activity

          People

            Unassigned Unassigned
            chaotianque ken q (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: