Slave servers with query cache enabled crash with memory corruption errors (Doc ID 1462190.1)

Last updated on DECEMBER 24, 2014

Applies to:

MySQL Server - Version 5.1 to 5.6 [Release 5.1 to 5.6]
Information in this document applies to any platform.

Symptoms

Slaves with query cache enabled, replicating Mixed or Statement based events are seen randomly crashing, often with glibc memory corruption errors.  Note: As DDL statements are always using the Statement based format these can trigger the memory corruption even when using Row based replication.

Affected versions are:


Common symptoms include messages like this in the error logs:

*** glibc detected *** /usr/libexec/mysqld: malloc(): memory corruption:
0x00007f28f089f600 ***

The backtrace will show the crash happening in various code locations, typically involving the query cache and parser.

Changes

For existing slaves the issue will typically happen after either:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms