Bug ID 784793: Blades 1, 3, and 4 go offline after ASM config changes and sync

Last Modified: Dec 13, 2023

Affected Product(s):
BIG-IP ASM(all modules)

Known Affected Versions:
11.6.2, 11.6.3, 11.6.3.1, 11.6.3.2, 11.6.3.3, 11.6.3.4, 11.6.4, 11.6.5, 11.6.5.1, 11.6.5.2, 11.6.5.3, 12.0.0, 12.0.0 HF1, 12.1.0 HF1, 12.0.0 HF2, 12.1.0 HF2, 12.0.0 HF3, 12.0.0 HF4, 12.1.1 HF1, 12.1.1 HF2, 12.1.2 HF1, 12.1.2 HF2, 12.1.0, 12.1.1, 12.1.2, 12.1.3, 12.1.3.1, 12.1.3.2, 12.1.3.3, 12.1.3.4, 12.1.3.5, 12.1.3.6, 12.1.3.7, 12.1.4, 12.1.4.1, 12.1.5, 12.1.5.1, 12.1.5.2, 12.1.5.3, 12.1.6, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1, 13.1.0, 13.1.0.1, 13.1.0.2, 13.1.0.3, 13.1.0.4, 13.1.0.5, 13.1.0.6, 13.1.0.7, 13.1.0.8, 13.1.1, 13.1.1.2, 13.1.1.3, 13.1.1.4, 13.1.1.5, 13.1.3, 13.1.3.1, 13.1.3.2, 13.1.3.3, 13.1.3.4, 13.1.3.5, 13.1.3.6, 13.1.4, 13.1.4.1, 13.1.5, 13.1.5.1, 14.0.0, 14.0.0.1, 14.0.0.2, 14.0.0.3, 14.0.0.4, 14.0.0.5, 14.0.1, 14.0.1.1, 14.1.0, 14.1.0.1, 14.1.0.2, 14.1.0.3, 14.1.0.5, 14.1.0.6, 14.1.2, 14.1.2.1, 14.1.2.2, 14.1.2.3, 14.1.2.4, 14.1.2.5, 14.1.2.6, 14.1.2.7, 14.1.2.8, 14.1.3, 14.1.3.1, 14.1.4, 14.1.4.1, 14.1.4.2, 14.1.4.3, 14.1.4.4, 14.1.4.5, 14.1.4.6, 14.1.5, 14.1.5.1, 14.1.5.2, 14.1.5.3, 14.1.5.4, 14.1.5.6, 15.0.0, 15.0.1, 15.0.1.1, 15.0.1.2, 15.0.1.3, 15.0.1.4, 15.1.0, 15.1.0.1, 15.1.0.2, 15.1.0.3, 15.1.0.4, 15.1.0.5, 15.1.1, 15.1.2, 15.1.2.1, 15.1.3, 15.1.3.1, 15.1.4, 15.1.4.1, 15.1.5, 15.1.5.1, 15.1.6, 15.1.6.1, 15.1.7, 15.1.8, 15.1.8.1, 15.1.8.2, 15.1.9, 15.1.9.1, 15.1.10, 15.1.10.2, 15.1.10.3

Opened: May 22, 2019

Severity: 3-Major

Symptoms

ASM chassis sync fails to load on secondary slot due to foreign key constraint failure. Secondary chassis blades go offline after ASM config changes and sync. The system reports errors in var/log/ts/asm_config_server.log: ------------------------ asm_config_server.pl|ERR|Apr 25 02:06:17.204|29603|F5::SetActive::Impl::set_active,,Setting policy active failed: Failed on insert to DCC.ACCOUNT_CHARSET_TEMPLATES (DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`DCC`.`ACCOUNT_CHARSET_TEMPLATES`, CONSTRAINT `ACCOUNT_CHARSET_TEMPLATES_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `ACCOUNTS` (`account_id`) ON DELETE CASCADE)) asm_config_server.pl|ERR|Apr 25 02:06:17.206|29603|F5::Cluster::Sync::apply_sync,,Applying sync file failed ------------------------ var/log/ts/asmcsd.log: ------------------------ asmcsd|ERR|Apr 25 02:06:17.334|19152| [APP::hbcl_bridge_thread, hbcl_read_status] Asm configuration failure detected. The high availability action <go_offline> will be applied on this blade ------------------------

Impact

Secondary chassis blades go offline after ASM config changes and sync,

Conditions

-- ASM provisioned on a chassis device with multiple blades. -- Change ASM config on primary blade and sync to secondary blades.

Workaround

None.

Fix Information

None

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips