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

Connection failure while reading chunk during incremental snapshot

    XMLWordPrintable

Details

    • Hide

      Trigger a read-only incremental snapshot and issue occurs sometimes.

       

      Show
      Trigger a read-only incremental snapshot and issue occurs sometimes.  

    Description

      At-times getting "com.mysql.cj.jdbc.exceptions.CommunicationsException" while executing a read-only incremental snapshot.

      Error logs:

      Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure  The last packet successfully received from the server was 4,670,390 milliseconds ago. The last packet sent successfully to the server was 4,670,421 milliseconds ago. com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)  com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:806) io.debezium.jdbc.JdbcConnection.commit(JdbcConnection.java:391) io.debezium.pipeline.source.snapshot.incremental.AbstractIncrementalSnapshotChangeEventSource.readChunk(AbstractIncrementalSnapshotChangeEventSource.java:210)... 15 more Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure  The last packet successfully received from the server was 4,670,390 milliseconds ago. The last packet sent successfully to the server was 4,670,421 milliseconds ago. java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490

      Attachments

        Activity

          People

            Unassigned Unassigned
            vivekwassan Vivek Wassan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: