在travis中构建spring boot+mysql+docker+travis获取mysql连接故障

Question

刚认识码头的。我已经使用mysql配置了spring引导，并编写了如下所示的docker和docker组合。我让码头-组成-f码头-合成- and建立在我的本地，它在当地工作良好。当我把它推到GIT，当travis捡起它时，我会在travis日志中获得以下的异常。我认为它无法连接到mysql。

    mysql-standalone_1_3deba3f11bd1 | 2020-11-05T15:41:27.929272Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
    mysql-standalone_1_3deba3f11bd1 | 2020-11-05T15:41:27.938951Z 0 [Note] Event Scheduler: Loaded 0 events
    mysql-standalone_1_3deba3f11bd1 | 2020-11-05T15:41:27.939205Z 0 [Note] mysqld: ready for connections.
    mysql-standalone_1_3deba3f11bd1 | Version: '5.7.32'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:27.949  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:27.950  INFO 1 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.39]
    mysql-standalone_1_3deba3f11bd1 | 2020-11-05 15:41:28+00:00 [Note] [Entrypoint]: Temporary server started.
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:28.644  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:28.645  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2615 ms
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:28.939  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    mysql-standalone_1_3deba3f11bd1 | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
    mysql-standalone_1_3deba3f11bd1 | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
    mysql-standalone_1_3deba3f11bd1 | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
    mysql-standalone_1_3deba3f11bd1 | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:30.199 ERROR 1 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.
    springboot-docker-container_1_39c0a7e72bdc | 
    springboot-docker-container_1_39c0a7e72bdc | com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    springboot-docker-container_1_39c0a7e72bdc | 
    springboot-docker-container_1_39c0a7e72bdc | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    springboot-docker-container_1_39c0a7e72bdc |    at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.22.jar!/:8.0.22]
    springboot-docker-container_1_39c0a7e72bdc |    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.22.jar!/:8.0.22]
    springboot-docker-container_1_39c0a7e72bdc |    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.22.jar!/:8.0.22]
    springboot-docker-container_1_39c0a7e72bdc |    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar!/:8.0.22]

My travis.yml

sudo: required
language: generic

services:
  - docker
script:
  - mvn clean install -DskipTests=true
  - docker-compose -f docker-compose.yml up --build

码头文件

From openjdk:8
ADD target/docker-mk.war docker-mk.war
EXPOSE 8085
ENTRYPOINT ["java", "-jar", "docker-mk.war"] 

docker-compose

version: '3'
services:
  mysql-standalone:
    image: mysql:5.7
    environment:
      - MYSQL_USER=root
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_PASSWORD=root
      - MYSQL_DATABASE=demo
    ports:
      - 3307:3306
    healthcheck:
      test: mysqladmin ping -h mysql-standalone -u $$MYSQL_USER --password=$$MYSQL_PASSWORD
  springboot-docker-container:
    image: springboot-docker-container
    ports:
      - 8089:8085
    build:
      context: .
      dockerfile: Dockerfile
    depends_on:
         - mysql-standalone
               


Anything am missing or doing wrong here? 

Answer 1

-depends-on: mysql-startalong只确保mysql容器是在春季启动容器之前启动的，但不要确保mysql服务器已经准备好连接。

如果使用已有的数据库启动mysql (可能是本地机器上的情况，因为包含mysql数据的volumn不是每次都被清除，除非您明确地这样做)，那么一切都应该是好的；

但是，如果mysql是从头开始的(这就是travis上的例子)，mysql需要一些时间来初始化帐户、数据库、配置等，并且在此过程中尝试连接会导致错误。

让我们看看你的日志，

    mysql-standalone_1_3deba3f11bd1 | 2020-11-05 15:41:28+00:00 [Note] [Entrypoint]: Temporary server started.
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:28.644  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:28.645  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2615 ms
    springboot-docker-container_1_39c0a7e72bdc | 2020-11-05 15:41:28.939  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    mysql-standalone_1_3deba3f11bd1 | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.

当您的spring应用程序开始初始化时，mysql刚刚启动了一个临时服务器，并且仍然在读取时区设置。因此，出现连接故障。

至于解决方案，下面是码头文件为Postgres提供的一个示例。

此外，您还可以使用netcat(请记住将其安装在dockerfile中)在入口点文件中检查端口，如下所示：

#!bin/sh

echo "Waiting for database..."
while ! nc -z DATABASE_HOST DATABASE_PORT; do
    sleep 0.5
done
echo "Database started."

java -jar YOURFILE

exec "$@"