MySQL Service not Starting

book

Article ID: 211925

calendar_today

Updated On:

Products

CA Virtual Network Assurance

Issue/Introduction

The VNA API was not working, so I went to cycle the services, but MySQL would not start back. 

ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

The /opt/CA/MySql/data/<hostname>.err file shows the following errors

2021-04-01T14:01:15.737605Z 1 [Warning] [MY-012638] [InnoDB] InnoDB: Retry attempts for writing partial data failed.
2021-04-01T14:01:15.738978Z 1 [ERROR] [MY-012639] [InnoDB] InnoDB: Write to file ./ibtmp1 failed at offset 0, 1048576 bytes should have been written, only 0 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.
2021-04-01T14:01:15.739005Z 1 [ERROR] [MY-012640] [InnoDB] InnoDB: Error number 28 means 'No space left on device'
2021-04-01T14:01:15.739022Z 1 [ERROR] [MY-012267] [InnoDB] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space

Cause

The partition is out of disk space and therefore MySql cannot start

Environment

Release : 20.2

Component : DX Performance Management 

Resolution

Remove whatever files are available for deletion, such as HPROF files