Bug ID 560014: Error written to monpd log if upgrade and there is traffic capture data in database

Last Modified: Oct 17, 2023

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

Known Affected Versions:
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

Fixed In:
12.1.0

Opened: Nov 26, 2015

Severity: 3-Major

Symptoms

You will see this error in the monpd log if you upgrade and there is traffic capture data in the database: ... [DB::mysql_query_safe, query failed] Error (error number 1064) executing SQL string : CALL AddPartition('AVR_STAT_TRAFFIC_CAPTURE_T', NULL, NULL, 'T') Because : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1

Impact

No impact other than this error written to log.

Conditions

Upgrading after collecting traffic capture data.

Workaround

You can safely ignore this error [related to AddPartition('AVR_STAT_TRAFFIC_CAPTURE_T ...].

Fix Information

You no longer see an error that was logged in the monpd log after upgrading when there was traffic capture data in the database.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips