show_check fails sometimes

Bug #1530145 reported by Vlad Lesin
6
This bug affects 1 person
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(con1,localhost,root,,);
CONNECTION con1;
LET $ID= `SELECT connection_id()`;

CONNECTION default;
--disable_query_log
eval KILL QUERY $ID;
--enable_query_log

CONNECTION con1;
--error ER_QUERY_INTERRUPTED
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://jenkins.percona.com/view/PS%205.6/job/percona-server-5.6-param/1062/BUILD_TYPE=release,Host=ubuntu-wily-64bit/testReport/junit/(root)/main/show_check/

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_set_client collation_connection Database Collation
ev1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev1` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO SELECT 'тест' AS test koi8r koi8r_general_ci latin1_swedish_ci
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
#

Tags: ci upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Does this affect 5.5 and 5.7? This is upstream, right? Then it has to be reported there.

tags: added: ci upstream
Changed in percona-server:
assignee: nobody → Vlad Lesin (vlad-lesin)
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-3351

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.