show_check fails sometimes
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
New
|
Undecided
|
Vlad Lesin | |||
5.6 |
New
|
Undecided
|
Vlad Lesin | |||
5.7 |
New
|
Undecided
|
Vlad Lesin |
Bug Description
--echo #
--echo # Bug #48985: show create table crashes if previous access to the table
--echo # was killed
--echo #
connect(
CONNECTION con1;
LET $ID= `SELECT connection_id()`;
CONNECTION default;
--disable_query_log
eval KILL QUERY $ID;
--enable_query_log
CONNECTION con1;
--error ER_QUERY_
SHOW CREATE TABLE non_existent;
^^^^^^^
In the case if the query is executed before the connection is killed there will be "the table does not exist" error.
Here is an example:
http://
CURRENT_TEST: main.show_check
mysqltest: At line 1223: query 'SHOW CREATE TABLE non_existent' failed with wrong errno 1146: 'Table 'test.non_existent' doesn't exist', instead of 1317...
The result from queries just before the failure was:
< snip >
FOR EACH ROW
SET NEW.c1 = 'тест' koi8r koi8r_general_ci latin1_swedish_ci
SHOW CREATE EVENT ev1;
Event sql_mode time_zone Create Event character_
ev1 NO_ENGINE_
DROP VIEW v1;
DROP PROCEDURE p1;
DROP FUNCTION f1;
DROP TABLE t1;
DROP EVENT ev1;
SHOW STORAGE ENGINES;
CREATE USER test_u@localhost;
GRANT PROCESS ON *.* TO test_u@localhost;
SHOW ENGINE MYISAM MUTEX;
SHOW ENGINE MYISAM STATUS;
DROP USER test_u@localhost;
#
# Bug #48985: show create table crashes if previous access to the table
# was killed
#
Changed in percona-server: | |
assignee: | nobody → Vlad Lesin (vlad-lesin) |
Does this affect 5.5 and 5.7? This is upstream, right? Then it has to be reported there.