문제발생.
에러로그 확인
systemctl status mysql
확인
Version: ‘10.4.21-MariaDB-1:10.4.21+maria~bionic-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 mariadb.org binary distribution
2021-09-26 0:00:22 0 [Note] InnoDB: Buffer pool(s) load completed at 210926 0:00:22
2021-09-26 6:50:07 406 [Warning] mysqld: Disk is full writing ‘/var/log/mysql/mariadb-bin.000034’ (Errcode: 28 “No space left on device”). Waiting for someone to free space… (Expect up to 60 secs delay for server to continue after freeing disk space)
2021-09-26 6:50:07 406 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2021-09-27 6:49:02 3217 [Warning] mysqld: Disk is full writing ‘/var/log/mysql/mariadb-bin.000034’ (Errcode: 28 “No space left on device”). Waiting for someone to free space… (Expect up to 60 secs delay for server to continue after freeing disk space)
2021-09-27 6:49:03 3217 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2021-09-27 15:13:19 8913 [ERROR] mysqld: Disk full (/tmp/#sql_9974_0.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”)
2021-09-27 15:13:29 8920 [Warning] mysqld: Disk is full writing ‘/var/log/mysql/mariadb-bin.000034’ (Errcode: 28 “No space left on device”). Waiting for someone to free space… (Expect up to 60 secs delay for server to continue after freeing disk space)
2021-09-27 15:13:29 8920 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2021-09-27 15:13:31 8922 [ERROR] mysqld: Disk full (/tmp/#sql_9974_0.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”)
2021-09-27 15:21:44 8964 [ERROR] mysqld: Disk full (/tmp/#sql_9974_0.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”)
2021-09-27 15:21:57 8965 [ERROR] mysqld: Disk full (/tmp/#sql_9974_0.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”)
2021-09-27 15:23:29 8920 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
원인
log 파일 메모리 오버된 상태..
/var/log/mysql 폴더에 있는 로그 삭제 후 제부팅.
정상작동.
데이터 로그파일 확인후 삭제
mariadb/mysql Disk is full writing 일시 대처법
cd /
du -sh *
순서대로 밑으로 확인후 log 파일 삭제한다..