-
Notifications
You must be signed in to change notification settings - Fork 2.2k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Not run mysql 5.7 in docker #840
Comments
docker versionClient: Docker Engine - Community Server: Docker Engine - Community |
I'm not able to reproduce $ docker run --cpus=".5" --memory=4g -d --name mysql -e MYSQL_ROOT_PASSWORD=admin -e MYSQL_DATABASE=app-db -e MYSQL_USERNAME=app-user -e MYSQL_PASSWORD=app-secret mysql:5.7
WARNING: Your kernel does not support swap limit capabilities or the cgroup is not mounted. Memory limited without swap.
f1cd17bfe3f69558708432d379109b9218e7c24e4f73ad6adc883f681b8c5d19 docker logs2022-04-08 20:40:56+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.37-1debian10 started.
2022-04-08 20:40:56+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-04-08 20:40:56+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.37-1debian10 started.
2022-04-08 20:40:56+00:00 [Warn] [Entrypoint]: MYSQL_PASSWORD specified, but missing MYSQL_USER; MYSQL_PASSWORD will be ignored
2022-04-08 20:40:56+00:00 [Note] [Entrypoint]: Initializing database files
2022-04-08T20:40:56.939952Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-08T20:40:57.534718Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-04-08T20:40:57.619978Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-04-08T20:40:57.630769Z 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: 3185914b-b77c-11ec-9809-0242ac110004.
2022-04-08T20:40:57.634519Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-04-08T20:40:59.377488Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-04-08T20:40:59.377528Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-04-08T20:40:59.378172Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-08T20:41:00.060961Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2022-04-08 20:41:02+00:00 [Note] [Entrypoint]: Database files initialized
2022-04-08 20:41:02+00:00 [Note] [Entrypoint]: Starting temporary server
2022-04-08 20:41:02+00:00 [Note] [Entrypoint]: Waiting for server startup
2022-04-08T20:41:02.950117Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-08T20:41:02.954669Z 0 [Note] mysqld (mysqld 5.7.37) starting as process 78 ...
2022-04-08T20:41:02.959449Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-04-08T20:41:02.959487Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-08T20:41:02.959491Z 0 [Note] InnoDB: Uses event mutexes
2022-04-08T20:41:02.959494Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-04-08T20:41:02.959497Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-08T20:41:02.959500Z 0 [Note] InnoDB: Using Linux native AIO
2022-04-08T20:41:02.960053Z 0 [Note] InnoDB: Number of pools: 1
2022-04-08T20:41:02.960285Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-04-08T20:41:02.963546Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-04-08T20:41:02.976465Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-08T20:41:03.034316Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-08T20:41:03.048094Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-04-08T20:41:03.062985Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-08T20:41:03.063066Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-08T20:41:03.108570Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-04-08T20:41:03.109636Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-04-08T20:41:03.109723Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-04-08T20:41:03.110558Z 0 [Note] InnoDB: 5.7.37 started; log sequence number 2749985
2022-04-08T20:41:03.111248Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-04-08T20:41:03.111344Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-04-08T20:41:03.114519Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220408 20:41:03
2022-04-08T20:41:03.132493Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-04-08T20:41:03.132717Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-04-08T20:41:03.132788Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-04-08T20:41:03.132860Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-04-08T20:41:03.133640Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-08T20:41:03.133919Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-04-08T20:41:03.135961Z 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.
2022-04-08T20:41:03.150024Z 0 [Note] Event Scheduler: Loaded 0 events
2022-04-08T20:41:03.150473Z 0 [Note] mysqld: ready for connections.
Version: '5.7.37' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
2022-04-08 20:41:03+00:00 [Note] [Entrypoint]: Temporary server started.
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2022-04-08 20:41:08+00:00 [Note] [Entrypoint]: Creating database app-db
2022-04-08 20:41:08+00:00 [Note] [Entrypoint]: Stopping temporary server
2022-04-08T20:41:08.445168Z 0 [Note] Giving 0 client threads a chance to die gracefully
2022-04-08T20:41:08.445210Z 0 [Note] Shutting down slave threads
2022-04-08T20:41:08.445218Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-04-08T20:41:08.445224Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-04-08T20:41:08.445376Z 0 [Note] Binlog end
2022-04-08T20:41:08.446585Z 0 [Note] Shutting down plugin 'ngram'
2022-04-08T20:41:08.446648Z 0 [Note] Shutting down plugin 'partition'
2022-04-08T20:41:08.446652Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-04-08T20:41:08.446659Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-04-08T20:41:08.446661Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-04-08T20:41:08.446703Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-04-08T20:41:08.446707Z 0 [Note] Shutting down plugin 'MyISAM'
2022-04-08T20:41:08.446718Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-04-08T20:41:08.446724Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-04-08T20:41:08.446727Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-04-08T20:41:08.446729Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-04-08T20:41:08.446731Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-04-08T20:41:08.446733Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-04-08T20:41:08.446736Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-04-08T20:41:08.446737Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-04-08T20:41:08.446740Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-04-08T20:41:08.446742Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-04-08T20:41:08.446744Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-04-08T20:41:08.446746Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-04-08T20:41:08.446748Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-04-08T20:41:08.446750Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-04-08T20:41:08.446752Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-04-08T20:41:08.446754Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-04-08T20:41:08.446756Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-04-08T20:41:08.446758Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-04-08T20:41:08.446760Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-04-08T20:41:08.446762Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-04-08T20:41:08.446763Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-04-08T20:41:08.446766Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-04-08T20:41:08.446767Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-04-08T20:41:08.446769Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-04-08T20:41:08.446771Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-04-08T20:41:08.446773Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-04-08T20:41:08.446775Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-04-08T20:41:08.446777Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-04-08T20:41:08.446779Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-04-08T20:41:08.446781Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-04-08T20:41:08.446783Z 0 [Note] Shutting down plugin 'InnoDB'
2022-04-08T20:41:08.446880Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-04-08T20:41:08.447117Z 0 [Note] InnoDB: Starting shutdown...
2022-04-08T20:41:08.547519Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-04-08T20:41:08.548028Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220408 20:41:08
2022-04-08T20:41:10.061074Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12659913
2022-04-08T20:41:10.062905Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-04-08T20:41:10.062958Z 0 [Note] Shutting down plugin 'MEMORY'
2022-04-08T20:41:10.062966Z 0 [Note] Shutting down plugin 'CSV'
2022-04-08T20:41:10.062971Z 0 [Note] Shutting down plugin 'sha256_password'
2022-04-08T20:41:10.062974Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-04-08T20:41:10.063130Z 0 [Note] Shutting down plugin 'binlog'
2022-04-08T20:41:10.066802Z 0 [Note] mysqld: Shutdown complete
2022-04-08 20:41:10+00:00 [Note] [Entrypoint]: Temporary server stopped
2022-04-08 20:41:10+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2022-04-08T20:41:10.848778Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-08T20:41:10.850912Z 0 [Note] mysqld (mysqld 5.7.37) starting as process 1 ...
2022-04-08T20:41:10.854583Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-04-08T20:41:10.854652Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-08T20:41:10.854658Z 0 [Note] InnoDB: Uses event mutexes
2022-04-08T20:41:10.854663Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-04-08T20:41:10.854668Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-08T20:41:10.854673Z 0 [Note] InnoDB: Using Linux native AIO
2022-04-08T20:41:10.854961Z 0 [Note] InnoDB: Number of pools: 1
2022-04-08T20:41:10.855098Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-04-08T20:41:10.857784Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-04-08T20:41:10.867802Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-08T20:41:10.871089Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-08T20:41:10.883565Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-04-08T20:41:10.930031Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-08T20:41:10.930392Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-08T20:41:10.979990Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-04-08T20:41:10.981140Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-04-08T20:41:10.981334Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-04-08T20:41:10.981851Z 0 [Note] InnoDB: Waiting for purge to start
2022-04-08T20:41:11.032294Z 0 [Note] InnoDB: 5.7.37 started; log sequence number 12659913
2022-04-08T20:41:11.033547Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-04-08T20:41:11.037077Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-04-08T20:41:11.041241Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-04-08T20:41:11.041476Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-04-08T20:41:11.041524Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-04-08T20:41:11.041546Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-04-08T20:41:11.042307Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-08T20:41:11.042427Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-04-08T20:41:11.042606Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220408 20:41:11
2022-04-08T20:41:11.043435Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-04-08T20:41:11.043572Z 0 [Note] IPv6 is available.
2022-04-08T20:41:11.043612Z 0 [Note] - '::' resolves to '::';
2022-04-08T20:41:11.043640Z 0 [Note] Server socket created on IP: '::'.
2022-04-08T20:41:11.044770Z 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.
2022-04-08T20:41:11.056510Z 0 [Note] Event Scheduler: Loaded 0 events
2022-04-08T20:41:11.057146Z 0 [Note] mysqld: ready for connections.
Version: '5.7.37' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) It looks like you gave it a command at the end that it error'd on |
I am facing the same problem. More specifically, when I start the container the system goes to 100% memory usage (no matter how much unused memory there is, in my case there were 10 gigabytes unused) and I get the following docker logs:
Also, when I create a container with
|
This is a containerd bug with a new kernel on Fedora35 апр 11 08:40:09 tk-kv.localhost kernel: eth0: renamed from vethe040851 |
I don't think there's anything we can really do to fix this in the Docker image (so I'm going to close). 😬 |
Hi. Mysql does not start
docker run --cpus=".5" --memory=4g -d --name mysql -e MYSQL_ROOT_PASSWORD=admin -e MYSQL_DATABASE=app-db -e MYSQL_USERNAME=app-user -e MYSQL_PASSWORD=app-secret mysql:5.7
docker logs 572bf0f67ae6
2022-04-08 20:20:46+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.37-1debian10 started.
2022-04-08 20:21:22+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
command was: mysqld --verbose --help --log-bin-index=/tmp/tmp.cDE9Y3Xtww
docker info
Client:
Context: default
Debug Mode: false
Plugins:
app: Docker App (Docker Inc., v0.9.1-beta3)
buildx: Docker Buildx (Docker Inc., v0.8.1-docker)
scan: Docker Scan (Docker Inc., v0.17.0)
Server:
Containers: 13
Running: 0
Paused: 0
Stopped: 13
Images: 328
Server Version: 20.10.14
Storage Driver: overlay2
Backing Filesystem: extfs
Supports d_type: true
Native Overlay Diff: true
userxattr: false
Logging Driver: json-file
Cgroup Driver: systemd
Cgroup Version: 2
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Log: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslog
Swarm: inactive
Runtimes: io.containerd.runtime.v1.linux runc io.containerd.runc.v2
Default Runtime: runc
Init Binary: docker-init
containerd version: 3df54a852345ae127d1fa3092b95168e4a88e2f8
runc version: v1.0.3-0-gf46b6ba
init version: de40ad0
Security Options:
seccomp
Profile: default
cgroupns
Kernel Version: 5.16.18-200.fc35.x86_64
Operating System: Fedora Linux 35 (KDE Plasma)
OSType: linux
Architecture: x86_64
CPUs: 4
Total Memory: 15.58GiB
Name: tkachuk-kv.localhost
ID: ZHLA:YNSD:2NNK:SLYH:TVM4:FWBV:XGFL:3T5K:IUQU:BNZ7:BKVG:LU6N
Docker Root Dir: /home/docker_data
Debug Mode: false
Username: inextuser
Registry: https://index.docker.io/v1/
Labels:
Experimental: false
Insecure Registries:
127.0.0.0/8
Live Restore Enabled: false
The text was updated successfully, but these errors were encountered: