mysql建库报错ERROR 1006 (HY000): Can‘t create database ‘test2‘ (errno: -1636751184)

建库报错

mysql> create database test;
ERROR 1006 (HY000): Can't create database 'test' (errno: -1636751184)
mysql> create database test2;
ERROR 1006 (HY000): Can't create database 'test2' (errno: -1636751184)
mysql> exit
Bye

检查磁盘空间，发现100%了
root@iZ2zedsnrp2aqjwa6l2d6iZ:~/.rjyj-security# df -kh
Filesystem      Size  Used Avail Use% Mounted on
udev            7.6G     0  7.6G   0% /dev
tmpfs           1.6G  672K  1.6G   1% /run
/dev/vda1        40G   38G     0 100% /
tmpfs           7.6G  204M  7.4G   3% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           7.6G     0  7.6G   0% /sys/fs/cgroup

找到大的日志文件并删除

root@iZ2zedsnrp2aqjwa6l2d6iZ:~# find / -size +300M
/www/server/mysql/bin/mysqld
/www/server/mysql/lib/libmysqld.a
/swapfile
/opt/gateway-check/console.log
/proc/kcore
find: ‘/proc/3533998/task/3533998/net’: Invalid argument
find: ‘/proc/3533998/net’: Invalid argument
find: ‘/proc/3541923/task/3541923/fd/6’: No such file or directory
find: ‘/proc/3541923/task/3541923/fdinfo/6’: No such file or directory
find: ‘/proc/3541923/fd/5’: No such file or directory
find: ‘/proc/3541923/fdinfo/5’: No such file or directory
find: ‘/proc/3541934’: No such file or directory
/root/store/commitlog/00000000000000000000
/root/store/index/20220526213938127
/root/logs/rocketmqlogs/otherdays/rocketmq_client.9.log
/root/logs/rocketmqlogs/otherdays/rocketmq_client.3.log
/root/logs/rocketmqlogs/otherdays/rocketmq_client.4.log
/root/logs/rocketmqlogs/otherdays/rocketmq_client.8.log
root@iZ2zedsnrp2aqjwa6l2d6iZ:~# du -sh /root/logs/rocketmqlogs/otherdays/rocketmq_client*
146M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.10.log
101M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.1.log
101M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.2.log
1.3G    /root/logs/rocketmqlogs/otherdays/rocketmq_client.3.log
1.8G    /root/logs/rocketmqlogs/otherdays/rocketmq_client.4.log
101M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.5.log
101M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.6.log
176M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.7.log
651M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.8.log
834M    /root/logs/rocketmqlogs/otherdays/rocketmq_client.9.log
 

root@iZ2zedsnrp2aqjwa6l2d6iZ:~# rm -rf /root/logs/rocketmqlogs/otherdays/rocketmq_client.*

root@iZ2zedsnrp2aqjwa6l2d6iZ:~# df -kh
Filesystem      Size  Used Avail Use% Mounted on
udev            7.6G     0  7.6G   0% /dev
tmpfs           1.6G  672K  1.6G   1% /run
/dev/vda1        40G   33G  4.8G  88% /
tmpfs           7.6G  204M  7.4G   3% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           7.6G     0  7.6G   0% /sys/fs/cgroup
 

root@iZ2zedsnrp2aqjwa6l2d6iZ:~# mysql -uroot -p
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 137198
Server version: 5.7.37-log Source distribution

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

可以建库了。

mysql> create database testjzf;
Query OK, 1 row affected (0.01 sec)

mysql> exit