Skip to content

Archery-1.12.0 版本docker-compose 部署后Mysql一刷报错 #3104

@yangyaodong1

Description

@yangyaodong1

重现步骤

root@k8s-master1:/data/archery/Archery-1.12.0/src/docker-compose# docker logs  -f mysql
2025-12-15 06:22:31+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
2025-12-15 06:22:31+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-12-15 06:22:31+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-12-15T06:22:31.623006Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-12-15T06:22:31.624196Z 0 [Note] mysqld (mysqld 5.7.44-log) starting as process 1 ...
2025-12-15T06:22:31.626661Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-12-15T06:22:31.626678Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-12-15T06:22:31.626682Z 0 [Note] InnoDB: Uses event mutexes
2025-12-15T06:22:31.626685Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2025-12-15T06:22:31.626688Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-12-15T06:22:31.626692Z 0 [Note] InnoDB: Using Linux native AIO
2025-12-15T06:22:31.626882Z 0 [Note] InnoDB: Number of pools: 1
2025-12-15T06:22:31.626965Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-12-15T06:22:31.628156Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2025-12-15T06:22:31.650569Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-12-15T06:22:31.655372Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-12-15T06:22:31.666570Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-12-15T06:22:31.677891Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-12-15T06:22:31.677929Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-12-15T06:22:31.692828Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2025-12-15T06:22:31.693374Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2025-12-15T06:22:31.693380Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2025-12-15T06:22:31.693657Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 12219719
2025-12-15T06:22:31.693750Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-12-15T06:22:31.693890Z 0 [Note] Plugin 'FEDERATED' is disabled.
2025-12-15T06:22:31.694863Z 0 [Note] InnoDB: Buffer pool(s) load completed at 251215  6:22:31
2025-12-15T06:22:31.701643Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2025-12-15T06:22:31.701650Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2025-12-15T06:22:31.701653Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2025-12-15T06:22:31.701654Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2025-12-15T06:22:31.702107Z 0 [Warning] CA certificate ca.pem is self signed.
2025-12-15T06:22:31.702135Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2025-12-15T06:22:31.702197Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2025-12-15T06:22:31.702226Z 0 [Note] IPv6 is available.
2025-12-15T06:22:31.702234Z 0 [Note]   - '::' resolves to '::';
2025-12-15T06:22:31.702243Z 0 [Note] Server socket created on IP: '::'.
2025-12-15T06:22:31.703855Z 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.
2025-12-15T06:22:31.706205Z 0 [Note] Failed to start slave threads for channel ''
2025-12-15T06:22:31.708965Z 0 [Note] Event Scheduler: Loaded 0 events
2025-12-15T06:22:31.709086Z 0 [Note] mysqld: ready for connections.
Version: '5.7.44-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2025-12-15T06:22:36.223983Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2025-12-15T06:22:38.082915Z 3 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:39.439429Z 4 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:40.939552Z 5 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:41.290748Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2025-12-15T06:22:42.439521Z 7 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:43.939593Z 8 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:45.439561Z 9 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:46.351348Z 10 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2025-12-15T06:22:46.939667Z 11 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:48.083150Z 12 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:48.439694Z 13 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:49.939847Z 14 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)
2025-12-15T06:22:51.418866Z 15 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2025-12-15T06:22:51.439827Z 16 [Note] Access denied for user 'jylt@2019'@'192.168.64.33' (using password: YES)

2、env文件配置如下

root@k8s-master1:/data/archery/Archery-1.12.0/src/docker-compose# cat .env
NGINX_PORT=9123

# https://django-environ.readthedocs.io/en/latest/quickstart.html#usage
# https://docs.djangoproject.com/zh-hans/4.1/ref/settings/
DEBUG=false
DATABASE_URL=mysql://root:123456@127.0.0.1:3306/archery
CACHE_URL=redis://redis:6379/0?PASSWORD=123456

# https://docs.djangoproject.com/en/4.0/ref/settings/#csrf-trusted-origins
CSRF_TRUSTED_ORIGINS=http://127.0.0.1:9123

# https://django-auth-ldap.readthedocs.io/en/latest/
ENABLE_LDAP=false
AUTH_LDAP_ALWAYS_UPDATE_USER=true
AUTH_LDAP_USER_ATTR_MAP=username=cn,display=displayname,email=email

# https://django-q.readthedocs.io/en/latest/configure.html#
Q_CLUISTER_WORKERS=4
Q_CLUISTER_TIMEOUT=60
Q_CLUISTER_SYNC=false

# 在网站标题及登录页面追加此内容, 可用于多archery实例的区分。Archery后台也有相同配置,如都做了配置,以后台配置为准
CUSTOM_TITLE_SUFFIX = ""

预期外的结果

Image

日志文本

版本

1.12.0

部署方式

Docker

是否还有其他可以辅助定位问题的信息?比如数据库版本等

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions