[ERROR] InnoDB: Error number 28 means 'No space left on device'
search cancel

[ERROR] InnoDB: Error number 28 means 'No space left on device'

book

Article ID: 139375

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

The following errors occur frequently in GatewayDB (MySQL).

**************************************************************************************************************************

2019-10-28T03:10:24.738213+08:00 1 [Warning] InnoDB: 1048576 bytes should have been written. Only 880640 bytes written. Retrying for the remaining bytes.

2019-10-28T03:10:24.748885+08:00 1 [Warning] InnoDB: Retry attempts for writing partial data failed.

2019-10-28T03:10:24.748909+08:00 1 [ERROR] InnoDB: Write to file (merge)failed at offset 1292894208, 1048576 bytes should have been written, only 880640 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.

2019-10-28T03:10:24.748929+08:00 1 [ERROR] InnoDB: Error number 28 means 'No space left on device'

2019-10-28T03:10:24.755750+08:00 1 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html

2019-10-28T03:10:28.228276+08:00 1 [ERROR] Incorrect key file for table 'audit_message'; try to repair it

*****************************************************************************************************************************

What is the cause of this error?


Environment

Release : 9.4

Component : API GTW ENTERPRISE MANAGER

Cause

The direct reason for the error is due to lack of disk space.

MySQL5.7 stores temporary data in ibtmp1.

This file will continue to grow unless MySQL is restarted.

As a result, you may run out of disk space.


Resolution

Restart the MySQL service.

Precaution: When starting the server, you must limit the size of this file by adding the "innodb_temp_data_file_path" parameter to my.cnf.

for example:  

        innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G


If my.cnf is changed, the MySQL service must be restarted.