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

Wrong number of Rows_read

Bug #746967 reported by Peter Zaitsev on 2011-04-01

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	Percona Server moved to https://jira.percona.com/projects/PS 5.1.61-13.2

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: 18446744073709551598
# 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.

Tags:

Stewart Smith (stewart) on 2011-05-19

Changed in percona-server:
status:	New → Confirmed

Stewart Smith (stewart) on 2011-06-07

Changed in percona-server:
importance:	Undecided → Medium
status:	Confirmed → Triaged

Oleg Tsarev (tsarev) on 2011-06-20

Changed in percona-server:
assignee:	nobody → Oleg Tsarev (tsarev)

Oleg Tsarev (tsarev) on 2011-06-28

Changed in percona-server:
status:	Triaged → In Progress

Revision history for this message

Oleg Tsarev (tsarev) wrote on 2011-08-04:

Valentin, please provide test-case for this bug

Revision history for this message

Valentine Gostev (longbow) wrote on 2011-08-10:

Oleg, bug requires source analysis, assigning back to you (confirmed by voice)

Oleg Tsarev (tsarev) on 2011-08-23

tags:

added: slow-extended

Alexey Kopytov (akopytov) on 2011-10-06

summary:

- Wrong number of rows examined
+ Wrong number of Rows_read

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2011-11-29:

Removed the duplicate status as this one has already been triaged and targeted to milestones, while bug #830286 is not.

There is also no evidence so far that bug #830286 and this one are identical. The reasons might be different even though the symptoms are similar. We can mark them is duplicate(s) once we have a fix for either bug that can be verified to also fix the other one.

Revision history for this message

Valentine Gostev (longbow) wrote on 2012-01-04:

Marking as duplicate of https://bugs.launchpad.net/percona-server/+bug/723073
I will work on test case in 723073

Report a bug

This report contains Public information

Everyone can see this information.

Duplicate of bug #830286 Remove

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

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