My Oracle Support Banner

Binary Log Filenames With Special Characters (Doc ID 2454709.1)

Last updated on MARCH 12, 2021

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.
BUG 27149587 - INCORRECT BINLOG FILE NAME HANDLING WITH MULTIPLE DOTS IN FILE NAME

Symptoms

There is a known defect as of Oct '18 which affects all versions of MySQL Server.

BUG 20370146 - --LOG-BIN WRONGLY PROCESSES BASENAME WITH A DOT ('.')

 

In certain configurations, where the server has configured the binary/relay log files with a "dot" or "period" ( eg the literal "."  ) in their names,, it would cause the Server to overwrite the log file, once it reached max_bin_log_file_size.

It would cause the files to be overwritten due to the server truncating the name of the file, based on the location of the 1st period.

Thus , not knowing that the rest of the filename isn't present , the server would write to the "next" file but the filenames on the disk are no longer unique.

 

 

Changes

Using multiple character literals: period / "dot" / "." , in the variable names for log_bin or relay_log

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.