• Support

  • Failed to create check sector file - InnoDB

Olá,
Estou com um problema no MySQL 8.4, instalei ele de forma compilada e estava funcionando normalmente.

Hoje percebi um uso alto de CPU e RAM, quando fui ver o MySQL estava usando todo o recurso do servidor, e pelo erro que pude ver, se refere ao MySQL não conseguir criar o arquivo check_sector_size.

Tentei modificar as permissões da pasta para o usuário mysql e tentei o suporte a O_DIRECT no diretório e está disponível.

Alguém teria uma idea de solução?
aaPanel versão 7.0.15
MySQL versão 8.4
Ubuntu 24.04 LTS

2025-01-21T18:35:31.786896Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.4.0) starting as process 587705
2025-01-21T18:35:31.897928Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-01-21T18:35:31.921456Z 1 [ERROR] [MY-012655] [InnoDB] Failed to create check sector file, errno:13 Please confirm O_DIRECT is supported and remove the file /www/server/check_sector_size if it exists.

    Hello, please check if the directory has mysql permissions? Check ls -alh /www/server/data

    Also check if /www/server/check_sector_size exists? ls -alh /www/server/check_sector_size
    What is server space partitioning? df -TH

    aaP_iaredev10

      Thank you for your reply.
      I had already checked for the existence of the file /www/server/check_sector but it is not present in the folder.

      About my current partitioning
      Filesystem Type Size Used Avail Use% Mounted on
      tmpfs tmpfs 813M 922k 812M 1% /run
      /dev/sda1 ext4 40G 16G 23G 42% /
      tmpfs tmpfs 4.1G 398k 4.1G 1% /dev/shm
      tmpfs tmpfs 5.3M 0 5.3M 0% /run/lock
      /dev/sda15 vfat 265M 150k 265M 1% /boot/efi
      tmpfs tmpfs 813M 13k 813M 1% /run/user/0

      And mysql has permission 755 in the folder /www/server/data

      root@iaReCRM:/www# ls -alh /www/server/data
      total 85M
      drwxr-xr-x 9 mysql mysql 4.0K Jan 22 08:42 .
      drwxr-xr-x+ 11 root root 4.0K Dec 6 12:28 ..
      -rwxr-xr-x 1 mysql mysql 56 Oct 23 12:20 auto.cnf
      -rwxr-xr-x 1 mysql mysql 1.7K Oct 23 12:20 ca-key.pem
      -rwxr-xr-x 1 mysql mysql 1.1K Oct 23 12:20 ca.pem
      -rwxr-xr-x 1 mysql mysql 1.1K Oct 23 12:20 client-cert.pem
      -rwxr-xr-x 1 mysql mysql 1.7K Oct 23 12:20 client-key.pem
      -rwxr-xr-x 1 mysql mysql 17K Jan 22 08:42 iaReCRM.err
      -rwxr-xr-x 1 mysql mysql 6.0M Jan 21 17:38 '#ib_16384_0.dblwr'
      -rwxr-xr-x 1 mysql mysql 14M Oct 23 16:19 '#ib_16384_1.dblwr'
      -rw-r----- 1 mysql mysql 53K Jan 21 17:38 ib_buffer_pool
      drwxr-xr-x 2 mysql mysql 4.0K Jan 21 15:35 '#innodb_redo'
      drwxr-xr-x 2 mysql mysql 4.0K Jan 21 17:38 '#innodb_temp'
      drwxr-xr-x 2 mysql mysql 4.0K Oct 23 12:20 mysql
      -rwxr-xr-x 1 mysql mysql 181 Jan 6 17:13 mysql-bin.000008
      -rwxr-xr-x 1 mysql mysql 19 Jan 6 17:13 mysql-bin.index
      -rwxr-xr-x 1 mysql mysql 26M Jan 21 17:33 mysql.ibd
      -rwxr-xr-x 1 mysql mysql 6.7M Jan 21 17:30 mysql-slow.log
      -rwxr-xr-x 1 mysql mysql 124 Oct 23 12:20 mysql_upgrade_history

        Hello, is the problem solved? Is it normal to try to add a file manually?
        touch /www/server/data/test.txt

        aaP_iaredev10