Database configuration error #364
Description
Hey 👾
I am running the app with Docker Compose locally, and I am having some errors configuring the MySQL database.
The first error is when executing the Docker run command:
Unable to find image 'mysql:5.7.8' locally
5.7.8: Pulling from library/mysql
docker: [DEPRECATION NOTICE] Docker Image Format v1 and Docker Image manifest version 2, schema 1 support is disabled by default and will be removed in an upcoming release. Suggest the author of docker.io/library/mysql:5.7.8 to upgrade the image to the OCI Format or Docker Image manifest v2, schema 2. More information at https://docs.docker.com/go/deprecated-image-specs/
I could get over this error running the 5.7.44 version. I am running the database inside the Docker Compose like this:
petclinic-database:
image: mysql:5.7.44
restart: always
ports:
- 3306:3306
environment:
- MYSQL_ROOT_PASSWORD=petclinic
- MYSQL_DATABASE=petclinic
volumes:
- db-data:/var/lib/mysql
healthcheck:
test: [ "CMD", "mysqladmin", "ping", "-h", "localhost" ]
interval: 10s
timeout: 5s
retries: 5
volumes:
db-data:
But I can't still connect to the database, I have this stacktrace on customers, visits and pets services:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Failed to initialize dependency 'dataSourceScriptDatabaseInitializer' of LoadTimeWeaverAware bean 'entityManagerFactory': Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Failed to execute database script
2025-03-23T16:49:20.567949676Z at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325)
2025-03-23T16:49:20.567953726Z at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
2025-03-23T16:49:20.567957466Z at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:970)
2025-03-23T16:49:20.567961216Z at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627)
2025-03-23T16:49:20.567964866Z at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
2025-03-23T16:49:20.567968756Z at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)
2025-03-23T16:49:20.567972396Z at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
2025-03-23T16:49:20.567975986Z at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
2025-03-23T16:49:20.567979496Z at org.springframework.boot.SpringApplication.run(SpringApplication.java:1361)
2025-03-23T16:49:20.567982996Z at org.springframework.boot.SpringApplication.run(SpringApplication.java:1350)
2025-03-23T16:49:20.568090526Z at org.springframework.samples.petclinic.customers.CustomersServiceApplication.main(CustomersServiceApplication.java:30)
2025-03-23T16:49:20.568096966Z at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2025-03-23T16:49:20.568102726Z at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
2025-03-23T16:49:20.568108396Z at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2025-03-23T16:49:20.568112075Z at java.base/java.lang.reflect.Method.invoke(Method.java:569)
2025-03-23T16:49:20.568115725Z at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)
2025-03-23T16:49:20.568119245Z at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
2025-03-23T16:49:20.568122785Z at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)
2025-03-23T16:49:20.568126445Z Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Failed to execute database script
2025-03-23T16:49:20.568130525Z at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1808)
2025-03-23T16:49:20.568134215Z at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:601)
2025-03-23T16:49:20.568137895Z at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:523)
2025-03-23T16:49:20.568141555Z at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
2025-03-23T16:49:20.568145225Z at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:289)
2025-03-23T16:49:20.568148875Z at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
2025-03-23T16:49:20.568152445Z at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
2025-03-23T16:49:20.568156015Z at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:312)
2025-03-23T16:49:20.568159595Z ... 17 common frames omitted
2025-03-23T16:49:20.568163005Z Caused by: org.springframework.jdbc.datasource.init.UncategorizedScriptException: Failed to execute database script
2025-03-23T16:49:20.568166585Z at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:67)
2025-03-23T16:49:20.568170505Z at org.springframework.boot.jdbc.init.DataSourceScriptDatabaseInitializer.runScripts(DataSourceScriptDatabaseInitializer.java:87)
2025-03-23T16:49:20.568174215Z at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.runScripts(AbstractScriptDatabaseInitializer.java:146)
2025-03-23T16:49:20.568182895Z at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applyScripts(AbstractScriptDatabaseInitializer.java:108)
2025-03-23T16:49:20.568186635Z at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.applySchemaScripts(AbstractScriptDatabaseInitializer.java:98)
2025-03-23T16:49:20.568190285Z at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.initializeDatabase(AbstractScriptDatabaseInitializer.java:76)
2025-03-23T16:49:20.568193905Z at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.afterPropertiesSet(AbstractScriptDatabaseInitializer.java:66)
2025-03-23T16:49:20.568197525Z at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855)
2025-03-23T16:49:20.568201175Z at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
2025-03-23T16:49:20.568204925Z ... 24 common frames omitted
2025-03-23T16:49:20.568208385Z Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection
2025-03-23T16:49:20.568211935Z at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:84)
2025-03-23T16:49:20.568215485Z at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:52)
2025-03-23T16:49:20.568219065Z ... 32 common frames omitted
2025-03-23T16:49:20.568222465Z Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
2025-03-23T16:49:20.568225985Z
2025-03-23T16:49:20.568229245Z The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2025-03-23T16:49:20.568232825Z at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:165)
2025-03-23T16:49:20.568236445Z at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:55)
2025-03-23T16:49:20.568239995Z at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:837)
2025-03-23T16:49:20.568243485Z at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:420)
2025-03-23T16:49:20.568247255Z at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238)
2025-03-23T16:49:20.568251195Z at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180)
2025-03-23T16:49:20.568254775Z at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:137)
2025-03-23T16:49:20.568258275Z at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:360)
2025-03-23T16:49:20.568261755Z at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
2025-03-23T16:49:20.568265255Z at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461)
2025-03-23T16:49:20.568268815Z at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:550)
2025-03-23T16:49:20.568368945Z at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:98)
2025-03-23T16:49:20.568373255Z at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:111)
2025-03-23T16:49:20.568376795Z at net.ttddyy.dsproxy.support.ProxyDataSource.getConnection(ProxyDataSource.java:72)
2025-03-23T16:49:20.568380315Z at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160)
2025-03-23T16:49:20.568383975Z at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118)
2025-03-23T16:49:20.568387495Z at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
2025-03-23T16:49:20.568391175Z ... 33 common frames omitted
2025-03-23T16:49:20.568394545Z Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
2025-03-23T16:49:20.568398035Z
2025-03-23T16:49:20.568401305Z The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2025-03-23T16:49:20.568404875Z at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2025-03-23T16:49:20.568408404Z at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
2025-03-23T16:49:20.568411964Z at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2025-03-23T16:49:20.568415534Z at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
2025-03-23T16:49:20.568419074Z at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
2025-03-23T16:49:20.568422524Z at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:52)
2025-03-23T16:49:20.568426004Z at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:95)
2025-03-23T16:49:20.568429504Z at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:140)
2025-03-23T16:49:20.568433164Z at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:156)
2025-03-23T16:49:20.568437554Z at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:79)
2025-03-23T16:49:20.568441144Z at com.mysql.cj.NativeSession.connect(NativeSession.java:142)
2025-03-23T16:49:20.568444604Z at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:961)
2025-03-23T16:49:20.568448124Z at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
2025-03-23T16:49:20.568451624Z ... 47 common frames omitted
2025-03-23T16:49:20.568455014Z Caused by: java.net.ConnectException: Connection refused
2025-03-23T16:49:20.568458484Z at java.base/sun.nio.ch.Net.pollConnect(Native Method)
2025-03-23T16:49:20.568465314Z at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
2025-03-23T16:49:20.568468834Z at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:547)
2025-03-23T16:49:20.568472304Z at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:602)
2025-03-23T16:49:20.568475794Z at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
2025-03-23T16:49:20.568479304Z at java.base/java.net.Socket.connect(Socket.java:633)
2025-03-23T16:49:20.568482724Z at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:144)
2025-03-23T16:49:20.568486224Z at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:53)
2025-03-23T16:49:20.568489784Z ... 50 common frames omitted