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

CaptureChangeMySQL throws NumberFormatException when sequence id exceeds maximum Integer

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.10.0
    • Component/s: Extensions
    • Labels:
      None

      Description

      NumberFormatException can be thrown because the internal sequence id is parsed as an integer where it should be a long.
      https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-cdc/nifi-cdc-mysql-bundle/nifi-cdc-mysql-processors/src/main/java/org/apache/nifi/cdc/mysql/processors/CaptureChangeMySQL.java#L492

      2019-10-14 04:45:54,727 WARN [Timer-Driven Process Thread-15] o.a.n.controller.tasks.ConnectableTask Administratively Yielding CaptureChangeMySQL[id=719232e6-2e6e-1d73-82b8-4f59a42c5e52] due to uncaught Exception: java.lang.NumberFormatException: For input string: "2291535530"
      java.lang.NumberFormatException: For input string: "2291535530"
              at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
              at java.lang.Integer.parseInt(Integer.java:583)
              at java.lang.Integer.parseInt(Integer.java:615)
              at org.apache.nifi.cdc.mysql.processors.CaptureChangeMySQL.setup(CaptureChangeMySQL.java:492)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ijokarumawak Koji Kawamura
                Reporter:
                ijokarumawak Koji Kawamura
              • Votes:
                0 Vote for this issue
                Watchers:
                2 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 - 20m
                  20m