Closed peer-jslater closed 6 months ago
While trying to fix the issue I deleted the volumes and ran docker compose again. Now the issue is no longer reproducible.
I now get this output when composing up:
PS ...\fulcio> docker compose up
[+] Running 10/10
✔ Network fulcio_default Created 0.1s
✔ Volume "fulcio_ctfeConfig" Created 0.0s
✔ Volume "fulcio_mysql" Created 0.0s
✔ Container fulcio-dex-idp-1 Created 0.2s
✔ Container fulcio-mysql-1 Created 0.2s
✔ Container fulcio-trillian-log-server-1 Created 0.2s
✔ Container fulcio-trillian-log-signer-1 Created 0.2s
✔ Container fulcio-fulcio-server-1 Created 0.2s
✔ Container fulcio-ctfe_init-1 Created 0.2s
✔ Container fulcio-ct_server-1 Created 0.1s
Attaching to ct_server-1, ctfe_init-1, dex-idp-1, fulcio-server-1, mysql-1, trillian-log-server-1, trillian-log-signer-1
mysql-1 | Initializing database
mysql-1 | 2024-03-11T17:25:32.379504Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql-1 | 2024-03-11T17:25:32.521218Z 0 [Warning] InnoDB: New log files created, LSN=45790
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config issuer: http://dex-idp:8888/auth"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config storage: memory"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config static client: Fulcio in Docker Compose"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config connector: https://any.valid.url/"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config response types accepted: [code]"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config skipping approval screen"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config signing keys expire after: 24h0m0s"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config id tokens valid for: 1m0s"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config auth requests valid for: 24h0m0s"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="config refresh tokens rotation enabled: true"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="keys expired, rotating"
mysql-1 | 2024-03-11T17:25:32.574006Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysql-1 | 2024-03-11T17:25:32.594746Z 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: 5d414dc7-dfcc-11ee-bc44-0242ac1b0003.
mysql-1 | 2024-03-11T17:25:32.600416Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="keys rotated, next rotation: 2024-03-12 17:25:32.781931089 +0000 UTC"
dex-idp-1 | time="2024-03-11T17:25:32Z" level=info msg="listening (http) on 0.0.0.0:8888"
mysql-1 | 2024-03-11T17:25:32.989471Z 0 [Warning] CA certificate ca.pem is self signed.
mysql-1 | 2024-03-11T17:25:33.039670Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
trillian-log-server-1 | I0311 17:25:33.337073 1 main.go:97] **** Log Server Starting ****
trillian-log-server-1 | W0311 17:25:33.338032 1 tree_storage.go:89] Failed to set strict mode on mysql db: dial tcp 172.27.0.3:3306: connect: connection refused
trillian-log-server-1 | F0311 17:25:33.338072 1 main.go:118] Failed to get storage provider: dial tcp 172.27.0.3:3306: connect: connection refused
trillian-log-signer-1 | I0311 17:25:34.156236 1 main.go:108] **** Log Signer Starting ****
fulcio-server-1 | 2024-03-11T17:25:34.830Z INFO app/grpc.go:214 listening on grpc at [::]:5554
fulcio-server-1 | 2024-03-11T17:25:34.831Z INFO app/grpc.go:262 listening on grpc at @fulcio-legacy-grpc-socket
fulcio-server-1 | 2024-03-11T17:25:34.831Z INFO app/http.go:111 listening on http at 0.0.0.0:5555
ctfe_init-1 | /bin/sh: 1: /root/logid.sh: not found
trillian-log-signer-1 | W0311 17:25:35.252113 1 tree_storage.go:89] Failed to set strict mode on mysql db: dial tcp 172.27.0.3:3306: connect: connection refused
trillian-log-signer-1 | F0311 17:25:35.252152 1 main.go:115] Failed to get storage provider: dial tcp 172.27.0.3:3306: connect: connection refused
trillian-log-server-1 exited with code 0
Gracefully stopping... (press Ctrl+C again to force)
service "ctfe_init" didn't complete successfully: exit 127
Resolved the issue. /root/logid.sh: not found did not appear if it has lf line endings. Since I'm on a windows machine, I cloned the repository with crlf line endings.
work around: after cloning the repo,
git config core.autocrlf false
git checkout .
will create PR for git attributes: +*.sh text eol=lf
EDIT: this issue was originally reported with the name: MySql container has (fatal) incorrect Schema Error on startup: [ERROR] Native table 'performance_schema' ... has the wrong structure. I've since change the issue name to one that I believe a user would encounter before the error I originally reported.
Description
Steps to reproduce:
v1.4.4
(same error occurred on main on commit 7e4718f2d4d98d76f3b55c6ae6b895506101000b)docker compose up
Expected: all containers in docker compose up remain running.
Actual: MySql container does not start up properly on
docker compose up
. There are two errors that occur:This causes other containers that depend on the mysql server to shutdown.
I exec'd into the container to try
mysql_upgrade
and got the following:Version Fulcio repo at:
HEAD detached at v1.4.4
Environment This was run on windows 11. And docker desktop (info collected from about):
Full log of
docker compose up
: