Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-8749

PutDatabaseRecord Insert Datetime Type Time Zone Issue

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • 1.13.0, 1.14.0, 1.13.2
    • 1.15.0
    • None
    • None

    Description

      when I query a record from Mysql to get an AVRO Flowfile, then use  PutDatabaseRecord(version 1.13.2) insert to another table (with same table structure), the data of the 'datetime' type column will change. The original data of the first table I query from is '2021-06-28 13:14:20.0'. and the data of the second table which I insert to becomes '2021-06-28 06:14:20.0'.The gap is 7 hours.

      our local timezone is PDT (-7:00). It seems that Nifi has done some timezone conversion work. But the 'datetime' type in mysql should have no relation to timezone

       

      when we use version 1.7.1 ,it works fine.

      Attachments

        1. cc1.png
          49 kB
          Billy Lin
        2. cc2.png
          8 kB
          Billy Lin
        3. cc3.png
          11 kB
          Billy Lin
        4. cc4.png
          10 kB
          Billy Lin
        5. image-2021-07-01-15-17-38-035.png
          63 kB
          Victor Li
        6. image-2021-07-30-17-35-58-914.png
          90 kB
          Xavier Balayer
        7. NIFI-8749.json
          16 kB
          David Handermann

        Issue Links

          Activity

            People

              exceptionfactory David Handermann
              adg7511 Billy Lin
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 50m
                  2h 50m