PS now has option to log statements in stored routine but uses bad log format

Bug #1419230 reported by Swany on 2015-02-07
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Laurynas Biveinis
5.1
Invalid
Undecided
Unassigned
5.5
Fix Released
Medium
Laurynas Biveinis
5.6
Fix Released
Medium
Laurynas Biveinis

Bug Description

# User@Host: flexviews[flexviews] @ localhost [localhost] Id: 83
# Schema: flexviews Last_errno: 1051 Killed: 0
# Query_time: 0.000045 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 4 Rows_affected: 0
# Bytes_sent: 0
# Stored routine: flexviews.apply_delta

Above is slow query log output from new feature. Notice the "Stored routine" key is missing an underscore and instead uses space.

Related branches

Verified with PS 5.6.22. Need to decide, is it okay with space or there should be _ .

root@desktop:/var/lib/mysql# cat desktop-slow-log.000013
/usr/sbin/mysqld, Version: 5.6.22-71.0-log (Percona Server (GPL), Release 71.0, Revision 726). started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
# Time: 150209 12:51:52
# User@Host: root[root] @ localhost [] Id: 37
# Schema: nil Last_errno: 0 Killed: 0
# Query_time: 13.517232 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 8388608 Rows_affected: 4194304
# Bytes_sent: 0
# Stored routine: nil.nil_test
use nil;
SET timestamp=1423466512;
INSERT INTo test SELECT * from test;
root@desktop:/var/lib/mysql#

Changed in percona-server:
status: New → Confirmed
tags: added: low-hanging-fruit slow-extended

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

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

Other bug subscribers