Wrong number of Rows_read
Bug #746967 reported by
Peter Zaitsev
This bug report is a duplicate of:
Bug #830286: rows_read is overflowed when changing db.
Edit
Remove
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Triaged
|
Medium
|
Oleg Tsarev | ||
5.1 |
Triaged
|
Medium
|
Oleg Tsarev |
Bug Description
Having such data in slow query log on percona server 5.1.55-12.6
# Thread_id: 2489208 Schema: forum Last_errno: 1161 Killed: 0
# Query_time: 59.658269 Lock_time: 0.000085 Rows_sent: 25 Rows_examined: 75 Rows_affected: 0 Rows_read: 184467440737095
# Bytes_sent: 145898 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
It looks like it is related to Last_errno not being zero - this query execution was aborted.
Changed in percona-server: | |
status: | New → Confirmed |
Changed in percona-server: | |
importance: | Undecided → Medium |
status: | Confirmed → Triaged |
Changed in percona-server: | |
assignee: | nobody → Oleg Tsarev (tsarev) |
Changed in percona-server: | |
status: | Triaged → In Progress |
tags: | added: slow-extended |
summary: |
- Wrong number of rows examined + Wrong number of Rows_read |
To post a comment you must log in.
Valentin, please provide test-case for this bug