GreatSQL社区

搜索

dock中数据库自动关闭情况

164 8 2025-4-28 15:29
在没网的情况下,启动镜像后1-2分钟就关闭了数据库,报错如下



Could not find OpenSSL on the system
MySQL init process in progress...
MySQL init process failed.


急急急
全部回复(8)
yejr 2025-4-28 15:32:01
请详细补充如何启动Docker容器的,如: docker run ...

以及详细的日志信息,如:docker logs ....
sl28271495 2025-4-28 15:39:02
yejr 发表于 2025-4-28 15:32
请详细补充如何启动Docker容器的,如: docker run ...

以及详细的日志信息,如:docker logs .... ...

启动命令:docker run -d -v /home/greatSql/data:/merged/data/GreatSQL --name greatsql --hostname=greatsql -e MYSQL_ALLOW_EMPTY_PASSWORD=1 greatsql/greatsql
sl28271495 2025-4-28 15:39:48
yejr 发表于 2025-4-28 15:32
请详细补充如何启动Docker容器的,如: docker run ...

以及详细的日志信息,如:docker logs .... ...

启动命令:docker run -d -v /home/greatSql/data:/merged/data/GreatSQL --name greatsql --hostname=greatsql -e MYSQL_ALLOW_EMPTY_PASSWORD=1 registry.cn-beijing.aliyuncs.com/greatsql/greatsql
sl28271495 2025-4-28 15:40:22
yejr 发表于 2025-4-28 15:32
请详细补充如何启动Docker容器的,如: docker run ...

以及详细的日志信息,如:docker logs .... ...

启动命令:docker run -d -v /home/greatSql/data:/merged/data/GreatSQL --name greatsql --hostname=greatsql -e MYSQL_ALLOW_EMPTY_PASSWORD=1 registry.cn-beijing.aliyuncs.com/greatsql/greatsql
sl28271495 2025-4-28 15:40:55
yejr 发表于 2025-4-28 15:32
请详细补充如何启动Docker容器的,如: docker run ...

以及详细的日志信息,如:docker logs .... ...

报错Initializing database
Database initialized
Initializing certificates
2025-04-28 07:42:35 [ERROR]   Could not find OpenSSL on the system
Certificates initialized
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
MySQL init process in progress...
yejr 2025-4-28 15:46:27
sl28271495 发表于 2025-4-28 15:40
报错Initializing database
Database initialized
Initializing certificates

我和你用完全一样的命令拉起,看起来是正常的
  1. # history | tail
  2. 1085  mkdir -p /home/greatSql/data
  3. 1086  docker run -d -v /home/greatSql/data:/merged/data/GreatSQL --name tt1 --hostname=tt1 -e MYSQL_ALLOW_EMPTY_PASSWORD=1 registry.cn-beijing.aliyuncs.com/greatsql/greatsql
  4. 1087  docker logs tt1

  5. # docker logs tt1
  6. Initializing database
  7. Database initialized
  8. MySQL init process in progress...
  9. MySQL init process in progress...
  10. MySQL init process in progress...
  11. MySQL init process in progress...
  12. mysql: [Warning] Using a password on the command line interface can be insecure.
  13. Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
  14. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
  15. Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
  16. Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
  17. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
  18. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
  19. mysql: [Warning] Using a password on the command line interface can be insecure.

  20. /greatsql-init.sh: ignoring /docker-entrypoint-initdb.d/*


  21. MySQL init process done. Ready for start up.
复制代码


可以正常启动。

你的宿主OS以及docker版本是哪个,可能是版本的问题,之前有其他用户遇到可能类似的情况 https://greatsql.cn/thread-1034-1-1.html
yejr 2025-4-29 10:35:07
yejr 发表于 2025-4-28 15:46
我和你用完全一样的命令拉起,看起来是正常的

我又换了个openKylin的虚机环境测试,也是OK的

  1. # cat /etc/os-release
  2. NAME="openKylin"
  3. FULL_NAME="openKylin"
  4. VERSION="2.0 SP1 (nile)"
  5. VERSION_US="2.0 SP1 (nile)"
  6. ID=openkylin
  7. PRETTY_NAME="openKylin 2.0 SP1"
  8. VERSION_ID="2.0"
  9. HOME_URL="https://www.openkylin.top/"
  10. VERSION_CODENAME=nile
  11. PRODUCT_FEATURES=3

  12. # arch
  13. aarch64

  14. # ldd --version
  15. ldd (Ubuntu GLIBC 2.38-1ok6.9) 2.38
  16. Copyright (C) 2023 Free Software Foundation, Inc.
  17. This is free software; see the source for copying conditions.  There is NO
  18. warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  19. Written by Roland McGrath and Ulrich Drepper.


  20. # mkdir -p /home/greatSql/data

  21. # docker run -d -v /home/greatSql/data:/merged/data/GreatSQL --name tt1 --hostname=tt1 -e MYSQL_ALLOW_EMPTY_PASSWORD=1 registry.cn-beijing.aliyuncs.com/greatsql/greatsql
  22. Unable to find image 'registry.cn-beijing.aliyuncs.com/greatsql/greatsql:latest' locally
  23. latest: Pulling from greatsql/greatsql
  24. 55a6912e699c: Pull complete
  25. 330a48c0446c: Pull complete
  26. Digest: sha256:69304dfc7712c13274fa722fd4aa1da62402d6f47251e5073f8af858b59e7fac
  27. Status: Downloaded newer image for registry.cn-beijing.aliyuncs.com/greatsql/greatsql:latest
  28. 9b0258cd2d9b6ead4a9f53fe1aa2efb2d80763fac93c6c4720cdfa0f580fcfe2

  29. # docker logs tt1
  30. Initializing database
  31. Database initialized
  32. MySQL init process in progress...
  33. mysql: [Warning] Using a password on the command line interface can be insecure.
  34. Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
  35. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
  36. Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
  37. Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
  38. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
  39. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
  40. mysql: [Warning] Using a password on the command line interface can be insecure.

  41. /greatsql-init.sh: ignoring /docker-entrypoint-initdb.d/*


  42. MySQL init process done. Ready for start up.
复制代码

上面是详细过程。

还是请提供更多详细信息以便排查,或者先自查你的运行环境有什么问题吧。
yejr 前天 11:16
怀疑是SELinux原因导致的,暂时找到解决方案了,启动容器时加上 --privileged 参数,即:docker run -d --privileged  --name greatsql --hostname=greatsql -e MYSQL_ALLOW_EMPTY_PASSWORD=1 registry.cn-beijing.aliyuncs.com/greatsql/greatsql 应该就可以
sl28271495

3

主题

0

博客

11

贡献

新手上路

Rank: 1

积分
19

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2025-5-9 23:31 , Processed in 0.020748 second(s), 17 queries , Redis On.
快速回复 返回顶部 返回列表