Skip to content

SQL Connection issue.. are there any password changes needed #3

@nagkumar

Description

@nagkumar

[ERROR] HikariPool-1 - Exception during pool initialization.
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:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException (SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO (ConnectionImpl.java:829)
at com.mysql.cj.jdbc.ConnectionImpl. (ConnectionImpl.java:449)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance (ConnectionImpl.java:242)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:198)
at com.zaxxer.hikari.util.DriverDataSource.getConnection (DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection (PoolBase.java:358)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry (PoolBase.java:206)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry (HikariPool.java:477)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast (HikariPool.java:560)
at com.zaxxer.hikari.pool.HikariPool. (HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource. (HikariDataSource.java:81)
at org.sqlcomponents.core.crawler.util.DataSourceUtil.getDataSource (DataSourceUtil.java:26)
at org.sqlcomponents.core.crawler.Crawler.getDatabase (Crawler.java:46)
at org.sqlcomponents.core.mapper.Mapper.getOrm (Mapper.java:39)
at org.sqlcomponents.compiler.java.JavaFTLCompiler.compile (JavaFTLCompiler.java:36)
at org.sqlcomponents.core.model.Application.compile (Application.java:282)
at org.sqlcomponents.SQLComponentsMojo.execute (SQLComponentsMojo.java:40)
at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)
at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute (MojoExecutor.java:301)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:211)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:165)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:157)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:121)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:127)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:294)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
at org.apache.maven.cli.MavenCli.execute (MavenCli.java:960)
at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:293)
at org.apache.maven.cli.MavenCli.main (MavenCli.java:196)
at jdk.internal.reflect.DirectMethodHandleAccessor.invoke (DirectMethodHandleAccessor.java:104)
at java.lang.reflect.Method.invoke (Method.java:577)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)
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 jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance (DirectConstructorHandleAccessor.java:67)
at java.lang.reflect.Constructor.newInstanceWithCaller (Constructor.java:499)
at java.lang.reflect.Constructor.newInstance (Constructor.java:483)
at com.mysql.cj.exceptions.ExceptionFactory.createException (ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException (ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException (ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException (ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeProtocol.readMessage (NativeProtocol.java:520)
at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities (NativeProtocol.java:475)
at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake (NativeProtocol.java:362)
at com.mysql.cj.protocol.a.NativeProtocol.connect (NativeProtocol.java:1367) at com.mysql.cj.NativeSession.connect (NativeSession.java:133)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly (ConnectionImpl.java:949)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO (ConnectionImpl.java:819)
at com.mysql.cj.jdbc.ConnectionImpl. (ConnectionImpl.java:449)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance (ConnectionImpl.java:242)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:198)
at com.zaxxer.hikari.util.DriverDataSource.getConnection (DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection (PoolBase.java:358)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry (PoolBase.java:206)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry (HikariPool.java:477)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast (HikariPool.java:560)
at com.zaxxer.hikari.pool.HikariPool. (HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource. (HikariDataSource.java:81)
at org.sqlcomponents.core.crawler.util.DataSourceUtil.getDataSource (DataSourceUtil.java:26)
at org.sqlcomponents.core.crawler.Crawler.getDatabase (Crawler.java:46)
at org.sqlcomponents.core.mapper.Mapper.getOrm (Mapper.java:39)
at org.sqlcomponents.compiler.java.JavaFTLCompiler.compile (JavaFTLCompiler.java:36)
at org.sqlcomponents.core.model.Application.compile (Application.java:282)
at org.sqlcomponents.SQLComponentsMojo.execute (SQLComponentsMojo.java:40)
at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)
at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute (MojoExecutor.java:301)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:211)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:165)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:157)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:121)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:127)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:294)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
at org.apache.maven.cli.MavenCli.execute (MavenCli.java:960)
at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:293)
at org.apache.maven.cli.MavenCli.main (MavenCli.java:196)
at jdk.internal.reflect.DirectMethodHandleAccessor.invoke (DirectMethodHandleAccessor.java:104)
at java.lang.reflect.Method.invoke (Method.java:577)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.cj.protocol.FullReadInputStream.readFully (FullReadInputStream.java:67)
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:514)
at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities (NativeProtocol.java:475)
at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake (NativeProtocol.java:362)
at com.mysql.cj.protocol.a.NativeProtocol.connect (NativeProtocol.java:1367) at com.mysql.cj.NativeSession.connect (NativeSession.java:133)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly (ConnectionImpl.java:949)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO (ConnectionImpl.java:819)
at com.mysql.cj.jdbc.ConnectionImpl. (ConnectionImpl.java:449)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance (ConnectionImpl.java:242)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:198)
at com.zaxxer.hikari.util.DriverDataSource.getConnection (DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection (PoolBase.java:358)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry (PoolBase.java:206)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry (HikariPool.java:477)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast (HikariPool.java:560)
at com.zaxxer.hikari.pool.HikariPool. (HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource. (HikariDataSource.java:81)
at org.sqlcomponents.core.crawler.util.DataSourceUtil.getDataSource (DataSourceUtil.java:26)
at org.sqlcomponents.core.crawler.Crawler.getDatabase (Crawler.java:46)
at org.sqlcomponents.core.mapper.Mapper.getOrm (Mapper.java:39)
at org.sqlcomponents.compiler.java.JavaFTLCompiler.compile (JavaFTLCompiler.java:36)
at org.sqlcomponents.core.model.Application.compile (Application.java:282)
at org.sqlcomponents.SQLComponentsMojo.execute (SQLComponentsMojo.java:40)
at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)
at org.apache.maven.lifecycle.internal.MojoExecutor.doExecute (MojoExecutor.java:301)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:211)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:165)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:157)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:121)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:127)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:294)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
at org.apache.maven.cli.MavenCli.execute (MavenCli.java:960)
at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:293)
at org.apache.maven.cli.MavenCli.main (MavenCli.java:196)
at jdk.internal.reflect.DirectMethodHandleAccessor.invoke (DirectMethodHandleAccessor.java:104)
at java.lang.reflect.Method.invoke (Method.java:577)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 7.015 s
[INFO] Finished at: 2022-07-04T12:28:26+05:30
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.sqlcomponents:sqlcomponents-maven-plugin:1.0-SNAPSHOT:generated-sources (default) on project spring-boot-sqlcomponents: Execution default of goal org.sqlcomponents:sqlcomponents-maven-plugin:1.0-SNAPSHOT:generated-sources failed: Failed to initialize pool: Communications link failure
[ERROR]
[ERROR] The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/PluginExecutionException

G:\DWork\osource\jug\sc\sample-app>

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions