Spectrum upgrade fails and MYSQL. log shows: Unable to lock ./ibdata1 error: 11

Products

• Network Observability
• Spectrum

Issue/Introduction

The Spectrum install fails and the $SPECROOT/Install-Tools/LOGS/<version>/postinst.<time> file notes that mysql.cus was not successful:

The install log shows:

running Custom Script Install-Tools/CUS/mysql.cus
 Error(s) occurred. Please see /opt/CA/Spectrum/Install-Tools/LOGS/<version>/mysql.log.

Script Install-Tools/CUS/mysql.cus has FAILED

The mysql.log shows:

2025-11-16T14:59:36.875121Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2025-11-16T14:59:37.875422Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2025-11-16T14:59:38.876035Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2025-11-16T14:59:39.876198Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2025-11-16T14:59:40.876798Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
2025-11-16T14:59:41.876970Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11

Cause

Corrupt mysql database

Resolution

The mysql db is corrupt.

If you have saved the Archive Manager/DDM database and have a save file you can load it from the $SPECROOT/SS/DDM directory:

./ddm_load.pl -f <DDM savefile>

Once complete stop all Spectrum processes and run the install again.

If you do not have a DDM save file you will need to delete the mysql information.

Stop all Spectrum processes.

Delete or move $SPECROOT/mysql directory.

Launch the installer again.