Server is hanging in 'checking permissions' state while executing DROP TABLE statement.

Description

Server is getting hang with checking permissions state while executing DROP TABLE statement.

Testcase.

1 2 3 4 5 6 7 8 9 DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE IF NOT EXISTS t2 (c1 VARCHAR(1024) CHARACTER SET 'latin1' COLLATE 'latin1_bin',c2 INT(1) ZEROFILL,c3 DECIMAL(40) ZEROFILL) ENGINE=TokuDB; LOCK TABLES t2 AS a3 WRITE; UNLOCK TABLES; TRUNCATE TABLE t2; CREATE DEFINER=CURRENT_USER FUNCTION f2 (i1 FLOAT(255,10) ZEROFILL) RETURNS CHAR(255) NO SQL RETURN CONCAT('function output:',i1); SELECT -606 MOD -923 - -434 % 0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001 / -75 DIV DEGREES(790); SELECT f2(0.0001); DROP TABLE IF EXISTS t2;

Please execute above testcase multiple times from cli.

1 mysql > source testcase.sql; source testcase.sql; source testcase.sql; source testcase.sql; source testcase.sql;

Environment

None

Status

Assignee

Vladislav Lesin

Reporter

Ramesh Sivaraman

Labels

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

Freshdesk Tickets

None

Affects versions

Percona-Server-5.7.17-11

Priority

Major
Configure