🐛 MySQL docker failure during dev and CI

[larsyencken]

MySQL in Docker is failing in the db-load-data step due to a new failure in the upstream mysql:latest image.

Example in CI

https://github.com/owid/owid-grapher/actions/runs/7570304773/job/20653772497

See CI log

==> Starting & initializing Mysql instance for testing
Creating network "owid-grapher_default" with the default driver
Creating volume "owid-grapher_mysql_data_testing" with default driver
Pulling db (mysql/mysql-server:latest)...
latest: Pulling from mysql/mysql-server
Digest: sha256:d6c8301b7834c5b9c2b733b10b7e630f441af7bc917c74dba379f24eeeb6a313
Status: Downloaded newer image for mysql/mysql-server:latest
Building db-load-data
#0 building with "default" instance using docker driver

#1 [internal] load .dockerignore
#1 transferring context: 2B done
#1 DONE 0.0s

#2 [internal] load build definition from Dockerfile
#2 transferring dockerfile: 185B done
#2 DONE 0.0s

#3 [internal] load metadata for docker.io/mysql/mysql-server:latest
#3 DONE 0.0s

#4 [1/2] FROM docker.io/mysql/mysql-server:latest
#4 DONE 0.0s

#5 [2/2] RUN microdnf -y update  && microdnf install -y     libpwquality     curl     rsync     unzip     gzip
#5 0.255 Downloading metadata...
#5 9.737 Downloading metadata...
#5 19.57 Downloading metadata...
#5 20.85 Downloading metadata...
#5 21.37 Downloading metadata...
#5 24.81 Package                                                                             Repository                Size
#5 24.81 Installing:                                                                                                       
#5 24.81  acl-2.2.53-1.el8.x86_64                                                            ol8_baseos_latest      82.9 kB
#5 24.81  cpio-2.12-11.el8.x86_64                                                            ol8_baseos_latest     271.9 kB
#5 24.81  cracklib-2.9.6-15.el8.x86_64                                                       ol8_baseos_latest      95.4 kB
#5 24.81  cracklib-dicts-2.9.6-15.el8.x86_64                                                 ol8_baseos_latest       4.1 MB
#5 24.81  crypto-policies-scripts-20230731-1.git3[177](https://github.com/owid/owid-grapher/actions/runs/7570304773/job/20653772497#step:5:182)e06.el8.noarch                           ol8_baseos_latest      86.1 kB
#5 24.81  cryptsetup-libs-2.3.7-7.el8.x86_64                                                 ol8_baseos_latest     500.7 kB
#5 24.81  dbus-1:1.12.8-26.0.1.el8.x86_64                                                    ol8_baseos_latest      42.2 kB
#5 24.81  dbus-common-1:1.12.8-26.0.1.el8.noarch                                             ol8_baseos_latest      47.0 kB
#5 24.81  dbus-daemon-1:1.12.8-26.0.1.el8.x86_64                                             ol8_baseos_latest     246.0 kB
#5 24.81  dbus-libs-1:1.12.8-26.0.1.el8.x86_64                                               ol8_baseos_latest     188.4 kB
#5 24.81  dbus-tools-1:1.12.8-26.0.1.el8.x86_64                                              ol8_baseos_latest      87.5 kB
#5 24.81  device-mapper-8:1.02.[181](https://github.com/owid/owid-grapher/actions/runs/7570304773/job/20653772497#step:5:186)-13.0.2.el8_9.x86_64                                       ol8_baseos_latest     386.8 kB
#5 24.81  device-mapper-event-8:1.02.181-13.0.2.el8_9.x86_64                                 ol8_baseos_latest     277.9 kB
#5 24.81  device-mapper-event-libs-8:1.02.181-13.0.2.el8_9.x86_64                            ol8_baseos_latest     276.9 kB
#5 24.81  device-mapper-libs-8:1.02.181-13.0.2.el8_9.x86_64                                  ol8_baseos_latest     419.8 kB
#5 24.81  device-mapper-multipath-0.8.4-39.el8.x86_64                                        ol8_baseos_latest     213.8 kB
#5 24.81  device-mapper-multipath-libs-0.8.4-39.el8.x86_64                                   ol8_baseos_latest     342.0 kB
#5 24.81  device-mapper-persistent-data-0.9.0-7.el8.x86_64                                   ol8_baseos_latest     959.5 kB
#5 24.81  diffutils-3.6-6.el8.x86_64                                                         ol8_baseos_latest     369.3 kB
#5 24.81  dracut-049-228.git20230802.0.1.el8.x86_64                                          ol8_baseos_latest     391.5 kB
#5 24.81  elfutils-debuginfod-client-0.189-3.el8.x86_64                                      ol8_baseos_latest      76.9 kB
#5 24.81  elfutils-default-yama-scope-0.189-3.el8.noarch                                     ol8_baseos_latest      53.4 kB
#5 24.81  elfutils-libs-0.189-3.el8.x86_64                                                   ol8_baseos_latest     309.8 kB
#5 24.81  redhat-release-2:8.9-0.1.0.1.el8.x86_64                                            ol8_baseos_latest      19.5 kB
#5 24.81   replacing redhat-release-2:8.7-0.3.0.1.el8.x86_64                                                               
#5 24.81  rpm-4.14.3-26.el8.x86_64                                                           ol8_baseos_latest     556.9 kB
#5 24.81   replacing rpm-4.14.3-24.el8_7.x86_64                                                                            
#5 24.81  rpm-libs-4.14.3-26.el8.x86_64                                                      ol8_baseos_latest     353.5 kB
#5 24.81   replacing rpm-libs-4.14.3-24.el8_7.x86_64                                                                       
#5 24.81  setup-2.12.2-9.el8.noarch                                                          ol8_baseos_latest     [185](https://github.com/owid/owid-grapher/actions/runs/7570304773/job/20653772497#step:5:190).2 kB
#5 24.81   replacing setup-2.12.2-7.el8.noarch                                                                             
#5 24.81  shadow-utils-2:4.6-19.el8.x86_64                                                   ol8_baseos_latest       1.3 MB
#5 24.81   replacing shadow-utils-2:4.6-17.el8.x86_64                                                                      
#5 24.81  sqlite-libs-3.26.0-19.0.1.el8_9.x86_64                                             ol8_baseos_latest     594.1 kB
#5 24.81   replacing sqlite-libs-3.26.0-17.el8_7.x86_64                                                                    
#5 24.81  systemd-libs-239-78.0.3.el8.x86_64                                                 ol8_baseos_latest       1.2 MB
#5 24.81   replacing systemd-libs-239-68.0.2.el8_7.2.x86_64                                                                
#5 24.81  tar-2:1.30-9.el8.x86_64                                                            ol8_baseos_latest     858.7 kB
#5 24.81   replacing tar-2:1.30-6.el8.x86_64                                                                               
#5 24.81  tzdata-2023d-1.0.1.el8.noarch                                                      ol8_baseos_latest     488.0 kB
#5 24.81   replacing tzdata-2022g-1.el8.noarch                                                                             
#5 24.81  zlib-1.2.11-25.el8.x86_64                                                          ol8_baseos_latest     104.6 kB
#5 24.81    replacing zlib-1.2.11-21.el8_7.x86_64                                                                          
#5 24.81 Transaction Summary:
#5 24.81  Installing:       80 packages
#5 24.81  Reinstalling:      0 packages
#5 24.81  Upgrading:        56 packages
#5 24.81  Obsoleting:        0 packages
#5 24.81  Removing:          0 packages
#5 24.81  Downgrading:       0 packages
#5 24.82 Downloading packages...
#5 27.40 error: package mysql-shell-8.0.36-1.el8.x86_64 cannot be verified and repo mysql-tools-community is GPG enabled: /var/cache/yum/metadata/mysql-tools-community-8-x86_64/packages/mysql-shell-8.0.36-1.el8.x86_64.rpm could not be verified.
#5 27.40 /var/cache/yum/metadata/mysql-tools-community-8-x86_64/packages/mysql-shell-8.0.36-1.el8.x86_64.rpm:  digest:  SIGNATURE:  NOT OK
#5 ERROR: process "/bin/sh -c microdnf -y update  && microdnf install -y     libpwquality     curl     rsync     unzip     gzip" did not complete successfully: exit code: 1
------
 > [2/2] RUN microdnf -y update  && microdnf install -y     libpwquality     curl     rsync     unzip     gzip:
