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

book

Article ID: 210797

calendar_today

Updated On:

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

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

Environment

Release : 10.3

Component : Spectrum Alarm & Event Management

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.

Attachments