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

Mysql connector tests are failing when executed without any profile

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 2.4.0.Beta1
    • None
    • mysql-connector
    • None
    • False
    • None
    • False
    • Moderate

      230 Mysql connector tests fail when executed with no profile on version Mysql version 8.0.32 although it probably happens on other versions as well. The error seems to correspond with ssl certificates. Including error log from a single falling test.

      ```2023-08-09 12:05:43,895 INFO |||| Starting test io.debezium.connector.mysql.MySqlDecimalIT#testPreciseDecimalHandlingMode [io.debezium.connector.mysql.MySqlDecimalIT]
      2023-08-09 12:05:43,921 INFO MySqlDecimalIT|||test| Stopping the connector [io.debezium.connector.mysql.MySqlDecimalIT]
      2023-08-09 12:06:37,632 INFO |||| Connection gracefully closed [io.debezium.jdbc.JdbcConnection]
      2023-08-09 12:06:37,753 WARN MySqlDecimalIT|||test| Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results. [org.apache.kafka.connect.runtime.WorkerConfig]
      2023-08-09 12:08:30,549 ERROR MySqlDecimalIT|||engine| Failed testing connection for jdbc:mysql://localhost:3306/?useInformationSchema=true&nullCatalogMeansCurrent=false&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&zeroDateTimeBehavior=CONVERT_TO_NULL&connectTimeout=30000 with user 'snapper' [io.debezium.connector.mysql.MySqlConnector]
      com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

      The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
      at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:175)
      at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
      at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
      at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:446)
      at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239)
      at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188)
      at io.debezium.jdbc.JdbcConnection.lambda$patternBasedFactory$1(JdbcConnection.java:241)
      at io.debezium.jdbc.JdbcConnection$ConnectionFactoryDecorator.connect(JdbcConnection.java:127)
      at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:873)
      at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:868)
      at io.debezium.jdbc.JdbcConnection.connect(JdbcConnection.java:396)
      at io.debezium.connector.mysql.MySqlConnector.validateConnection(MySqlConnector.java:86)
      at io.debezium.connector.common.RelationalBaseSourceConnector.validate(RelationalBaseSourceConnector.java:55)
      at io.debezium.embedded.EmbeddedEngine.getConnectorConfig(EmbeddedEngine.java:799)
      at io.debezium.embedded.EmbeddedEngine.run(EmbeddedEngine.java:711)
      at io.debezium.embedded.AbstractConnectorTest.lambda$start$6(AbstractConnectorTest.java:409)
      at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
      at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
      at java.base/java.lang.Thread.run(Thread.java:833)
      Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

      The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
      at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
      at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
      at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
      at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
      at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
      at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
      at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
      at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:582)
      at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762)
      at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:739)
      at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:156)
      at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:468)
      at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:213)
      at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1430)
      at com.mysql.cj.NativeSession.connect(NativeSession.java:134)
      at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:945)
      at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:815)
      ... 16 common frames omitted
      Caused by: javax.net.ssl.SSLHandshakeException: Received fatal alert: unknown_ca
      at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
      at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:117)
      at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:358)
      at java.base/sun.security.ssl.Alert$AlertConsumer.consume(Alert.java:293)
      at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:204)
      at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:172)
      at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1503)
      at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1474)
      at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1059)
      at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132)
      at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
      at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
      at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
      at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
      at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576)
      ... 25 common frames omitted
      2023-08-09 12:08:30,565 ERROR MySqlDecimalIT|||engine| Connector configuration is not valid. Unable to connect: Communications link failure

      The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. [io.debezium.connector.mysql.MySqlDecimalIT]
      2023-08-09 12:11:52,549 INFO MySqlDecimalIT|||test| Stopping the connector [io.debezium.connector.mysql.MySqlDecimalIT]
      2023-08-09 12:11:52,550 INFO MySqlDecimalIT|||test| Interrupting the engine [io.debezium.connector.mysql.MySqlDecimalIT]
      2023-08-09 12:11:54,373 INFO MySqlDecimalIT|||test| Stopping the connector [io.debezium.connector.mysql.MySqlDecimalIT]
      2023-08-09 12:11:57,283 INFO MySqlDecimalIT|||test| Test io.debezium.connector.mysql.MySqlDecimalIT#testPreciseDecimalHandlingMode failed [io.debezium.connector.mysql.MySqlDecimalIT]

      java.lang.AssertionError:
      Expecting actual not to be null

      at io.debezium.connector.mysql.MySqlDecimalIT.consumeInsert(MySqlDecimalIT.java:127)
      at io.debezium.connector.mysql.MySqlDecimalIT.testPreciseDecimalHandlingMode(MySqlDecimalIT.java:80)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:568)
      at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
      at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
      at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
      at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
      at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
      at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
      at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61)
      at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
      at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
      at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
      at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
      at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
      at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
      at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
      at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
      at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
      at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
      at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
      at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
      at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
      at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
      at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
      at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
      at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
      at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
      at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)```{}

            rhn-support-jnovotny Jiří Novotný
            rhn-support-jnovotny Jiří Novotný
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: