The deployment of the iMC SHM component fails, and the dbresult log shows Cannot add or update a child row

None

IMC Plat E0705P12 installation of SHM component E0707 fails to deploy, prompting that batch deployment fails and an error is reported

1.For problems encountered during installation and deployment, first check the dma and dms logs

The dms log error message is as follows：

2021-09-21 18:15:50 [ERROR] [SwingWorker-pool-3-thread-4] [com.h3c.imc.deploy.tasks.BuildDatabaseTask$DatabaseBuilderWorker::doInBackground(938)] Execute database script error! return value: 1. For details, see log file: /etc/iMC-Reserved/log/dbresult_2021092118154976.log 

2021-09-21 18:15:50 [ERROR] [Thread-18543] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(366)] Task execute failed 

The first error refers to the execution of the database script error, the second error indicates that the execution of the installation task failed,It is recommended that we check the /etc/iMC-Reserved/log/dbresult_2021092118154976.log log.

2.View /etc/iMC-Reserved/log/dbresult_2021092118154976.log ,display as follow:

Begin to install imcaclm database and data... -------------------------------- 

Begin to create sla_db database...

End to create sla_db database. ----------------------------- 

Begin to create sla_db table... 

End to create sla_db table. -----------------------------

Begin to install sla_db data... 

ERROR 1452 (23000) at line 29: Cannot add or update a child row: a foreign key constraint fails (`sla_db`.`tbl_sla_base_index`, CONSTRAINT `tbl_sla_base_index_ibfk_1` FOREIGN KEY (`GROUP_SUPPORT_ID`) REFERENCES `tbl_sla_group_support` (`GROUP_SUPPORT_ID`)) The install of imcaclm finished unsuccessfully, please contact your local IMC support centre.

This question points to the database side, cannot add row data to the database table.We need to find an engineer with database experience to check it.Check the auto_increment_increment parameter in the database configuration file /etc/my.cnf , and find that the key value parameter auto_increment_increment in the SHM database is incorrect. It is displayed as 100 and the default value is 1.

# The MariaDB server 

[mysqld] server_id=1

log_bin=mysql-bin 

binlog_do_db=ead 

expire_logs_days=8 

binlog_format=row 

auto_increment_increment=100

port = 3306

Modify the auto_increment_increment parameter in the database configuration file my.cnf from 100 to the default 1

# The MariaDB server 

[mysqld] server_id=1

log_bin=mysql-bin 

binlog_do_db=ead 

expire_logs_days=8 

binlog_format=row 

auto_increment_increment=1 

port = 3306