[ERROR] [MY-012576] [InnoDB] Unable to create temporary file； errno: 30

• 问题：

2020-09-11T18:53:13.758112Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.21) initializing of server in progress as process 43
2020-09-11T18:53:13.768247Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-09-11T18:53:13.775346Z 1 [ERROR] [MY-012576] [InnoDB] Unable to create temporary file; errno: 30
2020-09-11T18:53:13.775463Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2020-09-11T18:53:13.775820Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-11T18:53:13.775920Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-11T18:53:13.776070Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-11T18:53:13.776679Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21)  MySQL Community Server - GPL.
2020-09-15T10:32:05.925508Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.21) initializing of server in progress as process 43
2020-09-15T10:32:06.066772Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

• 问题描述：

正常启动 --> 根据tpot.yml文件
high_mysql:
    container_name: high_mysql
    image: new_1:v1  #根据实际需要更换镜像信息
    tty: true
    networks:
    - cowrie_local
    environment:
    - MYSQL_ROOT_PASSWORD=123456
    ports:
    - '3306:3306'
    read_only: true
    restart: 'no'
    tty: true
    volumes:
    - /data/mysql:/opt

(*)正常启动容器：

root@207:/opt/tpot/etc# docker run --name mysq_4 -v /data/mysql:/opt -e MYSQL_ROOT_PASSWORD=123456 -d new2:v1
0a4445d96dcb9c432f0383d2477ba11fda8729e50dfd9757a0289f3a8cf82381
(*)验证：
root@207:/opt/tpot/etc# docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
0a4445d96dcb        new2:v1             "docker-entrypoint.s…"   10 seconds ago      Up 3 seconds        3306/tcp, 33060/tcp 
                mysq_4

(*)异常启动容器：

root@207:/opt/tpot/etc# docker-compose -f etc/tpot.yml up -d high_mysql
(*)情况：
root@207:/opt/tpot/etc# docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                     PORTS                               NAMES
16d1a28327c4        new_1:v1            "docker-entrypoint.s…"   14 seconds ago      Exited (0) 5 seconds ago  

出现上面报错问题：[ERROR] [MY-012576] [InnoDB] Unable to create temporary file; errno: 30

• 解决问题：

(*)比较tpot.yml文件中映射路径的权限，用户组时候一致(/data/mysql:/opt)

/data/mysql：drwxr-xr-x  2  999 mysql 4096 Sep 16 15:20 mysql/
root@207:/data# id mysql
uid=2004(mysql) gid=999(mysql) groups=999(mysql)

/opt       ：drwxr-xr-x   1 mysql mysql 4096 Sep  9 14:14 opt
# id mysql
uid=999(mysql) gid=999(mysql) groups=999(mysql)

如果映射路径用户组不同，可以通过以下命令添加用户组，并指定相同组id
指定组id:groupadd -g 999 mysql
指定组中用户id:useradd -u 2004 -g mysql mysql

引用(Thanks!)：https://blog.youkuaiyun.com/ljx1528/article/details/81903964

(*)重新指定容器中mysql的临时路径

修改my.cnf文件：添加tmpdir = /var/lib/tmp/  // 要求目录操作前应当存在，没有：mkdir -p /var/lib/tmp/
root@207:/data# docker run -t -i new_1:v1 /bin/sh
# find / -name my.cnf
/etc/alternatives/my.cnf
/etc/mysql/my.cnf
# vi /etc/mysql/my.cnf
# exit

(*)提交新改动的镜像情况

root@207:/data# docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                      PORTS                               NAMES
af42962b55f9        new_1:v1            "docker-entrypoint.s…"   11 minutes ago      Exited (0) 2 minutes ago
root@207:/data# docker commit -m "commit" -a "root" af42962b55f9 new_1:v1
sha256:97da94867e9ddf5ed370846ee8398ea9b2bd33a10a61c7ec063f26fa7f368280
root@207:/data# docker images
REPOSITORY                 TAG                 IMAGE ID            CREATED             SIZE
new_1                      v1                  97da94867e9d        23 seconds ago      595MB

(*)验证

root@207:/data# docker-compose -f /opt/tpot/etc/tpot.yml up -d high_mysql
WARNING: Some networks were defined but are not used by any service: heralding_local, spiderfoot_local
Recreating high_mysql ...
Recreating high_mysql ... done
root@207:/data# docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
0b57a48163b0        new_1:v1            "docker-entrypoint.s…"   9 seconds ago       Up 4 seconds        0.0.0.0:3306->3306/tcp, 33060/tcp   high_mysql