Incorrect slow log file used after disabling slowlog rotation
General
Escalation
General
Escalation
Description
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
Lalit ChoudharyLalit ChoudharyReporter
Daniel KowalewskiDaniel Kowalewski(Deactivated)Labels
Affects versions
Priority
Medium
Details
Details
Assignee

Reporter

Labels
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist

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