24.81 Transaction Summary:
24.81  Installing:       80 packages
24.81  Reinstalling:      0 packages
24.81  Upgrading:        56 packages
24.81  Obsoleting:        0 packages
24.81  Removing:          0 packages
24.81  Downgrading:       0 packages
24.82 Downloading packages...
27.40 error: package mysql-shell-8.0.36-1.el8.x86_64 cannot be verified and repo mysql-tools-community is GPG enabled: /var/cache/yum/metadata/mysql-tools-community-8-x86_64/packages/mysql-shell-8.0.36-1.el8.x86_64.rpm could not be verified.
27.40 /var/cache/yum/metadata/mysql-tools-community-8-x86_64/packages/mysql-shell-8.0.36-1.el8.x86_64.rpm:  digest:  SIGNATURE:  NOT OK
------
Dockerfile:3
--------------------
   2 |     
   3 | >>> RUN microdnf -y update \
   4 | >>>  && microdnf install -y \
   5 | >>>     libpwquality \
   6 | >>>     curl \
   7 | >>>     rsync \
   8 | >>>     unzip \
   9 | >>>     gzip
  10 |     
--------------------
ERROR: failed to solve: process "/bin/sh -c microdnf -y update  && microdnf install -y     libpwquality     curl     rsync     unzip     gzip" did not complete successfully: exit code: 1
Service 'db-load-data' failed to build : Build failed

[larsyencken]

@danyx23 You've already been tackling this, not sure if you wrote up an issue yet.

[larsyencken]

• 9d5e731
• 🔨 switch mysql docker images to debian to work around microdnf issues #3112