Bug ID 530952: MySql query fails with error number 1615 'Prepared statement needs to be re-prepared'

Last Modified: Sep 13, 2023

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

Known Affected Versions:
11.5.1, 11.5.2, 11.5.3, 11.6.0, 12.1.0 HF1, 12.1.0 HF2, 12.1.1 HF1, 12.1.1 HF2, 12.1.2 HF1, 12.1.2 HF2

Fixed In:
12.0.0, 11.6.1, 11.5.4

Opened: Jul 01, 2015

Severity: 3-Major

Symptoms

MySql query fails with error number 1615 'Prepared statement needs to be re-prepared'. Errors in monpd.log similar to the following: [DB::mysql_query_safe, query failed] Error (error number 1615) executing SQL string ...

Impact

Monpd loses functionality

Conditions

This is due to a MySql bug. For information, see 'Prepared-Statement fails when MySQL-Server under load', available here: http://bugs.mysql.com/bug.php?id=42041

Workaround

Restart monpd.

Fix Information

Error number 1615, 'Prepared statement needs to be re-prepared', no longer occurs in the monpd.log.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips