Docker image for 5.7.37 fails to start #844
Labels
question
Usability question, not directly related to an error with the image
Comments
3 tasks
|
I'm not able to reproduce an issue with connecting using the unix socket $ docker run -d --name my37 -e MYSQL_ROOT_PASSWORD=my-secret-pw mysql:5.7.37
Unable to find image 'mysql:5.7.37' locally
5.7.37: Pulling from library/mysql
4be315f6562f: Pull complete
96e2eb237a1b: Pull complete
8aa3ac85066b: Pull complete
ac7e524f6c89: Pull complete
f6a88631064f: Pull complete
15bb3ec3ff50: Pull complete
ae65dc337dcb: Pull complete
291c7612f7a8: Pull complete
ffdc84226e0b: Pull complete
81340df4a52c: Pull complete
f3ec63f52b87: Pull complete
Digest: sha256:151ecb87a07404f2c2588464e86381bdf74795c6d24090f9c50bc8e947a57797
Status: Downloaded newer image for mysql:5.7.37
b95637a8679f1b877ad4fea10f9c9ce7ec9ef3cfeeed5d702cf67f477c8a6f2f
$ docker exec -it my37 mysql -u root -p -S /var/run/mysqld/mysqld.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.37 MySQL Community Server (GPL)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
docker logs$ docker logs my37
2022-04-21 16:29:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.37-1debian10 started.
2022-04-21 16:29:17+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-04-21 16:29:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.37-1debian10 started.
2022-04-21 16:29:17+00:00 [Note] [Entrypoint]: Initializing database files
2022-04-21T16:29:17.685585Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-21T16:29:18.033917Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-04-21T16:29:18.100988Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-04-21T16:29:18.158572Z 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: 30e7b4ef-c190-11ec-bfe4-0242ac110002.
2022-04-21T16:29:18.159551Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-04-21T16:29:18.847265Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-04-21T16:29:18.847314Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-04-21T16:29:18.848166Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-21T16:29:18.922430Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2022-04-21 16:29:21+00:00 [Note] [Entrypoint]: Database files initialized
2022-04-21 16:29:21+00:00 [Note] [Entrypoint]: Starting temporary server
2022-04-21 16:29:21+00:00 [Note] [Entrypoint]: Waiting for server startup
2022-04-21T16:29:21.421453Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-21T16:29:21.428840Z 0 [Note] mysqld (mysqld 5.7.37) starting as process 78 ...
2022-04-21T16:29:21.437852Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-04-21T16:29:21.437896Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-21T16:29:21.437902Z 0 [Note] InnoDB: Uses event mutexes
2022-04-21T16:29:21.437906Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-04-21T16:29:21.437910Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-21T16:29:21.437914Z 0 [Note] InnoDB: Using Linux native AIO
2022-04-21T16:29:21.438337Z 0 [Note] InnoDB: Number of pools: 1
2022-04-21T16:29:21.438662Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-04-21T16:29:21.442470Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-04-21T16:29:21.457947Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-21T16:29:21.463805Z 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-21T16:29:21.480094Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-04-21T16:29:21.496732Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-21T16:29:21.496849Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-21T16:29:21.542507Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-04-21T16:29:21.543381Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-04-21T16:29:21.543403Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-04-21T16:29:21.543996Z 0 [Note] InnoDB: Waiting for purge to start
2022-04-21T16:29:21.594235Z 0 [Note] InnoDB: 5.7.37 started; log sequence number 2749976
2022-04-21T16:29:21.594777Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-04-21T16:29:21.595115Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-04-21T16:29:21.597456Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220421 16:29:21
2022-04-21T16:29:21.607832Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-04-21T16:29:21.607865Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-04-21T16:29:21.607872Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-04-21T16:29:21.607875Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-04-21T16:29:21.608494Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-21T16:29:21.608537Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-04-21T16:29:21.610161Z 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-21T16:29:21.619831Z 0 [Note] Event Scheduler: Loaded 0 events
2022-04-21T16:29:21.620293Z 0 [Note] mysqld: ready for connections.
Version: '5.7.37' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
2022-04-21 16:29:22+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-21 16:29:23+00:00 [Note] [Entrypoint]: Stopping temporary server
2022-04-21T16:29:23.881404Z 0 [Note] Giving 0 client threads a chance to die gracefully
2022-04-21T16:29:23.881445Z 0 [Note] Shutting down slave threads
2022-04-21T16:29:23.881450Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-04-21T16:29:23.881460Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-04-21T16:29:23.881560Z 0 [Note] Binlog end
2022-04-21T16:29:23.882250Z 0 [Note] Shutting down plugin 'ngram'
2022-04-21T16:29:23.882275Z 0 [Note] Shutting down plugin 'partition'
2022-04-21T16:29:23.882279Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-04-21T16:29:23.882282Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-04-21T16:29:23.882284Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-04-21T16:29:23.882357Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-04-21T16:29:23.882361Z 0 [Note] Shutting down plugin 'MyISAM'
2022-04-21T16:29:23.882375Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-04-21T16:29:23.882389Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-04-21T16:29:23.882393Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-04-21T16:29:23.882397Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-04-21T16:29:23.882401Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-04-21T16:29:23.882405Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-04-21T16:29:23.882408Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-04-21T16:29:23.882448Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-04-21T16:29:23.882451Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-04-21T16:29:23.882453Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-04-21T16:29:23.882455Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-04-21T16:29:23.882457Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-04-21T16:29:23.882459Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-04-21T16:29:23.882462Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-04-21T16:29:23.882464Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-04-21T16:29:23.882466Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-04-21T16:29:23.882468Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-04-21T16:29:23.882470Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-04-21T16:29:23.882472Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-04-21T16:29:23.882474Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-04-21T16:29:23.882476Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-04-21T16:29:23.882478Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-04-21T16:29:23.882480Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-04-21T16:29:23.882483Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-04-21T16:29:23.882485Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-04-21T16:29:23.882486Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-04-21T16:29:23.882488Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-04-21T16:29:23.882491Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-04-21T16:29:23.882493Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-04-21T16:29:23.882495Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-04-21T16:29:23.882497Z 0 [Note] Shutting down plugin 'InnoDB'
2022-04-21T16:29:23.882622Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-04-21T16:29:23.882794Z 0 [Note] InnoDB: Starting shutdown...
2022-04-21T16:29:23.983316Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-04-21T16:29:23.983704Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220421 16:29:23
2022-04-21T16:29:25.506651Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12659904
2022-04-21T16:29:25.509059Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-04-21T16:29:25.509101Z 0 [Note] Shutting down plugin 'MEMORY'
2022-04-21T16:29:25.509107Z 0 [Note] Shutting down plugin 'CSV'
2022-04-21T16:29:25.509111Z 0 [Note] Shutting down plugin 'sha256_password'
2022-04-21T16:29:25.509113Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-04-21T16:29:25.509297Z 0 [Note] Shutting down plugin 'binlog'
2022-04-21T16:29:25.510802Z 0 [Note] mysqld: Shutdown complete
2022-04-21 16:29:25+00:00 [Note] [Entrypoint]: Temporary server stopped
2022-04-21 16:29:25+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2022-04-21T16:29:26.131534Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-21T16:29:26.134442Z 0 [Note] mysqld (mysqld 5.7.37) starting as process 1 ...
2022-04-21T16:29:26.138124Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-04-21T16:29:26.138158Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-21T16:29:26.138161Z 0 [Note] InnoDB: Uses event mutexes
2022-04-21T16:29:26.138167Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-04-21T16:29:26.138170Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-21T16:29:26.138173Z 0 [Note] InnoDB: Using Linux native AIO
2022-04-21T16:29:26.138492Z 0 [Note] InnoDB: Number of pools: 1
2022-04-21T16:29:26.138741Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-04-21T16:29:26.141504Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-04-21T16:29:26.152478Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-21T16:29:26.156860Z 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-21T16:29:26.169324Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-04-21T16:29:26.179414Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-21T16:29:26.179499Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-04-21T16:29:26.215725Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-04-21T16:29:26.216910Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-04-21T16:29:26.216936Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-04-21T16:29:26.217836Z 0 [Note] InnoDB: 5.7.37 started; log sequence number 12659904
2022-04-21T16:29:26.218206Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-04-21T16:29:26.218254Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-04-21T16:29:26.224451Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220421 16:29:26
2022-04-21T16:29:26.227977Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-04-21T16:29:26.228011Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-04-21T16:29:26.228016Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-04-21T16:29:26.228018Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-04-21T16:29:26.228675Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-21T16:29:26.228718Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-04-21T16:29:26.229719Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-04-21T16:29:26.229830Z 0 [Note] IPv6 is available.
2022-04-21T16:29:26.229995Z 0 [Note] - '::' resolves to '::';
2022-04-21T16:29:26.230110Z 0 [Note] Server socket created on IP: '::'.
2022-04-21T16:29:26.231215Z 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-21T16:29:26.242339Z 0 [Note] Event Scheduler: Loaded 0 events
2022-04-21T16:29:26.242861Z 0 [Note] mysqld: ready for connections.
Version: '5.7.37' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) |
wglambert
added
the
question
|
@tianon May we consider re-opening this issue for further investigations? Many similar was opened but this one brings the simplest way to reproduce. I got to the exact same situation of @fedinskiy, fixed by using Please also note if we do the same using Here is my docker info: Details
And my OS details: Details
Please ask if you need another details. It looks indeed the bug appears only on some operating system conditions. Thanks! |
|
I'm glad you've narrowed it down! I would suggest filing an issue with upstream MySQL with details -- even better if you can test it without Docker involved at all (just installing MySQL 5.7.36 and then updating it to 5.7.42 and verifying that it still breaks in the same way). We're a pretty faithful packaging of Oracle's own binaries (we don't build MySQL from source or anything esoteric like that), and our configuration changes are fairly minor, so any issue of this sort is very unlikely to be specific to our image, and is much more likely to be something in MySQL itself or in the environment/setup. |
|
@soullivaneuh, the two images: Note: that could not be the case for the original issue since we didn't change the default until |
9 tasks
|
I can also confirm the problem. mysql_legacy:
# https://dev.mysql.com/doc/refman/5.7/en/charset-server.html
command:
- "--character-set-server=utf8mb4"
- "--collation-server=utf8mb4_unicode_ci"
container_name: "${COMPOSE_PROJECT_NAME}-mysql_legacy"
# https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
environment:
MYSQLD_EXPORTER_PASSWORD: "${MYSQLD_EXPORTER_PASSWORD?:err}"
MYSQLD_EXPORTER_USER: "${MYSQLD_EXPORTER_USER?:err}"
MYSQL_DATABASE: null
MYSQL_PASSWORD: null
MYSQL_ROOT_PASSWORD: "${MYSQL_ROOT_PASSWORD?:err}"
MYSQL_USER: null
TZ: "${TZ?:err}"
healthcheck:
interval: "5s"
retries: 3
start_period: "5s"
test: '/usr/bin/mysql --user=root --password=${MYSQL_ROOT_PASSWORD} --execute "SHOW DATABASES;"'
timeout: "5s"
image: "mysql:5.7.36"
labels:
com.centurylinklabs.watchtower.enable: true
networks:
- "default"
- "dp-mysql"
- "dp-prometheus"
ports:
- "${MYSQL_LEGACY_PORT}:3306"
restart: "unless-stopped"
volumes:
# - "./data/mysql_legacy:/var/lib/mysql"
- "./services/databases/mysql/initdb-legacy:/docker-entrypoint-initdb.d"it outputs: but with 5.7.44 and 5.7.37 I get: with the relevant part: Both tested with a clean docker state. [
{
"Id": "57dfa157c6c572d147bfd179b56a2b264df85e9e244d227a362b59548b5f77eb",
"Created": "2024-10-12T14:08:06.607853603Z",
"Path": "docker-entrypoint.sh",
"Args": [
"--character-set-server=utf8mb4",
"--collation-server=utf8mb4_unicode_ci"
],
"State": {
"Status": "running",
"Running": true,
"Paused": false,
"Restarting": false,
"OOMKilled": false,
"Dead": false,
"Pid": 17162,
"ExitCode": 0,
"Error": "",
"StartedAt": "2024-10-12T14:08:30.673348188Z",
"FinishedAt": "2024-10-12T14:08:30.555970563Z",
"Health": {
"Status": "unhealthy",
"FailingStreak": 41,
"Log": [
{
"Start": "2024-10-12T17:11:38.105191988+03:00",
"End": "2024-10-12T17:11:38.174633059+03:00",
"ExitCode": 1,
"Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\n"
},
{
"Start": "2024-10-12T17:11:43.175755098+03:00",
"End": "2024-10-12T17:11:43.26113763+03:00",
"ExitCode": 1,
"Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\n"
},
{
"Start": "2024-10-12T17:11:48.262541293+03:00",
"End": "2024-10-12T17:11:48.333550066+03:00",
"ExitCode": 1,
"Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\n"
},
{
"Start": "2024-10-12T17:11:53.334725571+03:00",
"End": "2024-10-12T17:11:53.387745909+03:00",
"ExitCode": 1,
"Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\n"
},
{
"Start": "2024-10-12T17:11:58.388715078+03:00",
"End": "2024-10-12T17:11:58.437182544+03:00",
"ExitCode": 1,
"Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)\n"
}
]
}
},
"Image": "sha256:82d2d47667cf062cc9e70c31b9322fafc527ed61806f32f48d8797a0e1488ac6",
"ResolvConfPath": "/var/lib/docker/containers/57dfa157c6c572d147bfd179b56a2b264df85e9e244d227a362b59548b5f77eb/resolv.conf",
"HostnamePath": "/var/lib/docker/containers/57dfa157c6c572d147bfd179b56a2b264df85e9e244d227a362b59548b5f77eb/hostname",
"HostsPath": "/var/lib/docker/containers/57dfa157c6c572d147bfd179b56a2b264df85e9e244d227a362b59548b5f77eb/hosts",
"LogPath": "/var/lib/docker/containers/57dfa157c6c572d147bfd179b56a2b264df85e9e244d227a362b59548b5f77eb/57dfa157c6c572d147bfd179b56a2b264df85e9e244d227a362b59548b5f77eb-json.log",
"Name": "/dp-mysql_legacy",
"RestartCount": 1,
"Driver": "overlay2",
"Platform": "linux",
"MountLabel": "",
"ProcessLabel": "",
"AppArmorProfile": "",
"ExecIDs": null,
"HostConfig": {
"Binds": [
"/home/liviu/.repos/docker-playground/services/databases/mysql/initdb-legacy:/docker-entrypoint-initdb.d:rw"
],
"ContainerIDFile": "",
"LogConfig": {
"Type": "json-file",
"Config": {
"max-file": "10",
"max-size": "100m",
"mode": "non-blocking"
}
},
"NetworkMode": "dp_default",
"PortBindings": {
"3306/tcp": [
{
"HostIp": "",
"HostPort": "3305"
}
]
},
"RestartPolicy": {
"Name": "unless-stopped",
"MaximumRetryCount": 0
},
"AutoRemove": false,
"VolumeDriver": "",
"VolumesFrom": null,
"ConsoleSize": [
0,
0
],
"CapAdd": null,
"CapDrop": null,
"CgroupnsMode": "private",
"Dns": null,
"DnsOptions": null,
"DnsSearch": null,
"ExtraHosts": [],
"GroupAdd": null,
"IpcMode": "private",
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
"ReadonlyRootfs": false,
"SecurityOpt": null,
"UTSMode": "",
"UsernsMode": "",
"ShmSize": 67108864,
"Runtime": "runc",
"Isolation": "",
"CpuShares": 0,
"Memory": 0,
"NanoCpus": 0,
"CgroupParent": "",
"BlkioWeight": 0,
"BlkioWeightDevice": null,
"BlkioDeviceReadBps": null,
"BlkioDeviceWriteBps": null,
"BlkioDeviceReadIOps": null,
"BlkioDeviceWriteIOps": null,
"CpuPeriod": 0,
"CpuQuota": 0,
"CpuRealtimePeriod": 0,
"CpuRealtimeRuntime": 0,
"CpusetCpus": "",
"CpusetMems": "",
"Devices": null,
"DeviceCgroupRules": null,
"DeviceRequests": null,
"MemoryReservation": 0,
"MemorySwap": 0,
"MemorySwappiness": null,
"OomKillDisable": null,
"PidsLimit": null,
"Ulimits": null,
"CpuCount": 0,
"CpuPercent": 0,
"IOMaximumIOps": 0,
"IOMaximumBandwidth": 0,
"MaskedPaths": [
"/proc/asound",
"/proc/acpi",
"/proc/kcore",
"/proc/keys",
"/proc/latency_stats",
"/proc/timer_list",
"/proc/timer_stats",
"/proc/sched_debug",
"/proc/scsi",
"/sys/firmware",
"/sys/devices/virtual/powercap"
],
"ReadonlyPaths": [
"/proc/bus",
"/proc/fs",
"/proc/irq",
"/proc/sys",
"/proc/sysrq-trigger"
]
},
"GraphDriver": {
"Data": {
"LowerDir": "/var/lib/docker/overlay2/0e12cf101ab028140bd799f4a06cabf19bc0d83f410575308a9aa7ddd4706a3c-init/diff:/var/lib/docker/overlay2/f34523f3cde4b248aaafc67c3f8de2a9e5f59c5f815040adf4f4255aa13077e1/diff:/var/lib/docker/overlay2/a68421f1568b9fb87d621487606299be353c62c7e1eb30b1be802234046bfaca/diff:/var/lib/docker/overlay2/e085dbca344a530dfd5eba5184cfd9bd1540765b05455e5a1dc5da71cdfd073b/diff:/var/lib/docker/overlay2/042d57476cfae16aeda09851dda2782c17eb33e18cb143c8cd126803f3b56ef7/diff:/var/lib/docker/overlay2/bbe1a53f273d1c6ee6dd095f9a75ffbac784aba81cafcb83f2453f22c081fe0c/diff:/var/lib/docker/overlay2/6ba31668fb90038c8a3e6d496bb9239f55db3c26a4ad99d2f604f94e1a5ff974/diff:/var/lib/docker/overlay2/3a4f402b647448ab963d85ebc7ff3c02930b87780df1353f1aa823d8ec13e935/diff:/var/lib/docker/overlay2/f4f503bd6b655f566630b8408a9143b58ca47ce03e72b328e748096e09ab5e7d/diff:/var/lib/docker/overlay2/2554ea3ea2bb4046852604a611bce3a8e0007917e93def219d0135399512de54/diff:/var/lib/docker/overlay2/49dc54a55f8c80d2c8c37aff0992cc1b5b20bd0d3f6b57c66ca8fb134f5c1c20/diff:/var/lib/docker/overlay2/7c4be218e93001aad3d6185b875a120ffb8f88435a9ec47d0d97bc027df01d51/diff",
"MergedDir": "/var/lib/docker/overlay2/0e12cf101ab028140bd799f4a06cabf19bc0d83f410575308a9aa7ddd4706a3c/merged",
"UpperDir": "/var/lib/docker/overlay2/0e12cf101ab028140bd799f4a06cabf19bc0d83f410575308a9aa7ddd4706a3c/diff",
"WorkDir": "/var/lib/docker/overlay2/0e12cf101ab028140bd799f4a06cabf19bc0d83f410575308a9aa7ddd4706a3c/work"
},
"Name": "overlay2"
},
"Mounts": [
{
"Type": "bind",
"Source": "/home/liviu/.repos/docker-playground/services/databases/mysql/initdb-legacy",
"Destination": "/docker-entrypoint-initdb.d",
"Mode": "rw",
"RW": true,
"Propagation": "rprivate"
},
{
"Type": "volume",
"Name": "6f8932dcc9219ef11a8d018aa54dc525c724141a310e52bfe6941691d53239d2",
"Source": "/var/lib/docker/volumes/6f8932dcc9219ef11a8d018aa54dc525c724141a310e52bfe6941691d53239d2/_data",
"Destination": "/var/lib/mysql",
"Driver": "local",
"Mode": "",
"RW": true,
"Propagation": ""
}
],
"Config": {
"Hostname": "57dfa157c6c5",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": true,
"AttachStderr": true,
"ExposedPorts": {
"3306/tcp": {},
"33060/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"TZ=Europe/Bucharest",
"MYSQLD_EXPORTER_PASSWORD=password",
"MYSQLD_EXPORTER_USER=exporter",
"MYSQL_DATABASE=test",
"MYSQL_PASSWORD=password",
"MYSQL_ROOT_PASSWORD=password1",
"MYSQL_USER=user",
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"GOSU_VERSION=1.14",
"MYSQL_MAJOR=5.7",
"MYSQL_VERSION=5.7.37-1debian10"
],
"Cmd": [
"--character-set-server=utf8mb4",
"--collation-server=utf8mb4_unicode_ci"
],
"Healthcheck": {
"Test": [
"CMD-SHELL",
"/usr/bin/mysql --user=root --password=password1 --execute \"SHOW DATABASES;\""
],
"Interval": 5000000000,
"Timeout": 5000000000,
"StartPeriod": 5000000000,
"Retries": 3
},
"Image": "mysql:5.7.37",
"Volumes": {
"/var/lib/mysql": {}
},
"WorkingDir": "",
"Entrypoint": [
"docker-entrypoint.sh"
],
"OnBuild": null,
"Labels": {
"com.centurylinklabs.watchtower.enable": "true",
"com.docker.compose.config-hash": "ec8f5d06f38fde77303a114a01129eb83c46d68aa4b1c979e22e22bf4204c54a",
"com.docker.compose.container-number": "1",
"com.docker.compose.depends_on": "",
"com.docker.compose.image": "sha256:82d2d47667cf062cc9e70c31b9322fafc527ed61806f32f48d8797a0e1488ac6",
"com.docker.compose.oneoff": "False",
"com.docker.compose.project": "dp",
"com.docker.compose.project.config_files": "/home/liviu/.repos/docker-playground/docker-compose.yml,/home/liviu/.repos/docker-playground/services/databases/mongo/docker-compose.legacy.yml,/home/liviu/.repos/docker-playground/services/databases/mongo/docker-compose.yml,/home/liviu/.repos/docker-playground/services/databases/mysql/docker-compose.legacy.yml,/home/liviu/.repos/docker-playground/services/databases/mysql/docker-compose.yml,/home/liviu/.repos/docker-playground/services/databases/postgres/docker-compose.yml,/home/liviu/.repos/docker-playground/services/metrics/docker-compose.yml,/home/liviu/.repos/docker-playground/services/metrics/grafana/docker-compose.yml,/home/liviu/.repos/docker-playground/services/tools/mailpit.yml,/home/liviu/.repos/docker-playground/services/tools/watchtower.yml,/home/liviu/.repos/docker-playground/services/tools/rabbitmq.yml,/home/liviu/.repos/docker-playground/services/tools/redis-stack.yml,/home/liviu/.repos/docker-playground/services/tools/open-webui.yml,/home/liviu/.repos/docker-playground/services/tools/it-tools.yml",
"com.docker.compose.project.working_dir": "/home/liviu/.repos/docker-playground",
"com.docker.compose.service": "mysql_legacy",
"com.docker.compose.version": "2.29.7"
}
},
"NetworkSettings": {
"Bridge": "",
"SandboxID": "7d2fd174e6fde1cb27de2aa6fa059ea5acee4ae794c2cb905a0954d4d03eedc8",
"SandboxKey": "/var/run/docker/netns/7d2fd174e6fd",
"Ports": {
"3306/tcp": [
{
"HostIp": "0.0.0.0",
"HostPort": "3305"
},
{
"HostIp": "::",
"HostPort": "3305"
}
],
"33060/tcp": null
},
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"SecondaryIPAddresses": null,
"SecondaryIPv6Addresses": null,
"EndpointID": "",
"Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"IPAddress": "",
"IPPrefixLen": 0,
"IPv6Gateway": "",
"MacAddress": "",
"Networks": {
"dp-mysql": {
"IPAMConfig": null,
"Links": null,
"Aliases": [
"dp-mysql_legacy",
"mysql_legacy"
],
"MacAddress": "02:42:ac:16:00:02",
"DriverOpts": null,
"NetworkID": "4e3feba268fd581e2ed6ab24d39ce584110558849715a97fe3852d04f14483f4",
"EndpointID": "c6da8be18621141fbc2412562023759c9525053bd5e7c3e483279307cfd91db7",
"Gateway": "172.22.0.1",
"IPAddress": "172.22.0.2",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"DNSNames": [
"dp-mysql_legacy",
"mysql_legacy",
"57dfa157c6c5"
]
},
"dp-prometheus": {
"IPAMConfig": null,
"Links": null,
"Aliases": [
"dp-mysql_legacy",
"mysql_legacy"
],
"MacAddress": "02:42:ac:1c:00:02",
"DriverOpts": null,
"NetworkID": "a88188010891bddf32fc84e90a5c3e48206b368b3a85c14110158dd36bd6b9b4",
"EndpointID": "e7c280fde192ac951830e9626f384245d9d82adcadce03b00ff49430d3eb0ae5",
"Gateway": "172.28.0.1",
"IPAddress": "172.28.0.2",
"IPPrefixLen": 16,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"DNSNames": [
"dp-mysql_legacy",
"mysql_legacy",
"57dfa157c6c5"
]
},
"dp_default": {
"IPAMConfig": null,
"Links": null,
"Aliases": [
"dp-mysql_legacy",
"mysql_legacy"
],
"MacAddress": "02:42:c0:a8:10:02",
"DriverOpts": null,
"NetworkID": "edacb6fbbed65841314a2b6c418f875ccae26572bf279fe645d9dc79902ce4f6",
"EndpointID": "ad35d2be0da347f282ba4b38c5c2d619abecea7d859fbf035e4ec277f8ce3937",
"Gateway": "192.168.16.1",
"IPAddress": "192.168.16.2",
"IPPrefixLen": 20,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"DNSNames": [
"dp-mysql_legacy",
"mysql_legacy",
"57dfa157c6c5"
]
}
}
}
}
] |
|
It could be that I am running as the host, but didn't test: |
dp-mysql_legacy | ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)This log line is from your healthcheck firing too early and the container not having yet finished database initialization. But it shouldn't be the cause of the entrypoint script being killed. Increasing the Since it is dying during initialization, perhaps one of your scripts in Note that MySQL 5.7 is end of life since 31 October 2023. |
|
I've used the same script on the 3 versions; only 5.7.37 fails on my Arch machine. The script inside is: #!/bin/bash
set -eu
mysql -u root -p${MYSQL_ROOT_PASSWORD} --execute \
"CREATE USER '${MYSQLD_EXPORTER_USER}'@'%' IDENTIFIED BY '${MYSQLD_EXPORTER_PASSWORD}' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO '${MYSQLD_EXPORTER_USER}'@'%';"but on my Kubuntu machine works, with the same docker file, outputting: Could the Arch host be the problem? Also my system freezes for a few seconds when starting the 5.7.37 container :|. |
|
Switched to 6.11.3-arch1-1 kernel and have no problems anymore so probably the kernel? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
If 5.7.37 container started through docker, it fails with
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111).Docker images for 5.7.36 work flawlessly on the same hardware.
How to reproduce:
Run
docker run --name my37 -e MYSQL_ROOT_PASSWORD=my-secret-pw mysql:5.7.37(It works the same way with-doption)This works fine:
docker run --name my36 -e MYSQL_ROOT_PASSWORD=my-secret-pw mysql:5.7.36Docker version:
The text was updated successfully, but these errors were encountered: