Percona Server moved to https://jira.percona.com/projects/PS

Anomaly with opt_log_slow_slave_statements

Bug #1163232 reported by Raghavendra D Prabhu
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Medium
Unassigned
5.5
Triaged
Medium
Unassigned
5.6
Triaged
Medium
Unassigned
5.7
Triaged
Medium
Unassigned

Bug Description

As reported in lp:1160436

 Regarding slave threads, compared to upstream, I see

- thd->enable_slow_log= opt_log_slow_slave_statements;
- thd->write_to_slow_log= opt_log_slow_slave_statements;
+ thd->enable_slow_log= TRUE;

with this, opt_log_slow_slave_statements is only checked in
slow_log_print; which means for slave threads, the whole function log_slow_statement
is called because compared to upstream, it (it being thd->enable_slow_log) is TRUE till then due to https://code.launchpad.net/~laurynas-biveinis/percona-server/slow-log-fixes-5.5/+merge/144058

Following are missing from PS source:

 sql/log_event.cc do_apply_event 3484 thd->enable_slow_log= opt_log_slow_slave_statements;
 sql/slave.cc init_slave_thread 2082 thd->enable_slow_log= opt_log_slow_slave_statements;

Laurynas Biveinis (laurynas-biveinis)
tags: added: slow-extended
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1346

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.