Failed to dump the ddmdb - 1030: Got error 122 from storage engine when using LOCK TABLES

Products

• CA Spectrum

Issue/Introduction

The following is displayed to dump the MySQL DDMdb database:

# ./mysqldump -uroot -proot ddmdb > ddmdb.sql

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

 

Environment

Release : 10.3

Component : Spectrum Alarm & Event Management

Cause

There were two ghost tables in the ddmdb database. By running the following syntax we identified one of the ghost table:

# ./mysqldump -uroot -proot --single-transaction ddmdb > ddmdb.sql

 

Resolution

Dropped the ghost tables:

drop table event_innodb;

drop table tmp_partitionlog;

Even though we got Unknown table, those tables disappeared when we rerun "show tables;"

Successfully run the mysqldump.