Incorrect slow log file used after disabling slowlog rotation

Description

When disabling slow query log rotation by reversing the steps described here, the new value of `slow_query_log_file` is ignored until a server restart. The old file handle with the sequence number suffix remains open, and the correct file handle is never opened.

Start server with:

Enable slow log rotation:

 

Verify that file with sequence number suffix is open:

 

Now reverse steps to return to default slow log configuration:

 

Confirm old file is still open:

 

Just to make sure, disable and enable the slow log:

 

Old file handle is still open:

 

After a restart of mysqld, the correct file is being used:

 

Environment

CentOS Linux release 7.3.1611 (Core)

Percona Server 5.7.18-15

Smart Checklist

Activity

Show:

Lalit Choudhary August 23, 2018 at 8:41 AM

Hi Daniel,

I tested described behavior with the latest version of percona server 5.7.22 on centos 7.

I'm unable to reproduce the same issue.

Test:  

 

Cannot Reproduce

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created February 23, 2018 at 12:19 AM
Updated August 23, 2018 at 8:42 AM
Resolved August 23, 2018 at 8:42 AM
Loading...