@avonbertoldi yes we can use this, or we can fail on script when something is not working - there are several workarounds. My point is that it would be much better if it happened automatically (on non-0 exit), because if you want to check something you first have to know you need to do it. Right now it's not so obvious: clear problems are hidden from the developer, and CI environment may work differently than intended.
Maybe good solution for this would be an opt-in required flag that each service could set, which would change current behaviour and cause CI job to fail if such service exits with non-0 code?
@avonbertoldi thanks for explanation. I am wondering if only probing ports is a proper strategy here. What I personally would like to see, is verifying containers' exit codes, because containers that only spin up to do something and then exit (with code 0) are fine and shouldn't fail the job, I agree here.
Anyway, we talked here about MySQL before, but same problem is for Redis - when we've been debugging this with our DevOp, we saw on k8s namespace for this particular CI job that one Redis container exited with failure (port in use), which IMHO should stop execution of the job. In practice, the second Redis server took the responsibility of handling failed one's data, as - again - both aliases pointed to the same instance. In some cases it may work properly, but in some cases it may lead to mixing/overriding data, while intention was clear to separate it with 2 instances. Failing job in this case (with information that service XYZ exited with non-0 code) would enforce developer to fix it, by either getting rid of multiple instances, or by customising ports (if possible).
@gitlab-bot label typebug
@avonbertoldi created #509060 (moved).
Following @avonbertoldi's comment, I am reporting this as a standalone issue. There is confusing thing with such setup:
1307503)CI_DEBUG_SERVICES=1The problem: logs from MySQL containers are duplicated/merged which leads to invalid information displayed in the job's output. Please ignore mysqlx related stuff, we don't use it so we did not change the ports so 33060 is used for both servers and only one binds it, the other one has an error.
2024-12-11 13:10:54+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
2024-12-11 13:10:54+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-12-11 13:10:54+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
2024-12-11 13:10:54+00:00 [Note] [Entrypoint]: Initializing database files
2024-12-11T13:10:54.746483Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-12-11T13:10:54.746666Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.40) initializing of server in progress as process 80
2024-12-11T13:10:54.757137Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-11T13:10:55.356775Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-11T13:10:56.360299Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-12-11 13:10:59+00:00 [Note] [Entrypoint]: Database files initialized
2024-12-11 13:10:59+00:00 [Note] [Entrypoint]: Starting temporary server
2024-12-11T13:10:59.882656Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-12-11T13:10:59.885305Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 124
2024-12-11T13:10:59.972393Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-11T13:11:02.270762Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-11T13:11:04.062569Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-12-11T13:11:04.062677Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-12-11T13:11:04.080630Z 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.
2024-12-11T13:11:04.121212Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-12-11T13:11:04.121291Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
2024-12-11 13:11:04+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
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/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' 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.
2024-12-11 13:11:07+00:00 [Note] [Entrypoint]: Creating database db_shard
2024-12-11 13:11:07+00:00 [Note] [Entrypoint]: Creating user u1
2024-12-11 13:11:07+00:00 [Note] [Entrypoint]: Giving user u1 access to schema db_shard
2024-12-11 13:11:07+00:00 [Note] [Entrypoint]: Stopping temporary server
2024-12-11T13:11:07.811837Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.40).
2024-12-11T13:11:08.634263Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40) MySQL Community Server - GPL.
2024-12-11 13:11:08+00:00 [Note] [Entrypoint]: Temporary server stopped
2024-12-11 13:11:08+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2024-12-11T13:11:09.151319Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-12-11T13:11:09.153312Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 1
2024-12-11T13:11:09.171880Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-11T13:11:09.419081Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-11T13:11:10.545308Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of bind-address: '*' port: 33060 failed, `bind()` failed with error: Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
2024-12-11T13:11:10.545357Z 0 [ERROR] [MY-013597] [Server] Plugin mysqlx reported: 'Value '*' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'
2024-12-11T13:11:10.697654Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-12-11T13:11:10.697774Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-12-11T13:11:10.702373Z 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.
2024-12-11T13:11:10.727693Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-12-11T13:11:10.727904Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 3307 MySQL Community Server - GPL.
2024-12-11T13:22:36.859528Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2024-12-11 13:10:52+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
2024-12-11 13:10:53+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-12-11 13:10:53+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
2024-12-11 13:10:53+00:00 [Note] [Entrypoint]: Initializing database files
2024-12-11T13:10:53.538532Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-12-11T13:10:53.538849Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.40) initializing of server in progress as process 80
2024-12-11T13:10:53.553300Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-11T13:10:53.982857Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-11T13:10:55.256269Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-12-11 13:10:58+00:00 [Note] [Entrypoint]: Database files initialized
2024-12-11 13:10:58+00:00 [Note] [Entrypoint]: Starting temporary server
2024-12-11T13:10:58.334839Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-12-11T13:10:58.337398Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 124
2024-12-11T13:10:58.378093Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-11T13:10:58.602350Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-11T13:10:59.032635Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-12-11T13:10:59.032703Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-12-11T13:10:59.040673Z 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.
2024-12-11T13:10:59.075765Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-12-11T13:10:59.075887Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
2024-12-11 13:10:59+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
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/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' 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.
2024-12-11 13:11:03+00:00 [Note] [Entrypoint]: Creating database db_master
2024-12-11 13:11:03+00:00 [Note] [Entrypoint]: Creating user u1
2024-12-11 13:11:03+00:00 [Note] [Entrypoint]: Giving user u1 access to schema db_master
2024-12-11T13:11:04.020034Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.40).
2024-12-11 13:11:04+00:00 [Note] [Entrypoint]: Stopping temporary server
2024-12-11T13:11:07.459591Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40) MySQL Community Server - GPL.
2024-12-11 13:11:08+00:00 [Note] [Entrypoint]: Temporary server stopped
2024-12-11 13:11:08+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2024-12-11T13:11:08.372795Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-12-11T13:11:08.376104Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 1
2024-12-11T13:11:08.384657Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-11T13:11:08.594578Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-11T13:11:09.044219Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-12-11T13:11:09.044280Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-12-11T13:11:09.048437Z 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.
2024-12-11T13:11:09.088666Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-12-11T13:11:09.088770Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 3308 MySQL Community Server - GPL.And now, for comparison, logs from the Gitlab's UI. You can see that each service has 2 Creating database ... entries, while in fact only 1 database is created for each service (we verified it with mysql -h you-can-put-whichever-service-alias-here-because-only-port-matters -uroot -pu1 -P 3307 -e "show databases;").
[service:mysql-sql-shard-1] 2024-12-11T12:43:27.586381944Z 2024-12-11 12:43:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:28.123820271Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
[service:mysql-sql-shard-1] 2024-12-11T12:43:28.152527962Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:28.478582318Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Initializing database files
[service:mysql-sql-shard-1] 2024-12-11T12:43:28.501703042Z 2024-12-11T12:43:28.496956Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-shard-1] 2024-12-11T12:43:28.501756842Z 2024-12-11T12:43:28.497661Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.40) initializing of server in progress as process 80
[service:mysql-sql-shard-1] 2024-12-11T12:43:28.520351215Z 2024-12-11T12:43:28.520128Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.069469119Z 2024-12-11T12:43:29.069241Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-shard-1] 2024-12-11T12:43:30.464619908Z 2024-12-11T12:43:30.464458Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.274675733Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Database files initialized
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.280102333Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Starting temporary server
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.599077138Z 2024-12-11T12:43:33.569006Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.599154404Z 2024-12-11T12:43:33.571212Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 124
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.612575278Z 2024-12-11T12:43:33.612258Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.837310798Z 2024-12-11T12:43:33.837153Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.101502235Z 2024-12-11T12:43:34.101401Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.101527087Z 2024-12-11T12:43:34.101441Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.103810508Z 2024-12-11T12:43:34.103678Z 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.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.123200977Z 2024-12-11T12:43:34.122958Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.123260190Z 2024-12-11T12:43:34.123049Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.148474901Z 2024-12-11 12:43:34+00:00 [Note] [Entrypoint]: Temporary server started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.189816924Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.805335050Z Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.805366868Z Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.805371100Z Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:35.876983225Z Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:35.877008409Z Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:35.877035633Z Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.031588653Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Creating database db_master
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.062660728Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Creating user u1
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.084230000Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Giving user u1 access to schema db_master
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.106484389Z
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.113223510Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Stopping temporary server
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.123022880Z 2024-12-11T12:43:36.122880Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.40).
[service:mysql-sql-shard-1] 2024-12-11T12:43:37.589023571Z 2024-12-11T12:43:37.588901Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40) MySQL Community Server - GPL.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.131377791Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: Temporary server stopped
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.131419485Z
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.137452865Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.137466373Z
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.441562995Z 2024-12-11T12:43:38.436060Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.441618102Z 2024-12-11T12:43:38.438146Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 1
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.445921181Z 2024-12-11T12:43:38.445702Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.699289900Z 2024-12-11T12:43:38.699140Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.994227825Z 2024-12-11T12:43:38.994068Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.994260743Z 2024-12-11T12:43:38.994115Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.996743847Z 2024-12-11T12:43:38.996609Z 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.
[service:mysql-sql-shard-1] 2024-12-11T12:43:39.023811982Z 2024-12-11T12:43:39.023602Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 3308 MySQL Community Server - GPL.
[service:mysql-sql-shard-1] 2024-12-11T12:43:39.023867608Z 2024-12-11T12:43:39.023610Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
[service:mysql-sql-shard-1] 2024-12-11T12:43:28.670574651Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.032805387Z 2024-12-11 12:43:29+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.056441124Z 2024-12-11 12:43:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.336121232Z 2024-12-11 12:43:29+00:00 [Note] [Entrypoint]: Initializing database files
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.360844561Z 2024-12-11T12:43:29.356922Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.360870602Z 2024-12-11T12:43:29.357111Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.40) initializing of server in progress as process 81
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.367389375Z 2024-12-11T12:43:29.366951Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:29.867368298Z 2024-12-11T12:43:29.867171Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-shard-1] 2024-12-11T12:43:30.903972182Z 2024-12-11T12:43:30.903679Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.108601086Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Database files initialized
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.114505345Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Starting temporary server
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.431631525Z 2024-12-11T12:43:33.406764Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.431689786Z 2024-12-11T12:43:33.408905Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 125
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.453404895Z 2024-12-11T12:43:33.453106Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:33.687532000Z 2024-12-11T12:43:33.687391Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.014273757Z 2024-12-11T12:43:34.014130Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.014300254Z 2024-12-11T12:43:34.014169Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.017316585Z 2024-12-11T12:43:34.016751Z 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.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.039451858Z 2024-12-11T12:43:34.039254Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.039477506Z 2024-12-11T12:43:34.039354Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.064467395Z 2024-12-11 12:43:34+00:00 [Note] [Entrypoint]: Temporary server started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.106282200Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.722003371Z Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.722186846Z Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:34.722605439Z Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:35.835839372Z Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:35.836156815Z Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:35.837079500Z Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.000477621Z 2024-12-11 12:43:35+00:00 [Note] [Entrypoint]: Creating database db_shard
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.034798019Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Creating user u1
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.061554614Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Giving user u1 access to schema db_shard
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.082043099Z
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.085370351Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Stopping temporary server
[service:mysql-sql-shard-1] 2024-12-11T12:43:36.103085847Z 2024-12-11T12:43:36.102960Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.40).
[service:mysql-sql-shard-1] 2024-12-11T12:43:37.524332726Z 2024-12-11T12:43:37.524199Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40) MySQL Community Server - GPL.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.123120117Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: Temporary server stopped
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.123162089Z
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.128080949Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.128111612Z
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.454011779Z 2024-12-11T12:43:38.449430Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.454053971Z 2024-12-11T12:43:38.451334Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 1
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.458358088Z 2024-12-11T12:43:38.458071Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-shard-1] 2024-12-11T12:43:38.779704988Z 2024-12-11T12:43:38.779373Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-shard-1] 2024-12-11T12:43:39.925142937Z 2024-12-11T12:43:39.924975Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of bind-address: '*' port: 33060 failed, `bind()` failed with error: Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
[service:mysql-sql-shard-1] 2024-12-11T12:43:39.925186085Z 2024-12-11T12:43:39.925033Z 0 [ERROR] [MY-013597] [Server] Plugin mysqlx reported: 'Value '*' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'
[service:mysql-sql-shard-1] 2024-12-11T12:43:40.070696179Z 2024-12-11T12:43:40.070449Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-shard-1] 2024-12-11T12:43:40.070751654Z 2024-12-11T12:43:40.070473Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-shard-1] 2024-12-11T12:43:40.073110554Z 2024-12-11T12:43:40.072995Z 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.
[service:mysql-sql-shard-1] 2024-12-11T12:43:40.087517864Z 2024-12-11T12:43:40.087369Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 3307 MySQL Community Server - GPL.
[service:mysql-sql-shard-1] 2024-12-11T12:43:40.087556495Z 2024-12-11T12:43:40.087392Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock[service:mysql-sql-master] 2024-12-11T12:43:27.586381944Z 2024-12-11 12:43:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-master] 2024-12-11T12:43:28.123820271Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
[service:mysql-sql-master] 2024-12-11T12:43:28.152527962Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-master] 2024-12-11T12:43:28.478582318Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Initializing database files
[service:mysql-sql-master] 2024-12-11T12:43:28.501703042Z 2024-12-11T12:43:28.496956Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-master] 2024-12-11T12:43:28.501756842Z 2024-12-11T12:43:28.497661Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.40) initializing of server in progress as process 80
[service:mysql-sql-master] 2024-12-11T12:43:28.520351215Z 2024-12-11T12:43:28.520128Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-master] 2024-12-11T12:43:29.069469119Z 2024-12-11T12:43:29.069241Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-master] 2024-12-11T12:43:30.464619908Z 2024-12-11T12:43:30.464458Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[service:mysql-sql-master] 2024-12-11T12:43:33.274675733Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Database files initialized
[service:mysql-sql-master] 2024-12-11T12:43:33.280102333Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Starting temporary server
[service:mysql-sql-master] 2024-12-11T12:43:33.599077138Z 2024-12-11T12:43:33.569006Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-master] 2024-12-11T12:43:33.599154404Z 2024-12-11T12:43:33.571212Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 124
[service:mysql-sql-master] 2024-12-11T12:43:33.612575278Z 2024-12-11T12:43:33.612258Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-master] 2024-12-11T12:43:33.837310798Z 2024-12-11T12:43:33.837153Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-master] 2024-12-11T12:43:34.101502235Z 2024-12-11T12:43:34.101401Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-master] 2024-12-11T12:43:34.101527087Z 2024-12-11T12:43:34.101441Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-master] 2024-12-11T12:43:34.103810508Z 2024-12-11T12:43:34.103678Z 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.
[service:mysql-sql-master] 2024-12-11T12:43:34.123200977Z 2024-12-11T12:43:34.122958Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
[service:mysql-sql-master] 2024-12-11T12:43:34.123260190Z 2024-12-11T12:43:34.123049Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
[service:mysql-sql-master] 2024-12-11T12:43:34.148474901Z 2024-12-11 12:43:34+00:00 [Note] [Entrypoint]: Temporary server started.
[service:mysql-sql-master] 2024-12-11T12:43:34.189816924Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
[service:mysql-sql-master] 2024-12-11T12:43:34.805335050Z Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:34.805366868Z Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:34.805371100Z Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:35.876983225Z Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:35.877008409Z Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:35.877035633Z Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:36.031588653Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Creating database db_master
[service:mysql-sql-master] 2024-12-11T12:43:36.062660728Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Creating user gr
[service:mysql-sql-master] 2024-12-11T12:43:36.084230000Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Giving user gr access to schema db_master
[service:mysql-sql-master] 2024-12-11T12:43:36.106484389Z
[service:mysql-sql-master] 2024-12-11T12:43:36.113223510Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Stopping temporary server
[service:mysql-sql-master] 2024-12-11T12:43:36.123022880Z 2024-12-11T12:43:36.122880Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.40).
[service:mysql-sql-master] 2024-12-11T12:43:37.589023571Z 2024-12-11T12:43:37.588901Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40) MySQL Community Server - GPL.
[service:mysql-sql-master] 2024-12-11T12:43:38.131377791Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: Temporary server stopped
[service:mysql-sql-master] 2024-12-11T12:43:38.131419485Z
[service:mysql-sql-master] 2024-12-11T12:43:38.137452865Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
[service:mysql-sql-master] 2024-12-11T12:43:38.137466373Z
[service:mysql-sql-master] 2024-12-11T12:43:38.441562995Z 2024-12-11T12:43:38.436060Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-master] 2024-12-11T12:43:38.441618102Z 2024-12-11T12:43:38.438146Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 1
[service:mysql-sql-master] 2024-12-11T12:43:38.445921181Z 2024-12-11T12:43:38.445702Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-master] 2024-12-11T12:43:38.699289900Z 2024-12-11T12:43:38.699140Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-master] 2024-12-11T12:43:38.994227825Z 2024-12-11T12:43:38.994068Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-master] 2024-12-11T12:43:38.994260743Z 2024-12-11T12:43:38.994115Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-master] 2024-12-11T12:43:38.996743847Z 2024-12-11T12:43:38.996609Z 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.
[service:mysql-sql-master] 2024-12-11T12:43:39.023811982Z 2024-12-11T12:43:39.023602Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 3308 MySQL Community Server - GPL.
[service:mysql-sql-master] 2024-12-11T12:43:39.023867608Z 2024-12-11T12:43:39.023610Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
[service:mysql-sql-master] 2024-12-11T12:43:28.670574651Z 2024-12-11 12:43:28+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-master] 2024-12-11T12:43:29.032805387Z 2024-12-11 12:43:29+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
[service:mysql-sql-master] 2024-12-11T12:43:29.056441124Z 2024-12-11 12:43:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.40-1.el9 started.
[service:mysql-sql-master] 2024-12-11T12:43:29.336121232Z 2024-12-11 12:43:29+00:00 [Note] [Entrypoint]: Initializing database files
[service:mysql-sql-master] 2024-12-11T12:43:29.360844561Z 2024-12-11T12:43:29.356922Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-master] 2024-12-11T12:43:29.360870602Z 2024-12-11T12:43:29.357111Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.40) initializing of server in progress as process 81
[service:mysql-sql-master] 2024-12-11T12:43:29.367389375Z 2024-12-11T12:43:29.366951Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-master] 2024-12-11T12:43:29.867368298Z 2024-12-11T12:43:29.867171Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-master] 2024-12-11T12:43:30.903972182Z 2024-12-11T12:43:30.903679Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[service:mysql-sql-master] 2024-12-11T12:43:33.108601086Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Database files initialized
[service:mysql-sql-master] 2024-12-11T12:43:33.114505345Z 2024-12-11 12:43:33+00:00 [Note] [Entrypoint]: Starting temporary server
[service:mysql-sql-master] 2024-12-11T12:43:33.431631525Z 2024-12-11T12:43:33.406764Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-master] 2024-12-11T12:43:33.431689786Z 2024-12-11T12:43:33.408905Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 125
[service:mysql-sql-master] 2024-12-11T12:43:33.453404895Z 2024-12-11T12:43:33.453106Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-master] 2024-12-11T12:43:33.687532000Z 2024-12-11T12:43:33.687391Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-master] 2024-12-11T12:43:34.014273757Z 2024-12-11T12:43:34.014130Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-master] 2024-12-11T12:43:34.014300254Z 2024-12-11T12:43:34.014169Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-master] 2024-12-11T12:43:34.017316585Z 2024-12-11T12:43:34.016751Z 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.
[service:mysql-sql-master] 2024-12-11T12:43:34.039451858Z 2024-12-11T12:43:34.039254Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
[service:mysql-sql-master] 2024-12-11T12:43:34.039477506Z 2024-12-11T12:43:34.039354Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
[service:mysql-sql-master] 2024-12-11T12:43:34.064467395Z 2024-12-11 12:43:34+00:00 [Note] [Entrypoint]: Temporary server started.
[service:mysql-sql-master] 2024-12-11T12:43:34.106282200Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
[service:mysql-sql-master] 2024-12-11T12:43:34.722003371Z Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:34.722186846Z Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:34.722605439Z Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:35.835839372Z Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:35.836156815Z Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:35.837079500Z Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[service:mysql-sql-master] 2024-12-11T12:43:36.000477621Z 2024-12-11 12:43:35+00:00 [Note] [Entrypoint]: Creating database db_shard
[service:mysql-sql-master] 2024-12-11T12:43:36.034798019Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Creating user u1
[service:mysql-sql-master] 2024-12-11T12:43:36.061554614Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Giving user u1 access to schema db_shard
[service:mysql-sql-master] 2024-12-11T12:43:36.082043099Z
[service:mysql-sql-master] 2024-12-11T12:43:36.085370351Z 2024-12-11 12:43:36+00:00 [Note] [Entrypoint]: Stopping temporary server
[service:mysql-sql-master] 2024-12-11T12:43:36.103085847Z 2024-12-11T12:43:36.102960Z 13 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.40).
[service:mysql-sql-master] 2024-12-11T12:43:37.524332726Z 2024-12-11T12:43:37.524199Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.40) MySQL Community Server - GPL.
[service:mysql-sql-master] 2024-12-11T12:43:38.123120117Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: Temporary server stopped
[service:mysql-sql-master] 2024-12-11T12:43:38.123162089Z
[service:mysql-sql-master] 2024-12-11T12:43:38.128080949Z 2024-12-11 12:43:38+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
[service:mysql-sql-master] 2024-12-11T12:43:38.128111612Z
[service:mysql-sql-master] 2024-12-11T12:43:38.454011779Z 2024-12-11T12:43:38.449430Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[service:mysql-sql-master] 2024-12-11T12:43:38.454053971Z 2024-12-11T12:43:38.451334Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.40) starting as process 1
[service:mysql-sql-master] 2024-12-11T12:43:38.458358088Z 2024-12-11T12:43:38.458071Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
[service:mysql-sql-master] 2024-12-11T12:43:38.779704988Z 2024-12-11T12:43:38.779373Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
[service:mysql-sql-master] 2024-12-11T12:43:39.925142937Z 2024-12-11T12:43:39.924975Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of bind-address: '*' port: 33060 failed, `bind()` failed with error: Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
[service:mysql-sql-master] 2024-12-11T12:43:39.925186085Z 2024-12-11T12:43:39.925033Z 0 [ERROR] [MY-013597] [Server] Plugin mysqlx reported: 'Value '*' set to `Mysqlx_bind_address`, X Plugin can't bind to it. Skipping this value.'
[service:mysql-sql-master] 2024-12-11T12:43:40.070696179Z 2024-12-11T12:43:40.070449Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[service:mysql-sql-master] 2024-12-11T12:43:40.070751654Z 2024-12-11T12:43:40.070473Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[service:mysql-sql-master] 2024-12-11T12:43:40.073110554Z 2024-12-11T12:43:40.072995Z 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.
[service:mysql-sql-master] 2024-12-11T12:43:40.087517864Z 2024-12-11T12:43:40.087369Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.40' socket: '/var/run/mysqld/mysqld.sock' port: 3307 MySQL Community Server - GPL.
[service:mysql-sql-master] 2024-12-11T12:43:40.087556495Z 2024-12-11T12:43:40.087392Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sockNot only is this super confusing, but also wastes precious time by providing invalid information that needs to be processed and verified. I don't know how Gitlab fetches logs from the services, but it certainly looks like it matches more than it should. I believe this is clear bug in the runner.