Bug ID 640824: Upgrade fails with "DBD::mysql::db do failed: Too many partitions (including subpartitions) were defined" errors in ASM log

Last Modified: Sep 13, 2023

Affected Product(s):
BIG-IP ASM, Install/Upgrade(all modules)

Known Affected Versions:
13.0.0

Fixed In:
13.1.0, 13.0.0 HF1, 12.1.2 HF1

Opened: Jan 23, 2017

Severity: 3-Major

Related Article: K20770267

Symptoms

Upon first start after upgrade, the following error messages appear in asm log: ------------------------- notice boot_marker : ---===[ HD1.2 - BIG-IP 12.1.1 Build 0.0.184 <HD1.2> ]===--- info set_ibdata1_size.pl[18523]: Setting ibdata1 size finished successfully, a new size is: 8466M info tsconfig.pl[21351]: ASM initial configration script launched info tsconfig.pl[21351]: ASM initial configration script finished info asm_start[19802]: ASM config loaded crit perl[19802]: 01310027:2: ASM subsystem error (asm_start,F5::DbUpgrade::__ANON__): DBD::mysql::db do failed: Too many partitions (including subpartitions) were defined crit perl[19802]: 01310027:2: ASM subsystem error (asm_start,F5::DbUpgrade::__ANON__): DBD::mysql::db do failed: Cannot remove all partitions, use DROP TABLE instead crit perl[19802]: 01310027:2: ASM subsystem error (asm_start,F5::ConfigSync::load_traffic_data): Could not import table data PRX.REQUEST_LOG - ASM configuration save aborted info perl[21860]: 01310053:6: ASM starting -------------------------

Impact

Upgrade fails.

Conditions

-- ASM provisioned. -- Local request logging enabled. -- Upgrade of a maintenance release, hotfix, or engineering hotfix.

Workaround

Upgrade by the means of saving a UCS, performing a clean install and then loading the UCS. In the manual save/load UCS process, the upgrade of the Request Log can be disabled, which will workaround the error and the UCS will load fine. There are two options to disable the upgrade of the Request Log, when upgrading by the means of a UCS: ------------------- 1) Do not load a Request Log, when loading a UCS: # tmsh modify sys db ucs.asm.traffic_data.load value never 2) Do not save a Request Log, when saving a UCS: # tmsh modify sys db ucs.asm.traffic_data.save value disable -------------------

Fix Information

Roll-forward upgrade including traffic data now works correctly.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips