My Oracle Support Banner

Replica Servers With Query Cache Enabled Crash With Memory Corruption Errors (Doc ID 1462190.1)

Last updated on NOVEMBER 16, 2021

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

Replicas 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:

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

Changes

For existing replicas the issue will typically happen after either:

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.