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

Termination of the session is omitted sporadically from the slow query log

  1. Series 5.6
  2. Bug #1098857
Bug #1098857 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Incomplete
Medium
Yura Sorokin
5.1
Won't Fix
Medium
Yura Sorokin
5.5
Incomplete
Medium
Yura Sorokin
5.6
Incomplete
Medium
Yura Sorokin

Bug Description

I don't have enough information for a full reproducible procedure, so just opening this for a possible follow-up in the future.

Usually session termination is slow-logged as "# Administrative command: Quit", if slow log options allow it. However, occasionally it is not logged, with no clear pattern.

For example, http://jenkins.percona.com/job/percona-server-5.1-param/498/BUILD_TYPE=debug,Host=debian6-64/testReport/junit/%28root%29/main/percona_mysqldumpslow/ shows it to be logged 125 times out of 128.

This is with
log_slow_admin_statements=ON;
long_query_time=0;
min_examined_row_limit=0;

Currently not sure about upstream and 5.5.

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Setting triage to Low as it's unlikely to affect users in any important way.

tags: added: slow-extended
Revision history for this message
Stewart Smith (stewart) wrote : Re: [Bug 1098857] [NEW] Termination of the session is omitted sporadically from the slow query log

Laurynas Biveinis <email address hidden> writes:
> I don't have enough information for a full reproducible procedure, so
> just opening this for a possible follow-up in the future.
>
> Usually session termination is slow-logged as "# Administrative command:
> Quit", if slow log options allow it. However, occasionally it is not
> logged, with no clear pattern.

This may affect people using percona-playback to play back captured
load, leaving the replay with a lot of hanging connections not doing anything.

--
Stewart Smith

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

I haven't considered using slow query logs as an input to something else, with Quit as a session termination marker. That could be more serious, resetting triage then.

Revision history for this message
Stewart Smith (stewart) wrote : Re: [Bug 1098857] Re: Termination of the session is omitted sporadically from the slow query log

Laurynas Biveinis <email address hidden> writes:
> I haven't considered using slow query logs as an input to something
> else, with Quit as a session termination marker. That could be more
> serious, resetting triage then.

I'll set to Medium as is probably higher up than most of our Low ones,
and we certainly have a bunch more higher prio bugs too.

--
Stewart Smith

Laurynas Biveinis (laurynas-biveinis)
tags: added: ci
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

See also bug 1163680.

Revision history for this message
Yura Sorokin (yura-sorokin) wrote :

No signs of this test failure on both 5.5 and 5.6 in Jenkins for at least 1 months (as of September 21, 2015).
Setting status to "Incomplete".

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-1295

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.