Problem background
When logging into the database to view the table structure in Linux environment, an error is reported:
desc base_mirror;
ERROR 1030 (HY000): Got error 28 from storage engine
Most of the conclusions of Google search are the problem of insufficient disk space
View the temporary space directory of MySQL
mysql> show variables like '%dir%';
+-----------------------------------------+----------------------------+
| Variable_name | Value |
+-----------------------------------------+----------------------------+
| basedir | /usr/ |
| binlog_direct_non_transactional_updates | OFF |
| character_sets_dir | /usr/share/mysql/charsets/ |
| datadir | /var/lib/mysql/ |
| ignore_db_dirs | |
| innodb_data_home_dir | |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 75 |
| innodb_max_dirty_pages_pct_lwm | 0 |
| innodb_tmpdir | |
| innodb_undo_directory | . |
| lc_messages_dir | /usr/share/mysql/ |
| plugin_dir | /usr/lib64/mysql/plugin/ |
| slave_load_tmpdir | /tmp |
| tmpdir | /tmp |
+-----------------------------------------+----------------------------+
15 rows in set (0.00 sec)
View this machine as follows:
#df -TH
Filesystem Type Size Used Avail Use% Mounted on
devtmpfs devtmpfs 17G 9.6G 7.2G 58% /dev
tmpfs tmpfs 17G 4.1k 17G 1% /dev/shm
tmpfs tmpfs 17G 1.5M 17G 1% /run
tmpfs tmpfs 17G 0 17G 0% /sys/fs/cgroup
/dev/vda2 ext4 63G 63G 0G 100% /
/dev/vda1 ext4 1.1G 145M 809M 16% /boot
tmpfs tmpfs 3.4G 0 3.4G 0% /run/user/0
overlay overlay 63G 45G 15G 75% /home/docker/overlay/5a22b3cdbe381649e30044980fd09341ceb4460c98fd36055c4727c3c31f9f9b/merged
shm tmpfs 68M 0 68M 0% /home/docker/containers/f61e00164f9f7d2077952af0a025670d7b88a7fb42c37c4e73d7e4c68ef3115e/shm
The overall space of the machine is still available, but the space of the root directory is insufficient, and the MySQL temporary space directory is under the root directory. You need to delete it to make space. After operation:
mysql> desc base_mirror;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| mirror_name | varchar(100) | NO | | NULL | |
| origin_mirror_name | varchar(100) | NO | | NULL | |
| mirror_tag | varchar(100) | NO | | NULL | |
| cloud_version | varchar(100) | NO | | NULL | |
| archi | varchar(100) | NO | | NULL | |
| mirror_path | varchar(200) | NO | | NULL | |
| os_version | varchar(100) | NO | | NULL | |
| namespace | varchar(100) | NO | | NULL | |
| description | longtext | NO | | NULL | |
| upgrade_log | longtext | YES | | NULL | |
| create_time | datetime(6) | NO | | NULL | |
| gitlab_path | varchar(200) | NO | | NULL | |
| branch_name | varchar(200) | NO | | NULL | |
| docker_file_path | varchar(200) | NO | | NULL | |
| Dockerfile_info | longtext | YES | | NULL | |
| build_log | longtext | YES | | NULL | |
| commit_id | varchar(100) | NO | | NULL | |
| user | varchar(100) | YES | | NULL | |
| is_newest | varchar(100) | NO | | NULL | |
| is_delete | varchar(20) | NO | | NULL | |
| is_free | varchar(20) | NO | | NULL | |
| can_upgrade | int(11) | NO | | NULL | |
| owner | varchar(100) | NO | | NULL | |
| imageid | varchar(64) | NO | | NULL | |
| mirror_sha | varchar(255) | NO | | NULL | |
| mirror_label | varchar(25) | NO | | NULL | |
| is_escrow | int(11) | NO | | NULL | |
| openapi_taskid | int(11) | YES | | NULL | |
| is_recommend | int(11) | NO | | NULL | |
+--------------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)
Problem-solving.
Read More:
- MySQL: Got error 139 from storage engine [How to Solve]
- Mysql8.02/ubuntu 20 ERROR 1449 (HY000) [How to Solve]
- [Solved] ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- MySQL Error: errorCode 1130, state HY000 [How to Solve]
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- Mysqldump: Got error: 1045: Access denied for user ‘root‘@‘localhost‘
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- Doris reports an error: error 1064 (HY000) [How to Solve]
- Error 1418 (HY000): this function has none of deterministic, no SQL
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- [Solved] mysqldump: Got error: 1556: “You can‘t use locks with log tables.“ when using LOCK TABLES
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- ERROR 3021 (HY000): Unknown error 3021 [How to Solve]