Got error 122 from storage engine when doing LOCK TABLES 122 when backing up mysql database(s) on DX Netops Performance Management

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

mysqldump: Got error: 1030: Got error 122 from storage engine when doing LOCK TABLES

Cause

This may indicate a space or quota issue on the DX Netops Performance Managemen drive that contains the MySQL Data files.

If there are no quotas applied to the drive and there is no space issue this may indicate one or more corrupted tables.

Environment

Release : 20.2

Component : IM Reporting / Admin / Configuration

Resolution

Ensure the drive has sufficient space and no quota applied to the drive that MySQL data files reside on.

If there are no quotas or space issues, support for further assistance.