Errors executing docker-entrypoint-initdb.d files are ignored

[cer]

I had a typo in a file:

[Entrypoint] running /docker-entrypoint-initdb.d/5.configure-users.sql
ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"' at line 1

[Entrypoint] running /docker-entrypoint-initdb.d/tram-saga-schema.sql

The server (mysql/mysql-server:8.0.27-1.2.6-server) ignored the error and executed the next file.
It would be helpful if the such an error resulted in the server shutting down.

[tianon]

Does your container have a restart policy? I'm not able to reproduce:

$ echo 'this is a typo' > test.sql
$ docker run --rm --name test --mount type=bind,src="$PWD/test.sql",dst=/docker-entrypoint-initdb.d/test.sql,ro --pull=always --env MYSQL_ALLOW_EMPTY_PASSWORD=1 mysql:8.0
8.0: Pulling from library/mysql
Digest: sha256:548da4c67fd8a71908f17c308b8ddb098acf5191d3d7694e56801c6a8b2072cc
Status: Image is up to date for mysql:8.0
2022-06-13 17:04:58+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.29-1debian10 started.
2022-06-13 17:04:58+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-06-13 17:04:58+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.29-1debian10 started.
2022-06-13 17:04:58+00:00 [Note] [Entrypoint]: Initializing database files
2022-06-13T17:04:58.864035Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.29) initializing of server in progress as process 42
2022-06-13T17:04:58.874032Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-06-13T17:04:59.349705Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-06-13T17:05:00.804188Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2022-06-13 17:05:03+00:00 [Note] [Entrypoint]: Database files initialized
2022-06-13 17:05:03+00:00 [Note] [Entrypoint]: Starting temporary server
2022-06-13T17:05:04.161192Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29) starting as process 91
2022-06-13T17:05:04.174395Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-06-13T17:05:04.311735Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-06-13T17:05:04.532506Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-06-13T17:05:04.532615Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-06-13T17:05:04.535333Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2022-06-13T17:05:04.551086Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2022-06-13T17:05:04.551284Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.29'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2022-06-13 17:05:04+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-06-13 17:05:05+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/test.sql
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'this is a typo' at line 1
$ echo $?
1

[tianon]

Oh, you mentioned that you're using mysql/mysql-server, not mysql - you wanted https://github.com/mysql/mysql-docker instead 🙈