Unable to start MySQL 5.7 container

[whitehorsesoft]

Container freshly pulled starts, but then fails immediately, with recommended options:

docker container run -d -e MYSQL_ROOT_PASSWORD=pass mysql:5.7

Logs:

2023-03-03 20:17:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.
2023-03-03 20:17:52+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-03-03 20:17:52+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.
2023-03-03 20:18:06+00:00 [Note] [Entrypoint]: Initializing database files
2023-03-03T20:18:07.750669Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-03T20:18:07.915358Z 0 [Warning] InnoDB: New log files created, LSN=45790
2023-03-03T20:18:07.954355Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2023-03-03T20:18:08.020039Z 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: 83134d74-ba00-11ed-aeeb-0242ac110002.
2023-03-03T20:18:08.023939Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2023-03-03T20:18:08.333806Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-03-03T20:18:08.333814Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-03-03T20:18:08.334241Z 0 [Warning] CA certificate ca.pem is self signed.
2023-03-03T20:18:08.469326Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2023-03-03 20:18:11+00:00 [Note] [Entrypoint]: Database files initialized
2023-03-03 20:18:11+00:00 [Note] [Entrypoint]: Starting temporary server
2023-03-03 20:18:11+00:00 [Note] [Entrypoint]: Waiting for server startup
2023-03-03T20:18:13.690541Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-03T20:18:13.691363Z 0 [Note] mysqld (mysqld 5.7.41) starting as process 125 ...
2023-03-03T20:18:13.693475Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-03-03T20:18:13.693486Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-03T20:18:13.693488Z 0 [Note] InnoDB: Uses event mutexes
2023-03-03T20:18:13.693489Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-03-03T20:18:13.693491Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-03T20:18:13.693493Z 0 [Note] InnoDB: Using Linux native AIO
2023-03-03T20:18:13.693718Z 0 [Note] InnoDB: Number of pools: 1
2023-03-03T20:18:13.693801Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-03-03T20:18:13.694699Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-03-03T20:18:13.699377Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-03T20:18:13.700724Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-03-03T20:18:13.711871Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-03T20:18:13.743167Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-03-03T20:18:13.743309Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-03-03T20:18:13.767157Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-03-03T20:18:13.767852Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-03-03T20:18:13.767859Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-03-03T20:18:13.768373Z 0 [Note] InnoDB: 5.7.41 started; log sequence number 2762314
2023-03-03T20:18:13.768551Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-03-03T20:18:13.768737Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-03-03T20:18:13.769439Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230303 20:18:13
2023-03-03T20:18:13.773673Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-03-03T20:18:13.773685Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-03-03T20:18:13.773687Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-03-03T20:18:13.773689Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-03-03T20:18:13.774209Z 0 [Warning] CA certificate ca.pem is self signed.
2023-03-03T20:18:13.774239Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-03-03T20:18:13.778108Z 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.
2023-03-03T20:18:13.783702Z 0 [Note] Event Scheduler: Loaded 0 events
2023-03-03T20:18:13.784005Z 0 [Note] mysqld: ready for connections.
Version: '5.7.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
2023-03-03 20:18:13+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
/usr/local/bin/docker-entrypoint.sh: line 113:   125 Killed                  "$@" --skip-networking --default-time-zone=SYSTEM --socket="${SOCKET}"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

[tianon]

That looks like it's running out of memory; my best guess is that this is a duplicate of #950

[whitehorsesoft]

Thank you, you are partially correct. The actual duplicate is #579.

[whitehorsesoft]

Closing as duplicate of #579