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

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


Article ID: 139375


Updated On:


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


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?


Release : 9.4



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.


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.