ubuntu - mysql不断重启:docker-compose bitnami/mysql5.7
问题描述
当我运行时docker-compose up -d
,phpmyadmin 启动,mysql 启动和停止并继续重新启动。
有人可以告诉我问题是什么吗?似乎当我在引号中手动指定密码时它起作用了,但现在我似乎无法取得任何进展
运行此程序时是否会重新启动mysql?如果是这样,你怎么知道问题是什么?
我正在新安装 Ubuntu 18.04 LTS。
提前致谢
root@project:/home/user/project# cat .env
NODE_ENV=production
NODE_PORT=88
MYSQL_USER=root
MYSQL_HOST=127.0.0.1
MYSQL_PORT=3306
MYSQL_DB=testdb
MYSQL_ROOT_PASSWORD=Pass(word123)
ALLOW_EMPTY_PASSWORD=no
PHPMYADMIN_HTTP_PORT=4324
root@project:/home/user/project#
root@project:/home/user/project# cat docker-compose.yml
---
version: "3.4"
services:
db:
image: "bitnami/mysql:5.7"
user: root
container_name: db
restart: always
ports:
- "${MYSQL_PORT}:3306"
networks:
- db
volumes:
- projectvolume:/bitnami/mysql
environment:
MYSQL_ROOT_PASSWORD:
ALLOW_EMPTY_PASSWORD:
phpmyadmin:
image: phpmyadmin/phpmyadmin
container_name: phpmyadmin
restart: always
ports:
- "${PHPMYADMIN_HTTP_PORT}:80"
networks:
- db
depends_on:
- db
environment:
PMA_HOST: db
PMA_PORT: "${MYSQL_PORT}"
networks:
db:
driver: bridge
volumes:
projectvolume:
root@project:/home/user/project#
root@project:/home/user/project# docker-compose config
networks:
db:
driver: bridge
services:
db:
container_name: db
environment:
ALLOW_EMPTY_PASSWORD: "no"
MYSQL_ROOT_PASSWORD: Pass(word123)
image: bitnami/mysql:5.7
networks:
db: null
ports:
- published: 3306
target: 3306
restart: always
user: root
volumes:
- projectvolume:/bitnami/mysql:rw
phpmyadmin:
container_name: phpmyadmin
depends_on:
- db
environment:
PMA_HOST: db
PMA_PORT: '3306'
image: phpmyadmin/phpmyadmin
networks:
db: null
ports:
- published: 5050
target: 80
restart: always
version: '3.4'
volumes:
projectvolume: {}
root@project:/home/user/project#
这是 docker ps 显示 mysql 重新启动
root@project:/home/user/project# docker-compose up -d
Creating network "project_db" with driver "bridge"
Creating db ...
Creating db ... done
Creating phpmyadmin ...
Creating phpmyadmin ... done
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 9 seconds ago Up 7 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 10 seconds ago Up Less than a second 0.0.0.0:3306->3306/tcp db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 10 seconds ago Up 8 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 11 seconds ago Up 2 seconds 0.0.0.0:3306->3306/tcp db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 11 seconds ago Up 9 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 12 seconds ago Restarting (11) 1 second ago db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 13 seconds ago Up 11 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 14 seconds ago Up Less than a second 0.0.0.0:3306->3306/tcp db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 14 seconds ago Up 12 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 15 seconds ago Up 1 second 0.0.0.0:3306->3306/tcp db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 15 seconds ago Up 13 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 16 seconds ago Restarting (11) Less than a second ago db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 16 seconds ago Up 14 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 17 seconds ago Restarting (11) 1 second ago db
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 17 seconds ago Up 15 seconds 0.0.0.0:5050->80/tcp phpmyadmin
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 18 seconds ago Up Less than a second 0.0.0.0:3306->3306/tcp db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 18 seconds ago Up 15 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 19 seconds ago Up 1 second 0.0.0.0:3306->3306/tcp db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 19 seconds ago Up 16 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 20 seconds ago Up 2 seconds 0.0.0.0:3306->3306/tcp db
root@project:/home/user/project# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
da4357bf9eb4 phpmyadmin/phpmyadmin "/docker-entrypoint.…" 20 seconds ago Up 17 seconds 0.0.0.0:5050->80/tcp phpmyadmin
e791552657f7 bitnami/mysql:5.7 "/entrypoint.sh /run…" 21 seconds ago Restarting (11) Less than a second ago db
root@project:/home/user/project#
这是 docker-compose 输出:
root@project:/home/user/project# docker-compose up
Creating network "project_db" with driver "bridge"
Creating db ...
Creating db ... done
Creating phpmyadmin ...
Creating phpmyadmin ... done
Attaching to db, phpmyadmin
phpmyadmin | phpMyAdmin not found in /var/www/html - copying now...
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:43.48
db | mysql 07:20:43.48 Welcome to the Bitnami mysql container
db | mysql 07:20:43.48 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:43.48 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:43.48 Send us your feedback at containers@bitnami.com
db | mysql 07:20:43.48
db | mysql 07:20:43.49 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:43.58 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:43.69 INFO ==> Initializing mysql database
db | mysql 07:20:43.72 INFO ==> Using persisted data
db | mysql 07:20:43.75 INFO ==> Running mysql_upgrade
db | mysql 07:20:43.76 INFO ==> Starting mysql in background
db | mysql 07:20:44.80 INFO ==> Stopping mysql
phpmyadmin | Complete! phpMyAdmin has been successfully copied to /var/www/html
phpmyadmin | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.29.0.3. Set the 'ServerName' directive globally to suppress this message
phpmyadmin | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.29.0.3. Set the 'ServerName' directive globally to suppress this message
phpmyadmin | [Wed Dec 18 07:20:45.128237 2019] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/7.2.25 configured -- resuming normal operations
phpmyadmin | [Wed Dec 18 07:20:45.128321 2019] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
db exited with code 11
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:43.48
db | mysql 07:20:43.48 Welcome to the Bitnami mysql container
db | mysql 07:20:43.48 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:43.48 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:43.48 Send us your feedback at containers@bitnami.com
db | mysql 07:20:43.48
db | mysql 07:20:43.49 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:43.58 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:43.69 INFO ==> Initializing mysql database
db | mysql 07:20:43.72 INFO ==> Using persisted data
db | mysql 07:20:43.75 INFO ==> Running mysql_upgrade
db | mysql 07:20:43.76 INFO ==> Starting mysql in background
db | mysql 07:20:44.80 INFO ==> Stopping mysql
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:48.31
db | mysql 07:20:48.31 Welcome to the Bitnami mysql container
db | mysql 07:20:48.31 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:48.31 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:48.31 Send us your feedback at containers@bitnami.com
db | mysql 07:20:48.32
db | mysql 07:20:48.32 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:48.38 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:48.39 INFO ==> Initializing mysql database
db | mysql 07:20:48.42 INFO ==> Using persisted data
db | mysql 07:20:48.43 INFO ==> Running mysql_upgrade
db | mysql 07:20:48.43 INFO ==> Starting mysql in background
db | mysql 07:20:49.46 INFO ==> Stopping mysql
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:51.93
db | mysql 07:20:51.93 Welcome to the Bitnami mysql container
db | mysql 07:20:51.94 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:51.94 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:51.94 Send us your feedback at containers@bitnami.com
db | mysql 07:20:51.94
db | mysql 07:20:51.94 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:52.02 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:52.03 INFO ==> Initializing mysql database
db | mysql 07:20:52.05 INFO ==> Using persisted data
db | mysql 07:20:52.07 INFO ==> Running mysql_upgrade
db | mysql 07:20:52.07 INFO ==> Starting mysql in background
db | mysql 07:20:53.10 INFO ==> Stopping mysql
db exited with code 11
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:43.48
db | mysql 07:20:43.48 Welcome to the Bitnami mysql container
db | mysql 07:20:43.48 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:43.48 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:43.48 Send us your feedback at containers@bitnami.com
db | mysql 07:20:43.48
db | mysql 07:20:43.49 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:43.58 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:43.69 INFO ==> Initializing mysql database
db | mysql 07:20:43.72 INFO ==> Using persisted data
db | mysql 07:20:43.75 INFO ==> Running mysql_upgrade
db | mysql 07:20:43.76 INFO ==> Starting mysql in background
db | mysql 07:20:44.80 INFO ==> Stopping mysql
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:48.31
db | mysql 07:20:48.31 Welcome to the Bitnami mysql container
db | mysql 07:20:48.31 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:48.31 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:48.31 Send us your feedback at containers@bitnami.com
db | mysql 07:20:48.32
db | mysql 07:20:48.32 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:48.38 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:48.39 INFO ==> Initializing mysql database
db | mysql 07:20:48.42 INFO ==> Using persisted data
db | mysql 07:20:48.43 INFO ==> Running mysql_upgrade
db | mysql 07:20:48.43 INFO ==> Starting mysql in background
db | mysql 07:20:49.46 INFO ==> Stopping mysql
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:51.93
db | mysql 07:20:51.93 Welcome to the Bitnami mysql container
db | mysql 07:20:51.94 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:51.94 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:51.94 Send us your feedback at containers@bitnami.com
db | mysql 07:20:51.94
db | mysql 07:20:51.94 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:52.02 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:52.03 INFO ==> Initializing mysql database
db | mysql 07:20:52.05 INFO ==> Using persisted data
db | mysql 07:20:52.07 INFO ==> Running mysql_upgrade
db | mysql 07:20:52.07 INFO ==> Starting mysql in background
db | mysql 07:20:53.10 INFO ==> Stopping mysql
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:20:55.75
db | mysql 07:20:55.75 Welcome to the Bitnami mysql container
db | mysql 07:20:55.75 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:20:55.76 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:20:55.76 Send us your feedback at containers@bitnami.com
db | mysql 07:20:55.76
db | mysql 07:20:55.76 INFO ==> ** Starting MySQL setup **
db | mysql 07:20:55.83 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:20:55.84 INFO ==> Initializing mysql database
db | mysql 07:20:55.86 INFO ==> Using persisted data
db | mysql 07:20:55.87 INFO ==> Running mysql_upgrade
db | mysql 07:20:55.88 INFO ==> Starting mysql in background
db | mysql 07:20:56.90 INFO ==> Stopping mysql
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | /libmysql.sh: line 500: DB_FLAVOR: unbound variable
db | /libmysql.sh: line 513: : bad substitution
db | mysql 07:21:01.00
db | mysql 07:21:01.00 Welcome to the Bitnami mysql container
db | mysql 07:21:01.00 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-mysql
db | mysql 07:21:01.00 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-mysql/issues
db | mysql 07:21:01.01 Send us your feedback at containers@bitnami.com
db | mysql 07:21:01.01
db | mysql 07:21:01.01 INFO ==> ** Starting MySQL setup **
db | mysql 07:21:01.08 INFO ==> Validating settings in MYSQL_*/MARIADB_* env vars
db | mysql 07:21:01.09 INFO ==> Initializing mysql database
db | mysql 07:21:01.11 INFO ==> Using persisted data
db | mysql 07:21:01.13 INFO ==> Running mysql_upgrade
db | mysql 07:21:01.14 INFO ==> Starting mysql in background
^CGracefully stopping... (press Ctrl+C again to force)
Stopping phpmyadmin ... done
Stopping db ... done
root@project:/home/user/project#
更新:
所以这真的让我很困惑:如果我用projectvolume
新卷替换卷,mysql 会正常运行。
我相信当我更改 .env 文件中的密码时,它以某种方式搞砸了。将密码设置回其原始值并不能解决问题。
现在,我想这可能是一个 UID/GID 问题,我已经仔细检查过,文件权限和 UID/GID 没有改变,据我所知是正确的。正在工作的原始卷是在我第一次运行时由容器创建的docker-compose up
,我创建了一个数据库并通过 phpmyadmin 将数据加载到其中,没有任何问题。一切都很好。
那么为什么更改密码会搞砸呢?我希望能够将这个 docker-compose 文件用于生产服务器,但由于它对改变事物如此脾气暴躁,我不太确定。我已经在网上阅读过,甚至与熟悉 docker 和 docker-compose 的同事交谈过,只要 UID/GID 正确,应该没有问题。那么这是bitnami/mysql5.7容器本身的问题吗?
我仍然想学习如何解决这个问题,以便我可以将它用于生产部署。我希望在周末之前启动该项目,但我不知道该怎么做。再次感谢您的洞察力!
解决方案
在这个GitHub issue中似乎有一个类似的问题,Bitnami 团队发布了一个带有修复的新图像版本。这对您来说是一个有效的解决方案吗?
推荐阅读
- c++ - while循环后如何继续阅读?
- jpa - 对实体内的列进行分组
- swift - 如果一个按钮被设置为触发到另一个视图控制器的 segue,如何可视化?
- php - 将输入类型从文本更改为多选下拉列表 - 技能分类
- angular - 管道未正确映射和错误处理 Angular
- python - 如何在 Keras 中将我的张量的 2D 子集与另一个 2D 张量分配?
- spring-boot - Spring Boot Autowired 模型中的 repo
- liquid - 液体模板:将字符串值解析为对象并用作变量
- php - 如何在 Google Cloud Platform 上的 App Engine 中更改 php 版本(运行时)?
- python - 如何从 HTML 中提取列到列表中?