main.percona_userstat fails sporadically
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Low
|
Yura Sorokin | ||
5.5 |
Fix Released
|
Low
|
Yura Sorokin | ||
5.6 |
Fix Released
|
Low
|
Yura Sorokin |
Bug Description
_StringException: Text attachment: traceback
------------
Comment:
Logfile:
CURRENT_TEST: main.percona_
mysqltest: At line 121: query 'SELECT
Select_commands, Update_commands, Other_commands, Rows_fetched
INTO
@initial_
FROM
INFORMATION_
' failed: 1172: Result consisted of more than one row
The result from queries just before the failure was:
< snip >
ROWS_READ
10
FLUSH INDEX_STATISTICS;
SELECT ROWS_READ FROM INFORMATION_
ROWS_READ
SELECT COUNT(*) FROM t1;
COUNT(*)
10
SELECT ROWS_READ FROM INFORMATION_
ROWS_READ
10
SELECT ROWS_READ FROM INFORMATION_
ROWS_READ
10
DROP TABLE t1;
CREATE TABLE t2 (c1 INT UNSIGNED) ENGINE=InnoDB;
ALTER TABLE t2 MODIFY c1 FLOAT;
SELECT * FROM INFORMATION_
TABLE_SCHEMA TABLE_NAME ROWS_READ ROWS_CHANGED ROWS_CHANGED_
DROP TABLE t2;
More results from queries before failure can be found in /mnt/workspace/
------------
https:/ /github. com/percona/ percona- server/ pull/241 /github. com/percona/ percona- server/ pull/242
https:/