【docker-compose】使用docker-compose部署运行spring boot+mysql 【处理容器的时区问题】【详解】【福利：使用docker-compose构建 wordpress+mysql】
=================================================================================================================================
在正式开始之前，可以先去看看这个【使用docker-compose构建 wordpress+mysql】（https://www.cnblogs.com/52fhy/p/5991344.html）
参考：docker三剑客compose 【https://www.imooc.com/article/34135】有比较详细的命令解析和docker-compose.yml属性解析
=================================================================================================================================
好啦开始吧
=================================================================================================================================
一.简介docker三剑客
docker-machine
docker技术是基于Linux内核的cgroup技术实现的，那么问题来了，在非Linux平台上是否就不能使用docker技术了呢？答案是可以的，不过显然需要借助虚拟机去模拟出Linux环境来。
docker-machine就是docker公司官方提出的，用于在各种平台上快速创建具有docker服务的虚拟机的技术，甚至可以通过指定driver来定制虚拟机的实现原理（一般是virtualbox）。
docker-compose
docker镜像在创建之后，往往需要自己手动pull来获取镜像，然后执行run命令来运行。当服务需要用到多种容器，容器之间又产生了各种依赖和连接的时候，部署一个服务的手动操作是令人感到十分厌烦的。
dcoker-compose技术，就是通过一个.yml配置文件，将所有的容器的部署方法、文件映射、容器连接等等一系列的配置写在一个配置文件里，最后只需要执行docker-compose up命令就会像执行脚本一样的去一个个安装容器并自动部署他们，极大的便利了复杂服务的部署。【服务编排工具】
docker-swarm
swarm是基于docker平台实现的集群技术，他可以通过几条简单的指令快速的创建一个docker集群，接着在集群的共享网络上部署应用，最终实现分布式的服务。
相比起zookeeper等集群管理框架来说，swarm显得十分轻量，作为一个工具，它把节点的加入、管理、发现等复杂的操作都浓缩为几句简单的命令，并且具有自动发现节点和调度的算法，还支持自定制。虽然swarm技术现在还不是非常成熟，但其威力已经可见一般。
二.使用docker-compose安装spring boot服务容器+mysql容器，实现自动部署
==============================================================基础概念 ==============================================================
工程、服务、容器
-
Docker Compose 将所管理的容器分为三层，分别是工程（project）、服务（service）、容器（container）
-
Docker Compose 运行目录下的所有文件（docker-compose.yml）组成一个工程,一个工程包含多个服务，每个服务中定义了容器运行的镜像、参数、依赖，一个服务可包括多个容器实例
》在本例子中，整个的docker-compose.yml文件中的services共同组成了一个大的工程。
》这个工程，目前包含了两个服务，spring boot服务【服务名：swapping】 mysql服务【服务名：mysql】
》其中每个服务都可以同时启动多个容器实例。
===================================================================== ==============================================================
1.创建一个空目录
创建一个空目录的原因是，可以将
【docker-compose.yml或者docker-compose.yaml文件】
【构建spring boot容器的Dockerfile文件】
【spring boot的jar包】
放在同一个目录下。
mkdir swapping-docker-compose
本命令创建了一个目录【swapping-docker-compose】
cd swapping-docker-compose/
本命令进入本目录下
2.创建构建spring boot容器的Dockerfile文件
使用vi命令，创建文件名为【Dockerfile-swapping】的文件【名字自定义，只需要在docker-compose.yml中指定正确就可以】
vi Dockerfile-swapping
复制一下文本到本文件中【关于Dockerfile文件内容解释：https://www.cnblogs.com/sxdcgaq8080/p/10057088.html】
FROM java:8
VOLUME /temp
ADD swapping.jar swapping.jar
RUN bash -c 'touch /swapping.jar'
ENTRYPOINT ["java","-Djava.security.egd=file:/dev/./urandom","-jar","-Xmx1024m","-Xms1024m","/swapping.jar"]
3.创建docker-compose.yml文件，用于构建本组工程中各个参与服务的镜像【名词最上面有解释】
使用vi命令创建docker-compose.yml文件【文件名特定，也可以创建docker-compose.yaml文件，但也是特定名称，不能自定义】
vi docker-compose.yml
复制一下内容到文本中【文本内容解释在这个地方：https://www.cnblogs.com/sxdcgaq8080/p/10072040.html】【处理时区问题也在这个地方】
version : '3'
services:
swapping:
container_name: swapping-compose
build:
context: .
dockerfile: Dockerfile-swapping
ports:
- "9666:9666"
volumes:
- .:/vol/development
depends_on:
- mysql
links:
- "mysql:mysql"
restart: always
networks:
- my-network
environment:
- TZ=Asia/Shanghai
mysql:
container_name: mysql-compose
image: mysql:5.7
ports:
- "33061:3306"
command: [
'--character-set-server=utf8mb4',
'--collation-server=utf8mb4_unicode_ci',
'--default-time-zone=+8:00'
]
environment:
MYSQL_DATABASE: swapping
MYSQL_ROOT_PASSWORD: 398023
MYSQL_ROOT_HOST: '%'
restart: always
networks:
- my-network
networks:
my-network:
4.打包jar包，上传spring boot服务的jar包
打包操作参考https://www.cnblogs.com/sxdcgaq8080/p/10057088.html
注意数据库连接配置【是指定了具体的ip的，而没有用docker-compose.yml文件中配置的数据库服务名 mysql，因为出错连接不上https://www.cnblogs.com/sxdcgaq8080/p/10070740.html】
spring.datasource.url=jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8
打包以后使用rz命令上传jar包【rz命令不能使用的解决方法：https://www.cnblogs.com/sxdcgaq8080/p/10059141.html】
rz
上传以后，jar包 Dockerfile文件 docker-compose.yml文件位于同一个目录下
5.使用docker-compose命令构建并启动容器
使用命令 构建并启动本工程中的各个服务的容器
docker-compose up -d
-d代表在后台启动
也可以不加，这样启动日志就会当即打印出来
从下面的打印可以看到，初次构建并启动容器的时候，会有下面红框部分出现，也就是构建spring boot服务的镜像的过程。
注意：如果这个镜像你一直不删除，那就一直存在，并且在下次重新启动的时候，还是会用之前构建的这个镜像。
这也就意味着，如果你的spring boot服务中代码更新了，即时你重新打包上传到服务器上，如果你没有删除之前的镜像，那就算重启服务，依旧还是老的代码，使用的旧的镜像！！！！
因为docker-compose up命令会在没有镜像的时候去构建镜像，如果有，就会用旧的镜像，然后直接启动容器！！！
所以，千万注意重新部署的话，需要删除旧的镜像！！
此刻看到两个服务的容器都 done了，可以使用命令查看启动日志
docker-compose logs
本命令会展示本工程下所有服务容器的启动日志
[root@centos7 swapping-docker-compose]# docker-compose logs Attaching to swapping-compose, mysql-compose mysql-compose | Initializing database mysql-compose | 2018-12-05T09:20:07.572331Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). mysql-compose | 2018-12-05T09:20:08.220435Z 0 [Warning] InnoDB: New log files created, LSN=45790 mysql-compose | 2018-12-05T09:20:08.819688Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. mysql-compose | 2018-12-05T09:20:08.961497Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f5da42ca-f86e-11e8-b51f-0242ac130002. mysql-compose | 2018-12-05T09:20:08.979327Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. mysql-compose | 2018-12-05T09:20:09.006262Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. mysql-compose | 2018-12-05T09:20:12.833682Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:12.833705Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:12.833711Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:12.833722Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:12.833724Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:12.833732Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:12.833751Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:12.833757Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | Database initialized mysql-compose | Initializing certificates mysql-compose | Generating a 2048 bit RSA private key mysql-compose | .................................................................................+++ mysql-compose | ................................................................+++ mysql-compose | unable to write 'random state' mysql-compose | writing new private key to 'ca-key.pem' mysql-compose | ----- mysql-compose | Generating a 2048 bit RSA private key mysql-compose | ...............+++ mysql-compose | ..................................................................+++ mysql-compose | unable to write 'random state' mysql-compose | writing new private key to 'server-key.pem' mysql-compose | ----- mysql-compose | Generating a 2048 bit RSA private key mysql-compose | .............+++ mysql-compose | ....................................................+++ mysql-compose | unable to write 'random state' mysql-compose | writing new private key to 'client-key.pem' mysql-compose | ----- mysql-compose | Certificates initialized mysql-compose | MySQL init process in progress... mysql-compose | 2018-12-05T09:20:17.277021Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). mysql-compose | 2018-12-05T09:20:17.279578Z 0 [Note] mysqld (mysqld 5.7.23) starting as process 88 ... mysql-compose | 2018-12-05T09:20:17.304677Z 0 [Note] InnoDB: PUNCH HOLE support available mysql-compose | 2018-12-05T09:20:17.304695Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins mysql-compose | 2018-12-05T09:20:17.304699Z 0 [Note] InnoDB: Uses event mutexes mysql-compose | 2018-12-05T09:20:17.304701Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier mysql-compose | 2018-12-05T09:20:17.304703Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 mysql-compose | 2018-12-05T09:20:17.304705Z 0 [Note] InnoDB: Using Linux native AIO mysql-compose | 2018-12-05T09:20:17.304904Z 0 [Note] InnoDB: Number of pools: 1 mysql-compose | 2018-12-05T09:20:17.304989Z 0 [Note] InnoDB: Using CPU crc32 instructions mysql-compose | 2018-12-05T09:20:17.306646Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M mysql-compose | 2018-12-05T09:20:17.317369Z 0 [Note] InnoDB: Completed initialization of buffer pool mysql-compose | 2018-12-05T09:20:17.319873Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). mysql-compose | 2018-12-05T09:20:17.332153Z 0 [Note] InnoDB: Highest supported file format is Barracuda. mysql-compose | 2018-12-05T09:20:17.374662Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables mysql-compose | 2018-12-05T09:20:17.374750Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... mysql-compose | 2018-12-05T09:20:17.468070Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. mysql-compose | 2018-12-05T09:20:17.469072Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. mysql-compose | 2018-12-05T09:20:17.469081Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. mysql-compose | 2018-12-05T09:20:17.469337Z 0 [Note] InnoDB: Waiting for purge to start mysql-compose | 2018-12-05T09:20:17.526447Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2588944 mysql-compose | 2018-12-05T09:20:17.526745Z 0 [Note] Plugin 'FEDERATED' is disabled. mysql-compose | 2018-12-05T09:20:17.531295Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. mysql-compose | 2018-12-05T09:20:17.531554Z 0 [Warning] CA certificate ca.pem is self signed. mysql-compose | 2018-12-05T09:20:17.532519Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool mysql-compose | 2018-12-05T09:20:17.533692Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181205 9:20:17 mysql-compose | 2018-12-05T09:20:17.543334Z 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-compose | 2018-12-05T09:20:17.544394Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.544423Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.544429Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.544447Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.544450Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.544458Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.545558Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.545567Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:17.552217Z 0 [Note] Event Scheduler: Loaded 0 events mysql-compose | 2018-12-05T09:20:17.552440Z 0 [Note] mysqld: ready for connections. mysql-compose | Version: '5.7.23' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL) mysql-compose | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. mysql-compose | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. mysql-compose | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. mysql-compose | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it. mysql-compose | 2018-12-05T09:20:25.695127Z 4 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:25.695159Z 4 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:25.695166Z 4 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:25.695183Z 4 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:25.695188Z 4 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:25.695199Z 4 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:25.695281Z 4 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:25.695292Z 4 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | mysql: [Warning] Using a password on the command line interface can be insecure. mysql-compose | mysql-compose | 2018-12-05T09:20:25.755438Z 0 [Note] Giving 0 client threads a chance to die gracefully mysql-compose | 2018-12-05T09:20:25.755457Z 0 [Note] Shutting down slave threads mysql-compose | 2018-12-05T09:20:25.755462Z 0 [Note] Forcefully disconnecting 0 remaining clients mysql-compose | 2018-12-05T09:20:25.755467Z 0 [Note] Event Scheduler: Purging the queue. 0 events mysql-compose | 2018-12-05T09:20:25.755588Z 0 [Note] Binlog end mysql-compose | 2018-12-05T09:20:25.755979Z 0 [Note] Shutting down plugin 'ngram' mysql-compose | 2018-12-05T09:20:25.755988Z 0 [Note] Shutting down plugin 'partition' mysql-compose | 2018-12-05T09:20:25.755991Z 0 [Note] Shutting down plugin 'BLACKHOLE' mysql-compose | 2018-12-05T09:20:25.755995Z 0 [Note] Shutting down plugin 'ARCHIVE' mysql-compose | 2018-12-05T09:20:25.755997Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' mysql-compose | 2018-12-05T09:20:25.756016Z 0 [Note] Shutting down plugin 'MRG_MYISAM' mysql-compose | 2018-12-05T09:20:25.756019Z 0 [Note] Shutting down plugin 'MyISAM' mysql-compose | 2018-12-05T09:20:25.756026Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' mysql-compose | 2018-12-05T09:20:25.756029Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' mysql-compose | 2018-12-05T09:20:25.756031Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' mysql-compose | 2018-12-05T09:20:25.756033Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' mysql-compose | 2018-12-05T09:20:25.756035Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' mysql-compose | 2018-12-05T09:20:25.756037Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' mysql-compose | 2018-12-05T09:20:25.756038Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' mysql-compose | 2018-12-05T09:20:25.756040Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' mysql-compose | 2018-12-05T09:20:25.756042Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' mysql-compose | 2018-12-05T09:20:25.756044Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' mysql-compose | 2018-12-05T09:20:25.756045Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' mysql-compose | 2018-12-05T09:20:25.756047Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' mysql-compose | 2018-12-05T09:20:25.756049Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' mysql-compose | 2018-12-05T09:20:25.756051Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' mysql-compose | 2018-12-05T09:20:25.756052Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' mysql-compose | 2018-12-05T09:20:25.756054Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' mysql-compose | 2018-12-05T09:20:25.756056Z 0 [Note] Shutting down plugin 'INNODB_METRICS' mysql-compose | 2018-12-05T09:20:25.756058Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' mysql-compose | 2018-12-05T09:20:25.756060Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' mysql-compose | 2018-12-05T09:20:25.756061Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' mysql-compose | 2018-12-05T09:20:25.756063Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' mysql-compose | 2018-12-05T09:20:25.756065Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' mysql-compose | 2018-12-05T09:20:25.756067Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' mysql-compose | 2018-12-05T09:20:25.756068Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' mysql-compose | 2018-12-05T09:20:25.756070Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' mysql-compose | 2018-12-05T09:20:25.756072Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' mysql-compose | 2018-12-05T09:20:25.756073Z 0 [Note] Shutting down plugin 'INNODB_CMP' mysql-compose | 2018-12-05T09:20:25.756075Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' mysql-compose | 2018-12-05T09:20:25.756077Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' mysql-compose | 2018-12-05T09:20:25.756079Z 0 [Note] Shutting down plugin 'INNODB_TRX' mysql-compose | 2018-12-05T09:20:25.756080Z 0 [Note] Shutting down plugin 'InnoDB' mysql-compose | 2018-12-05T09:20:25.756126Z 0 [Note] InnoDB: FTS optimize thread exiting. mysql-compose | 2018-12-05T09:20:25.756430Z 0 [Note] InnoDB: Starting shutdown... mysql-compose | 2018-12-05T09:20:25.882147Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool mysql-compose | 2018-12-05T09:20:25.962129Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181205 9:20:25 mysql-compose | 2018-12-05T09:20:27.821638Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12359060 mysql-compose | 2018-12-05T09:20:27.822720Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" mysql-compose | 2018-12-05T09:20:27.822758Z 0 [Note] Shutting down plugin 'MEMORY' mysql-compose | 2018-12-05T09:20:27.822769Z 0 [Note] Shutting down plugin 'CSV' mysql-compose | 2018-12-05T09:20:27.822772Z 0 [Note] Shutting down plugin 'sha256_password' mysql-compose | 2018-12-05T09:20:27.822774Z 0 [Note] Shutting down plugin 'mysql_native_password' mysql-compose | 2018-12-05T09:20:27.822949Z 0 [Note] Shutting down plugin 'binlog' mysql-compose | 2018-12-05T09:20:27.823329Z 0 [Note] mysqld: Shutdown complete mysql-compose | mysql-compose | mysql-compose | MySQL init process done. Ready for start up. mysql-compose | mysql-compose | 2018-12-05T09:20:30.050736Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). mysql-compose | 2018-12-05T09:20:30.052564Z 0 [Note] mysqld (mysqld 5.7.23) starting as process 1 ... mysql-compose | 2018-12-05T09:20:30.056181Z 0 [Note] InnoDB: PUNCH HOLE support available mysql-compose | 2018-12-05T09:20:30.056209Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins mysql-compose | 2018-12-05T09:20:30.056214Z 0 [Note] InnoDB: Uses event mutexes mysql-compose | 2018-12-05T09:20:30.056217Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier mysql-compose | 2018-12-05T09:20:30.056221Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 mysql-compose | 2018-12-05T09:20:30.056224Z 0 [Note] InnoDB: Using Linux native AIO mysql-compose | 2018-12-05T09:20:30.056773Z 0 [Note] InnoDB: Number of pools: 1 mysql-compose | 2018-12-05T09:20:30.056922Z 0 [Note] InnoDB: Using CPU crc32 instructions mysql-compose | 2018-12-05T09:20:30.059732Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M mysql-compose | 2018-12-05T09:20:30.069279Z 0 [Note] InnoDB: Completed initialization of buffer pool mysql-compose | 2018-12-05T09:20:30.071126Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). mysql-compose | 2018-12-05T09:20:30.083095Z 0 [Note] InnoDB: Highest supported file format is Barracuda. mysql-compose | 2018-12-05T09:20:30.130405Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables mysql-compose | 2018-12-05T09:20:30.130495Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... mysql-compose | 2018-12-05T09:20:30.218630Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. mysql-compose | 2018-12-05T09:20:30.219315Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. mysql-compose | 2018-12-05T09:20:30.219332Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. mysql-compose | 2018-12-05T09:20:30.219598Z 0 [Note] InnoDB: Waiting for purge to start mysql-compose | 2018-12-05T09:20:30.270653Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 12359060 mysql-compose | 2018-12-05T09:20:30.271359Z 0 [Note] Plugin 'FEDERATED' is disabled. mysql-compose | 2018-12-05T09:20:30.280545Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. mysql-compose | 2018-12-05T09:20:30.280845Z 0 [Warning] CA certificate ca.pem is self signed. mysql-compose | 2018-12-05T09:20:30.282512Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool mysql-compose | 2018-12-05T09:20:30.287770Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 mysql-compose | 2018-12-05T09:20:30.287837Z 0 [Note] IPv6 is available. mysql-compose | 2018-12-05T09:20:30.287850Z 0 [Note] - '::' resolves to '::'; mysql-compose | 2018-12-05T09:20:30.287873Z 0 [Note] Server socket created on IP: '::'. mysql-compose | 2018-12-05T09:20:30.288964Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181205 9:20:30 mysql-compose | 2018-12-05T09:20:30.289798Z 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-compose | 2018-12-05T09:20:30.291352Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.291400Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.291409Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.291442Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.291447Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.291459Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.293915Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.293931Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql-compose | 2018-12-05T09:20:30.301345Z 0 [Note] Event Scheduler: Loaded 0 events mysql-compose | 2018-12-05T09:20:30.301551Z 0 [Note] mysqld: ready for connections. mysql-compose | Version: '5.7.23' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) swapping-compose | swapping-compose | . ____ _ __ _ _ swapping-compose | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ swapping-compose | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ swapping-compose | \\/ ___)| |_)| | | | | || (_| | ) ) ) ) swapping-compose | ' |____| .__|_| |_|_| |_\__, | / / / / swapping-compose | =========|_|==============|___/=/_/_/_/ swapping-compose | :: Spring Boot :: (v2.0.1.RELEASE) swapping-compose | swapping-compose | 2018-12-05 17:20:12.373 INFO 1 --- [ main] com.sxd.swapping.SwappingApplication : Starting SwappingApplication v0.0.1-SNAPSHOT on d1a5bc850e1f with PID 1 (/swapping.jar started by root in /) swapping-compose | 2018-12-05 17:20:12.399 INFO 1 --- [ main] com.sxd.swapping.SwappingApplication : No active profile set, falling back to default profiles: default swapping-compose | 2018-12-05 17:20:12.706 INFO 1 --- [ main] ConfigServletWebServerApplicationContext : Refreshing org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@1c2c22f3: startup date [Wed Dec 05 17:20:12 CST 2018]; root of context hierarchy swapping-compose | 2018-12-05 17:20:15.940 INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode! swapping-compose | 2018-12-05 17:20:16.096 INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode! swapping-compose | 2018-12-05 17:20:16.134 INFO 1 --- [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.sxd.swapping.dao.jpa.GoodsStockDao. swapping-compose | 2018-12-05 17:20:16.140 INFO 1 --- [ main] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface com.sxd.swapping.dao.jpa.HuaYangAreaDao. swapping-compose | 2018-12-05 17:20:17.892 INFO 1 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$50d4864] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) swapping-compose | 2018-12-05 17:20:18.735 INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 9666 (http) swapping-compose | 2018-12-05 17:20:18.782 INFO 1 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] swapping-compose | 2018-12-05 17:20:18.782 INFO 1 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet Engine: Apache Tomcat/8.5.29 swapping-compose | 2018-12-05 17:20:18.794 INFO 1 --- [ost-startStop-1] o.a.catalina.core.AprLifecycleListener : The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib] swapping-compose | 2018-12-05 17:20:18.966 INFO 1 --- [ost-startStop-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext swapping-compose | 2018-12-05 17:20:18.966 INFO 1 --- [ost-startStop-1] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 6262 ms swapping-compose | 2018-12-05 17:20:19.521 INFO 1 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean : Servlet statViewServlet mapped to [/druid/*] swapping-compose | 2018-12-05 17:20:19.528 INFO 1 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean : Servlet dispatcherServlet mapped to [/] swapping-compose | 2018-12-05 17:20:19.530 INFO 1 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'characterEncodingFilter' to: [/*] swapping-compose | 2018-12-05 17:20:19.530 INFO 1 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'hiddenHttpMethodFilter' to: [/*] swapping-compose | 2018-12-05 17:20:19.531 INFO 1 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'httpPutFormContentFilter' to: [/*] swapping-compose | 2018-12-05 17:20:19.531 INFO 1 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'requestContextFilter' to: [/*] swapping-compose | 2018-12-05 17:20:19.531 INFO 1 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'webStatFilter' to urls: [/*] swapping-compose | 2018-12-05 17:20:20.666 INFO 1 --- [ main] j.LocalContainerEntityManagerFactoryBean : Building JPA container EntityManagerFactory for persistence unit 'default' swapping-compose | 2018-12-05 17:20:20.723 INFO 1 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [ swapping-compose | name: default swapping-compose | ...] swapping-compose | 2018-12-05 17:20:21.009 INFO 1 --- [ main] org.hibernate.Version : HHH000412: Hibernate Core {5.2.16.Final} swapping-compose | 2018-12-05 17:20:21.010 INFO 1 --- [ main] org.hibernate.cfg.Environment : HHH000206: hibernate.properties not found swapping-compose | 2018-12-05 17:20:21.744 INFO 1 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.1.Final} swapping-compose | 2018-12-05 17:20:25.206 ERROR 1 --- [ main] com.alibaba.druid.pool.DruidDataSource : init datasource error, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:859) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1227) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1223) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:90) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:259) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:233) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:861) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:888) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1761) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1698) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:579) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:501) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1089) ~[spring-context-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:859) ~[spring-context-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at com.sxd.swapping.SwappingApplication.main(SwappingApplication.java:14) ~[classes!/:0.0.1-SNAPSHOT] swapping-compose | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111] swapping-compose | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 74 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:25.220 ERROR 1 --- [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} init error swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:859) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1227) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1223) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:90) [druid-1.1.9.jar!/:1.1.9] swapping-compose | at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:259) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:233) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:861) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:888) [hibernate-core-5.2.16.Final.jar!/:5.2.16.Final] swapping-compose | at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) [spring-orm-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1761) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1698) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:579) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:501) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) [spring-beans-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1089) ~[spring-context-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:859) ~[spring-context-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.0.5.RELEASE.jar!/:5.0.5.RELEASE] swapping-compose | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) ~[spring-boot-2.0.1.RELEASE.jar!/:2.0.1.RELEASE] swapping-compose | at com.sxd.swapping.SwappingApplication.main(SwappingApplication.java:14) ~[classes!/:0.0.1-SNAPSHOT] swapping-compose | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111] swapping-compose | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) ~[swapping.jar:0.0.1-SNAPSHOT] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 74 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:25.220 INFO 1 --- [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} inited swapping-compose | 2018-12-05 17:20:25.220 WARN 1 --- [ main] o.h.e.j.e.i.JdbcEnvironmentInitiator : HHH000342: Could not obtain connection to query metadata : Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | 2018-12-05 17:20:25.256 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:25.263 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:25.276 INFO 1 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL55Dialect swapping-compose | 2018-12-05 17:20:25.360 INFO 1 --- [ main] o.h.e.j.e.i.LobCreatorBuilderImpl : HHH000422: Disabling contextual LOB creation as connection was null swapping-compose | 2018-12-05 17:20:25.766 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:26.272 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:26.792 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:27.297 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:27.802 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:28.316 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:28.833 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:29.345 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | 2018-12-05 17:20:29.865 ERROR 1 --- [reate-259219561] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://192.168.92.130:33061/swapping?useSSL=false&useUnicode=true&characterEncoding=UTF-8, errorCode 0, state 08S01 swapping-compose | swapping-compose | com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure swapping-compose | swapping-compose | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:633) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111] swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111] swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111] swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111] swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) ~[druid-1.1.9.jar!/:1.1.9] swapping-compose | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. swapping-compose | at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:568) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] swapping-compose | ... 24 common frames omitted swapping-compose | swapping-compose | DEBUG - {conn-10001} connected swapping-compose | DEBUG - {conn-10001} pool-connect swapping-compose | Hibernate: create table goods_stock (id bigint not null auto_increment, create_date datetime not null, create_id varchar(255) not null, uid varchar(255) not null, update_date datetime, update_id varchar(255), buy_num bigint, goods_name varchar(255), goods_price varchar(255), sale_num bigint, stock bigint, version integer, primary key (id)) engine=InnoDB swapping-compose | DEBUG - {conn-10001, stmt-20000} created swapping-compose | DEBUG - {conn-10001, stmt-20000} executed. 210.672749 millis. create table goods_stock (id bigint not null auto_increment, create_date datetime not null, create_id varchar(255) not null, uid varchar(255) not null, update_date datetime, update_id varchar(255), buy_num bigint, goods_name varchar(255), goods_price varchar(255), sale_num bigint, stock bigint, version integer, primary key (id)) engine=InnoDB swapping-compose | Hibernate: create table hua_yang_area (id bigint not null auto_increment, create_date datetime not null, create_id varchar(255) not null, uid varchar(255) not null, update_date datetime, update_id varchar(255), area_name varchar(255) not null, area_person bigint not null, primary key (id)) engine=InnoDB swapping-compose | DEBUG - {conn-10001, stmt-20000} executed. 10.512824 millis. create table hua_yang_area (id bigint not null auto_increment, create_date datetime not null, create_id varchar(255) not null, uid varchar(255) not null, update_date datetime, update_id varchar(255), area_name varchar(255) not null, area_person bigint not null, primary key (id)) engine=InnoDB swapping-compose | Hibernate: create table model_entity (key1 varchar(36) not null, key2 varchar(32) not null, key3 varchar(32) not null, password varchar(255), user_name varchar(255), primary key (key1)) engine=InnoDB swapping-compose | DEBUG - {conn-10001, stmt-20000} executed. 18.893699 millis. create table model_entity (key1 varchar(36) not null, key2 varchar(32) not null, key3 varchar(32) not null, password varchar(255), user_name varchar(255), primary key (key1)) engine=InnoDB swapping-compose | Hibernate: create index IDXktg7cw2kycq7870ki49o3v0au on model_entity (user_name) swapping-compose | DEBUG - {conn-10001, stmt-20000} executed. 15.198104 millis. create index IDXktg7cw2kycq7870ki49o3v0au on model_entity (user_name) swapping-compose | Hibernate: create index IDX9rnmyvumfxu3otgr4wslqf0h2 on model_entity (password) swapping-compose | DEBUG - {conn-10001, stmt-20000} executed. 7.608148 millis. create index IDX9rnmyvumfxu3otgr4wslqf0h2 on model_entity (password) swapping-compose | Hibernate: alter table model_entity drop index UKqr702kgh0gmsfjqapg4w8fici swapping-compose | ERROR - {conn-10001, stmt-20000} execute error. alter table model_entity drop index UKqr702kgh0gmsfjqapg4w8fici swapping-compose | com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'UKqr702kgh0gmsfjqapg4w8fici'; check that column/key exists swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) swapping-compose | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) swapping-compose | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) swapping-compose | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) swapping-compose | at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) swapping-compose | at com.mysql.jdbc.Util.getInstance(Util.java:408) swapping-compose | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) swapping-compose | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) swapping-compose | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) swapping-compose | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) swapping-compose | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) swapping-compose | at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482) swapping-compose | at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440) swapping-compose | at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845) swapping-compose | at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745) swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2600) swapping-compose | at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473) swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188) swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598) swapping-compose | at com.alibaba.druid.wall.WallFilter.statement_execute(WallFilter.java:414) swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598) swapping-compose | at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473) swapping-compose | at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188) swapping-compose | at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598) swapping-compose | at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:147) swapping-compose | at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:558) swapping-compose | at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) swapping-compose | at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) swapping-compose | at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504) swapping-compose | at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyUniqueKeys(AbstractSchemaMigrator.java:374) swapping-compose | at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:85) swapping-compose | at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207) swapping-compose | at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) swapping-compose | at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183) swapping-compose | at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72) swapping-compose | at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:312) swapping-compose | at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:460) swapping-compose | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:892) swapping-compose | at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) swapping-compose | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) swapping-compose | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390) swapping-compose | at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) swapping-compose | at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1761) swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1698) swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:579) swapping-compose | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:501) swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) swapping-compose | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) swapping-compose | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) swapping-compose | at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1089) swapping-compose | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:859) swapping-compose | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) swapping-compose | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) swapping-compose | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) swapping-compose | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255) swapping-compose | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243) swapping-compose | at com.sxd.swapping.SwappingApplication.main(SwappingApplication.java:14) swapping-compose | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) swapping-compose | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) swapping-compose | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) swapping-compose | at java.lang.reflect.Method.invoke(Method.java:498) swapping-compose | at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) swapping-compose | at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) swapping-compose | at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) swapping-compose | at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) swapping-compose | Hibernate: alter table model_entity add constraint UKqr702kgh0gmsfjqapg4w8fici unique (key2, key3) swapping-compose | DEBUG - {conn-10001, stmt-20000} executed. 6.940655 millis. alter table model_entity add constraint UKqr702kgh0gmsfjqapg4w8fici unique (key2, key3) swapping-compose | DEBUG - {conn-10001, stmt-20000} closed swapping-compose | DEBUG - {conn-10001} pool-recycle swapping-compose | 2018-12-05 17:20:30.775 INFO 1 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' swapping-compose | 2018-12-05 17:20:33.206 INFO 1 --- [ main] o.h.h.i.QueryTranslatorFactoryInitiator : HHH000397: Using ASTQueryTranslatorFactory swapping-compose | 2018-12-05 17:20:35.998 WARN 1 --- [ main] aWebConfiguration$JpaWebMvcConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning swapping-compose | 2018-12-05 17:20:36.383 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/goods/stock/concurrentStock],methods=[POST]}" onto public com.sxd.swapping.base.UniVerResponse<java.util.Map<java.lang.Integer, java.lang.String>> com.sxd.swapping.controller.GoodsStockController.concurrentStock(com.sxd.swapping.domain.GoodsStock) swapping-compose | 2018-12-05 17:20:36.384 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/goods/stock/insert],methods=[POST]}" onto public com.sxd.swapping.base.UniVerResponse<com.sxd.swapping.domain.GoodsStock> com.sxd.swapping.controller.GoodsStockController.insert(com.sxd.swapping.domain.GoodsStock) swapping-compose | 2018-12-05 17:20:36.400 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/oneHuaYang],methods=[GET]}" onto public com.sxd.swapping.base.UniVerResponse<com.sxd.swapping.domain.HuaYangArea> com.sxd.swapping.controller.HuaYangApiWithMyBatis.findOne(java.lang.String) swapping-compose | 2018-12-05 17:20:36.401 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/findByNameLike],methods=[GET]}" onto public com.sxd.swapping.base.UniVerResponse<java.util.List<com.sxd.swapping.domain.HuaYangArea>> com.sxd.swapping.controller.HuaYangApiWithMyBatis.findAll1(java.lang.String) swapping-compose | 2018-12-05 17:20:36.413 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/findByNameLike2],methods=[GET]}" onto public com.sxd.swapping.base.UniVerResponse<java.util.List<com.sxd.swapping.domain.HuaYangArea>> com.sxd.swapping.controller.HuaYangApiWithMyBatis.findAll2(java.lang.String) swapping-compose | 2018-12-05 17:20:36.413 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/oneHuaYang],methods=[DELETE]}" onto public com.sxd.swapping.base.UniVerResponse<java.lang.String> com.sxd.swapping.controller.HuaYangApiWithMyBatis.deleteOne(java.lang.Long) swapping-compose | 2018-12-05 17:20:36.414 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/findBy3],methods=[GET]}" onto public com.sxd.swapping.base.UniVerResponse<java.util.List<com.sxd.swapping.base.HuaYangModelBean>> com.sxd.swapping.controller.HuaYangApiWithMyBatis.findByNameAndPersonAndCreateDate(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.414 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/findBy3Page],methods=[GET]}" onto public com.sxd.swapping.base.PageResponse<com.sxd.swapping.base.HuaYangModelBean> com.sxd.swapping.controller.HuaYangApiWithMyBatis.findByNameAndPersonAndCreateDatePage(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.414 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/findMap],methods=[GET]}" onto public com.sxd.swapping.base.UniVerResponse<java.util.Map<java.lang.String, java.lang.String>> com.sxd.swapping.controller.HuaYangApiWithMyBatis.findMap(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.414 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/update],methods=[PUT]}" onto public com.sxd.swapping.base.UniVerResponse<com.sxd.swapping.domain.HuaYangArea> com.sxd.swapping.controller.HuaYangApiWithMyBatis.update(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.414 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayangMybatis/insert],methods=[POST]}" onto public com.sxd.swapping.base.UniVerResponse<com.sxd.swapping.domain.HuaYangArea> com.sxd.swapping.controller.HuaYangApiWithMyBatis.insert(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.416 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayang/pages],methods=[GET]}" onto public com.sxd.swapping.base.PageResponse<com.sxd.swapping.domain.HuaYangArea> com.sxd.swapping.controller.HuaYangApiWithJPA.pages(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.416 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayang],methods=[POST]}" onto public com.sxd.swapping.base.UniVerResponse<com.sxd.swapping.domain.HuaYangArea> com.sxd.swapping.controller.HuaYangApiWithJPA.huayang(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.416 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayang/huayangs],methods=[GET]}" onto public com.sxd.swapping.base.UniVerResponse<java.util.List<com.sxd.swapping.domain.HuaYangArea>> com.sxd.swapping.controller.HuaYangApiWithJPA.huayangs(java.lang.String) swapping-compose | 2018-12-05 17:20:36.416 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayang/updates],methods=[POST]}" onto public com.sxd.swapping.base.UniVerResponse<java.util.List<com.sxd.swapping.domain.HuaYangArea>> com.sxd.swapping.controller.HuaYangApiWithJPA.updates(com.sxd.swapping.base.BatchBean) swapping-compose | 2018-12-05 17:20:36.416 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/huayang/update],methods=[PUT]}" onto public com.sxd.swapping.base.UniVerResponse<com.sxd.swapping.domain.HuaYangArea> com.sxd.swapping.controller.HuaYangApiWithJPA.update(com.sxd.swapping.domain.HuaYangArea) swapping-compose | 2018-12-05 17:20:36.417 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/createCode/getCode]}" onto public com.sxd.swapping.base.UniVerResponse<java.lang.String> com.sxd.swapping.controller.CreateCodeController.createCode() swapping-compose | 2018-12-05 17:20:36.444 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/swagger-resources/configuration/ui]}" onto public org.springframework.http.ResponseEntity<springfox.documentation.swagger.web.UiConfiguration> springfox.documentation.swagger.web.ApiResourceController.uiConfiguration() swapping-compose | 2018-12-05 17:20:36.452 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/swagger-resources/configuration/security]}" onto public org.springframework.http.ResponseEntity<springfox.documentation.swagger.web.SecurityConfiguration> springfox.documentation.swagger.web.ApiResourceController.securityConfiguration() swapping-compose | 2018-12-05 17:20:36.455 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/swagger-resources]}" onto public org.springframework.http.ResponseEntity<java.util.List<springfox.documentation.swagger.web.SwaggerResource>> springfox.documentation.swagger.web.ApiResourceController.swaggerResources() swapping-compose | 2018-12-05 17:20:36.466 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) swapping-compose | 2018-12-05 17:20:36.466 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController.error(javax.servlet.http.HttpServletRequest) swapping-compose | 2018-12-05 17:20:36.859 INFO 1 --- [ main] pertySourcedRequestMappingHandlerMapping : Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)] swapping-compose | 2018-12-05 17:20:37.078 INFO 1 --- [ main] o.s.w.s.handler.SimpleUrlHandlerMapping : Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] swapping-compose | 2018-12-05 17:20:37.501 INFO 1 --- [ main] s.w.s.m.m.a.RequestMappingHandlerAdapter : Looking for @ControllerAdvice: org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@1c2c22f3: startup date [Wed Dec 05 17:20:12 CST 2018]; root of context hierarchy swapping-compose | 2018-12-05 17:20:37.639 INFO 1 --- [ main] o.s.w.s.handler.SimpleUrlHandlerMapping : Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] swapping-compose | 2018-12-05 17:20:37.639 INFO 1 --- [ main] o.s.w.s.handler.SimpleUrlHandlerMapping : Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] swapping-compose | 2018-12-05 17:20:37.680 INFO 1 --- [ main] .m.m.a.ExceptionHandlerExceptionResolver : Detected @ExceptionHandler methods in myControllerAdvice swapping-compose | 2018-12-05 17:20:38.890 INFO 1 --- [ main] o.s.ui.freemarker.SpringTemplateLoader : SpringTemplateLoader for FreeMarker: using resource loader [org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@1c2c22f3: startup date [Wed Dec 05 17:20:12 CST 2018]; root of context hierarchy] and template loader path [classpath:/templates/] swapping-compose | 2018-12-05 17:20:38.905 INFO 1 --- [ main] o.s.w.s.v.f.FreeMarkerConfigurer : ClassTemplateLoader for Spring macros added to FreeMarker configuration swapping-compose | 2018-12-05 17:20:38.946 WARN 1 --- [ main] o.s.b.a.f.FreeMarkerAutoConfiguration : Cannot find template location(s): [classpath:/templates/] (please add some templates, check your FreeMarker configuration, or set spring.freemarker.checkTemplateLocation=false) swapping-compose | 2018-12-05 17:20:40.633 INFO 1 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on startup swapping-compose | 2018-12-05 17:20:40.635 INFO 1 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Bean with name 'dataSource' has been autodetected for JMX exposure swapping-compose | 2018-12-05 17:20:40.642 INFO 1 --- [ main] o.s.j.e.a.AnnotationMBeanExporter : Located MBean 'dataSource': registering with JMX server as MBean [com.alibaba.druid.pool:name=dataSource,type=DruidDataSource] swapping-compose | 2018-12-05 17:20:40.653 INFO 1 --- [ main] o.s.c.support.DefaultLifecycleProcessor : Starting beans in phase 2147483647 swapping-compose | 2018-12-05 17:20:40.653 INFO 1 --- [ main] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed swapping-compose | 2018-12-05 17:20:40.693 INFO 1 --- [ main] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s) swapping-compose | 2018-12-05 17:20:40.769 INFO 1 --- [ main] s.d.s.w.s.ApiListingReferenceScanner : Scanning for api listing references swapping-compose | 2018-12-05 17:20:41.452 INFO 1 --- [ main] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: insertUsingPOST_1 swapping-compose | 2018-12-05 17:20:41.460 INFO 1 --- [ main] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPUT_1 swapping-compose | 2018-12-05 17:20:41.682 INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 9666 (http) with context path '' swapping-compose | 2018-12-05 17:20:41.684 INFO 1 --- [ main] com.sxd.swapping.SwappingApplication : Started SwappingApplication in 30.76 seconds (JVM running for 31.716) [root@centos7 swapping-docker-compose]#
而如果你只想查看工程中某个服务的容器的启动日志，可以指定服务名进行查看【注意是服务名，不是容器名称】
docker-compose logs swapping
注意： 是服务名swapping，而不是容器名swapping-compose。
因为容器名称是你自己指定的，如果你没有指定，那么容器的名称是你当前docker-compose.yml所在目录的名字+服务名字+_1生成的
6.启动服务后，测试访问使用
访问spring boot服务所在IP的地址+端口，访问服务：
http://192.168.92.130:9666/huayang
数据库存储正常
同时可以看到mysql数据库的数据集设置正确
7.停止本工程中所有服务，并移除容器，切记，如果代码更新，需要同时移除镜像再进行重新构建并启动容器的步骤
如果仅需要停止本工程，可以使用一下的1. 2. 3. 步的命令。
如果是因为spring boot代码更新，需要提供新的功能，那不仅需要1. 2. 3.步去停止容器实例运行，移除容器实例。还需要4.5.步查看并删除开始根据yml文件配置构建的镜像，才能重新构建镜像，否则下次启动依旧使用的旧镜像，你新的代码不会起作用！
====================================================================================================================
最后附录上，关于docker-compose命令的详解和docker-compose.yml文件的属性详解【https://www.cnblogs.com/sxdcgaq8080/p/10072040.html】！！
====================================================================================================================
遗留问题，如果使用docker-compose启动服务，每个服务有多实例，怎么解决端口冲突的问题？
docker-compose scale mysql=2 swapping=3
docker-compose scale 服务名=个数 服务名=个数
这里只是去掉yml配置文件中指定容器名称的属性，解决容器名称重复的问题，那么端口问题怎么解决呢？？
container_name: swapping-compose
待解决！！！！！！！！！
