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

Last Modified: Nov 07, 2022

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

Known Affected Versions:
11.5.1, 11.5.1 HF1, 11.5.1 HF10, 11.5.1 HF11, 11.5.1 HF2, 11.5.1 HF3, 11.5.1 HF4, 11.5.1 HF5, 11.5.1 HF6, 11.5.1 HF7, 11.5.1 HF8, 11.5.1 HF9, 11.5.10, 11.5.2, 11.5.2 HF1, 11.5.3, 11.5.3 HF1, 11.5.3 HF2, 11.6.0, 11.6.0 HF1, 11.6.0 HF2, 11.6.0 HF3, 11.6.0 HF4, 11.6.0 HF5, 11.6.0 HF6, 11.6.0 HF7, 11.6.0 HF8

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