Pessoal boa tarde!
Estou com um problema para Deploy do projeto no Heroku, alguém pode me ajudar?
Estou usando o Ecossistema Spring, não sei como configurar a variável de ambiente.
log de erro:
C:\linguagens-api>heroku logs --tail
2022-10-19T12:56:41.920906+00:00 app[web.1]: at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1141) ~[spring-context-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920906+00:00 app[web.1]: at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:916) ~[spring-context-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920907+00:00 app[web.1]: at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:592) ~[spring-context-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920907+00:00 app[web.1]: at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.0.0-M5.jar!/:3.0.0-M5]
2022-10-19T12:56:41.920907+00:00 app[web.1]: at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:751) ~[spring-boot-3.0.0-M5.jar!/:3.0.0-M5]
2022-10-19T12:56:41.920907+00:00 app[web.1]: at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:442) ~[spring-boot-3.0.0-M5.jar!/:3.0.0-M5]
2022-10-19T12:56:41.920908+00:00 app[web.1]: at org.springframework.boot.SpringApplication.run(SpringApplication.java:314) ~[spring-boot-3.0.0-M5.jar!/:3.0.0-M5]
2022-10-19T12:56:41.920908+00:00 app[web.1]: at org.springframework.boot.SpringApplication.run(SpringApplication.java:1323) ~[spring-boot-3.0.0-M5.jar!/:3.0.0-M5]
2022-10-19T12:56:41.920908+00:00 app[web.1]: at org.springframework.boot.SpringApplication.run(SpringApplication.java:1312) ~[spring-boot-3.0.0-M5.jar!/:3.0.0-M5]
2022-10-19T12:56:41.920908+00:00 app[web.1]: at br.com.tsa.linguagens.api.LinguagensApiApplication.main(LinguagensApiApplication.java:10) ~[classes!/:0.0.1-SNAPSHOT]
2022-10-19T12:56:41.920908+00:00 app[web.1]: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
2022-10-19T12:56:41.920909+00:00 app[web.1]: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na]
2022-10-19T12:56:41.920909+00:00 app[web.1]: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
2022-10-19T12:56:41.920909+00:00 app[web.1]: at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
2022-10-19T12:56:41.920910+00:00 app[web.1]: at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[linguagens-api-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
2022-10-19T12:56:41.920910+00:00 app[web.1]: at org.springframework.boot.loader.Launcher.launch(Launcher.java:95) ~[linguagens-api-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
2022-10-19T12:56:41.920910+00:00 app[web.1]: at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[linguagens-api-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
2022-10-19T12:56:41.920910+00:00 app[web.1]: at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) ~[linguagens-api-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
2022-10-19T12:56:41.920930+00:00 app[web.1]: Caused by: jakarta.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution
2022-10-19T12:56:41.920931+00:00 app[web.1]: at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:421) ~[spring-orm-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920931+00:00 app[web.1]: at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) ~[spring-orm-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920931+00:00 app[web.1]: at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:352) ~[spring-orm-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920931+00:00 app[web.1]: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920931+00:00 app[web.1]: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1750) ~[spring-beans-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920932+00:00 app[web.1]: … 24 common frames omitted
2022-10-19T12:56:41.920932+00:00 app[web.1]: Caused by: org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution
2022-10-19T12:56:41.920932+00:00 app[web.1]: at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:98) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920932+00:00 app[web.1]: at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920932+00:00 app[web.1]: at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920933+00:00 app[web.1]: at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920933+00:00 app[web.1]: at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:68) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920933+00:00 app[web.1]: at org.hibernate.tool.schema.internal.exec.ImprovedExtractionContextImpl.getJdbcConnection(ImprovedExtractionContextImpl.java:63) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920933+00:00 app[web.1]: at org.hibernate.tool.schema.internal.exec.ImprovedExtractionContextImpl.getJdbcDatabaseMetaData(ImprovedExtractionContextImpl.java:70) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920934+00:00 app[web.1]: at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.processTableResultSet(InformationExtractorJdbcDatabaseMetaDataImpl.java:64) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920934+00:00 app[web.1]: at org.hibernate.tool.schema.extract.internal.AbstractInformationExtractorImpl.getTables(AbstractInformationExtractorImpl.java:558) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920934+00:00 app[web.1]: at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.getTablesInformation(DatabaseInformationImpl.java:122) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920935+00:00 app[web.1]: at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920935+00:00 app[web.1]: at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:225) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920935+00:00 app[web.1]: at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:126) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920935+00:00 app[web.1]: at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:284) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920936+00:00 app[web.1]: at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.lambda$process$5(SchemaManagementToolCoordinator.java:143) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920936+00:00 app[web.1]: at java.base/java.util.HashMap.forEach(HashMap.java:1421) ~[na:na]
2022-10-19T12:56:41.920936+00:00 app[web.1]: at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:140) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920939+00:00 app[web.1]: at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:333) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920940+00:00 app[web.1]: at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:415) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920940+00:00 app[web.1]: at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1425) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920940+00:00 app[web.1]: at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:66) ~[spring-orm-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920940+00:00 app[web.1]: at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:376) ~[spring-orm-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920940+00:00 app[web.1]: at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[spring-orm-6.0.0-M6.jar!/:6.0.0-M6]
2022-10-19T12:56:41.920940+00:00 app[web.1]: … 28 common frames omitted
2022-10-19T12:56:41.920941+00:00 app[web.1]: Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
2022-10-19T12:56:41.920941+00:00 app[web.1]:
2022-10-19T12:56:41.920941+00:00 app[web.1]: The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2022-10-19T12:56:41.920941+00:00 app[web.1]: at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920941+00:00 app[web.1]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920941+00:00 app[web.1]: at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920942+00:00 app[web.1]: at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920942+00:00 app[web.1]: at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920942+00:00 app[web.1]: at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920942+00:00 app[web.1]: at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar!/:na]
2022-10-19T12:56:41.920943+00:00 app[web.1]: at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar!/:na]
2022-10-19T12:56:41.920943+00:00 app[web.1]: at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar!/:na]
2022-10-19T12:56:41.920943+00:00 app[web.1]: at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar!/:na]
2022-10-19T12:56:41.920943+00:00 app[web.1]: at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-5.0.1.jar!/:na]
2022-10-19T12:56:41.920944+00:00 app[web.1]: at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:100) ~[HikariCP-5.0.1.jar!/:na]
2022-10-19T12:56:41.920944+00:00 app[web.1]: at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-5.0.1.jar!/:na]
2022-10-19T12:56:41.920944+00:00 app[web.1]: at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920944+00:00 app[web.1]: at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:284) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920945+00:00 app[web.1]: at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:41) ~[hibernate-core-6.1.3.Final.jar!/:6.1.3.Final]
2022-10-19T12:56:41.920945+00:00 app[web.1]: … 46 common frames omitted
2022-10-19T12:56:41.920945+00:00 app[web.1]: Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
2022-10-19T12:56:41.920945+00:00 app[web.1]:
2022-10-19T12:56:41.920945+00:00 app[web.1]: The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2022-10-19T12:56:41.920945+00:00 app[web.1]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
2022-10-19T12:56:41.920945+00:00 app[web.1]: at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) ~[na:na]
2022-10-19T12:56:41.920946+00:00 app[web.1]: at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
2022-10-19T12:56:41.920946+00:00 app[web.1]: at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[na:na]
2022-10-19T12:56:41.920948+00:00 app[web.1]: at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480) ~[na:na]
2022-10-19T12:56:41.920948+00:00 app[web.1]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920948+00:00 app[web.1]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920948+00:00 app[web.1]: at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920948+00:00 app[web.1]: at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920949+00:00 app[web.1]: at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920949+00:00 app[web.1]: at com.mysql.cj.NativeSession.connect(NativeSession.java:120) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920949+00:00 app[web.1]: at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920949+00:00 app[web.1]: at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920949+00:00 app[web.1]: … 59 common frames omitted
2022-10-19T12:56:41.920950+00:00 app[web.1]: Caused by: java.net.ConnectException: Connection refused
2022-10-19T12:56:41.920950+00:00 app[web.1]: at java.base/sun.nio.ch.Net.pollConnect(Native Method) ~[na:na]
2022-10-19T12:56:41.920950+00:00 app[web.1]: at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672) ~[na:na]
2022-10-19T12:56:41.920950+00:00 app[web.1]: at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542) ~[na:na]
2022-10-19T12:56:41.920950+00:00 app[web.1]: at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597) ~[na:na]
2022-10-19T12:56:41.920950+00:00 app[web.1]: at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) ~[na:na]
2022-10-19T12:56:41.920951+00:00 app[web.1]: at java.base/java.net.Socket.connect(Socket.java:639) ~[na:na]
2022-10-19T12:56:41.920951+00:00 app[web.1]: at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920951+00:00 app[web.1]: at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63) ~[mysql-connector-java-8.0.30.jar!/:8.0.30]
2022-10-19T12:56:41.920951+00:00 app[web.1]: … 62 common frames omitted
2022-10-19T12:56:41.920951+00:00 app[web.1]:
2022-10-19T12:56:42.065305+00:00 heroku[web.1]: Process exited with status 1
2022-10-19T12:56:42.168111+00:00 heroku[web.1]: State changed from starting to crashed