Circleci/mysql:5.7 failing to start: "Unable to start server."

Feedback & Bug Reports
1

Having this issue at the moment when trying to start the “circleci/mysql:5.7” container:

2019-10-16 13:35:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started.
2019-10-16 13:35:25+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2019-10-16 13:35:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started.
2019-10-16 13:35:25+00:00 [Note] [Entrypoint]: Initializing database files
2019-10-16T13:35:25.317439Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-10-16T13:35:25.518335Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-10-16T13:35:25.543683Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-10-16T13:35:25.598781Z 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: cf66ea05-f019-11e9-b9d5-0242ac190003.
2019-10-16T13:35:25.599758Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-10-16T13:35:26.141410Z 0 [Warning] CA certificate ca.pem is self signed.
2019-10-16T13:35:26.296835Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2019-10-16 13:35:27+00:00 [Note] [Entrypoint]: Database files initialized
2019-10-16 13:35:27+00:00 [Note] [Entrypoint]: Starting temporary server
Please enable --log-error option or set appropriate redirections for standard output and/or standard error in daemon mode.
2019-10-16 13:35:27+00:00 [ERROR] [Entrypoint]: Unable to start server.

Exited with code 1

The version being pulled:

Status: Downloaded newer image for circleci/mysql:5.7
  using image circleci/mysql@sha256:f0583894885c3bd7b5df2f16745560c52e4daf98e1ccd10cafe49dece5185520
2 Likes
2

The same here.
Started failing recently, probably after the base image has been updated an hour ago or so: https://hub.docker.com/r/circleci/mysql/tags?page=1&name=5.7

1 Like
3

Just for anyone else having the issue, I’ve got builds working again by updating my config.yml to use the specific digest of the last good 5.7 image I built with:

- image: circleci/mysql@sha256:a0c894df6535a095c78f7b9e1d1c4ee3cc064eda39c5fe4f95b34c31e25a88ed

Until there’s a new image that works.

4

Hey. There’s an upstream issue, please see: MySQL v5.7 Docker Image Issue (October 16th, 2019)

I wouldn’t use this. See my post for a cleaner workaround (though your way does work).

1 Like