Wrong time in slow.log

Bug #600360 reported by Vadim Tkachenko
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Oleg Tsarev

Bug Description

Sometimes we can see strange times in slow.log i.e.:

# Query_time: 0.000042 Lock_time: 18446744073706.851562 Rows_sent: 0
> Rows_examined: 0 Rows_affected: 0 Rows_read: 1

The same can me for Query_time.

The reason is
http://www.mysqlperformanceblog.com/2009/05/17/what-time-18446744073709550000-means/

We need to skip such wrong values ( we can write just 0 in this case)

Changed in percona-server:
status: New → Triaged
importance: Undecided → Medium
assignee: nobody → Oleg Tsarev (tsarev)
milestone: none → 5.1-12.0
Oleg Tsarev (tsarev)
Changed in percona-server:
status: Triaged → Fix Committed
Changed in percona-server:
status: Fix Committed → Fix Released
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-1144

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

Other bug subscribers

Remote bug watches

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